FINANCIAL MATHEMATICS WITH EXCEL - 2025/6
Module code: MAN1145
Module Overview
The module teaches tools and techniques of Business Mathematics, together with the development and application of Excel skills.
Module provider
Surrey Business School
Module Leader
HAN Liang (SII DUFE)
Number of Credits: 15
ECTS Credits: 7.5
Framework: FHEQ Level 4
Module cap (Maximum number of students): N/A
Overall student workload
Independent Learning Hours: 117
Lecture Hours: 22
Seminar Hours: 11
Module Availability
Semester 1
Prerequisites / Co-requisites
N/A
Module content
Topics include, but not exhausted to:
- Basic numeracy
- Data collection, analysis and presentation
- Probability Distributions
- Linear and Multiple Regression
- Forecasting
- Time Value of Money
- Spreadsheet skills - MS Excel
- Problem-solving using mathematical tools, including the use of Excel
Assessment pattern
Assessment type | Unit of assessment | Weighting |
---|---|---|
Online Scheduled Summative Class Test | Excel class test set time and date (90 minutes) | 50 |
Examination | Examination (90 minutes) | 50 |
Alternative Assessment
N/A
Assessment Strategy
The assessment strategy is designed to provide students with the opportunity to demonstrate their ability to use mathematical skills to solve numerical problems, both on paper and using Excel.
The summative assessment for this module consists of:
- A class test that addresses learning outcomes 1 and 2
- A final term examination covering learning outcomes 3 to 5
Formative assessment and feedback:
Students will receive verbal feedback during seminars/PC laboratory sessions through direct questioning, also from class exercises which will challenge their understanding of the building blocks. Class exercises and indicative questions given before the class test and examination will help students prepare for the assessments and students will be encouraged to research these and ask questions.
Module aims
- Enable students to use mathematical and statistical methods to solve quantitative business problems, both on paper and using Excel.
- Prepare students with the Excel skills and mathematical tools required in future modules within the undergraduate degree programme and enhance employability.
Learning outcomes
Attributes Developed | ||
001 | Demonstrate competence in spreadsheet software (MS Excel) in data analysis and visualisation. | KCPT |
003 | Analyse and present data in an effective manner. | KCPT |
002 | Use Excel skills effectively in solving quantitative business problems. | KCPT |
004 | Use probability, statistical and other mathematical tools in problem solving. | KCPT |
005 | Apply financial mathematics techniques to business scenarios. | KCPT |
Attributes Developed
C - Cognitive/analytical
K - Subject knowledge
T - Transferable skills
P - Professional/Practical skills
Methods of Teaching / Learning
The learning and teaching strategy:
Give students the opportunity to gain knowledge and understanding of mathematical tools relevant to finance and accounting modules.
Engage students to develop excel skills enhancing digital literacy.
The learning and teaching methods include:
Elements of seminars, PC laboratory tutorials, workshops, guided reading and captured content including illustrative practice exercises.
Indicated Lecture Hours (which may also include seminars, tutorials, workshops and other contact time) are approximate and may include in-class tests where one or more of these are an assessment on the module. In-class tests are scheduled/organised separately to taught content and will be published on to student personal timetables, where they apply to taken modules, as soon as they are finalised by central administration. This will usually be after the initial publication of the teaching timetable for the relevant semester.
Reading list
https://readinglists.surrey.ac.uk
Upon accessing the reading list, please search for the module using the module code: MAN1145
Other information
Surrey Business School is committed to developing graduates with strengths in Employability, Digital Capabilities, Global and Cultural Capabilities, Sustainability, and Resourcefulness and Resilience. This module is designed to allow students to develop knowledge, skills, and capabilities particularly in the following areas: Digital Capabilities: Students will use excel throughout the module to learn module contents. The excel skills aid the development of finance and accounting related modelling and enhance their digital capabilities. Employability: The module aims to develop excel skills and financial awareness that will aid in enhancing employability. During the course of module delivery, students develop the ability to evaluate problems and devise solutions. As a result, students build and enhance individual and professional skills. Resourcefulness and Resilience: Students solve problems as well as critically analyse the solutions, thereby fostering an openness to different perspectives and developing their own viewpoint. In addition, through the independent and guided learning, students develop attributes such as confidence, adaptability, self-regulation, self-efficacy, problem solving and decision-making abilities.
Programmes this module appears in
Programme | Semester | Classification | Qualifying conditions |
---|---|---|---|
Accounting and Finance (SII DUFE) BSc (Hons)(DUFE) | 1 | Compulsory | A weighted aggregate mark of 40% is required to pass the module |
Please note that the information detailed within this record is accurate at the time of publishing and may be subject to change. This record contains information for the most up to date version of the programme / module for the 2025/6 academic year.