ScholaFly

GE06-06 Geography Watch

Reading a data table and drawing a conclusion

Watch on YouTube

In this lesson

Reading a data table: how to read a table of data - its title, units, rows, columns and date, with worked examples and the mistakes examiners report. AQA 8035, Edexcel 1GA0, Edexcel 1GB0, Eduqas C111, Eduqas C112, OCR J383 and OCR J384 GCSE. Maths for geography 6 of 6. More at https://scholafly.com

What it covers

  1. 0:00 Intro: reading a data table
  2. 0:49 Reading a table
  3. 2:05 Describe or conclude
  4. 6:21 Manipulate the data
  5. 9:57 True or false

About this video

Reading a data table and drawing a conclusion | GCSE Geography | GE06-06

Reading a data table: how to read a table of data - its title, units, rows, columns and date, with worked examples and the mistakes examiners report.
AQA 8035, Edexcel 1GA0, Edexcel 1GB0, Eduqas C111, Eduqas C112, OCR J383 and OCR J384 GCSE. Maths for geography 6 of 6.
More at https://scholafly.com

Video code: GE06-06 (search "ScholaFly GE06-06")

#GCSEGeography #MathsForGeography #ReadingADataTable

For teachers
This GCSE Geography lesson teaches reading a data table and drawing a conclusion. By the end, students should be able to read a table of data - its title, units, rows, columns and date - and manipulate it (totals, differences, means, percentages) to draw an informed conclusion about a pattern between places or over time: a judgement across the data, backed by figures from it, naming any anomaly, and claiming no more than the data shows. It works through three worked examples and the mistakes examiners report.

Exam board specification references:
AQA 8035
- 3.4.3
Edexcel 1GA0
- IS:T1(10)
- IS:T1(14)
- IS:T2(6)
- IS:T5(1)
- IS:T5(3)
- MS:Numerical:4
Edexcel 1GB0
- MS-Num.4
- T2-IS(1)
- T2-IS(4)
Eduqas C111
- AppA:1.4
- Section 2
Eduqas C112
- AppA:1.4
- Sec 2
OCR J383
- 3.3(13)
- 3.3(7)
- 5d[numerical]-b4
OCR J384
- 5d[Numerical skills][4]
- 9.3.13
- 9.3.7

Read the transcript

Should a new health centre go to the ward with the most people in it? Picture a council in Hootley, in the fictional land of Owlobia, that can afford one new health centre. The officer's table lists five wards, with each ward's population, how many residents are over sixty-five, and how far it is to the nearest doctor. Ward A has by far the most people, so it looks like the obvious pick. It's the wrong one, and the table itself says so once it's read properly. Reading a table properly is a routine, and it starts before the numbers.

A data table is a grid of figures in rows and columns, and the first thing to read is everything around the figures. Read the title, what each row and each column holds, the units and the date. Then check whether the figures are totals, percentages or rates, because a total and a percentage can't be compared like for like. Then find the story. Look for the highest and the lowest, the biggest change, and either a trend over time or a contrast between places. A trend over time is called a temporal pattern. A difference between places is called a spatial pattern. Now try one. A table lists the mean July temperature at one weather station for each decade since the nineteen sixties. Think about what changes from one row to the next. Is that a temporal pattern or a spatial one? Temporal. It's one place, followed decade by decade through time.

