Choose exam board for KS4 Computer Science (GCSE)
Choose exam board for KS4 English
Choose exam board for KS4 French
Choose exam board for KS4 Geography
Choose exam board for KS4 German
Choose exam board for KS4 History
Choose tier for KS4 Maths
Choose exam board for KS4 Music
Choose exam board for KS4 Physical education (GCSE)
Choose exam board for KS4 Religious education (GCSE)
Choose exam board for KS4 Spanish

Statistical summaries using technology

Lesson details

Learning outcome

I can use technology to effectively summarise and represent data.

Key learning points

  1. Technology can be used to calculate numerical summary statistics.
  2. Technology can be used to create visual representations of data.
  3. It is important to select appropriate representations and summaries based on context and the type of data.

Keywords

  • Statistical summary - A statistical summary sums up the features of a data set.

Common misconception

Spreadsheets should always be used for data analysis as they are perfect.

Spreadsheet software is incredibly powerful but care should be taken as human error can lead to incorrect results.

Teacher tip

This lesson requires pupils to use a device that can access the internet. They will be using sets of data provided. The data can be downloaded before the lesson and saved locally if preferred.

Licence

This content is © Oak National Academy Limited (2025), licensed on Open Government Licence version 3.0
except where otherwise stated. See Oak's terms & conditions
(Collection 2).

Lesson video

Loading...

Prior knowledge starter quiz

6 Questions

Q1.
A __________ is a circular graph where sectors represent different groups proportionally.

bar chart
pictogram
Correct answer: pie chart
scatter graph
time series graph

Q2.
Find the mode of the following numbers: 15, 13, 20, 15, 17, 16.

Correct Answer: 15, Fifteen

Q3.
Find the median of the following numbers: 15, 13, 20, 15, 17, 16.

Correct Answer: 15.5, Fifteen point five

Q4.
Find the range of the following numbers: 15, 13, 20, 15, 17, 16.

Correct Answer: 7, seven

Q5.
Find the mean of the following numbers: 15, 13, 20, 15, 17, 16.

Correct Answer: 16, sixteen

Q6.
An estimate for the mean of the data presented in the table is kilograms.

An image in a quiz
Correct Answer: 28, twenty eight

6 Questions

Q1.
A __________ sums up the features of a data set.

data cycle
graph
sample
Correct answer: statistical summary

Q2.
When using spreadsheet software, which command would calculate the mean for a column of numerical data?

average(A1:A10)
mean(A1:A10)
Correct answer: =average(A1:A10)
=mean(A1:A10)

Q3.
When using spreadsheet software, which command would calculate the range for a column of numerical data?

max(A1:A10)-min(A1:A10)
range(A1:A10)
Correct answer: =max(A1:A10)-min(A1:A10)
=range(A1:A10)

Q4.
When using spreadsheet software, which command would calculate the median for a column of numerical data?

median(A1:A10)
middle(A1:A10)
Correct answer: =median(A1:A10)
=middle(A1:A10)

Q5.
When using spreadsheet software, what symbol represents multiplication?

Correct Answer: *, asterisk

Q6.
When using spreadsheet software, what symbol represents division?

Correct Answer: /, slash, forward slash

To help you plan your 10 maths lesson on: Statistical summaries using technology, download all teaching resources for free and adapt to suit your pupils' needs...