This module will introduce students to the basic skills of using Microsoft Excel, a market leading analytical tool and software package. It introduces the way in which business organisations use 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.
Total contact hours: 44
Private study hours: 106
Total Study hours: 150
Main assessment methods
Individual Excel Project (40%)
Written Assignment (1,000 words) (40%)
In-class test (45 minutes) (20%)
Reassessment methods
100% Coursework
Winston, W. (2019) Microsoft Excel 2019 Data Analysis and Business Modeling (Business Skills) (6th Ed.), London: Pearson International.
Etheridge, D. (2010) Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts, and Pivot Tables (3rd Ed.), Chichester: John Wiley & Sons.
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.
The intended subject specific learning outcomes.
On successfully completing the module students will be able to:
8.1 Identify a range of quantitative tools, including data collection and analysis, and construct basic models.
8.2. Understand and a range of quantitative methods used in the solving of business problems.
8.3. Explain how quantitative models are used to describe and predict business scenarios using Excel spreadsheets.
8.4. Demonstrate an understanding of Information and Communication Technology (ICT) in typical business applications.
The intended generic learning outcomes.
On successfully completing the module students will be able to:
9.1 Retrieve information from a variety of sources.
9.2 Undertake independent and self-managed learning.
9.3 Apply numerical skills and techniques in practical scenarios.
9.4 Demonstrate analytical abilities in problem solving, systematic work and study skills sufficiently to be able to deal effectively with the demands of a first-year undergraduate study at a UK university
9.5 Communicate accurately and reliably in a variety of forms.
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.
