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
Subject area group: Creative and Social Informatics
Prerequisites

None

2018/9, 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:


Learning, Teaching and Assessment (LTA) Approach:
Learning & Teaching methods including their alignment to LOs
The module is designed around the main textbook, and lectures are used primarily as support and clarification for the written material. They also provide the opportunity to give students practical demonstrations of some of the techniques covered.

Practical spreadsheet skills are developed during the laboratory session in the early weeks of the module. Later a more problem-based approach is taken, and practical sessions are used to provide support as students work on their coursework assignments.

The module is highly interactive, and students are encouraged from the outset to steer the discussion by asking questions both in class and in advance.

In combination, the set text and the practical work cover all learning outcomes.

Assessment (formative or summative)
Formative verbal feedback is provided throughout the module as the students work on practical exercises. The summative assessment tasks require the students to demonstrate their proficiency in the general operation of spreadsheet applications and in using spreadsheets to develop financial models (LOs 1-3).


Formative Assessment:
The University is currently undertaking work to improve the quality of information provided on methods of assessment and feedback. Please refer to the section on Learning and Teaching Approaches above for further information about this module’s learning, teaching and assessment practices, including formative and summative approaches.

Summative Assessment:
The University is currently undertaking work to improve the quality of information provided on methods of assessment and feedback. Please refer to the section on Learning and Teaching Approaches above for further information about this module’s learning, teaching and assessment practices, including formative and summative approaches.

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 1,2,3 5 HOURS= 6, WORDS= 0
Practical Skills Assessment 60 1,2,3 14 HOURS= 12, WORDS= 0
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100

Description of module content:

• 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

Indicative References and Reading List - URL:

Core - DANIELLE STEIN FAIRHURST (2012) USING EXCEL FOR BUSINESS ANALYSIS : A GUIDE TO FINANCIAL MODELLING FUNDAMENTALS: VLEBOOKS, 1st ed. - ISBN: 9781118132869
Click here to view the LibrarySearch.