Introduction to spreadsheets
Downloads can take a few minutes, especially for larger files or slower connections.
Threads
Why this why now
Having already explored ways of collecting and presenting data, pupils are now ready to organise and manipulate information using spreadsheets. This unit shows them how to structure data into columns and rows, format it clearly, and apply simple formulas to perform calculations. Learning this now helps pupils see how spreadsheets can be used to analyse and interpret data efficiently, a skill with clear applications across beyond computing and everyday problem-solving in the wider world.
Prior knowledge requirements
- Pupils understand the representation of numerical information in graphical form.
- Pupils recognise that data can take different forms.
- Pupils recognise that data types describe the form that data will take.
- Pupils can perform calculations that involve totalling quantities and costs of items.
Threads
Why this why now
Having already explored ways of collecting and presenting data, pupils are now ready to organise and manipulate information using spreadsheets. This unit shows them how to structure data into columns and rows, format it clearly, and apply simple formulas to perform calculations. Learning this now helps pupils see how spreadsheets can be used to analyse and interpret data efficiently, a skill with clear applications across beyond computing and everyday problem-solving in the wider world.
Prior knowledge requirements
- Pupils understand the representation of numerical information in graphical form.
- Pupils recognise that data can take different forms.
- Pupils recognise that data types describe the form that data will take.
- Pupils can perform calculations that involve totalling quantities and costs of items.
Introduction to spreadsheets
This unit introduces pupils to how spreadsheets can be used to organise data and create their own data sets. They will discover the importance of formatting data to support calculations, while also examining how formulas can be used to produce calculated data and how graphs can present this data.
6 lessons in unit
slide decks, worksheet PDFs, quizzes and lesson overviews. You can select individual lessons from the Introduction to spreadsheets unit and download the resources you need, or download the entire unit now. See every unit listed in our primary computing curriculum and discover more of our teaching resources for primary computing programmes.