Spreadsheet project I
Lesson details
Learning outcome
I can create a spreadsheet model for an event to investigate income and costs.
Key learning points
- A spreadsheet can be used to model real-world events.
- A spreadsheet can be used to calculate whether an event will make a profit, loss or break-even.
- A spreadsheet model can help event organisers decide what they should charge or whether they need to reduce costs.
Keywords
Fixed cost - something that will stay the same no matter how many people attend the event
Variable cost - changes depending on how many people attend the event
Profit - the amount of money made after subtracting all costs from total revenue
Loss - occurs when total costs are greater than total revenue
Break-even - the point at which the total revenue equals total costs
Common misconception
A spreadsheet can only be used to explore the costs of the event after it has happened.
A spreadsheet model can be used to predict and model the costs of the event before it happens to help the organisers make decisions about income and expenditure.
Teacher tip
Context for lessons helps pupils appreciate where what they are learning is useful in their everyday lives. Consider changing the context for this project if you think learners would be more interested in something else.
Equipment
Pupils will need access to a device with spreadsheet software. Examples in this lesson use Google Sheets https://oak.link/google-sheets
File needed for this lesson
prom-planning 8.27 KB (XLSX)
Download this file to use in the lesson.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.What does the fill handle do in a spreadsheet?
Q2.What spreadsheet formula would you use to multiply the value in cell A2 by the value in cell D10?
Q3.Match each formatting feature to its purpose:
combines cells
breaks text into multiple lines
highlights data based on criteria
improves appearance of data
Q4.What spreadsheet formula would you use to add together the values in cells A1 to A5?
Q5.Arrange these steps for using conditional formatting:
Q6.Match each keyword to its definition:
a set of data and formulas to test scenarios
a recorded set of steps
cell reference that changes when copied
cell reference that remains constant
Assessment exit quiz
6 Questions
Q1.What is a key benefit of using a spreadsheet model for an event?
Q2.What does “break-even” mean in the context of an event?
Q3.Which formula could calculate profit in a spreadsheet?
Q4.Match each keyword to its definition:
stays the same regardless of attendance
changes with number of attendees
money left after costs
costs greater than income
Q5.What formula would you use in a spreadsheet to find the mean average of values in cells C1 to C10?
Q6.Which statement is correct about using spreadsheets for event planning?
To help you plan your 11 computing lesson on: Spreadsheet project I, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 11 computing lesson on: Spreadsheet project I, download all teaching resources for free and adapt to suit your pupils' needs.
The starter quiz will activate and check your pupils' prior knowledge, with versions available both with and without answers in PDF format.
We use learning cycles to break down learning into key concepts or ideas linked to the learning outcome. Each learning cycle features explanations with checks for understanding and practice tasks with feedback. All of this is found in our slide decks, ready for you to download and edit. The practice tasks are also available as printable worksheets and some lessons have additional materials with extra material you might need for teaching the lesson.
The assessment exit quiz will test your pupils' understanding of the key learning points.
Our video is a tool for planning, showing how other teachers might teach the lesson, offering helpful tips, modelled explanations and inspiration for your own delivery in the classroom. Plus, you can set it as homework or revision for pupils and keep their learning on track by sharing an online pupil version of this lesson.
Explore more key stage 4 computing lessons from the Spreadsheets unit, dive into the full secondary computing curriculum, or learn more about lesson planning.