KS1 & KS2 computing curriculum

Unit sequence

Filter and highlight

Year group

Highlight a thread
Computing
Year 6

Introduction to spreadsheets

6 lessons

Threads

  • Data and information
  • Effective use of tools

Description

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.

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.

  1. Collecting data
  2. Formatting a spreadsheet
  3. Spreadsheet formulas
  4. Using formulas in a spreadsheet
  5. Event planning using a spreadsheet
  6. Presenting data using charts

Use this KS1 and KS2 computing curriculum plan to explore our sequences developed by leading subject...

30 units shown,

Need help with our new curriculum?

Visit our help centre for technical support as well as tips and ideas to help you make the most of Oak.

Go to help centre