Using data to make recommendations
I can analyse visualisations to draw conclusions and report findings.
Using data to make recommendations
I can analyse visualisations to draw conclusions and report findings.
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
Lesson details
Key learning points
- Graphs and charts can be used to visualise data and make it easier to understand.
- By looking at visualisations, patterns can be spotted, trends can be seen over time.
- Unusual data (outliers) can be identified and removed.
- A report can be used to present conclusions and findings from data analysis.
Keywords
Visualisation - a variety of techniques used to illustrate a problem and/or its solution to make it easier to understand
Conclusion - a judgement or decision reached by reasoning or using data
Common misconception
A visualiation will always tell you the information you need to know.
You may need to refine or collect more data to create visualisations which answer your questions effectively.
To help you plan your year 9 computing lesson on: Using data to make recommendations, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your year 9 computing lesson on: Using data to make recommendations, 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 3 computing lessons from the Using data science unit, dive into the full secondary computing curriculum, or learn more about lesson planning.
File needed for this lesson
- litter-sample-data 20.7 KB (XLSX)
Download this file to use in the lesson.
Equipment
Pupils will need access to oak.link/codap-new for this lesson.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.What is one possible effect of using data that has not been cleansed?
Q2.Which of these would you most likely remove during data cleansing?
Q3.Why might real world data contain errors or missing information?
Q4.Put these steps in order for preparing data for a chart.
Q5.What is one benefit of creating a chart from cleansed data?
Q6.Match each data issue to its solution.
remove or fill with a sensible value
delete extra copies
change to the correct type
check and correct the value
Assessment exit quiz
6 Questions
Q1.Match each keyword to its meaning.
a technique to show data in charts or graphs
a judgement based on data analysis
a value that stands out from the rest
a repeated trend or feature in the data
Q2.Why might you remove outliers from your data before drawing conclusions?
Q3.Which statement about visualisations is incorrect?
Q4.Match each step to its purpose.
Spot patterns and trends.
Decide what the data shows.
Make your results more accurate.
Share your answers.