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

n/a

2018/9, Trimester 2, Face-to-Face,
Occurrence: 001
Primary mode of delivery: Face-to-Face
Location of delivery: MERCHISTON
Partner:
Member of staff responsible for delivering module: Wegene Demeke
Module Organiser:


Learning, Teaching and Assessment (LTA) Approach:
The student is required to be employed as a Graduate Apprentice based in and around Edinburgh to be eligible to complete this module, in this format. This module is offered in day release (GA) study mode and will be delivered during the period that students are attending classes from 9 am to 5 pm, one day per week. The delivery of the module is in line with normal university delivery models. The traditional lecture materials will be delivered in a blended form using online materials, while in-class time is devoted to practical exercises, projects, or discussions. The module is designed around online and student-centred learning in practice with an emphasis on building a learning community. The module is introduced by an induction workshop which introduces students to the online resources and explains the assessment process.
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.



Formative Assessment:
Tutorial/practical sessions are used to provide formative feedback for students on the module. During these sessions, module tutors assess and evaluate student performance on tasks relevant to the summative assessment, providing timely feedback which supports the development of students’ capabilities. These formative tasks provide the essential underpinning for the summative assessments that follow

Summative Assessment:
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).




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:

Please contact your Module Leader for details
Click here to view the LibrarySearch.