Comparing data visually
Lesson details
Learning outcome
I can explain that computer programs can be used to compare data visually.
Key learning points
- Charts can be used to visually compare data.
- Charts can be refined by selecting a particular filter.
- Computer-based charts can be edited and refined more easily than paper-based charts.
Keywords
Chart - a way of presenting data graphically
Axis - a line on a chart that shows what the data means
Common misconception
All charts made from the same data are equally useful.
Some charts might not help answer a specific question, even if they are accurate. Choosing the right chart type and structure matters.
Teacher tip
Model how the same dataset can be used to create different types of charts, helping pupils choose the most effective visual representation.
Equipment
Pupils will need access to a device with database software. Examples in this lesson use J2E database https://oak.link/database
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.What does the term 'AND' do in a database search?
Q2.What does the term 'OR' do in a database search?
Q3.What is the name for a category used to organise data in a database?
Q4.If you want to find all students who play football and are in Year 5, which search term would you use?
Q5.Match the following examples to their database terms.
field
value
search criteria
Q6.Put these steps in order to perform a search in a database.
Assessment exit quiz
6 Questions
Q1.What is the purpose of a chart?
Q2.What is the name of a line on a chart that shows what the data means?
Q3.Which of the following is a benefit of computer-based charts?
Q4.Why might one chart be better than another for the same data?
Q5.Match the following terms to their correct definitions.
a chart type used to compare data with rectangular bars
a chart type used to show proportions or percentages
a line on a chart that explains what the data represents
a label that describes the purpose or content of the chart
a way to refine data to show specific information
Q6.Why is it important to label the axes on a chart?
To help you plan your 5 computing lesson on: Comparing data visually, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 5 computing lesson on: Comparing data visually, 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 Flat-file databases unit, dive into the full primary computing curriculum, or learn more about lesson planning.