Skip to content
Oak National Academy
Oak National Academy
Teachers
Pupils
icon-background-square
New
New
Year 8

Constructing bar charts by utilising technology

I can construct bar charts from data using technology.

Download all resources
arrow-right
Share activities with pupils
arrow-right
icon-background-square
New
New
Year 8

Constructing bar charts by utilising technology

I can construct bar charts from data using technology.

Download all resources
arrow-right
Share activities with pupils
arrow-right
warning

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.
View new resources
arrow-right

Lesson details

Key learning points

  1. Bar charts can be constructed quickly using spreadsheets.
  2. Bar charts can be constructed quickly using Desmos.
  3. A template file can be used to make bar chart creation quick and easy.

Keywords

  • Frequency - The frequency is the number of times an event occurs; or the number of individuals (people, animals etc.) with some specific property.

  • Bar chart - A bar chart (bar graph) is a graph consisting of bars visually representing the frequency of objects or groups.

  • Data - Data are a collection of information.

Common misconception

Pupils may select additional cells which will cause their chart to look strange.

They can edit the data selected or delete the chart and start again.

You may wish to set up your own data file to allow pupils to investigate all the formatting tools available.
speech-bubble
Teacher tip
copyright

Licence

This content is © Oak National Academy Limited (2024), licensed on

Open Government Licence version 3.0
except where otherwise stated. See Oak's terms & conditions (Collection 2).

Lesson video

Skip lesson video

Loading...

Starter quiz

Download starter quiz

6 Questions

Q1.
A is a graph consisting of bars visually representing the frequency of objects or groups.
Correct Answer: bar graph, bar chart
Q2.
What is the frequency of 'planet' according to this bar chart?
An image in a quiz
2
Correct answer: 4
6
Q3.
Starting with the least amount of time spent reading put the months in order from least to greatest.
An image in a quiz
1 - month 2
2 - month 3
3 - month 1
Q4.
The had the same amount of visitors on both Saturday and Sunday.
An image in a quiz
Correct Answer: theatre, Theatre
Q5.
Which charts represent this data?
An image in a quiz
An image in a quiz
Correct Answer: An image in a quiz
An image in a quiz
Correct Answer: An image in a quiz
An image in a quiz
An image in a quiz
Q6.
Frequency is always found on the vertical axis of a bar chart. True or false?
True - the categories are along the horizontal axis. e.g. food types
Correct answer: False - bar charts can be horizontal rather than vertical

Exit quiz

Download exit quiz

6 Questions

Q1.
A file is used to support the creation of multiple charts with similar formatting and style.
Correct Answer: template
Q2.
Microsoft Excel and Google Sheets are two examples of software.
Correct Answer: spreadsheet
Q3.
Put the steps for chart creation in order.
1 - Input data to the spreadsheet
2 - Select all the data to be included
3 - Click insert chart
4 - Choose desired chart i.e. pie chart or bar chart
5 - Edit formatting as required
Q4.
The frequency scale is auto generated by the software. Can it be changed?
Correct answer: Yes - nearly all of the parts of the bar chart can be changed using the editor.
No - it is auto generated and therefore fixed.
Q5.
When data has been copied into the spreadsheet software, each piece of data needs to be in its own cell and the list needs to be .
Correct Answer: vertical
Q6.
These buttons insert charts on MS Excel and Google Sheets respectively, but where can you find them?
An image in a quiz
Under 'View' on the top ribbon
Correct answer: Under 'Insert' on the top ribbon
Under 'Data' on the top ribbon
Correct answer: On the shortcut bar
On the right click options