Printable · GCSE Foundation · ages 14-16
Tables, charts and diagrams for data worksheet — GCSE Foundation
Fifteen questions on "tables, charts and diagrams for data" — DfE statement S2. Print it, or print three versions so neighbours cannot copy by letter; the key gives the letter for each version.
Tables, charts and diagrams for data worksheet — GCSE Foundation
MathsUKwww.geekhero.co.uk
- 1.A stacked bar for one day at a café in Norwich shows total drink sales of 50 drinks, split into three parts: 22 were tea, 15 were coffee and the rest were hot chocolate. Work out the number of hot chocolates sold.
- 2.A two-way table records whether each of 50 pupils in Year 10 or Year 11 at a school walks to school or is driven. 28 of the 50 pupils are in Year 10. In total, 22 of the 50 pupils walk to school. Of the Year 10 pupils, 15 walk to school. Work out how many Year 11 pupils are driven to school.
- 3.A sports centre in Newcastle asks 60 members which activity they prefer: swimming 15 members, football 25 members, badminton 12 members and other activities 8 members. Work out the angle at the centre of the pie chart sector that represents badminton.
- 4.A two-way table records whether each of the 30 pupils in a class passed maths and whether they passed science. 18 pupils passed maths, 12 pupils passed science and 8 pupils passed both. Work out how many pupils passed at least one of the two subjects.
- 5.A timetable shows the departure times of a bus from Leeds to Harrogate: 08:15, 08:50, 09:25, 10:05, 10:40. Chloe arrives at the bus stop at 09:30. Work out how many minutes she has to wait for the next bus.
- 6.A charity shop in Leicester made £2,400 in one month. A pie chart shows how this was spent: repairs took up an angle of 90°, wages took up an angle of 150°, and the rest was other costs. Work out how much was spent on wages.
- 7.A table shows the time each of four pupils took to run 100 m: Oliver 12 seconds, Grace 15 seconds, Ethan 10 seconds, Freya 14 seconds. Write down the name of the fastest runner and the time taken.
- 8.A dual bar chart shows how many boys and how many girls are in a class. The bar for boys stands at 14 and the bar for girls stands at 16. Work out how many pupils are in the class altogether.
- 9.A pie chart is divided into 10 equal sectors. 6 of those sectors stand for the people who chose purple. Altogether 120 people were asked. Work out how many of them chose purple.
- 10.A sector of a pie chart stands for 25% of the data. Work out the angle at the centre of that sector.
- 11.A garden centre's sales, in thousands of pounds, at the end of each quarter last year were: quarter 1 — 18, quarter 2 — 34, quarter 3 — 30, quarter 4 — 22. Work out the increase in sales from quarter 1 to the quarter with the highest sales.
- 12.A composite (stacked) bar for a charity bake sale in Durham shows the number of cakes sold, split into three types. The bar has a total height of 80 cakes: 34 were sponge cakes, 26 were chocolate cakes and the rest were fruit cakes. Work out the percentage of the cakes sold that were fruit cakes.
- 13.A line graph shows the temperature in a greenhouse at the end of each of six hours. The six readings were 10 °C, 14 °C, 18 °C, 22 °C, 26 °C and 30 °C. Describe the trend shown by the line graph.
- 14.A bar chart is drawn for a set of categorical data. Write down what the height of each bar represents.
- 15.A garden centre records its total sales, in pounds, at the end of each of the twelve months of one year, to see how sales change over time. Write down the most suitable type of chart to show this time series data.
Answer key
- (b) 13 — The total is 50, and the two known parts are 22 (tea) and 15 (coffee), so 50 − 22 − 15 = 13 hot chocolates. Choosing 28 comes from 50 − 22, subtracting only the tea and forgetting the coffee. Choosing 35 comes from 50 − 15, subtracting only the coffee and forgetting the tea. Choosing 37 comes from 22 + 15, which finds how many drinks were tea or coffee, not the number left over for hot chocolate.
- (a) 15 — Year 11 has 50 − 28 = 22 pupils in total. Of the 22 pupils who walk in total, 15 are in Year 10, so 22 − 15 = 7 Year 11 pupils walk. Subtracting that from the Year 11 total gives 22 − 7 = 15 Year 11 pupils who are driven. Choosing 28 takes the whole school's driven total, 50 − 22 = 28, and treats it as if it were Year 11's alone, without separating the year groups. Choosing 7 correctly finds how many Year 11 pupils walk but stops there, giving that figure instead of the number who are driven. Choosing 35 comes from 50 − 15, subtracting the Year 10 walkers from the whole school total rather than working within Year 11.
- (c) 72° — The angle is 12 ÷ 60 × 360 = 72°. Choosing 150° divides football's frequency of 25 instead of badminton's 12: 25 ÷ 60 × 360 = 150. Choosing 20° finds badminton as a percentage of the members, 12 ÷ 60 × 100 = 20, rather than an angle in degrees. Choosing 90° uses 48, the total of the other three activities, as the total instead of the full 60 members: 12 ÷ 48 × 360 = 90.
- (a) 22 — Method: the two subject totals overlap, because every pupil who passed both subjects has been counted once in the maths total and once again in the science total; adding the totals therefore counts those pupils twice, and the overlap has to be taken off once. Working: 18 + 12 = 30, and the 8 pupils who passed both have been counted twice in that 30, so the number who passed at least one subject is 30 − 8 = 22. Answer: 22 pupils, a count of pupils, and it is less than the 30 in the class, which leaves 8 pupils who passed neither. The distractors: 30 comes from adding the two subject totals and never removing the overlap, so it counts the 8 pupils twice; 14 comes from taking the 8 away twice, 18 + 12 − 8 − 8, removing an overlap that was only counted twice once too often; 18 comes from writing down the larger of the two subject totals on its own, which leaves out every pupil who passed science but not maths.
- (a) 35 minutes — Chloe arrives at 09:30, so she needs the first departure time that is at or after 09:30. The bus at 09:25 has already left five minutes before she arrives, so it is missed, not caught; the next one on the timetable is 10:05. From 09:30 to 10:00 is 30 minutes, then a further 5 minutes to 10:05, so the wait is 35 minutes. Giving 40 minutes measures the gap from the missed 09:25 bus to the 10:05 bus, counting from the bus Chloe missed instead of from the time she arrived. Giving 5 minutes uses the missed 09:25 bus, working out 09:30 − 09:25 the wrong way round. Giving 45 minutes comes from treating the times as decimals — 10.05 − 9.30 = 0.75, then × 60 = 45 — instead of working in hours and minutes, where 05 minutes past the hour is not 0.05 of an hour.
- (b) £1,000 — Wages take up 150° out of 360°, so the amount spent on wages is 150 ÷ 360 × 2400 = £1,000. Choosing £600 uses the repairs angle, 90°, instead of the wages angle: 90 ÷ 360 × 2400 = 600. Choosing £3,600 treats the angle in degrees as if it were a percentage, 150 ÷ 100 × 2400 = 3600, instead of dividing by 360°. Choosing £800 uses the angle for the 'other costs' sector, 360 − 90 − 150 = 120°, instead of the wages sector: 120 ÷ 360 × 2400 = 800.
- (b) Ethan, 10 seconds — Method: over the same distance the fastest runner is the one who takes the least time, so the smallest time in the table is found first and the name is then read from the same row. Working: the four times are 12 seconds, 15 seconds, 10 seconds and 14 seconds; in order of size these are 10, 12, 14 and 15, so the least time is 10 seconds, and the row holding 10 seconds is the row for Ethan. Answer: Ethan, 10 seconds — the time is in seconds, and a smaller time means a faster runner. The distractors: Grace with 15 seconds comes from taking the largest number in the table to mean the fastest runner, which reverses the relationship between time and speed over a fixed distance; Oliver with 12 seconds comes from writing down the first row of the table without comparing the four times; Ethan with 15 seconds comes from identifying the right runner but then reading the time from a different row of the table.
- (d) 30 — Method: on a dual bar chart each bar is a separate frequency, so a total for the whole class is found by combining the two frequencies the bars show. Working: the bars show 14 boys and 16 girls, and 14 + 16 = 30. Answer: 30 pupils, a count of pupils in the class. The distractors: 32 comes from doubling the taller bar, 16 + 16, as though the two bars were equal; 28 comes from doubling the shorter bar, 14 + 14, in the same way; 2 comes from finding the difference between the two bars, 16 − 14, which answers how many more girls there are rather than how many pupils there are.
- (c) 72 — Method: when a pie chart is divided into equal sectors, each sector stands for the same share of the people asked, so the fraction of the sectors that are shaded is also the fraction of the people. Working: 6 sectors out of 10 are purple, which is the fraction 6/10 of the whole pie chart; one tenth of the 120 people is 120 ÷ 10 = 12 people, so six tenths is 6 × 12 = 72 people. Answer: 72 people, a count of people rather than a number of sectors. The distractors: 48 comes from working with the 4 sectors that are not purple, 4 × 12, and so answering for the wrong part of the chart; 60 comes from turning the fraction 6/10 into 60% and then writing the 60 down as though it were a number of people; 6 comes from writing down the number of purple sectors instead of the number of people those sectors stand for.
- (c) 90° — Method: the sectors of a pie chart share the 360° at the centre of the chart in the same proportion as the data, so a sector's angle is its share of the data multiplied by 360°. Working: a share of 25% is the fraction 25/100, which is one quarter of the whole chart, and one quarter of 360° is 360 ÷ 4 = 90°. Answer: 90°, an angle in degrees rather than a percentage. The distractors: 25° comes from sharing out 100 instead of 360, so the percentage is written straight down as a number of degrees; 14.4° comes from dividing 360 by 25 instead of multiplying 360 by the fraction 25/100, which is the division done the wrong way round; 45° comes from taking a quarter of 180° instead of a quarter of 360°, treating the pie chart as a semicircle.
- (a) £16,000 — Method: first find the quarter with the highest sales figure, then subtract quarter 1's sales from it — remembering that every figure is given in THOUSANDS of pounds. Working: the highest sales figure is quarter 2, at £34,000 (34 thousand pounds). The increase from quarter 1 is £34,000 − £18,000 = £16,000. Giving £34,000 reads off the highest sales figure on its own, without subtracting quarter 1's sales — that is the highest quarter's total, not the increase. Giving £12,000 uses quarter 3's sales, 30, the SECOND-highest figure, instead of quarter 2's 34, the actual highest — 30 − 18 = 12, but quarter 3 is not the quarter with the highest sales. Giving £16 gets the subtraction right, 34 − 18 = 16, but forgets that every figure in the question is in thousands of pounds, so the increase is £16,000, not £16. Always identify the correct quarter FIRST, and always check the units the numbers are given in before writing your final answer.
- (d) 25% — First find the number of fruit cakes: 80 − 34 − 26 = 20. Then write this as a percentage of the total: 20 ÷ 80 × 100 = 25%. Giving 20% comes from reporting the count of fruit cakes, 20, directly as a percentage, without dividing by the total of 80 first. Giving 32.5% computes the percentage of chocolate cakes instead of fruit cakes: 26 ÷ 80 × 100 = 32.5%. Giving 42.5% computes the percentage of sponge cakes instead of fruit cakes: 34 ÷ 80 × 100 = 42.5%.
- (a) The temperature is rising steadily — Method: the trend of a line graph is the overall direction of the readings as time goes on, found by comparing each reading with the one before it. Working: from 10 °C to 14 °C is a rise of 4 °C, and the same comparison from 14 °C to 18 °C, from 18 °C to 22 °C, from 22 °C to 26 °C and from 26 °C to 30 °C gives a rise of 4 °C every time; every reading is greater than the one before it and none of them falls. Answer: the temperature is rising steadily — steadily because the rise is the same size each hour. The distractors: falling steadily comes from reading the six values from right to left, which reverses the direction of time; stays the same comes from noticing that the step of 4 °C is the same each hour and describing the step as constant instead of the temperature; rises and then falls comes from assuming that a line graph has to turn at some point rather than reading the values that are actually given.
- (c) The frequency of that category — Method: a bar chart for categorical data has one bar for each category, and the vertical scale on which the bars are measured is a count. Working: a bar drawn twice as tall as another tells you that twice as many items of data fell into its category, so the height measures how many items of data belong to that one category, which is exactly what a frequency is. Answer: the height of each bar is the frequency of that category — a count of items of data. The distractors: the number of different categories comes from reading the vertical scale as though it counted the bars, which is shown along the horizontal axis instead; the total of all the data comes from treating one bar as though it stood for the whole data set rather than for one category; the mean of all the data comes from confusing a bar chart with a measure of average, which no single bar can show.
- (b) A line graph — Sales recorded at the end of each of the twelve months are time series data, and a line graph is the chart built to show how a value changes over time, with the points usually joined in order. A pie chart is for showing categorical data as shares of a whole, not a trend over time. A pictogram shows a frequency for separate categories using symbols, not a continuous trend. A scatter graph is for comparing two different variables against each other, not one variable over time.
Build your own mix at the worksheet builder.