- View more resources from this publisher
Core Maths
Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.
Mortgages and spreadsheets
This Core Maths task involves the analysis of mortgage repayments and requires the calculation of percentages and the use of a spreadsheet.
A help sheet is included in the materials for students who are not confident with spreadsheets.
The task is suitable for work in pairs or small groups. The presentation is intended to be used to introduce the task. Students are then asked to design a model to describe the situation set out in the presentation. Students can then present their findings to the whole group.
The teachers' notes provide a suggested approach to the task and suggestions for possible extensions. A specimen spreadsheet solution is also available.
Show health and safety information
Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.
Downloads
Show downloads
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
