Improving a spreadsheet model
I can use a range of tools to improve a spreadsheet model.
Improving a spreadsheet model
I can use a range of tools to improve a spreadsheet model.
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
Lesson details
Key learning points
- A spreadsheet model is used to represent a real-world situation.
- It uses data to help you to understand a real-life scenario and to make plans.
- A macro is a recorded set of actions that can be repeated automatically in a spreadsheet.
- Macros can be recorded using built-in tools and assigned to buttons for easy access.
- Using macros can make spreadsheet models more efficient and easier to use.
Keywords
Model - a set of data, formulas and calculations used to test different situations
Macro - a recorded set of steps in a spreadsheet
Common misconception
A macro can only be used to clear data in a spreadsheet.
A macro is used to record and repeat tasks that can be automated in a spreadsheet. They are not just used to clear or reset data.
To help you plan your year 11 computing lesson on: Improving a spreadsheet model, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your year 11 computing lesson on: Improving a spreadsheet model, download all teaching resources for free and adapt to suit your pupils' needs.
The starter quiz will activate and check your pupils' prior knowledge, with versions available both with and without answers in PDF format.
We use learning cycles to break down learning into key concepts or ideas linked to the learning outcome. Each learning cycle features explanations with checks for understanding and practice tasks with feedback. All of this is found in our slide decks, ready for you to download and edit. The practice tasks are also available as printable worksheets and some lessons have additional materials with extra material you might need for teaching the lesson.
The assessment exit quiz will test your pupils' understanding of the key learning points.
Our video is a tool for planning, showing how other teachers might teach the lesson, offering helpful tips, modelled explanations and inspiration for your own delivery in the classroom. Plus, you can set it as homework or revision for pupils and keep their learning on track by sharing an online pupil version of this lesson.
Explore more key stage 4 computing lessons from the Spreadsheets unit, dive into the full secondary computing curriculum, or learn more about lesson planning.
Files needed for this lesson
- RSC competition 50.83 KB (XLSX)
- RSC live show event 87.04 KB (XLSM)
Download these files to use in the lesson.
Equipment
You may need to allow the use of macros on school systems for this lesson. This lesson is modelled using Google Sheets and some features may not work in alternative spreadsheet software.
Licence
Lesson video
Prior knowledge starter quiz
6 Questions
describes the chart’s purpose
helps you read values accurately
shows parts of a whole
compares data across categories
Assessment exit quiz
6 Questions
macro
spreadsheet model
formula
chart