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.
A tutor will be present during the discussion session to help you plan and develop your assignment.
(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.

1. Assignment 100% (Learning Outcomes 1,2, 3 and 4)
You will design and develop an automated Excel-based system (suggested by yourself, but agreed with the module leader) to manipulate / analyse a set of data.

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