Objectives

This module builds on the techniques developed during MSCI 242. The aim is to improve the student’s technical competence, model design skills and VBA programming, to enable effective and powerful      models to be constructed. As previously, case studies and real-life applications will often be used to      illustrate these concepts, and show how value can be added to models used in management and analysis situations.

Contact

Each week there will be a 1-hr lecture/demonstration session, uploaded to moodle as a video, plus a 2-hr face-to-face practical computer workshop session.

Additional workshops and study tasks will also be made available during the term.

Lecture style       Workshop

Assessment

Coursework 100%. A single, individual project handed out around week 7 and due 9th May.

Resources

As with 242, the course will be supported by comprehensive workshop notes1 .

Additional book support could include:

  Excel 2019 (or 2016) Power Programming with VBA   Microsoft Excel 2019 VBA and Macros

by Alexander and Kusleika

by Bill Jelen and Tracy Syrstad

1 All material is copyright