Using formulas in a spreadsheet
Lesson details
Learning outcome
I can use spreadsheet functions that work with ranges of cells.
Key learning points
- 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.
Keywords
Function - a ready-made instruction that performs a specific mathematical job
Range - a group of cells that are next to each other
Common misconception
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.
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.
Teacher tip
Functions have similarities to function machines in maths. Draw on pupils experiences of using them to produce outputs based on a specified input.
Equipment
Pupils will need access to a device with spreadsheet software. Examples in this lesson use Google Sheets https://oak.link/google-sheets
File needed for this lesson
Using spreadsheet functions 57.15 KB (XLSX)
Download this file to use in the lesson.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.What is the main purpose of using a table to organise data?
Q2.What does 'replicate' mean in the context of spreadsheets?
Q3.What is a rectangular box in a spreadsheet called?
Q4.What is used to perform calculations in a spreadsheet?
Q5.Type the formula to add cell A1 to B3:
Q6.Type the formula to divide B1 by C1:
Assessment exit quiz
6 Questions
Q1.What does a range of cells refer to in a spreadsheet?
Q2.How would you type in the range of cells that include A1, A2, A3, B1, B2 and B3.
Q3.Which of the following is NOT a benefit of using spreadsheet functions?
Q4.What should you do if a pre-built function exists for your calculation needs?
Q5.How do you calculate the average of values in cells A1 to A5 using a spreadsheet function?
Q6.Match the term to its definition:
A mathematical expression that calculates a value.
An operation that performs calculations on a range of data.
The total of a group of numbers.
The number of items in a range.
The mean value of a group of numbers.
To help you plan your 6 computing lesson on: Using formulas in a spreadsheet, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 6 computing lesson on: Using formulas in a spreadsheet, 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 2 computing lessons from the Introduction to spreadsheets unit, dive into the full primary computing curriculum, or learn more about lesson planning.