Year 6

Year 6

# Event planning

## Lesson details

### Key learning points

1. In this lesson, we will plan and calculate the cost of an event using a spreadsheet. We will use a list to choose what we would like to include in our event, and use our spreadsheet to answer questions on the data we have selected.

### 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

### 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?
=B3xC3
=C3*D3
=C3xD3
Q3.
3) What does this SUM function calculate?=SUM(A1:A4)
The total cost of items
The total of A1 and A4
Correct answer: The total of A1, A2, A3 and A4

## Exit quiz

Share with pupils

### 3 Questions

Q1.
Why are data headings important? (Tick 2 boxes)
They allow us to experiment with formatting.
Correct answer: They enable us to keep the data organised.
Correct answer: They help for effective use of formula.
They look attractive on a spreadsheet.
Q2.
Why should data be organised? (Tick 2 boxes)
Correct answer: It is easier to perform calculations using the data.