Cover lesson · Social Studies · Year 10 · Intermediate

Measuring digital exclusion with data

DCF: Data and computational thinking → Data and information literacy

Name: Class: Date:

Cover teacher: you need no subject knowledge

What this practises: GCSE Social Studies (Made for Wales) Unit 1: Society and Social Issues. Section 1.1.2 Understanding and transforming data about society (mean, median, mode, percentages, range, drawing graphs, identifying weaknesses in the presentation of data) applied to section 1.3.3 Digital exclusion (causes, overrepresented groups, and difficulties faced when researching digital exclusion).

Print: this sheet, one per pupil, and the stimulus sheet “Who is offline in Cwm Eithin? The survey pack”, one between two. Pupils need a calculator and a ruler. No computers are needed. All 200 answers are in eithin-digital-survey.csv if you are in a computer room and pupils finish early.

Run: 5 min read the survey pack in pairs · 10 min Step 2, averages · 10 min Step 3, percentages · 12 min Step 4, draw the bar chart · 10 min Step 5, weaknesses in two charts · 8 min Step 6, conclusion, alone. Total 55 minutes.

Collect: this sheet. The worked example has every answer. Key answers: mean 4.3 hours, median 3, mode 2, range 13; 34.0% of adults aged 75 and over do not use the internet, against 15.0% of all adults.

What you are doing

A community group in a Welsh village surveyed 200 adults to find out who does not use the internet, and why. You are going to analyse their data, turn part of it into a bar chart, and find the weaknesses in two charts that other people made about the same village. Then you will write a conclusion that the community group could act on.

Step 1: read the survey pack

Read sections 1 to 7 with your partner. Pay close attention to section 1: how the data was collected matters as much as the numbers.

Step 2: averages

Use the hours online for the 15 people in section 4. Write the values in order first.

Mean (1 decimal place)MedianModeRange

Which average best describes a typical person in this group? Why? Hint: look at person 13.

Step 3: percentages

For each group, what percentage do not use the internet? Give answers to one decimal place.

GroupWorking% not online
All adults
Aged 16 to 34
Aged 35 to 54
Aged 55 to 74
Aged 75 and over
Village centre
Outlying farm or hamlet
Disabled
Not disabled

(a) Describe the pattern across the four age groups in one sentence.

(b) Which three groups are overrepresented among people who are offline? Hint: people aged 75 and over are 50 of the 200 adults asked. How many of the 30 offline adults are they?

Step 4: draw the bar chart

Draw a bar chart of the main reasons in section 3. You need: a title, both axes labelled, a scale that goes up in equal steps from 0, and bars of equal width with gaps between them. Put the bars in order, biggest first.

Which cause of digital exclusion should the Community Hub’s free sessions help with most, and which cause can a session not fix?

Step 5: weaknesses in two charts

Look at Chart A and Chart B in the survey pack. Find at least two weaknesses in the way each one presents data. Think about the axis, the numbers, who was asked, how they were asked, and who made the chart.

 WeaknessWhy it could mislead someone
Chart A
Chart A
Chart B
Chart B

Step 6: your conclusion

On your own, write 80 to 120 words for the Community Hub: Who is most likely to be digitally excluded in Cwm Eithin, and why? Use at least three figures from your work. End with one difficulty of researching digital exclusion that their door-to-door survey got right, or still got wrong.

Step by step

  1. 5 min Read the survey pack. Notice how the data was collected.
  2. 10 min Put the hours in order. Find the mean, median, mode and range.
  3. 10 min Work out the nine percentages and answer (a) and (b).
  4. 12 min Draw the bar chart of main reasons with a ruler.
  5. 10 min Find two weaknesses in each chart.
  6. 8 min Write your conclusion on your own.

Success criteria

If you finish early