Grade 8 Computer Science — Charts from a spreadsheet

1.A chart is drawn from a range of cells, one bar for each cell. Match each range to the number of bars the chart would have.

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

3.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?

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) Makes it look far smaller than it is
• b) Shows it exactly as it is
• c) Makes it look far bigger than it is
• d) Hides it, so that the two bars look identical

5.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) The four days would have to be put in order of temperature first
• c) A slice shows a share of one whole, and four temperatures added together make no whole of anything
• d) A pie chart can only ever show three things at a time

6.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 chart with one point for each of the 200 pupils
• b) A line chart
• c) A pie chart
• d) A chart with a single bar for the whole year group

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

8.A sheet holds a shop's takings on each of thirty days running. The chart is to show whether they are climbing or falling as the days go by. Which kind of chart is that?

• a) A line chart
• b) A chart with one slice for each of the thirty days
• c) A pie chart
• d) A chart with a single bar for the thirty days together