Year 6

Year 6

# What's the formula?

## Lesson details

### Key learning points

1. In this lesson, we will begin to use formulas to produce calculated data. We will learn that the type of data in a cell is important (e.g. numbers can be used in calculations whereas words cannot). Then we will create formulas to use in our spreadsheets using cell references

### 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.
Which format is best for the data held in a column with the data heading Discount?
Date
Time
Q2.
Which format is best for the data held in a column with the data heading Number of items sold?
Currency
Date
Q3.
Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)
£3.20
Apples
Q4.
Which number format has been applied to this piece of data? 12:05:00
Currency
Date
Italics

## Exit 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 * ?