This workbook allows Pupil Premium CSV files to copied and processed, to help schools to understand each pupils eligibility for each type of Pupil Premium and how that translates to the amount of Pupil Premium funding allocated to the school for each of the pupils and the overall amount of funding involved for the school.
This spreadsheet has been designed to help schools check and understand the pupil level Pupil Premium information provided in CSV format by the DfE.
It has been designed to cope with the CSV downloads provided to individual schools by the DfE to indicate (1) which pupils have been identified for Pupil Premium, (2) which Pupil Premiums apply for each of those pupils, 3) the school funding that would apply for those pupils and 4) the most recent School Census that has indicated eligibility for FSM.
The DfE expects to provide the first CSV file in July, but at that point the Looked After Premium will be based on out of date In Care information. The DfE expects to provide the second CSV file in November and at that point the Looked After Premium will be based on the latest In Care information. The total amount of actual funding will be based on the second CSV file. In many cases payment of Looked After Premium to the local authority will result in less Premium being paid to the school. The CSV file only identifies Looked After Premium for pupils where other Pupils Premiums apply and therefore does not include pupils who have only be identified for Looked After Premium.