KS2 Attainment Results 2014CSV  KS2 Abbreviations

ColumnField NameLabel/Description
1RECTYPERecord type
2ALPHAINDAlphabetic index
3LEALocal authority number
4ESTABEstablishment number
5URNSchool unique reference number
6SCHNAMESchool/Local authority name
7ADDRESS1School address (1)
8ADDRESS2School address (2)
9ADDRESS3School address (3)
10TOWNSchool town
11PCODESchool postcode
12TELNUMSchool telephone number
13URN_ACConverter academy: URN
14SCHNAME_ACConverter academy: name
15OPEN_ACConverter academy: open date
16NFTYPESchool type
17ICLOSEClosed Flag
18RELDENOMReligious denomination
19AGERANGEAge range
20CONFEXAMConfirmation that core performance information has been checked
21TAB15School published in secondary school (key stage 4) performance tables
22TAB1618School published in school and college (key stage 5) performance tables
23TOTPUPSTotal number of pupils (including part-time pupils)
24TPUPYEARNumber of pupils aged 11
25TELIGPublished eligible pupil number
26BELIGEligible boys on school roll at time of tests
27GELIGEligible girls on school roll at time of tests
28PBELIG% eligible boys on school roll at time of tests
29PGELIG% eligible girls on school roll at time of tests
30TKS1APSCohort level key stage 1 average points score
31TKS1EXP_LNumber of pupils in cohort with low KS1 attainment
32PKS1EXP_L% pupils in cohort with low KS1 attainment
33TKS1EXP_MNumber of pupils in cohort with medium KS1 attainment
34PKS1EXP_M% pupils in cohort with medium KS1 attainment
35TKS1EXP_HNumber of pupils in cohort high KS1 attainment
36PKS1EXP_H% pupils in cohort with high KS1 attainment
37TFSMCLANumber of key stage 2 disadvantaged pupils (those who were eligible for free school meals in last 6 years or are looked after by the LA)
38PTFSMCLA% key stage 2 disadvantaged pupils
39TNotFSMCLANumber of key stage 2 pupils who are not disadvantaged
40PTNotFSMCLA% key stage 2 pupils who are not disadvantaged
41TEALGRP2Number of eligible pupils with English as additional language (EAL)
42PTEALGRP2% eligible pupils with English as additional language (EAL)
43TMOBNNumber of eligible pupils classified as non-mobile
44PTMOBN% eligible pupils classified as non-mobile
45SENELSNumber of eligible pupils with SEN with a statement or supported at School Action Plus
46PSENELS% eligible pupils with SEN with a statement or supported at School Action Plus
47PT2MATH% pupils making at least 2 levels of progress in maths
48COVMATH% pupils included in maths progress measure
49PT2READ% pupils making at least 2 levels of progress in reading
50COVREAD% pupils included in reading progress measure
51PT2WRITTA% pupils making at least 2 levels of progress in writing TA
52COVWRITTA% pupils included in writing TA progress measure
53PTREADWRITTAMATX% pupils achieving level 4 or above in reading and maths test and writing TA
54PTREADWRITTAMAT4B% pupils achieved level 4B or above in reading and maths test and level 4 in writing TA
55PTREADWRITTAMATAX% pupils achieving level 5 or above in reading and maths test and writing TA
56PTREADWRITTAMATBX% pupils achieving 3 or below in reading and maths test and writing TA
57TAPSAverage point score
58AVGLEVELAverage level per pupil
59OVAMEASOverall value added measure
60VACOVCoverage indicator - % pupils included in value added calculations
61OLCONFOverall value added lower 95% confidence limit
62OUCONFOverall value added upper 95% confidence limit
63PT2Math_B% boys making at least 2 levels of progress in maths
64PT2Math_G% girls making at least 2 levels of progress in maths
65PT2Math_L% pupils with low key stage 1 attainment making at least 2 levels of progress in maths
66PT2Math_M% pupils with middle key stage 1 attainment making at least 2 levels of progress in maths
67PT2Math_H% pupils with high key stage 1 attainment making at least 2 levels of progress in maths
68PT2Math_FSMCLA% disadvantaged pupils making at least 2 levels of progress in maths
69PT2Math_NotFSMCLA% pupils not disadvantaged making at least 2 levels of progress in maths
70GAP_PRMATGap between % making expected progress in maths for disadvantaged pupils and others
71GAPN_PRMAT_FSMCLAGap between school and national % making expected progress in maths for disadvantaged pupils
72GAPN_PRMAT_NotFSMCLAGap between school and national % making expected progress in maths for other pupils
73PT2Math_EALY% EAL pupils making at least 2 levels of progress in maths
74PT2Math_MOBN% non-mobile pupils making at least 2 levels of progress in maths
75PT2Read_B% boys making at least 2 levels of progress in reading
76PT2Read_G% girls making at least 2 levels of progress in reading
77PT2Read_L% pupils with low key stage 1 attainment making at least 2 levels of progress in reading
78PT2Read_M% pupils with middle key stage 1 attainment making at least 2 levels of progress in reading
79PT2Read_H% pupils with high key stage 1 attainment making at least 2 levels of progress in reading
80PT2Read_FSMCLA% disadvantaged pupils making at least 2 levels of progress in reading
81PT2Read_NotFSMCLA% pupils not disadvantaged making at least 2 levels of progress in reading
82GAP_PRREADGap between % making expected progress in reading for disadvantaged pupils and others
83GAPN_PRREAD_FSMCLAGap between school and national % making expected progress in reading for disadvantaged pupils
84GAPN_PRREAD_NotFSMCLAGap between school and national % making expected progress in reading for other pupils
85PT2Read_EALY% EAL pupils making at least 2 levels of progress in reading
86PT2Read_MOBN% non-mobile pupils making at least 2 levels of progress in reading
87PT2WritTA_B% boys making at least 2 levels of progress in writing TA
88PT2WritTA_G% girls making at least 2 levels of progress in writing TA
89PT2WritTA_L% pupils with low key stage 1 attainment making at least 2 levels of progress in writing TA
90PT2WritTA_M% pupils with middle key stage 1 attainment making at least 2 levels of progress in writing TA
91PT2WritTA_H% pupils with high key stage 1 attainment making at least 2 levels of progress in writing TA
92PT2WritTA_FSMCLA% disadvantaged pupils making at least 2 levels of progress in writing TA
93PT2WritTA_NotFSMCLA% pupils not disadvantaged making at least 2 levels of progress in writing
94GAP_PRWRITGap between % making expected progress in writing TA for disadvantaged pupils and others
95GAPN_PRWRIT_FSMCLAGap between school and national % making expected progress in writing TA for disadvantaged pupils
96GAPN_PRWRIT_NotFSMCLAGap between school and national % making expected progress in writing TA for other pupils
97PT2WritTA_EALY% EAL pupils making at least 2 levels of progress in writing TA
98PT2WritTA_MOBN% non-mobile pupils making at least 2 levels of progress in writing TA
99PBREADWRITTAMATX% boys achieving level 4 or above in reading and maths test and writing TA
100PGREADWRITTAMATX% girls achieving level 4 or above in reading and maths test and writing TA
101PTREADWRITTAMATX_L% pupils with low key stage 1 attainment achieving level 4 or above in reading and maths test and writing TA
102PTREADWRITTAMATX_M% pupils with middle key stage 1 attainment achieving level 4 or above in reading and maths test and writing TA
103PTREADWRITTAMATX_H% pupils with high key stage 1 attainment achieving level 4 or above in reading and maths test and writing TA
104PTREADWRITTAMATX_FSMCLA% disadvantaged pupils achieving level 4 or above in reading and maths tests and writing TA
105PTREADWRITTAMATX_NotFSMCLA% pupils not disadvantaged achieving level 4 or above in reading and maths tests and writing TA
106GAP_RWMXGap between % achieving level 4 or above in reading, writing TA and maths for disadvantaged pupils and others
107GAPN_RWMX_FSMCLAGap between school and national % achieving level 4 or above in reading, writing TA and maths for disadvantaged pupils
108GAPN_RWMX_NotFSMCLAGap between school and national % achieving level 4 or above in reading, writing TA and maths for other pupils
109PTREADWRITTAMATX_EALY% EAL pupils achieving level 4 or above in reading and maths test and writing TA
110PTREADWRITTAMATX_MOBN% non-mobile pupils achieving level 4 or above in reading and maths test and writing TA
111PBREADWRITTAMAT4B% boys achieved level 4B or above in all of reading test. maths test, writing TA
112PGREADWRITTAMAT4B% girls achieved level 4B or above in all of reading test. maths test, writing TA
113PTREADWRITTAMAT4B_L% pupils with low key stage 1 attainment achieving level 4B or above in reading test. maths test, writing TA
114PTREADWRITTAMAT4B_M% pupils with middle key stage 1 attainment achieving level 4B or above in reading test. maths test, writing TA
115PTREADWRITTAMAT4B_H% pupils with high key stage 1 attainment achieving level 4B or above in reading test. maths test, writing TA
116PTREADWRITTAMAT4B_FSMCLA% disadvantaged pupils achieving level 4B or above in reading and maths tests and writing TA
117PTREADWRITTAMAT4B_NotFSMCLA% pupils not disadvantaged achieving level 4B or above in both English and maths
118GAP_RWM4BGap between % achieving level 4B or above in reading, writing TA and maths for disadvantaged pupils and others
119GAPN_RWM4B_FSMCLAGap between school and national % achieving level 4B or above in reading, writing TA and maths for disadvantaged pupils
120GAPN_RWM4B_NotFSMCLAGap between school and national % achieving level 4B or above in reading, writing TA and maths for other pupils
121PTREADWRITTAMAT4B_EALY% EAL pupils achieving level 4B or above in reading and maths test and writing TA
122PTREADWRITTAMAT4B_MOBN% non-mobile pupils achieving level 4B or above in reading and maths test and writing TA
123PBREADWRITTAMATAX% boys achieving level 5 or above in reading and maths test and writing TA
124PGREADWRITTAMATAX% girls achieving level 5 or above in reading and maths test and writing TA
125PTREADWRITTAMATAX_L% pupils with low key stage 1 attainment achieving level 5 or above in reading and maths test and writing TA
126PTREADWRITTAMATAX_M% pupils with middle key stage 1 attainment achieving level 5 or above in reading and maths test and writing TA
127PTREADWRITTAMATAX_H% pupils with high key stage 1 attainment achieving level 5 or above in reading and maths test and writing TA
128PTREADWRITTAMATAX_FSMCLA% disadvantaged pupils achieving level 5 or above in reading and maths tests and writing TA
129PTREADWRITTAMATAX_NotFSMCLA% pupils not disadvantaged achieving level 5 or above in reading and maths tests and writing TA
130PTREADWRITTAMATAX_EALY% EAL pupils achieving level 5 or above in reading and maths test and writing TA
131PTREADWRITTAMATAX_MOBN% non-mobile pupils achieving level 5 or above in reading and maths test and writing TA
132PBREADWRITTAMATBX% boys achieving 3 or below in reading and maths test and writing TA
133PGREADWRITTAMATBX% girls achieving 3 or below in reading and maths test and writing TA
134PTREADWRITTAMATBX_L% pupils with low key stage 1 attainment achieving level 3 or below in reading and maths test and writing TA
135PTREADWRITTAMATBX_M% pupils with middle key stage 1 attainment achieving level 3 or below in reading and maths test and writing TA
136PTREADWRITTAMATBX_H% pupils with high key stage 1 attainment achieving level 3 or below in reading and maths test and writing TA
137PTREADWRITTAMATBX_FSMCLA% disadvantaged pupils achieving level 3 or below in reading and maths tests and writing TA
138PTREADWRITTAMATBX_NotFSMCLA% pupils not disadvantaged achieving level 3 or below in reading and maths tests and writing TA
139PTREADWRITTAMATBX_EALY% EAL pupils achieving level 3 or below in reading and maths test and writing TA
140PTREADWRITTAMATBX_MOBN% non-mobile pupils achieving level 3 or below in reading and maths test and writing TA
141OVAMEAS_LOverall value added measure: Low prior attainers
142OLCONF_LOverall value added lower 95% confidence limit: Low prior attainers
143OUCONF_LOverall value added upper 95% confidence limit: Low prior attainers
144OVAMEAS_MOverall value added measure: Middle prior attainers
145OLCONF_MOverall value added lower 95% confidence limit: Middle prior attainers
146OUCONF_MOverall value added upper 95% confidence limit: Middle prior attainers
147OVAMEAS_HOverall value added measure: High prior attainers
148OLCONF_HOverall value added lower 95% confidence limit: High prior attainers
149OUCONF_HOverall value added upper 95% confidence limit: High prior attainers
150OVAMEAS_FSMCLAOverall value added measure: disadvantaged pupils
151OLCONF_FSMCLAOverall value added lower 95% confidence limit: disadvantaged pupils
152OUCONF_FSMCLAOverall value added upper 95% confidence limit: disadvantaged pupils
153OVAMEAS_NotFSMCLAOverall value added measure: other pupils (ie. not disadvantaged)
154OLCONF_NotFSMCLAOverall value added lower 95% confidence limit: other pupils (ie. not disadvantaged)
155OUCONF_NotFSMCLAOverall value added upper 95% confidence limit: other pupils (ie. not disadvantaged)
156PTMATX% pupils achieving level 4 or above in maths test
157PTMAT4B% pupils achieved level 4B or above in maths test
158PTMATAX% pupils achieving level 5 or above in maths test
159PTMAT6% pupils achieving level 6 in maths test
160PTMATBX% pupils achieving level 3 or below in maths test
161PTMATAT% pupils absent from or not able to access the test in maths
162PTREADX % eligible pupils achieving level 4 or above in reading test
163PTREAD4B% pupils achieved level 4B or above in reading test
164PTREADAX % eligible pupils achieving level 5 or above in reading test
165PTREAD6% eligible pupils achieving level 6 in reading test
166PTREADBX % eligible pupils achieving level 3 or below in reading test
167PTREADAT% pupils absent from or not able to access the tests in reading (A/T)
168PTGPSX% pupils achieving level 4 or above in GPS test
169PTGPS4B% of pupils achieving level 4B or above in GPS test
170PTGPSAX% pupils achieving level 5 or above in GPS test
171PTGPS6% pupils achieving level 6 in GPS test
172PTGPSBX% pupils achieving level 3 or below in GPS test
173PTGPSAT% pupils absent from or not able to access the tests in GPS
174PTENGXTA% pupils achieving level 4 or above in English TA
175PTENGAXTA% pupils achieving level 5 or above in English TA
176PTENG6TA% pupils achieving level 6 above in English TA
177PTENGBXTA% pupils achieving level 3 or below in English TA
178PTENGADTA% pupils absent or disapplied in English TA
179PTMATXTA% pupils achieving level 4 or above in maths TA
180PTMATAXTA% pupils achieving level 5 or above in maths TA
181PTMAT6TA% pupils achieving level 6 in maths TA
182PTMATBXTA% pupils achieving level 3 or below in maths TA
183PTMATADTA% pupils absent or disapplied in maths TA
184PTSCIXTA% pupils achieving level 4 or above in science TA
185PTSCIAXTA% pupils achieving level 5 or above in science TA
186PTSCI6TA% pupils achieving level 6 in science TA
187PTSCIBXTA% pupils achieving level 3 or below in science TA
188PTSCIADTA% pupils absent or disapplied in Science TA
189PTREADXTA% pupils achieving level 4 or above in reading TA
190PTREADAXTA% pupils achieving level 5 or above in reading TA
191PTREAD6TA% pupils achieving level 6 in reading TA
192PTREADBXTA% pupils achieving level 3 or below in reading TA
193PTREADADTA% pupils absent or disapplied in reading TA
194PTWRITXTA% pupils achieving level 4 or above in writing TA
195PTWRITAXTA% pupils achieving level 5 or above in writing TA
196PTWRIT6TA% pupils achieving level 6 in writing TA
197PTWRITBXTA% pupils achieving level 3 or below in writing TA
198PTWRITADTA% pupils absent or disapplied in writing TA
199MVAMEASMaths value added measure
200MLCONFMaths value added lower 95% confidence limit
201MUCONFMaths value added upper 95% confidence limit
202RVAMEASReading value added measure
203RLCONFReading value added lower 95% confidence limit
204RUCONFReading value added upper 95% confidence limit
205WVAMEASWriting TA value added measure
206WLCONFWriting TA value added lower 95% confidence limit
207WUCONFWriting TA value added upper 95% confidence limit
208PTMATX_L% of pupils achieving level 4+ in maths: Low prior attaining KS1 group
209PTMATX_M% of pupils achieving level 4+ in maths: M KS1 group
210PTMATX_H% of pupils achieving level 4+ in maths: H KS1 group
211PTMATX_FSMCLA% of pupils achieving level 4+ in maths: disadvantaged
212PTMATX_NotFSMCLA% of pupils achieving level 4+ in maths: not disadvantaged
213PTMAT4B_L% of pupils achieving level 4B+ in maths: Low prior attaining KS1 group
214PTMAT4B_M% of pupils achieving level 4B+ in maths: M KS1 group
215PTMAT4B_H% of pupils achieving level 4B+ in maths: H KS1 group
216PTMAT4B_FSMCLA% of pupils achieving level 4B+ in maths: disadvantaged
217PTMAT4B_NotFSMCLA% of pupils achieving level 4B+ in maths: not disadvantaged
218PTREADX_L% of pupils achieving level 4+ in reading: Low prior attaining KS1 group
219PTREADX_M% of pupils achieving level 4+ in reading: M KS1 group
220PTREADX_H% of pupils achieving level 4+ in reading: H KS1 group
221PTREADX_FSMCLA% of pupils achieving level 4+ in reading: disadvantaged
222PTREADX_NotFSMCLA% of pupils achieving level 4+ in reading: not disadvantaged
223PTREAD4B_L% of pupils achieving level 4B+ in reading: Low prior attaining KS1 group
224PTREAD4B_M% of pupils achieving level 4B+ in reading: M KS1 group
225PTREAD4B_H% of pupils achieving level 4B+ in reading: H KS1 group
226PTREAD4B_FSMCLA% of pupils achieving level 4B+ in reading: disadvantaged
227PTREAD4B_NotFSMCLA% of pupils achieving level 4B+ in reading: not disadvantaged
228PTGPSX_L% of pupils achieving level 4+ in GPS: Low prior attaining KS1 group
229PTGPSX_M% of pupils achieving level 4+ in GPS: M KS1 group
230PTGPSX_H% of pupils achieving level 4+ in GPS: H KS1 group
231PTGPSX_FSMCLA% of pupils achieving level 4+ in GPS: disadvantaged
232PTGPSX_NotFSMCLA% of pupils achieving level 4+ in GPS: not disadvantaged
233PTGPS4B_L% of pupils achieving level 4B+ in GPS: Low prior attaining KS1 group
234PTGPS4B_M% of pupils achieving level 4B+ in GPS: M KS1 group
235PTGPS4B_H% of pupils achieving level 4B+ in GPS: H KS1 group
236PTGPS4B_FSMCLA% of pupils achieving level 4B+ in GPS: disadvantaged
237PTGPS4B_NotFSMCLA% of pupils achieving level 4B+ in GPS: not disadvantaged
238PTWRITXTA_L% of pupils achieving level 4+ in writing TA: Low prior attaining KS1 group
239PTWRITXTA_M% of pupils achieving level 4+ in writing TA: M KS1 group
240PTWRITXTA_H% of pupils achieving level 4+ in writing TA: H KS1 group
241PTWRITXTA_FSMCLA% of pupils achieving level 4+ in writing TA: disadvantaged
242PTWRITXTA_NotFSMCLA% of pupils achieving level 4+ in writing TA: not disadvantaged
243PTREADWRITTAMATX12% pupils achieving level 4 or above in reading and maths test and writing TA: 2012
244PTREADWRITTAMATAX12% pupils achieving level 5 or above in reading and maths test and writing TA: 2012
245PTREADWRITTAMATX13% pupils achieving level 4 or above in reading and maths test and writing TA: 2013
246PTREADWRITTAMAT4B13% pupils achieving level 4B or above in reading and maths test and writing TA: 2013
247PTREADWRITTAMATAX13% pupils achieving level 5 or above in reading and maths test and writing TA: 2013
248PTREADWRITTAMATX14% pupils achieving level 4 or above in reading and maths test and writing TA: 2014
249PTREADWRITTAMAT4B14% pupils achieving level 4B or above in reading and maths test and writing TA: 2014
250PTREADWRITTAMATAX14% pupils achieving level 5 or above in reading and maths test and writing TA: 2014
251TFSMCLA12Number of key stage 2 disadvantaged pupils (those who were eligible for free school meals in last 6 years or are looked after by the LA) in 2012
252PTFSMCLA12% key stage 2 disadvantaged in 2012
253TNotFSMCLA12Number of key stage 2 pupils who are not disadvantaged in 2012
254PTNotFSMCLA12% key stage 2 pupils who are not in 2012
255TFSMCLA13Number of key stage 2 disadvantaged pupils (those who were eligible for free school meals in last 6 years or are looked after by the LA) in 2013
256PTFSMCLA13% key stage 2 disadvantaged in 2013
257TNotFSMCLA13Number of key stage 2 pupils who are not disadvantaged in 2013
258PTNotFSMCLA13% key stage 2 pupils who are not disadvantage in 2013
259PTREADWRITTAMATX_FSMCLA12% pupils achieving level 4 or above in reading and maths test and writing TA: disadvantaged 2012
260PTREADWRITTAMATX_NotFSMCLA12% pupils achieving level 4 or above in reading and maths test and writing TA: not disadvantaged 2012
261PTREADWRITTAMATAX_FSMCLA12% pupils achieving level 5 or above in reading and maths test and writing TA: disadvantaged 2012
262PTREADWRITTAMATAX_NotFSMCLA12% pupils achieving level 5 or above in reading and maths test and writing TA: not disadvantaged 2012
263PTREADWRITTAMATX_FSMCLA13% pupils achieving level 4 or above in reading and maths test and writing TA: disadvantaged 2013
264PTREADWRITTAMATX_NotFSMCLA13% pupils achieving level 4 or above in reading and maths test and writing TA: not disadvantaged 2013
265PTREADWRITTAMAT4B_FSMCLA13% pupils achieving level 4B or above in reading and maths test and writing TA: disadvantaged 2013
266PTREADWRITTAMAT4B_NotFSMCLA13% pupils achieving level 4B or above in reading and maths test and writing TA: not disadvantaged 2013
267PTREADWRITTAMATAX_FSMCLA13% pupils achieving level 5 or above in reading and maths test and writing TA: disadvantaged 2013
268PTREADWRITTAMATAX_NotFSMCLA13% pupils achieving level 5 or above in reading and maths test and writing TA: not disadvantaged 2013
269PT2Math_12Percentage of pupils making at least 2 levels of progress in maths 2012
270PT2Math_FSMCLA_12% disadvantaged pupils making at least 2 levels of progress in maths 2012
271PT2Math_NotFSMCLA_12% pupils not disadvantaged making at least 2 levels of progress in maths 2012
272PT2Math_13Percentage of pupils making at least 2 levels of progress in maths 2013
273PT2Math_FSMCLA_13% disadvantaged pupils making at least 2 levels of progress in maths 2013
274PT2Math_NotFSMCLA_13% pupils not disadvantaged making at least 2 levels of progress in maths 2013
275PT2Read_12Percentage of pupils making at least 2 levels of progress in reading 2012
276PT2Read_FSMCLA_12% disadvantaged pupils making at least 2 levels of progress in reading 2012
277PT2Read_NotFSMCLA_12% pupils not disadvantaged making at least 2 levels of progress in reading 2012
278PT2Read_13% disadvantaged pupils making at least 2 levels of progress in reading 2013
279PT2Read_FSMCLA_13% disadvantaged pupils making at least 2 levels of progress in reading 2013
280PT2Read_NotFSMCLA_13% pupils not disadvantaged making at least 2 levels of progress in reading 2013
281PT2WritTA_12Percentage of pupils making at least 2 levels of progress in writing 2012
282PT2WritTA_FSMCLA_12% disadvantaged pupils making at least 2 levels of progress in writing 2012
283PT2WritTA_NotFSMCLA_12% pupils not disadvantaged making at least 2 levels of progress in writing 2012
284PT2WritTA_13Percentage of pupils making at least 2 levels of progress in writing 2013
285PT2WritTA_FSMCLA_13% disadvantaged pupils making at least 2 levels of progress in writing 2013
286PT2WritTA_NotFSMCLA_13% pupils not disadvantaged making at least 2 levels of progress in writing 2013
287TEALGRP1Number of eligible pupils with English as first language
288PTEALGRP1% eligible pupils with English as first language
289TEALGRP3Number of eligible pupils with unclassified language
290PTEALGRP3% eligible pupils with unclassified language
291TSENELSTNumber of eligible pupils with SEN (Special Educational Needs) statements
292PSENELST% eligible pupils with SEN (Special Educational Needs) statements
293TSENELSAPNumber of eligible pupils with School Action Plus
294PSENELSAP% eligible pupils with School Action Plus
295SENELNNumber of eligible pupils with SEN (Special Educational Needs) supported at School Action
296PSENELN% eligible pupils with SEN (Special Educational Needs) supported at School Action
297THREEYR_FLAGAverage based on 3 years data
298TELIG_3YRTotal number of pupils at the end of key stage 2 over the past three years
299TFSMCLA_3YRTotal number of disadvantaged pupils at the end of key stage 2 over the past three years
300TNOTFSMCLA_3YRTotal number of non-disadvantaged pupils at the end of key stage 2 over the past three years
301ProgMaths_3YrPercentage of making at least 2 levels of progress in maths - 3 year average
302ProgMaths_3Yr_FSMCLAPercentage of disadvantaged pupils making at least 2 levels of progress in maths - 3 year average
303ProgMaths_3Yr_NotFSMCLAPercentage of pupils not disadvantaged making at least 2 levels of progress in maths - 3 year average
304ProgRead_3YrPercentage of making at least 2 levels of progress in reading - 3 year average
305ProgRead_3Yr_FSMCLAPercentage of disadvantaged pupils making at least 2 levels of progress in reading - 3 year average
306ProgRead_3Yr_NotFSMCLAPercentage of pupils not disadvantaged making at least 2 levels of progress in reading - 3 year average
307ProgWritTA_3YrPercentage of making at least 2 levels of progress in reading - 3 year average
308ProgWritTA_3Yr_FSMCLAPercentage of disadvantaged pupils making at least 2 levels of progress in reading - 3 year average
309ProgWritTA_3Yr_NotFSMCLAPercentage of pupils not disadvantaged making at least 2 levels of progress in reading - 3 year average
310PReadWritTAMatX_3YrPercentage of pupils achieving level 4 or above in reading and maths tests and writing TA - 3 year average
311PReadWritTAMatX_3Yr_FSMCLAPercentage of disadvantaged pupils achieving level 4 or above in reading and maths tests and writing TA - 3 year average
312PReadWritTAMatX_3Yr_NotFSMCLAPercentage of pupils not disadvantaged achieving level 4 or above in reading and maths tests and writing TA - 3 year average
313GAP_3YR_RWMXGap between Percentage of achieving level 4 or above in reading, writing TA and maths for disadvantaged pupils and others - 3 year average
314GAP_3YR_PRREADGap between Percentage of making expected progress in reading for disadvantaged pupils and others - 3 year average
315GAP_3YR_PRWRITGap between Percentage of making expected progress in writing for disadvantaged pupils and others - 3 year average
316GAP_3YR_PRMATGap between Percentage of making expected progress in maths for disadvantaged pupils and others - 3year average
317GAPN_3YR_RWMX_FSMCLAGap between school and national Percentage of achieving level 4 or above in reading, writing TA and maths for disadvantaged pupils - 3 year average
318GAPN_3YR_PRREAD_FSMCLAGap between school and national Percentage of making expected progress in reading for disadvantaged pupils - 3 year average
319GAPN_3YR_PRWRIT_FSMCLAGap between school and national Percentage of making expected progress in writing for disadvantaged pupils - 2 year average
320GAPN_3YR_PRMAT_FSMCLAGap between school and national Percentage of making expected progress in maths for disadvantaged pupils - 3 year average
321GAPN_3YR_RWMX_NotFSMCLAGap between school and national Percentage of achieving level 4 or above in reading, writing TA and maths for other pupils - 3 year average
322GAPN_3YR_PRREAD_NotFSMCLAGap between school and national Percentage of making expected progress in reading for other pupils - 3 year average
323GAPN_3YR_PRWRIT_NotFSMCLAGap between school and national Percentage of making expected progress in writing for other pupils - 3 year average
324GAPN_3YR_PRMAT_NotFSMCLAGap between school and national Percentage of making expected progress in maths for other pupils - 3 year average

