The activities in this resource look at percentage increase and decrease both individually, in combination and in reverse. It would make a good recap resource for those confident in working with percentages or a focus lesson for those in need of reinforcement.
Number and Measures, Financial Maths
Previous experience of using spreadsheets would useful as well as knowledge of calculating percentages.
Students should be encouraged initially to think about different ways to calculate percentages with reference to a multiplicative method to give final amounts after interest has been added. Examples of real available savings accounts would be useful too.
In addition to this overview, there are:
• Detailed teacher notes (Word and PDF)
• Student information sheet (Word and PDF)
• Excel spreadsheet worksheet
• Excel spreadsheet worksheet – solutions
Access to Excel or an alternative spreadsheet programme is required. Calculators and internet access would also be useful.
Students could be given a virtual sum of money to invest in one of the available savings accounts in order to maximise their return. Reference to ISAs, variable rates and long-term investments should be made.
This is a resource developed by the Nuffield Foundation for the FSMQs and can be accessed at www.nuffieldfoundation.org/fsmqs/level-2-financial-calculations