Class 8 Computer Science — Charts from a spreadsheet

1.Someone draws a pie chart from the temperature at noon on each of four days. Why is a pie chart the wrong choice here?

• a) A pie chart cannot show a number larger than a hundred
• b) A pie chart can only ever show three things at a time
• c) The four days would have to be put in order of temperature first
• d) A slice shows a share of one whole, and four temperatures added together make no whole of anything

2.This bar chart has one bar for each of four shops. Tap the bar belonging to the shop that sold the second most.

3.A sheet records how many of the 200 pupils in a year group joined each of four clubs, and every pupil joined exactly one. The chart is to show what share of the year group each club took. Which kind of chart is that?

• a) A line chart
• b) A chart with a single bar for the whole year group
• c) A chart with one point for each of the 200 pupils
• d) A pie chart

4.A bar chart's upright scale begins at 90 rather than at nothing. Two of its bars stand for 95 and for 100. What does the chart do to the difference between the two?

• a) Shows it exactly as it is
• b) Hides it, so that the two bars look identical
• c) Makes it look far bigger than it is
• d) Makes it look far smaller than it is

5.A chart is drawn from the range B2:B9, with one bar for each cell in it. How many bars does the chart have?

6.A pie chart is drawn for 24 people, one of whom is you. How many degrees of the circle does a single person take?

7.A bar chart is drawn from the range D2:D13, one bar for each cell. Two of those cells have been left empty and no bar is drawn for them. How many bars does the chart have?

8.A pie chart is drawn for four clubs that 200 pupils divided themselves between, and 50 of them joined one particular club. How many degrees of the circle does that club's slice take?