An indicative set of topics to be covered within the module are outlined below.
• Basic Spreadsheet Functionalities: Introduction to common spreadsheet features: workbooks, worksheets, menus, cells, rows, columns, data types, relative and absolute cell addressing, copying, basic formulae, naming cells, formatting, charts and graphs, printing.
• Data Management Facilities: sorting, filtering, data forms, pivot tables.
• What-If Analysis: scenario manager, goal seek, data tables.
• Basic Financial Analysis: Introduction to basic financial analysis and how to carry this out using spreadsheets: compound interest, discounting, NPV, IRR, loans and mortgages.
• Advanced Spreadsheet Functionalities: automating tasks and solving simple optimisation business problems.
Total contact hours: 31
Private study hours: 119
Total study hours: 150
Method of assessment
Main assessment methods
Online VLE Test 1 (45 minutes) 20%
Online VLE Test 2 (45 minutes) 20%
Online VLE Test 3 (45 minutes) 20%
Individual Project (Excel based) 40%
L. Swift and S. Piff (2010) Quantitative Methods for Business, Management and Finance (3rd Edition), Palgrave, NY.
W. Winston (2011) Microsoft Excel 2010: Data Analysis and Business Modeling (3rd Edition), Microsoft Press.
See the library reading list for this module (Canterbury)
Subject specific learning outcomes:
- Have knowledge of essential data analysis, modelling and decision making in a business environment.
- Have developed the necessary technical skills to structure, analyse and solve practical decision problems using Excel spread sheets.
- Be able to analyse the quantitative/qualitative data and present findings both in tabular and graphical form.
- Be able to design, implement and use simple databases.
- Be able to carry out basic financial and "what-if" type analyses.
- Be able to design and implement a maintainable, well documented spread sheet model suitable for end-users.
Intended generic learning outcomes:
- Plan work and study independently using relevant resources.
- Apply their model building, problem solving and numerical skills to solve everyday business problems.
- Present their findings in a clear manner.
Back to top
Credit level 4. Certificate level module usually taken in the first stage of an undergraduate degree.
- ECTS credits are recognised throughout the EU and allow you to transfer credit easily from one university to another.
- The named convenor is the convenor for the current academic session.
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.