Business Analysis Tools - CB364

Location Term Level Credits (ECTS) Current Convenor 2019-20
Canterbury
(version 2)
Autumn
View Timetable
4 15 (7.5) MR T Yu

Pre-requisites

None

Restrictions

Available to short-term/exchange students.

2019-20

Overview

An indicative set of topics to be covered within the module are outlined below.
• Basic Spreadsheet Functionalities: Introduction to common spreadsheet features: workbooks, worksheets, menus, cells, rows, columns, data types, relative and absolute cell addressing, copying, basic formulae, naming cells, formatting, charts and graphs, printing.
• Data Management Facilities: sorting, filtering, data forms, pivot tables.
• What-If Analysis: scenario manager, goal seek, data tables.
• Basic Financial Analysis: Introduction to basic financial analysis and how to carry this out using spreadsheets: compound interest, discounting, NPV, IRR, loans and mortgages.
• Advanced Spreadsheet Functionalities: automating tasks and solving simple optimisation business problems.

Details

This module appears in:


Contact hours

Total contact hours: 31
Private study hours: 119
Total study hours: 150

Method of assessment

Main assessment methods
In-Course Test (45 minutes) 20%
In-Course Test (45 minutes) 20%
In-Course Test (45 minutes) 20%
Individual Project (Excel based) 40%

Reassessment methods
100% Coursework

Indicative reading

L. Swift and S. Piff (2010) Quantitative Methods for Business, Management and Finance (3rd Edition), Palgrave, NY.
W. Winston (2011) Microsoft Excel 2010: Data Analysis and Business Modeling (3rd Edition), Microsoft Press.

See the library reading list for this module (Canterbury)

Learning outcomes

Subject specific learning outcomes:
- Have knowledge of essential data analysis, modelling and decision making in a business environment.
- Have developed the necessary technical skills to structure, analyse and solve practical decision problems using Excel spread sheets.
- Be able to analyse the quantitative/qualitative data and present findings both in tabular and graphical form.
- Be able to design, implement and use simple databases.
- Be able to carry out basic financial and "what-if" type analyses.
- Be able to design and implement a maintainable, well documented spread sheet model suitable for end-users.

Intended generic learning outcomes:
- Plan work and study independently using relevant resources.
- Apply their model building, problem solving and numerical skills to solve everyday business problems.
- Present their findings in a clear manner.

University of Kent makes every effort to ensure that module information is accurate for the relevant academic session and to provide educational services as described. However, courses, services and other matters may be subject to change. Please read our full disclaimer.