Core Module Information
Module title: Modelling for Business

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

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


Description of module content:

• 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
2023/4, Trimester 2, FACE-TO-FACE, Edinburgh Napier University
Occurrence: 001
Primary mode of delivery: FACE-TO-FACE
Location of delivery: MERCHISTON
Partner: Edinburgh Napier University
Member of staff responsible for delivering module: Wegene Demeke
Module Organiser:

Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)
Face To Face Lecture 24
Face To Face Practical classes and workshops 24
Independent Learning Guided independent study 152
Total Study Hours200
Expected Total Study Hours for Module200

Type of Assessment Weighting % LOs covered Week due Length in Hours/Words
Practical Skills Assessment 40 2 5 HOURS= 06.00, WORDS= 0
Project - Practical 60 1,3 14/15 HOURS= 12.00, WORDS= 0
Component 1 subtotal: 40
Component 2 subtotal: 60
Module subtotal: 100

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