MATH6005 Visual Basic for Applications
Module Overview
This module aims to teach students the fundamentals of writing structured computer programs, applicable using any high level programming language. However, students will be shown the special event driven features of Visual Basic for Application (VBA) that makes it especially versatile. The module uses software engineering techniques to enforce the importance of good programming manners and will review traditional computing algorithm analysis, design and implementation using VBA.
Aims and Objectives
Module Aims
This module aims to teach students the fundamentals of writing structured computer programs, applicable using any high level programming language. However, students will be shown the special event driven features of Visual Basic for Application (VBA) that makes it especially versatile. The module uses software engineering techniques to enforce the importance of good programming manners and will review traditional computing algorithm analysis, design and implementation using VBA.
Learning Outcomes
Knowledge and Understanding
Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:
- Having successfully completed this module, you will have knowledge and understanding of the fundamentals of writing structured computer programs, applicable to using any high level programming language.
- You will have an understanding of traditional computing algorithm analysis, design and implementation using VBA.
Transferable and Generic Skills
Having successfully completed this module you will be able to:
- You will have skills in writing structured computer programs, applicable using any high level programming language.
- You will have skills in programming according to good practice, applicable in all high level languages.
- You will have developed skills in technical report writing.
Subject Specific Practical Skills
Having successfully completed this module you will be able to:
- Having successfully completed this module, you will have developed a working facility of using VBA.
- You will be able to carry out analysis, design and implementation of algorithms using VBA.
- You will have your own library of algorithms for use in other modules or in project work
Syllabus
No prior programming experience is required. The module will cover the basic principles of programming in a high level language. The main focus will, however, be in developing a working facility of Visual Basic. The module will cover a range of the most commonly used techniques and algorithms including technical calculations as well as data manipulation, graphical users interface, file handling, object-oriented programming (OOP), and integration with other packages such as Excel and Access. Practical exercises are used to reinforce the ideas taught in the module, which will enable the students to build up their own library of algorithms for use in other modules or in project work.
Learning and Teaching
Teaching and learning methods
Six 1-hour lectures Six 3-hour computer sessions
| Type | Hours |
|---|---|
| Independent Study | 51 |
| Teaching | 24 |
| Total study time | 75 |
Resources & Reading list
SC Albright. VBA for Modelers: Developing Decision Support Systems using Microsoft Excel.
R Stephens. Ready-to-Run Visual Basic Algorithms.
DE Knuth. The Art of Computer Programming (Volume 1).
P Jones. Visual Basic: A Complete Module.
MC Kerman & RL Brown. Computer Programming Fundamentsl with Applications in Visual Basic.
Assessment
Summative
| Method | Percentage contribution |
|---|---|
| Coursework assignment(s) | 100% |
Referral
| Method | Percentage contribution |
|---|---|
| Coursework | 100% |
Repeat Information
Repeat type: Internal & External
Costs
Costs associated with this module
Students are responsible for meeting the cost of essential textbooks, and of producing such essays, assignments, laboratory reports and dissertations as are required to fulfil the academic requirements for each programme of study.
In addition to this, students registered for this module typically also have to pay for:
Books and Stationery equipment
Course texts are provided by the library and there are no additional compulsory costs associated with the module.
Please also ensure you read the section on additional costs in the University’s Fees, Charges and Expenses Regulations in the University Calendar available at www.calendar.soton.ac.uk.