Â鶹´«Ã½

-


MN50643: Spreadsheet modelling

Academic Year: 2018/9
Owning Department/School: School of Management
Credits: 6      [equivalent to 12 CATS credits]
Notional Study Hours: 120
Level: Masters UG & PG (FHEQ level 7)
Period:
Semester 1
Assessment Summary: CW 50%, EX 50%
Assessment Detail:
  • Coursework (CW 50%)
  • Examination (EX 50%)
Supplementary Assessment:
Like-for-like reassessment (where allowed by programme regulations)
Requisites:
Description: Aims:
This unit covers the functionalities of Excel spreadsheet software including data analysis tools like the statistical testing tools and the optimisation solver. The programming language (VBA) embedded within Excel is also explored in depth and the issues of code efficiency and web integration are analysed.

Learning Outcomes:
At the end of this unit, students will be able to:
* Design spreadsheets to solve business problems, the capabilities of which can be extended to the needs of the user
* Use statistical testing tools and the optimisation solver to provide business decision support
* Use the object model of Excel to access data contained internally as well as externally and implement algorithms to process it

Skills:
Intellectual skills:
* Model business processes using spreadsheets and identify possible improvements (T, F, A)
* Generate multiple business scenarios and test them statistically (T, F, A)
Practical skills:
* Practical knowledge of the high level capabilities of Excel (T, F, A)
* Integration of data sources and design of efficient algorithms (T, F, A)
Transferable skills:
* Advanced use of information technology (F)
* Extended knowledge of data types, their storage, and conversion (T, F)

Content:
Topics covered include basic and advanced spreadsheet functions, data validation, charts, pivot tables, using statistical testing facilities in spreadsheets, applying optimisation principles in Excel, conducting what-if analysis, introduction to VBA programming, conditional statements, loops, user-defined functions and creating usable applications.
Programme availability:

MN50643 is a Designated Essential Unit on the following programmes:

School of Management

Notes:

  • This unit catalogue is applicable for the 2018/19 academic year only. Students continuing their studies into 2019/20 and beyond should not assume that this unit will be available in future years in the format displayed here for 2018/19.
  • Programmes and units are subject to change in accordance with normal University procedures.
  • Availability of units will be subject to constraints such as staff availability, minimum and maximum group sizes, and timetabling factors as well as a student's ability to meet any pre-requisite rules.
  • Undergraduates: .
  • Postgraduates: .