Core Module Information
Module title: Modelling for Business

SCQF level: 07:
SCQF credit value: 20.00
ECTS credit value: 10

Module code: INF07104
Module leader: Wegene Demeke
School School of Computing, Engineering and the Built Environment
Subject area group: Applied Informatics
Prerequisites

None

Description of module content:

Module content includes:
• Concept of model building
• The role of information in model building
• Definition and design of financial models
• Spreadsheet basics: addressing, shortcuts, error checking, formatting, multiple sheets, etc.
• Spreadsheet presentation: layout, charts, tables, etc.
• Built-in spreadsheet functions
• Custom function development
• Modelling techniques: escalation methods, cumulative calculations, depreciation, break-even analysis, etc.
• Analysis techniques: what-if?, scenarios, sensitivity

Learning Outcomes for module:

Upon completion of this module you will be able to
LO1: Construct simple business models
LO2: Use a range of logical and mathematical techniques
LO3: Develop spreadsheet applications

Full Details of Teaching and Assessment

Indicative References and Reading List - URL:
Contact your module leader