This chart came my way via Twitter - it "shows" the progress from Key Stage 2 to Key Stage 3 for the learners from a specific primary school.

I say "shows" as it gave me a headache trying to decipher what the chart is actually showing.

  • X-axis as KS2 levels - that's OK
  • Y-axis as "number of pupils at KS3 level" makes the chart difficult to read, as the numbers on this axis don't directly link to the x-axis
  • KS3 levels as series (and different colours) makes it doubly difficult to see what's happening.

As a parent I want to know - how much progress do the learners from this school make between KS2 and KS3 - an interpretation that is almost impossible to deduce from this chart.

Some Excel-fu and a bubble chart later:

I can see:
  • 1 level of progress (2 to 3, 3 to 4 and 5 to 6) is the most common
  • Some learners make 2 or 3 levels of progress
  • 3 learners incoming with level 4 left KS3 with a level 3 (so went down)
  • 31 learners made no progress from KS2 to KS3
Call to action
When you make a chart run it past some parents - if they can't "see" what the chart is showing, then you may need to find an alternative visualisation.