The University of Southampton
Courses

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

TypeHours
Teaching24
Independent Study126
Total study time150

Resources & Reading list

SC Albright. VBA for Modelers: Developing Decision Support Systems using Microsoft Excel. 

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. 

R Stephens. Ready-to-Run Visual Basic Algorithms. 

Assessment

Summative

MethodPercentage contribution
Coursework assignment(s) 100%

Referral

MethodPercentage 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.

Share this module Facebook Google+ Twitter Weibo

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.

×