Cover lesson · Social Studies · Year 10 · Intermediate
DCF: Data and computational thinking → Data and information literacy
Name: Class: Date:
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.
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.
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.
Use the hours online for the 15 people in section 4. Write the values in order first.
| Mean (1 decimal place) | Median | Mode | Range |
|---|---|---|---|
Which average best describes a typical person in this group? Why? Hint: look at person 13.
For each group, what percentage do not use the internet? Give answers to one decimal place.
| Group | Working | % 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?
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?
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.
| Weakness | Why it could mislead someone | |
|---|---|---|
| Chart A | ||
| Chart A | ||
| Chart B | ||
| Chart B |
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.
COUNTIFS to find how many offline adults are both aged 75 and over and live in an outlying farm or hamlet.