← Back to the activity

Year 9 Computing — Charts from a spreadsheet

Choose the kind of chart a set of numbers needs, and read amounts and shares off the chart that results.

Name: ________________________

  1. 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.

    • B2:B5
    • C1:C9
    • D3:D8
    • A2:A12
    • E4:E10
    • 11
    • 7
    • 6
    • 9
    • 4

  2. 2.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 pie 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 line chart

  3. 3.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 chart with one slice for each of the thirty days
    • b) A line chart
    • c) A chart with a single bar for the thirty days together
    • d) A pie chart

  4. 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 smaller than it is
    • d) Makes it look far bigger than it is

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

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

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

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

Answer key — Year 9 Computing — Charts from a spreadsheet

  1. 1. B2:B5 → 4; C1:C9 → 9; D3:D8 → 6; A2:A12 → 11; E4:E10 → 7
  2. 2. a) A pie chart
  3. 3. b) A line chart
  4. 4. d) Makes it look far bigger than it is
  5. 5. c) A slice shows a share of one whole, and four temperatures added together make no whole of anything
  6. 6. 10
  7. 7. 15
  8. 8. 90