To describe a table is to say what it shows. To conclude is to say what it means, a judgement across the data as a whole. Take that weather station, at Gradeley. Its mean July maximum was nineteen point eight degrees Celsius in the nineteen sixties, twenty point nought in the seventies and twenty point two in the eighties. After that it was twenty point seven in the nineties, twenty-one point two in the two thousands and twenty-one point eight in the twenty tens. Two students answer. Student A writes that the sixties were nineteen point eight degrees and the twenty tens were twenty-one point eight degrees. Student B writes that summers at the station have been getting warmer, by two degrees Celsius across the period. The question asked for a conclusion about how summers have changed. Which answer is the conclusion, and why? B is the conclusion. A copies two figures and says what the table shows, while B makes a judgement, that summers are warming, and backs it with a figure. One examiner's report on a question asking for conclusions notes that "some confused describing with giving a conclusion". The fix is to open the sentence with the judgement, what the data suggests, and bring the figures in as its evidence. A full conclusion has three parts. First the overall trend or contrast, then figures from the table as evidence, with units and years, then the anomaly, named. An anomaly is a value that doesn't fit the pattern, the same idea as an outlier in a set of data. Find how much of the two degrees came in the first two decades, and how much in the last three. Have a go at this one before I show you. From the sixties to the eighties, nineteen point eight rose to twenty point two, which is nought point four degrees Celsius. From the eighties to the twenty tens, twenty point two rose to twenty-one point eight, which is one point six degrees Celsius. That's about nought point two degrees a decade early on, against about nought point five a decade later. The conclusion is that summers at the station have been getting warmer, and faster since the nineteen eighties, with those figures as its evidence. Every decade here fits that trend, so this table has no anomaly to name. One examiner's report on a conclusion question says "Most candidates who gave a correct answer scored only one of the two available marks as no supporting data was supplied in the answers." The fix is a figure, with its unit, in every conclusion. If one conclusion is asked for, give one and back it with data, rather than adding a second. Claim only what the data shows. Say suggests rather than proves, and most rather than all, and leave out anything the table doesn't contain. One examiner's report, on a question about hot desert climate data, notes that "The simplest responses were the most successful", with high temperatures and low rainfall securing both marks for about two thirds of the students. The same report adds that other answers "included features of hot deserts not shown in the data, such as cold night time temperatures". The fix is to cover everything but the table. If a claim's evidence isn't in it, the claim goes, and keeping it that direct is what the best answers did.

Raw figures often hide the story, so the next step is to manipulate the data, turning counts into totals, differences, means, percentages or ranks. A percentage puts places of different sizes on the same footing. Saying one ward has three times another's share of over-sixty-fives says more than copying two counts across. The Hootley table runs like this. Ward A has fourteen thousand two hundred people, one thousand four hundred and twenty of them over sixty-five, and it's nought point eight kilometres to a doctor. Ward B has nine thousand six hundred people, two thousand eight hundred and eighty over sixty-five, and four point five kilometres to a doctor. Ward C has eleven thousand people, one thousand six hundred and fifty over sixty-five, and one point two kilometres. Ward D has six thousand five hundred people, one thousand nine hundred and fifty over sixty-five, and five point one kilometres. Ward E has eight thousand three hundred people, one thousand two hundred and forty-five over sixty-five, and two point nought kilometres to a doctor. The council's question is which ward should get the health centre, justified with the data. Turning each ward's older residents into a share of its people is the place to start. Try it on paper before I show you the answer. Ward A first. One thousand four hundred and twenty divided by fourteen thousand two hundred, times a hundred, is ten per cent, and a doctor is only nought point eight kilometres away. Ward B is two thousand eight hundred and eighty over nine thousand six hundred, times a hundred, which is thirty per cent, with the doctor four point five kilometres away. Wards C and E both come to fifteen per cent. Ward D comes to thirty per cent, level with B, at five point one kilometres. D is a little further away, but B has more older residents in total, two thousand eight hundred and eighty against one thousand nine hundred and fifty. The answer is Ward B. It has the joint highest share of over-sixty-fives, more older residents than any other ward, and a doctor four and a half kilometres away. The anomaly worth naming is Ward A. The biggest ward is among the least in need, the reverse of what its population suggests. One examiner's report on a graph of two linked measures notes that many students saw the main relationship, but "Only a minority were able to see any of the anomalies on the graph". The fix is one more question after every trend: which value doesn't fit? That's why the obvious pick was wrong. Ward A had the most people, but read as percentages, the table points to Ward B. When a question asks you to complete a table, fill every cell it asks for, totals included, and check a total against the column it adds up.

