Event planning using a spreadsheet
Lesson details
Learning outcome
I can use a spreadsheet to plan an event.
Key learning points
- Spreadsheets are useful as planning tools.
- A budget is a value of money that can be spent as part of a plan.
- Subtotals are used to work out overall totals in smaller steps.
Keywords
Budget - an amount of money planned to be spent
Subtotal - a part of an overall total based on some of the values
Common misconception
Spreadsheets make planning an event more difficult as you have to enter data and use formulas.
Spreadsheets make planning an event easier as they have useful tools that save you work and allow you to make changes. You can use spreadsheets to model changes to the event and instantly recalulate all the important information.
Teacher tip
The context for this lesson is easily changed. It helps to find a context appropraite to your school and pupils. If they can see the practical implications of using a spreadsheet to plan they are more likely to reuse the software for similar tasks in the future.
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
party-planning-spreadsheet 95.83 KB (XLSX)
Download this file to use in the lesson.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.Put these steps for dealing with data in the correct order.
Q2.What symbol is used to start a formula in a spreadsheet?
Q3.What do you call a group of cells used in a formula?
Q4.Write the formula to subtract cell A5 from B8.
Q5.What does the SUM function do in a spreadsheet?
Q6.What does the term 'replicate' mean in the context of spreadsheets?
Assessment exit quiz
6 Questions
Q1.Match the terms with their definitions.
Q2.How do spreadsheets make planning an event easier?
Q3.What is the smallest unit of data storage in a spreadsheet where you can enter information?
Q4.What does it mean to replicate a formula in a spreadsheet?
Q5.Why do people create budgets?
Q6.Order these steps for using a spreadsheet when budgeting.
To help you plan your 6 computing lesson on: Event planning using a spreadsheet, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 6 computing lesson on: Event planning using a spreadsheet, 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 2 computing lessons from the Introduction to spreadsheets unit, dive into the full primary computing curriculum, or learn more about lesson planning.