Event planning
Slide deck
Download slide deck
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.
Video
Share with pupils
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