Essential Reading
Reed Jacobson (2007). Microsoft Office Excel 2007 Visual Basic for Applications: Step by Step. Microsoft Press, ISBN: 073562402X

Must be a competent user of Excel or other spreadsheet software.

Microsoft Excel and VBA

Each week the module will be delivered via a one-hour lecture, a two-hour computer-based workshop session, and a one-hour discussion session. A tutor will be present during the workshops to help you and to provide whole class instruction.
Outside of class contact hours you will be expected to complete set exercises, to read background literature and to improve your skills by revising the material issued during the lectures and workshops.
(1:n)1, (1:20)3

VBA is the programming language behind most Microsoft applications. It can be used to automate series of spreadsheet tasks and to customise them for use by non-specialists.

VBA macro programming techniques for automating spreadsheet calculations:
objects, properties and methods: Ranges, Charts, PivotTables; procedures and functions, variables, control structures, input and output, debugging tools.
VBA user interface design:
customizing Userforms, ActiveX controls, WorkSheet and WorkBook events, toolbars and menus.
Quantitative applications:
eg. data analysis, financial modelling, simulation, production planning, budgetting, forecasting, stock control, statistical analysis, performance review, quality control.

A CLASS TEST length 1.5 hours weighted at 50%. A GP ASSIGNMT weighted at 50%

1. Group Assignment (50%) (Learning Outcomes 1,2,3 and 4)
2. Practical Test (50%) 1.5 hours (Learning Outcomes 1,2 and 3)