Programming for Business Analytics

Module code: MTH785P

Credits: 15.0
Semester: SEM1

Contact: Dr Sebastian Del Bano Rollin

This module will provide an introduction to programming in a commercial environment including:
- Advanced use of Microsoft Excel for data analysis
- Usage of Macros to automate common tasks
- Introduction of Visual Basic for applications programming language (VBA)
- Writing custom Excel functions and subroutines using VBA
- Design of databases in Microsoft Access
- Querying data with Microsoft Access
- Externally loading data to Microsoft Access
- Using ActiveX Data objects
- The SQL query language

Connected course(s): UDF DATA
Assessment: 50.0% Coursework, 50.0% Examination
Level: 7