Study Hub

Study Guides

This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.

Back to Study HubBrowse Year 6 Computing Guides

Year 6 - Computing

Spreadsheet formulas

Introduction to spreadsheets

Unit Summary

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.

Lesson Summary

You will learn to calculate new data in a spreadsheet using formulas.

Key Notes

  • Formulas in a spreadsheet are used to perform common mathematical operations using data from cells.
  • Only cells that have a numerical data format can be used as part of a formula.
  • Spreadsheet formulas can use cell references as a part of a calculation.
  • Spreadsheet formulas can be duplicated to other cells and change their cell references accordingly.

Vocabulary To Learn

  • calculation: working out an answer using numbers and mathematical operations
  • operation: a mathematical action like adding, subtracting, multiplying, or dividing numbers
  • formula: performs calculations in a spreadsheet
  • replicate: to make a copy or repeat something in the same way

Common Mistakes To Avoid

  • Spreadsheet forumlas need to use values that are typed directly into the formula.

3 Quick Questions (With Answers)

1. Describe the system or process from this lesson in clear steps.

Formulas in a spreadsheet are used to perform common mathematical operations using data from cells. Only cells that have a numerical data format can be used as part of a formula.

2. Define this computing term and give one practical example. 'calculation'

working out an answer using numbers and mathematical operations. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: Spreadsheet forumlas need to use values that are typed directly into the formula. Correction: A formula in a spreadsheet should use cell references where possible. Whilst a forumla can use a typed value, cell references saves having to retype values and also benefits from updating the results of the calculation if data changes.

More Lessons In This Unit

Browse all guides in the Year 6 Computing guide library.