This module will utilise some of the advanced spreadsheet functions and features available to aid modelling/analysis/decision making for quantity based problems. Those met will include amongst others: a range of functions to aid modelling, lookup functions for value selection, array formulae for criteria based analysis, customising worksheet interfaces, solver for problem optimisation, sensitivity analysis using scenarios and data tables, and pivot tables for cross tabulations.
Students will also be introduced to VBA macros together with some basic tools of programming enabling the automation of processes within a spreadsheet. Principles met will include: recording macros, editing macros, use of message boxes and input boxes to allow interaction with the user, if statements, for each and do loops, an introduction to forms, and the development of personalised functions.

Excel

Students will experience 24 hours of computer based in-class practical sessions (2 hours per week).
There will be a further 12 hour of class contact (1 hour per week) consisting some weeks of a lecture addressing issues relevant to spreadsheet modelling in general and/or the content of the practical sessions, and in the remaining weeks of a practical surgery in which students can access additional lab based contact time if required. Independent study time will be spent completing the worksheets, further practising the methods met in class, and preparing for assessments.

1. Lab Based Test 1 requiring the prior preparation (with the option to work in a small group) of a spreadsheet model for use in the test: One hour and 15 minutes weighted 50% (Learning Outcomes 1 and 2)
2. Lab Based Test 2 requiring the prior critical appraisal of the VBA model provided for use in the test: One hour and 15 minutes weighted 50% (Learning Outcomes 2, 3 and 4)

For background reading:
Excel 2007 Bible, John Walkenbach, Wiley, Jan 2007, ISBN: 0470044039

A basic knowledge of spreadsheets including experience of formulae formulation,charts and built-in functions such as SUM, AVERAGE. Examples of modules developing these skills are:-
Quantitative Tools for Computing (CE61007-1), or (BLB10115-1) Business Skills 2, or Essential Computing for EDLC (CE61003-1), or Using Computer Packages (CE00305-1), or equivalent. This module is NOT available to students on the Mathematics and Applied Statistics award who instead can take the equivalent module at Level 1 (CE61025-1).