A visual way to pivot on two categories of data for a class or year group. The spreadhseet accepts any valid table of data that has a unique id as the first column.
You can group the data by any column and colour code by any other column allowing you to identify outliers in a quick and visual fashion. Clicking on a dot will reveal more info about that data point.
Included is a table of sample data to show you what sort of things you can achieve.
(Theoretically you can have any number of pupils but it's only tested up to 250)