How to calculate Prior Attainment Bands in Pupil Asset

This guide has been written for the academic year 2017/18.

The terminology of Prior Attainment Bands is currently used interchangeably at a national level, with some basing it on the average point scores from the previous key stage and others using it to refer to prior attainment in a specific subject.

For KS2, this is summarised as follows: 

Ofted Inspection Dashboard 

Progress - low/middle/high bands are based on KS1 APS. 

Attainment - low/middle/high bands refer to the KS1 level in that specific subject.

Analyse School Performance (ASP) 

Progress - low/middle/high bands are based on KS1 APS. 

Attainment - low/middle/high bands are based on KS1 APS for general/overall reports and based on the individual KS1 level for subject specific reports. 

Fischer Family Trust 

Progress & Attainment - initially based on KS1 APS, but then all pupils are ranked nationally and split into thirds so low/middle/high is based on the corresponding third. 

(For a more detailed explanation, click here to read this excellent Blog by James Pembroke. The DfE have also clarified their position on this matter, click here).


Pupil Asset users are able to automatically calculate prior attainment bands for every year group.


Years 1 and 2  

The Prior Attainment Bands for years 1 and 2 are based on the combined minimum of the core EYFS subjects - that is whether pupils were awarded a 1 (LOW)(MIDDLE) or 3 (HIGH) in Reading, Writing and BOTH Numbers and Shape, Space & Measure for Maths. 

To calculate the Prior Attainment Bands for these year groups, navigate to Results > Results and ensure that you have results in the required columns (EYFS Judgement for year 1 and End Reception for year 2).  Next, click Edit and then Auto-calculate the Prior Attainment Bands.









Years 3 and 4

The Prior Attainment Bands for years 3 and 4 are based on a combined minimum of Maths, Reading and Writing Key Stage 1 Teacher Assessments. 

To calculate the Prior Attainment Bands for these year groups, navigate to Results > Results and ensure that you have results in the required columns (End of Key Stage 1 Interim/Teacher Assessment). Next, click Edit and then Auto-calculate the Prior Attainment Bands.


NB: There is currently no DfE guidance on calculating Prior Attainment Bands at KS1; however, IDSR guidance for OfSTED inspectors states the following: 

"Prior attainment for Year 3 (and 4) is based on... who achieved at least the expected standard at key stage 1", therefore we have based our calculations on this also. If the DfE produce updated guidance, we will update our calculations accordingly. 







Years 5 and 6

In years 5 and 6, the Prior Attainment Group (PAG) column shows which Prior Attainment Group pupils are in. This is based on their Key Stage 1 Baseline Score and is calculated as follows:









SourceDfE Primary Accountability Document 

The colours in the Prior Attainment Group column represent which Prior Attainment Band the children are in (low/middle/high), also based on the KS1 APS Score, but with the following boundaries applied:  

Low: KS1 APS <12 

Middle: KS1 APS 12-17.99 

High: KS1 APS 18+



For more information on using Prior Attainment Bands in Pupil Asset, see 'Ways to use prior attainment bands in Pupil Asset'


Explore this section

Related pages

For an instant idea of cost, use our simple widget tailored to your needs.

CALCULATE COST