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 ✓
-
Exit quiz
- 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
-
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Lesson Details
Key learning points
- Bar charts can be constructed quickly using spreadsheets.
- Bar charts can be constructed quickly using Desmos.
- A template file can be used to make bar chart creation quick and easy.
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.
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.
+