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 LOsTeaching 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 verbal feedback is provided throughout the module as the students work on practical exercises.
|
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 activity | Learning & Teaching Activity | NESH (Study Hours) |
Face To Face | Lecture | 24 |
Face To Face | Practical classes and workshops | 24 |
Independent Learning | Guided independent study | 152 |
| Total Study Hours | 200 |
| Expected Total Study Hours for Module | 200 |
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 | | | |