Business Analysis Tools - BUSN3640

Looking for a different module?

Module delivery information

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


Excel is the industry standard software for data processing and modelling. This module will develop students' understanding and skills of using Microsoft Excel. It covers the essential ways in which all types of organizations today utilize quantitative data to obtain insights for decision-making. Students will gain hands-on experience on the techniques of Excel and spreadsheet modelling - through a handful of comprehensive examples and realistic problems. The module will explore Excel functions and formulae, data visualisation, data analysis and statistical analysis, and Excel Macros.


Contact hours

Total contact hours: 22
Private study hours: 128
Total study hours: 150


The programmes of study to which the module contributes:

BSc Business and Management and associated programmes
BSc International Business
BSc Business and Marketing
BSc Business Analytics and Management

Method of assessment

Main assessment methods:

Individual Excel Project (60%)
Individual Report (40%)

Reassessment methods:

Reassessment Instrument: 100% coursework

Indicative reading

See the library reading list for this module (Canterbury)

Learning outcomes

The intended subject specific learning outcomes.
On successfully completing the module students will be able to:

- Understand essential data analysis, modelling, and decision making in a business environment.
- Apply technical skills to structure, analyse, and solve practical decision problems using Excel spreadsheets.
- Analyse quantitative/qualitative data and present findings both in tabular and graphical form.
- Design, implement, and use simple databases.
- Use "what-if" analysis tools to analyse different business scenarios and make informed decisions.
- Construct and apply quantitative models to describe and predict business scenarios using Excel spreadsheets.

The intended generic learning outcomes.
On successfully completing the module students will be able to:

- Retrieve information from a variety of sources.
- Undertake independent and self-managed learning.
- Apply numerical skills and techniques in practical scenarios.
- Communicate accurately and reliably in a variety of forms the results of business analysis.


  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.