# Business Analysis for Foundation Studies - FOUN1052

Looking for a different module?

## Module delivery information

Location Term Level1 Credits (ECTS)2 Current Convenor3 2024 to 2025
Medway
Spring Term 3 15 (7.5) Gerald Rukambiro

## Overview

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.

## Details

### Contact hours

Total contact hours: 44

Private study hours: 106

Total Study hours: 150

## Method of assessment

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.

## Learning outcomes

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.

## Notes

1. Credit level 3. Foundation level module taken in preparation for a 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.