Spreadsheet project II
Lesson details
Learning outcome
I can use a spreadsheet to model different scenarios for an event and use the model to make recommendations.
Key learning points
- A spreadsheet model can be used for what-if analysis.
- Different types of charts are suitable for different purposes.
- The COUNTIF function can be used to count how many cells meet a set criterion.
Keywords
Scenario - where different sets of input values are used within a spreadsheet to explore various potential outcomes
COUNTIF - function used to count how many cells meet a set criterion
Common misconception
The COUNTIF function is the same as the COUNT function.
A COUNTIF function returns the total number of cells based on a set criterion, whereas the COUNT function returns the number of cells that contain a number in a range.
Teacher tip
Consider how this project could be used as part of other subjects. Spreadsheets are useful in many different applications and pupils would benefit from understanding this.
Equipment
Pupils will need access to a device with spreadsheet software. Examples in this lesson use Google Sheets https://oak.link/google-sheets
Files needed for this lesson
prom-planning-v2 1.14 MB (XLSX)
prom-ticket-sales 1.23 MB (XLSX)
Download these files to use in the lesson.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.What does the SUM function do in a spreadsheet?
Q2.What is a cell reference in a spreadsheet?
Q3.Match each function to what it does:
adds numbers
finds the mean
finds the smallest value
finds the largest value
Q4.Match each feature to its purpose:
identifies a cell’s location
changes cell appearance based on value
restricts what data can be entered
calculates values using cell data
Q5.What formula would you use to find the mean value of the numbers in cells A1 to A20 in a spreadsheet?
Q6.If you want to highlight all cells with values over 100, what should you use?
Assessment exit quiz
6 Questions
Q1.What is the main purpose of a spreadsheet model in what-if analysis?
Q2.Why would you use a chart in a spreadsheet model?
Q3.Which chart type is best for showing parts of a whole?
Q4.Arrange these steps for modelling a scenario:
Q5.Match each function to what it counts:
counts cells that contain numbers
counts all non-empty cells
counts cells that meet a set condition
Q6.Put these steps in order for using COUNTIF in a spreadsheet:
To help you plan your 11 computing lesson on: Spreadsheet project II, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 11 computing lesson on: Spreadsheet project II, 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.