Pupils should be able to:

• Save files in appropriate formats and create a hierarchical folder structure.
• Automate simple processes by harnessing software tools; recognise where automation tools, such as filtering, can be used to improve safety when using the internet.
• Combine variables within a model in different ways to form rules.
• Recognise that the rules contained within a model determine its output, and make more complex predictions based on several variables.
• Amend existing simple models by changing variables and formulae.

Pupils should be taught to:

• Use appropriate software to create a financial model.
• Find and use external data including test data.
• Use the spreadsheet to model break-even points.
• Some pupils may extend their spreadsheet by using command buttons and graphs.