Some courses give several statements about a table and ask which one is true. Test each against the table, and reject any that says all or always, uses a wrong figure, or claims more than the data can show. Four towns' populations changed between twenty eleven and twenty twenty-one. Perchley went from twelve thousand to thirteen thousand eight hundred, and Talonford from forty-five thousand to forty-seven thousand two hundred and fifty. Featherby went from eight thousand to seven thousand six hundred, and Penbury from twenty thousand to twenty-four thousand. Here are the changes, already worked out. Perchley grew by one thousand eight hundred, Talonford by two thousand two hundred and fifty, Featherby fell by four hundred, and Penbury grew by four thousand. Statement A says all four towns grew. B says Talonford grew by the largest number of people. C says Penbury grew fastest, by twenty per cent. D says the data proves people moved from Featherby to Penbury. Test each one against the table before you choose. Which of the four statements is true? C is true. Penbury rose by four thousand on twenty thousand, which is twenty per cent, against fifteen per cent for Perchley and five for Talonford. A is false, because Featherby fell by four hundred. B is false, because Penbury's four thousand beats Talonford's two thousand two hundred and fifty. D is false too. The table shows totals, not who moved where, so it can't prove anything about migration. Weather data, rankings of countries and a country's economic data all take this same routine. Why a country ranks differently on different measures is in the video on the Human Development Index.

One last recap for the chapter, and the conclusions are yours to draw. What's the difference between describing a table and concluding from it? Describing says what the table shows. Concluding says what it means, a judgement across the data. Now a new table: crime fell as street lights doubled. Did the lights cause the fall? The table can't say that. It suggests a link, but it shows no cause, so the claim is one it can't support. Another one. Village one has ninety shops for nine thousand people, and village two has forty shops for two thousand. Which village has more shops per person? The second. It has twenty for every thousand, against ten for every thousand in the first. Now the shape: what three parts make a full conclusion? The overall trend or contrast, then figures from the table as evidence, then the anomaly, named. And the Hootley health centre goes to Ward B, because the table read as percentages beats the biggest number in it. That closes the chapter: every sum in it, from map areas to quartiles, is a tool for this last step.

If you can turn a table into one judgement, with figures and an anomaly, give this a thumbs-up, because there's no need to see this twice. If not, every paper keeps using this, so it comes back round.

The next chapter is Development: what it means and how we measure it. Hopefully that's next in your feed, but if not, search for ScholaFly G E oh seven, oh oh.

Every other video is on scholafly.com too, easy to search by video code or by keyword. Whatever you're revising, go there and have a look, or, watch the next video.

Related terms

For: AQA GCSE 8035, Edexcel GCSE 1GA0, Edexcel GCSE 1GB0, Eduqas GCSE C111, Eduqas GCSE C112, OCR GCSE J383, OCR GCSE J384

On the specification

BoardSpecStatement
AQA GCSE 80353.4.3
Edexcel GCSE 1GA0IS:T1(10)
Edexcel GCSE 1GA0IS:T1(14)
Edexcel GCSE 1GA0IS:T2(6)
Edexcel GCSE 1GA0IS:T5(1)
Edexcel GCSE 1GA0IS:T5(3)
Edexcel GCSE 1GA0MS:Numerical:4
Edexcel GCSE 1GB0MS-Num.4
Edexcel GCSE 1GB0T2-IS(1)
Edexcel GCSE 1GB0T2-IS(4)
Eduqas GCSE C111AppA:1.4
Eduqas GCSE C111Section 2
Eduqas GCSE C112AppA:1.4
Eduqas GCSE C112Sec 2
OCR GCSE J3833.3(13)
OCR GCSE J3833.3(7)
OCR GCSE J3835d[numerical]-b4
OCR GCSE J3845d[Numerical skills][4]
OCR GCSE J3849.3.13
OCR GCSE J3849.3.7
For teachers

This GCSE Geography lesson teaches reading a data table and drawing a conclusion. By the end, students should be able to read a table of data - its title, units, rows, columns and date - and manipulate it (totals, differences, means, percentages) to draw an informed conclusion about a pattern between places or over time: a judgement across the data, backed by figures from it, naming any anomaly, and claiming no more than the data shows. It works through three worked examples and the mistakes examiners report.