Year 6

Year 6

# Calculate and duplicate

## Lesson details

### Key learning points

1. In this lesson, we will recognise that data can be calculated using different operations: multiplication, subtraction, division and addition. We will create formulas in a spreadsheet. We will then understand the importance of creating formulas that include a range of cells.

### Licence

This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.

## Video

Share with pupils

## Worksheet

Share with pupils

## Starter quiz

Share with pupils

### 4 Questions

Q1.
What does this operator mean in a spreadsheet / ?
Multiply
Q2.
What does this operator mean in a spreadsheet * ?
Subtract
Q3.
Give the cell reference of the colored cell
A1
A2
B1
Q4.
The Subtotal column in the spreadsheet section below has been calculated using a formula. Which cell could be changed to change the value shown in D2?
A1
A2

## Exit quiz

Share with pupils

### 3 Questions

Q1.
Which of these statements are true about spreadsheets? (Tick all that apply)
Calculations can be used on any data type in a spreadsheet
Correct answer: Data can be calculated using different operations within the spreadsheet
Correct answer: When using formulas with cell references; changing one cell can change another
Q2.
Using the spreadsheet, which formula is the correct formula to calculate the subtotal for bananas?