Spend per Pupil dataCSV

VariableLabelTypeDescription
URNUnique Reference Number
LANUMBERLocal Authority Number
LONDONLondon/Non-LondonLONDONTYPE
MEDIANGroup to compareSAMEGROUPTYPE
PUPILSNumber of pupils (FTE)FLOATCFRFull time equivalent pupils
FSMPercentage of pupils eligible for Free School Meals (FSM)PCT1
FSMBANDFree school meals eligibility bandTEXT
GRANTFUNDINGGrant funding (£ per pupil)INTEGERIncludes funds delegated by the LA, funding for 6th form students, SEN funding, funding for minority ethnic pupils, standards fund, other government grants, other grants and payments, SSG pupil focused, pupil focused extended school funding and/or grants and Additional grant for schools
SELFGENERATEDINCOMESelf generated income (£ per pupil)INTEGERIncludes income from facilities and services, receipts from other insurance claims, income from contributions to visits etc, donations and/or private funds
TOTALINCOMETotal income (£ per pupil)INTEGERSum of grant funding and self generated income
TEACHINGSTAFFTeaching staff (£ per pupil)INTEGERIncludes all teachers' pay
SUPPLYTEACHERSSupply Staff (£ per pupil)INTEGERIncludes salaries for supply staff employed directly by the school, agency staff and insurance costs
EDUCATIONSUPPORTSTAFFEducation support staff (£ per pupil)INTEGERIncludes salaries and wages of education support staff and insurance costs
PREMISESPremises (incl. Staff costs) (£ per pupil)INTEGERIncludes building and premises maintenance and improvement, cleaning and caretaking, water and sewerage services including security and hygiene and includes salaries for employees of the school
BACKOFFICEBack office (incl. Staff costs) (£ per pupil)INTEGERIncludes administrative and clerical staff, administrative supplies and bought in professional services for administrative functions such as finances or legal
CATERINGCatering (incl. Staff costs) (£ per pupil)INTEGERIncludes spending on catering staff and catering supplies including providing free school meals and free milk
OTHERSTAFFOther staff costs (£ per pupil)INTEGERIncludes cost of other staff, indirect employess expenses, development and training, staff related insurance
ENERGYEnergy (£ per pupil)INTEGERIncludes all costs related to fuel and energy
LEARNINGRESOURCESLearning resources (not ICT equipment) (£ per pupil)INTEGERIncludes books, classroom and learning equipment, school trips and payments to alternative provision services
ICTICT learning resources (£ per pupil)INTEGERIncludes education software, cost of broadband, hire contracts and ICT revenue expenditure
BOUGHTINPROFESSIONALSERVICESBought in professional services - curriculum (£ per pupil)INTEGERIncludes spending on professional services to support the curriculum
OTHEROther expenditure (£ per pupil)INTEGERIncludes rates, exam fees, other insurance premiums, revenue contributions to capital costs, special facilities such as swimming pools
TOTALEXPENDITURETotal expenditure (£ per pupil)INTEGERSum of all expenditure categories
ATTAINMENTPercentage of pupils achieving Level 4 or above in all of reading, writing and mathsPCTPupils achieving Level 4 or above in all of reading, writing and maths
T1011CAT12010-11 Teaching and Education Support Staff Costs (£ per pupil)INTEGER
T1112CAT12011-12 Teaching and Education Support Staff Costs (£ per pupil)INTEGER
T1213CAT12012-13 Teaching and Education Support Staff Costs (£ per pupil)INTEGER
T1314CAT12013-14 Teaching and Education Support Staff Costs (£ per pupil)INTEGER
DCAT1Difference between 2010-11 and 2013-14 (£ per pupil)INTEGER
T1011CAT22010-11 Supply Staff Costs (£ per pupil)INTEGER
T1112CAT22011-12 Supply Staff Costs (£ per pupil)INTEGER
T1213CAT22012-13 Supply Staff Costs (£ per pupil)INTEGER
T1314CAT22013-14 Supply Staff Costs (£ per pupil)INTEGER
DCAT2Difference between 2010-11 and 2013-14 (£ per pupil)INTEGER
T1011CAT32010-11 Back Office (£ per pupil)INTEGER
T1112CAT32011-12 Back Office (£ per pupil)INTEGER
T1213CAT32012-13 Back Office (£ per pupil)INTEGER
T1314CAT32013-14 Back Office (£ per pupil)INTEGER
DCAT3Difference between 2010-11 and 2013-14 (£ per pupil)INTEGER
T1011CAT42010-11 Energy (£ per pupil)INTEGER
T1112CAT42011-12 Energy (£ per pupil)INTEGER
T1213CAT42012-13 Energy (£ per pupil)INTEGER
T1314CAT42013-14 Energy (£ per pupil)INTEGER
DCAT4Difference between 2010-11 and 2013-14 (£ per pupil)INTEGER
T1011CAT52010-11 Total Expenditure (£ per pupil)INTEGER
T1112CAT52011-12 Total Expenditure (£ per pupil)INTEGER
T1213CAT52012-13 Total Expenditure (£ per pupil)INTEGER
T1314CAT52013-14 Total Expenditure (£ per pupil)INTEGER
DCAT5Difference between 2010-11 and 2013-14 (£ per pupil)INTEGER
PGRANTFUNDINGGrant funding (proportion of total income)PCTIncludes funds delegated by the LA, funding for 6th form students, SEN funding, funding for minority ethnic pupils, standards fund, other government grants, other grants and payments, SSG pupil focused, pupil focused extended school funding and/or grants and Additional grant for schools
PSELFGENERATEDINCOMESelf generated income (proportion of total income)PCTIncludes income from facilities and services, receipts from other insurance claims, income from contributions to visits etc, donations and/or private funds
PTOTALINCOMETotal income (£ per pupil)INTEGERSum of grant funding and self generated income
PTEACHINGSTAFFTeaching staff (proportion of total expenditure)PCTIncludes all teachers' pay
PSUPPLYTEACHERSSupply Staff (proportion of total expenditure)PCTIncludes salaries for supply staff employed directly by the school, agency staff and insurance costs
PEDUCATIONSUPPORTSTAFFEducation support staff (proportion of total expenditure)PCTIncludes salaries and wages of education support staff and insurance costs
PPREMISESPremises (incl. Staff costs) (proportion of total expenditure)PCTIncludes building and premises maintenance and improvement, cleaning and caretaking, water and sewerage services including security and hygiene and includes salaries for employees of the school
PBACKOFFICEBack office (incl. Staff costs) (proportion of total expenditure)PCTIncludes administrative and clerical staff, administrative supplies and bought in professional services for administrative functions such as finances or legal
PCATERINGCatering (incl. Staff costs) (proportion of total expenditure)PCTIncludes spending on catering staff and catering supplies including providing free school meals and free milk
POTHERSTAFFOther staff costs (proportion of total expenditure)PCTIncludes cost of other staff, indirect employess expenses, development and training, staff related insurance
PENERGYEnergy (proportion of total expenditure)PCTIncludes all costs related to fuel and energy
PLEARNINGRESOURCESLearning resources (not ICT equipment) (proportion of total expenditure)PCTIncludes books, classroom and learning equipment, school trips and payments to alternative provision services
PICTICT learning resources (proportion of total expenditure)PCTIncludes education software, cost of broadband, hire contracts and ICT revenue expenditure
PBOUGHTINPROFESSIONALSERVICESBought in professional services - curriculum (proportion of total expenditure)PCTIncludes spending on professional services to support the curriculum
POTHEROther expenditure (proportion of total expenditure)PCTIncludes rates, exam fees, other insurance premiums, revenue contributions to capital costs, special facilities such as swimming pools
PTOTALEXPENDITURETotal expenditure (£ per pupil)INTEGERSum of all expenditure categories
PT1011CAT12010-11 Teaching and Education Support Staff Costs (proportion of total expenditure)PCT
PT1112CAT12011-12 Teaching and Education Support Staff Costs (proportion of total expenditure)PCT
PT1213CAT12012-13 Teaching and Education Support Staff Costs (proportion of total expenditure)PCT
PT1314CAT12013-14 Teaching and Education Support Staff Costs (proportion of total expenditure)PCT
PDCAT1Difference between 2010-11 and 2013-14 (percentage point difference)INTEGER
PT1011CAT22010-11 Supply Staff Costs (proportion of total expenditure)PCT
PT1112CAT22011-12 Supply Staff Costs (proportion of total expenditure)PCT
PT1213CAT22012-13 Supply Staff Costs (proportion of total expenditure)PCT
PT1314CAT22013-14 Supply Staff Costs (proportion of total expenditure)PCT
PDCAT2Difference between 2010-11 and 2013-14 (percentage point difference)INTEGER
PT1011CAT32010-11 Back Office (proportion of total expenditure)PCT
PT1112CAT32011-12 Back Office (proportion of total expenditure)PCT
PT1213CAT32012-13 Back Office (proportion of total expenditure)PCT
PT1314CAT32013-14 Back Office (proportion of total expenditure)PCT
PDCAT3Difference between 2010-11 and 2013-14 (percentage point difference)INTEGER
PT1011CAT42010-11 Energy (proportion of total expenditure)PCT
PT1112CAT42011-12 Energy (proportion of total expenditure)PCT
PT1213CAT42012-13 Energy (proportion of total expenditure)PCT
PT1314CAT42013-14 Energy (proportion of total expenditure)PCT
PDCAT4Difference between 2010-11 and 2013-14 (percentage point difference)INTEGER
PT1011CAT52010-11 Total Expenditure (proportion of total expenditure)PCT
PT1112CAT52011-12 Total Expenditure (proportion of total expenditure)PCT
PT1213CAT52012-13 Total Expenditure (proportion of total expenditure)PCT
PT1314CAT52013-14 Total Expenditure (proportion of total expenditure)PCT
PDCAT5Difference between 2010-11 and 2013-14 (percentage point difference)INTEGER
T1011CAT1LA2010-11 Teaching and Education Support Staff Costs (£ per pupil) for LAFLOAT
T1112CAT1LA2011-12 Teaching and Education Support Staff Costs (£ per pupil) for LAFLOAT
T1213CAT1LA2012-13 Teaching and Education Support Staff Costs (£ per pupil) for LAFLOAT
T1314CAT1LA2013-14 Teaching and Education Support Staff Costs (£ per pupil) for LAFLOAT
T1011CAT2LA2010-11 Supply Staff Costs (£ per pupil) for LAFLOAT
T1112CAT2LA2011-12 Supply Staff Costs (£ per pupil) for LAFLOAT
T1213CAT2LA2012-13 Supply Staff Costs (£ per pupil) for LAFLOAT
T1314CAT2LA2013-14 Supply Staff Costs (£ per pupil) for LAFLOAT
T1011CAT3LA2010-11 Back Office (£ per pupil) for LAFLOAT
T1112CAT3LA2011-12 Back Office (£ per pupil) for LAFLOAT
T1213CAT3LA2012-13 Back Office (£ per pupil) for LAFLOAT
T1314CAT3LA2013-14 Back Office (£ per pupil) for LAFLOAT
T1011CAT4LA2010-11 Energy (£ per pupil) for LAFLOAT
T1112CAT4LA2011-12 Energy (£ per pupil) for LAFLOAT
T1213CAT4LA2012-13 Energy (£ per pupil) for LAFLOAT
T1314CAT4LA2013-14 Energy (£ per pupil) for LAFLOAT
T1011CAT5LA2010-11 Total Expenditure (£ per pupil) for LAFLOAT
T1112CAT5LA2011-12 Total Expenditure (£ per pupil) for LAFLOAT
T1213CAT5LA2012-13 Total Expenditure (£ per pupil) for LAFLOAT
T1314CAT5LA2013-14 Total Expenditure (£ per pupil) for LAFLOAT
PT1011CAT1LA2010-11 Teaching and Education Support Staff Costs (proportion of total expenditure) for LAPCT
PT1112CAT1LA2011-12 Teaching and Education Support Staff Costs (proportion of total expenditure) for LAPCT
PT1213CAT1LA2012-13 Teaching and Education Support Staff Costs (proportion of total expenditure) for LAPCT
PT1314CAT1LA2013-14 Teaching and Education Support Staff Costs (proportion of total expenditure) for LAPCT
PT1011CAT2LA2010-11 Supply Staff Costs (proportion of total expenditure) for LAPCT
PT1112CAT2LA2011-12 Supply Staff Costs (proportion of total expenditure) for LAPCT
PT1213CAT2LA2012-13 Supply Staff Costs (proportion of total expenditure) for LAPCT
PT1314CAT2LA2013-14 Supply Staff Costs (proportion of total expenditure) for LAPCT
PT1011CAT3LA2010-11 Back Office (proportion of total expenditure) for LAPCT
PT1112CAT3LA2011-12 Back Office (proportion of total expenditure) for LAPCT
PT1213CAT3LA2012-13 Back Office (proportion of total expenditure) for LAPCT
PT1314CAT3LA2013-14 Back Office (proportion of total expenditure) for LAPCT
PT1011CAT4LA2010-11 Energy (proportion of total expenditure) for LAPCT
PT1112CAT4LA2011-12 Energy (proportion of total expenditure) for LAPCT
PT1213CAT4LA2012-13 Energy (proportion of total expenditure) for LAPCT
PT1314CAT4LA2013-14 Energy (proportion of total expenditure) for LAPCT
PT1011CAT5LA2010-11 Energy (proportion of total expenditure) for LAPCT
PT1112CAT5LA2011-12 Energy (proportion of total expenditure) for LAPCT
PT1213CAT5LA2012-13 Energy (proportion of total expenditure) for LAPCT
PT1314CAT5LA2013-14 Energy (proportion of total expenditure) for LAPCT

