The ability matrix is for comparing scores in the same markbook subject on different dates. It allows you to specify the ability level that is expected on each date which allows the comparison of data from ability levels that span more than one year. 

To load an Ability Matrix Report:

  • % of Assessed/Overall %: The report can be loaded up using either type of markbook data.

  • Class: Select the class group to view information for.

  • Curriculum: Select the curriculum which contains the subjects you wish to view information for.

  • Subject: Select the subject you have recorded markbook assessments for and wish to view.

  • Expected Ability/Year Date: Select the date to look at assessments from

  • Expected Ability/Year: Select the ability you wish to view pupil data for

  • Show Settings: Set what counts as Sig. Below, Below, At, Above and Sig. Above based on the data you are looking at.  Guidance for markbook data can be found here: Attainment Settings

  • Load Report.

The report will generate with an overlay applied.  The green segments indicate pupils Working Above, the white segments the pupils Working At and the orange section the pupils Working Below.  The percentages of the pupils in each category can be seen in the overlay summary below the table. 

Clicking on 'hide overlay' will change the view of the matrix.


Clicking on a cell or cells identifies the names of the pupils in that cell or cells so that you can use the data to inform practice.  In the example above we can see that in September 2019, 3 pupils were below, but in November 2019, they are now AT.