Business Analysis Tools - BUSN3640

Looking for a different module?

Module delivery information

Location Term Level1 Credits (ECTS)2 Current Convenor3 2023 to 2024
Canterbury
 Autumn Term 4 15 (7.5) K Naveed Bhatti checkmark-circle

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

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.

Notes

  1. Credit level 4. Certificate level module usually taken in the first stage of an undergraduate degree.
  2. ECTS credits are recognised throughout the EU and allow you to transfer credit easily from one university to another.
  3. The named convenor is the convenor for the current academic session.
Back to top

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.