School Workforce dataCSV

 VariableLabelDescription
1LALocal Authority Number
2URNUnique Reference Number
3NTEATotal Number of Classroom Teachers and Teachers in the Leadership Group (Headcount)Headcount of all teachers in a school
4NTEAASTotal Number of Teaching Assistants (Headcount)Headcount of all teaching assistants in a school
5NNONTEATotal Number of Non Classroom-Based School Support Staff, Excluding Auxiliary Staff (Headcount)Headcount of all support (exc. auxillary) staff in a school
6NFTETEATotal Number of Classroom Teachers and Teachers in the Leadership Group (Full-time Equivalent)Full-time equivalent number of all teachers in a school
7NFTETEAASTotal Number of Teaching Assistants (Full-time Equivalent)Full-time equivalent number of all teaching assistants in a school
8NFTENONTEATotal Number of Non Classroom-Based School Support Staff, Excluding Auxiliary Staff (Full-time Equivalent)Full-time equivalent number of all support (exc. auxillary) staff in a school
9RATPUPTEAPupil:Teacher RatioRatio of pupils to teachers in a school
10SALARYMean Gross FTE Salary of All Teachers (Classroom Teachers and Those in the Leadership Group) (£s)Average gross salary of all teachers in a school

Spine dataCSV

ColumnField NameDescription
1URNSchool unique reference number
2LALocal Authority number
3ESTABEstablishment number
4LAESTABDfE number
5SCHNAMESchool name
6STREETSchool address (1)
7LOCALITYSchool address (2)
8ADDRESS3School address (3)
9TOWNSchool town
10POSTCODESchool postcode
11TELNUMSchool telephone number
12ICLOSESchool open / closed status (1 = Open, 2 = Closed, 3 = Pending closure)
13OPENDATEOpen date of school (if opened on or after 12th September 2011)
14CLOSEDATEDate the school closed (if closed on or after 12th September 2011)
15ISNEWIs the school new ( 0 = No, 1 = Yes)
16MINORGROUPType of school / college eg maintained school
17NFTYPESchool Type eg Voluntary Aided school
18ISPRIMARYDoes the school provide primary education? ( 0 = No, 1 = Yes)
19ISSECONDARYDoes the school provide secondary education? ( 0 = No, 1 = Yes)
20ISPOST16Does the school provide post 16 education? ( 0 = No, 1 = Yes)
21AGELLowest age of entry
22AGEHHighest age of entry
23GENDERIndicates whether it's a mixed or single sex school
24SFGENDERIndicates whether the sixth form is mixed or single sex (0 = Not Applicable 1 = Boys, 2 = Girls, 3 = Mixed)
25RELDENOMReligious Denomination
26ADMPOLAdmission Policy
27NEWACFLAGSchool academy status (1 = newly converted academy, 2 = school prior to conversion, 3 = sponsored academy, 4 = school closed to become an academy, 5 = closed school (not related to academies), 6 = no change to school status, 7 = new school)

