Starter quiz
- Why is it important to organise data?
- to make it easier to understand ✓
- to make it look pretty
- to make it harder to find
- to confuse others
-
- What is a spreadsheet?
- a piece of paper with data
- a tool for drawing pictures
- an electronic document for organising data ✓
- a type of graph
-
- Match the terms with their definitions.
- row⇔a horizontal line of data ✓
- column⇔a vertical group of data ✓
- cell⇔a rectangular box in a spreadsheet ✓
- formula⇔a calculation in a spreadsheet ✓
- function⇔a ready-made instruction for a calculation ✓
- range⇔a group of cells next to each other ✓
- What is the cell reference for the first cell in a spreadsheet?
- 'A1' ✓
- If we wanted to add up all the cells between B2 to B10 using a function, what would we type in?
- '=SUM(B2:B10)' ✓
- What is a budget used for?
- organising data
- calculating totals
- creating graphs
- planning spending ✓
-
Exit quiz
- What is the main purpose of a chart?
- to organise raw data
- to calculate totals
- to represent data graphically ✓
- to format a spreadsheet
-
- Match the terms with their definitions.
- chart⇔a graphical representation of data values ✓
- pie chart⇔a circular chart showing percentages of a total ✓
- bar chart⇔a chart that uses rectangles to compare different data values ✓
- table⇔a structured way of showing exact data values ✓
- What does a pie chart show?
- data in rows and columns
- percentages of a whole ✓
- exact data values
- mathematical operations
-
- What type of chart uses rectangles to compare different data values?
- 'bar chart' ✓
- What is a common limitation of charts?
- They are difficult to create.
- They don’t show patterns.
- They don’t provide exact values. ✓
- They can’t be used with tables.
-
- Which of the following is true about charts and tables?
- Charts are not suitable for showing exact values. ✓
- Tables are always harder to understand than charts.
- Tables are better for spotting patterns in data.
- The only type of chart is a pie chart.
-
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Video
Lesson Details
Key learning points
- A chart is a graphical representation of data values.
- Different types of chart are useful for different reasons.
- A pie chart is useful visual method of comparing percentages of data values against a total.
- Tables and graphical charts should be used together to present data in most effective way.
Common misconception
Graphically presented data is always easier to understand than data in tables.
Graphical charts help to spot patterns in the data they are based on but they are not intended to be able to read actual values. Tables should be used to provide the exact values.
Keywords
Chart - a way of presenting data graphically
Pie chart - a circular chart where sectors represent different groups in proportion to each other
+