Year 6 - Computing
Using formulas in a spreadsheet
Introduction to spreadsheets
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
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 use spreadsheet functions that work with ranges of cells.
Key Notes
- A range of cells is a collection of cells located directly next to each other.
- A function in a spreadsheet performs a preset formula to a cell using any number of other cells.
- Use of pre-built functions in spreadsheets makes it easier to perform complex calculations.
Vocabulary To Learn
- function: a ready-made instruction that performs a specific mathematical job
- range: a group of cells that are next to each other
Common Mistakes To Avoid
- You should create a formula in a spreadsheet yourself even if a pre-built function already exisits that does what you need your formula to do.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
A range of cells is a collection of cells located directly next to each other. A function in a spreadsheet performs a preset formula to a cell using any number of other cells.
2. Define this computing term and give one practical example. 'function'
a ready-made instruction that performs a specific mathematical job. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: You should create a formula in a spreadsheet yourself even if a pre-built function already exisits that does what you need your formula to do. Correction: Use pre-built spreadsheet functions whenever possible to save time and avoid mistakes. Use of technology should help you find ways to assist in what you need to do.
More Lessons In This Unit
Browse all guides in the Year 6 Computing guide library.