Modules

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
2023/4, 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:


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
 

Related information