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
Prerequisites

n/a

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
2022/3, Trimester 2, FACE-TO-FACE, Edinburgh Napier University
VIEW FULL DETAILS
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:


Learning, Teaching and Assessment (LTA) Approach:
Learning & Teaching methods including their alignment to LOs
Teaching comprises a blend of lectures and practical sessions that cover all learning outcomes. The lectures address a range of theoretical and practical concepts in financial modelling (LOs 1,2, & 3).
The lectures also address the nature of models as an approximation of reality, limitation and capability discussed with examples. The role of information in building models, including quality of data, assumption and manging error using inbuilt excel tools.
Practicals include exposure to a range of Excel tools and functions that will assist students in learning the building blocks of financial modelling. The practical sessions enable students to use a variety of logical and mathematical techniques such as escalation methods, cumulative calculations, depreciation, break-even analysis. The lecture covers analysis techniques such as what-if, scenarios, and sensitivity. Students are guided to build an excel application for a given scenario (LOs 1, 2, & 3).


Formative Assessment:
Formative assessment:
Formative verbal feedback is provided throughout the module as the students work on practical exercises.


Summative Assessment:
Summative assessment:
There are two summative assessments for this module.
The first summative assessment tasks require the students to demonstrate their proficiency in the general operation of spreadsheet applications to develop financial models (40% of the total mark) (LOs 2).
The second summative assessment is building a simple financial model by creating an excel application for a given scenario (60 % of the mark) (LO1 &3).


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


Assessment
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