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.
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
Main assessment methods:
Individual Excel Project (60%)
Individual Report (40%)
Reassessment methods:
Reassessment Instrument: 100% coursework
See the library reading list for this module (Canterbury)
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.
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.
