Year 6
Event planning
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.
Year 6
Event planning
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.
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
Lesson details
Key learning points
- 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.
Loading...
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
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)
A data heading
The total cost of items
The total of A1 and A4
3 Questions
Q1.
Why are data headings important? (Tick 2 boxes)
They allow us to experiment with formatting.
They look attractive on a spreadsheet.
Q2.
Why should data be organised? (Tick 2 boxes)
It stifles creativity.
Makes the spreadsheet attractive.
Q3.
What calculation in your formula will you use to find C2-Total budget?
A2-B2
A2/B2
A2+B2