Data Science — Spreadsheets and Charts — Year 5 Lesson Plan
National Curriculum: Computing KS2 — collect, analyse, evaluate and present data and information; select, use and combine a variety of software to accomplish given goals.
Overview
Pupils work with a larger, real-world-inspired dataset to develop skills in data analysis. They use advanced formulas including MAX, MIN, and IF to extract insights, create and evaluate a range of chart types (bar, pie, and line), and write a structured data analysis report presenting their findings with supporting evidence. The unit develops the ability to move from raw data to meaningful conclusions — a skill central to computing, mathematics, and science.
Learning Objectives
- Use MAX, MIN, and IF formulas in a spreadsheet to interrogate a dataset.
- Choose an appropriate chart type to represent different kinds of data and justify the choice.
- Interpret charts to draw conclusions and identify patterns or anomalies.
- Write a structured data analysis report with findings supported by charts.
Key Vocabulary
Suggested Lesson Structure
Display three different chart types (bar chart, pie chart, line graph) all showing the same fictional school attendance data. Ask pupils: which chart best shows change over time? Which best shows proportions? Which makes individual values easiest to compare? Collect reasoning. Establish that choosing the right chart type is as important as having the right data.
Open a shared spreadsheet containing data about monthly rainfall across five cities over a year (real or plausible fictional data). Demonstrate: use MAX to find the wettest month; use MIN to find the driest; write an IF formula to flag months where rainfall exceeded 100 mm as 'High' and others as 'Normal'. Create a line graph showing rainfall over the year for one city, label axes, and add a title. Then create a bar chart comparing average rainfall across all five cities. Discuss: which chart is better for which question?
In pairs, pupils open the shared dataset and complete a set of guided tasks: find the city with the highest and lowest average rainfall using MAX and MIN; add an IF column to flag anomalously high values; create a line graph for a second city and annotate the highest and lowest points. Pupils compare their charts with another pair and discuss whether they tell the same story.
Pupils choose a different aspect of the dataset (e.g. comparing three cities, or looking at seasonal patterns) and create their own analysis: at least one chart and a short written commentary (three to four sentences) explaining what the chart shows and what conclusion can be drawn from it.
Share one anonymised pupil analysis. Ask the class: is the chart the right type for the question being answered? Does the written commentary match what the chart shows? Are there any other patterns the pupil could have commented on? Reinforce: good data analysis requires selecting the right representation and then explaining it clearly.
Common Misconceptions
- Pupils often assume that a larger dataset automatically produces more meaningful results — discuss data quality versus data quantity and the concept of outliers distorting averages.
- Pupils sometimes use a pie chart for data that changes over time (e.g. monthly values) — emphasise that pie charts show proportions of a whole at one moment, not change across time.
Prior Knowledge
Pupils should already be able to:
- Experience using SUM and AVERAGE formulas and creating simple bar charts in Year 4.
- Ability to read and interpret charts from Maths.
Want a personalised version of this lesson?
Use Staffroom to generate a complete lesson plan tailored to your class — add context about ability, recent learning, or specific pupils and get a plan ready to teach. Free trial, no card required.