Business Analysis In Practice - BUSN3850

Looking for a different module?

Module delivery information

Location Term Level1 Credits (ECTS)2 Current Convenor3 2021 to 2022
Medway
Spring Term 4 15 (7.5) Ramin Raeesi checkmark-circle

Overview

This module will develop core understanding and skills of using Microsoft Excel, a market leading analytical tool and software package. It covers the way in which enterprises such as businesses, not-for-profit organisations and governments utilise quantitative data to obtain insights for decision-making. Techniques will be taught and delivered with case studies and simulated datasets.
Topics to be covered include:
• Microsoft Excel functions and formulae: Nested functions, filters, lookup functions, and logical functions
• Data visualisation: Graphic operations
• Data analysis and statistical analysis: conditional formatting, Solver, Add-ins and Trend analysis
• Excel Macros: defining, recording, assigning, running and storing, etc.

Details

Contact hours

Total contact hours: 21
Private study hours: 129
Total study hours: 150

Method of assessment

Main assessment methods:
Individual Excel Project (60%)
Individual Report (40%)

Reassessment method:
100% coursework

Indicative reading

Essential Reading:

Etheridge, D. (2010) Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts, and Pivot Tables (3rd Ed.), Chichester: John Wiley & Sons.

Background Reading:

Davis, G. and Pecar, B. (2013) Business Statistics Using Excel, Second edition, Oxford: OUP.

Swift, L. and Piff, S. (2014) Quantitative Methods for Business, Management and Finance, Basingstoke, Palgrave Macmillan.

See the library reading list for this module (Medway)

Learning outcomes

The intended subject specific learning outcomes.
On successfully completing the module students will be able to:
- Identify and apply a range of quantitative tools, including data collection and analysis, interpretation and extrapolation.
- Select appropriate quantitative methods to assist in the solving of business problems.
- Construct and apply quantitative models to describe and predict business scenarios using Excel spreadsheets.
- Demonstrate the application of Information and Communication Technology (ICT) appropriately and effectively in typical business applications.

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.

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.