FINANCIAL MATHEMATICS WITH EXCEL - 2024/5
Module code: MAN1145
Module Overview
The module teaches tools and techniques of Business Mathematics.
Module provider
Surrey Business School
Module Leader
MADON Farhad (SBS)
Number of Credits: 15
ECTS Credits: 7.5
Framework: FHEQ Level 4
JACs code:
Module cap (Maximum number of students): N/A
Overall student workload
Independent Learning Hours: 90
Lecture Hours: 10
Seminar Hours: 20
Guided Learning: 20
Captured Content: 10
Module Availability
Semester 1
Prerequisites / Co-requisites
N/A
Module content
Topics include, but not exhausted to:
Basic numeracy, Data collection and Presentation, Descriptive Statistics, Index Numbers, Probability, Probability Distributions, Inference and Hypothesis Testing, Correlation, Linear and Multiple Regression, Forecasting, Linear Programming techniques, Time Value of Money, Investment Appraisal including Net Present Value
Assessment pattern
| Assessment type | Unit of assessment | Weighting |
|---|---|---|
| School-timetabled exam/test | School-timetabled exam/test 50 min | 30 |
| Examination | Examination 120 min | 70 |
Alternative Assessment
N/A
Assessment Strategy
The assessment strategy is designed to provide students with the opportunity to demonstrate
¿ Their knowledge of relevant mathematical tools
¿ Their ability to use excel to solve numerical problems
The summative assessment for this module consists of:
¿ A midterm test that addresses learning outcomes 1 and 2
¿ A final term examination covering all learning outcomes
Formative assessment and feedback
¿ Students will receive verbal feedback during lectures/seminars through direct questioning, also from class exercises which will challenge their understanding of the building blocks
¿ Class exercises and indicative questions given before the test will be the basis of the midterm test ¿ students will be encouraged to research these and ask questions
Module aims
- Enable students to use mathematical and statistical methods.
- Prepare students to apply mathematical tools required in future modules within the undergraduate degree programme.
Learning outcomes
| Attributes Developed | ||
| 001 | Identify and use appropriate basic mathematical tools | CKPT |
| 002 | Analyse and present data | CKPT |
| 003 | Use probability techniques, apply probability distribution theory, make inferences and test hypotheses | CKP |
| 004 | Calculate correlations and demonstrate tools for forecasting, including linear, multiple regression and time series | CKPT |
| 005 | Apply financial mathematics techniques | CKPT |
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, lectures, 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 (Dual degree with SII-DUFE ) BSc (Hons) | 1 | Compulsory | A weighted aggregate mark of 40% is required to pass the module |
| Accounting and Finance BSc (Hons) | 1 | Compulsory | A weighted aggregate mark of 40% is required to pass the module |
| Accounting and Finance (SII DUFE) BSc (Hons) | 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 2024/5 academic year.