Constructing bar charts by utilising technology | Maths

Starter quiz

A ______ is a graph consisting of bars visually representing the frequency of objects or groups.

'bar graph' ✓
What is the frequency of 'planet' according to this bar chart?

2

4 ✓

6
Starting with the least amount of time spent reading put the months in order from least to greatest.

1

⇔

month 2

2

⇔

month 3

3

⇔

month 1
The ______ had the same amount of visitors on both Saturday and Sunday.

'theatre' ✓
Which charts represent this data?
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

False - bar charts can be horizontal rather than vertical ✓

A ______ file is used to support the creation of multiple charts with similar formatting and style.

'template' ✓
Microsoft Excel and Google Sheets are two examples of ______ software.

'spreadsheet' ✓
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
The frequency scale is auto generated by the software. Can it be changed?

Yes - nearly all of the parts of the bar chart can be changed using the editor. ✓

No - it is auto generated and therefore fixed.
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 ______.

'vertical' ✓
These buttons insert charts on MS Excel and Google Sheets respectively, but where can you find them?

Under 'View' on the top ribbon

Under 'Insert' on the top ribbon ✓

Under 'Data' on the top ribbon

On the shortcut bar ✓

On the right click options

Loading worksheet ...

Loading presentation ...

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.

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.