Census dataCSV

 
VariableLabelTypeDescription
URNUnique Reference Number  
LAESTABDfE Number  
TOTPUPSENDNTotal number of pupils on roll (all ages)INTEGER 
NORGNumber of girls on rollINTEGER 
NORBNumber of boys on rollINTEGER
PNORGPercentage of girls on rollPCT1 
PNORBPercentage of boys on rollPCT1 
TSENSAPNumber of pupils SEN statement or on School Action PlusINTEGER 
TSENANumber of pupils on roll with SEN on School ActionINTEGER 
TOTSENSTTotal pupils with SEN statementINTEGER 
TOTSENAPTotal pupils at School Action PlusINTEGER 
PSENSAPPercentage of pupils with SEN statement or on School Action PlusPCT1 
PSENAPercentage of pupils on roll with SEN on School ActionPCT1 
PTOTSENSTPercentage pupils with SEN statementPCT1 
PTOTSENAPPercentage pupils at School Action PlusPCT1 
NUMEALNumber of pupils with English not as first languageINTEGER 
NUMUNGFLNumber of pupils with English first languageINTEGER 
NUMUNCFLNumber of pupils where first language is unclassifiedINTEGER 
PNUMEALPercentage of pupils with English not as first languagePCT1 
PNUMUNGFLPercentage pupils with English first languagePCT1 
PNUMUNCFLPercentage of pupils where first language is unclassifiedPCT1 
TOTPUPFSMDNNumber of pupils used in FSM calculationINTEGER 
NUMFSMTotal pupils eligible for free school mealsINTEGER 
NUMNOFSMTotal pupils not eligible for free school mealsINTEGER 
PNUMFSMPercentage of pupils eligible for free school mealsPCT1 
PNUMNOFSMPercentage pupils not eligible for free school mealsPCT1 
NUMFSMEVERNumber of pupils eligible for FSM at any time during the past 6 yearsFLOAT1 
PNUMFSMEVERPercentage of pupils eligible for FSM at any time during the past 6 yearsPCT1