School Census Autumn 2010

1. Version 1.3 School Census Autumn 2010 DfE Summary Report Jim Haywood Product Manager 1

2. DfE Guidance • School Census 2010 School Summary has been designed by the DfE to provide key school level information from the pupil and school level modules in an easy to read format. • The summary is designed to fulfil the needs of nursery, primary, middle deemed primary, secondary, including middle deemed secondary, CTC’s and academies and special schools (including non-maintained special schools) and special hospital schools and on a voluntary basis Service Children’s Education (primary schools). 2

3. DfE Guidance • The summary fulfils a number of purposes: • to allow school staff preparing the return to check its accuracy and completeness before passing it to the head teacher • to allow the head teacher authorising the return to check its accuracy and completeness before passing it to the LA and DCSF • where the summary is forwarded to the LA, it enables the LA to check the return from the school • provides DfE with assurance that the return has been subject to plausibility checking by the school and LA • to allow the head teacher to keep track of absence figures – particularly persistent absentees. 3

4. School Census Autumn 2010 Report Header 4

5. This summary report is created from XSL files provided by the DfE. We recommend import of Fileset 0053 which includes the XSL files for this Summary Report issued by the DfE on the 27th August. You should quote this version number when contacting the DfE Date Services Group help desk (dsg.helpdesk@education.gsi.gov.uk). 5

6. School Census Autumn 2010 Report Tables 6

7. Establishment Name A1 A1 LA Number A2 A3 A2 A3 DfE Establishment Number Sub-dwelling, Dwelling, Street, Town and Post Town A4 A4 Telephone Number A5 School Email Address A6 A7 School Phase A8 Type of School A5 A9 Governance Intake Type A6 A10 Gender of Pupils (Entry to School) A11 A7 Gender of Pupils (Entry to Sixth Form) A12 A8 Maximum Year Group A13 A9 Maximum Year Group A14 A10 A11 A12 A13 A14 7

8. Count pupils on roll where Pupil Gender = M and Pupil Part-time Indicator = false and Pupil Date of Birth is before 01/09/1991 B1 Count pupils on roll where Pupil Gender = F and Pupil Part-time Indicator = false and Pupil Date of Birth is before 01/09/1991 B2 B2 B3 B4 B1 B6 B7 B8 Count pupil on roll where Pupil Gender = M and Pupil Part-time Indicator = true and Pupil Date of Birth is before 01/09/1991 B5 B3 Count pupils on roll where Pupil Gender = F and Pupil Part-time Indicator = true and Pupil Date of Birth is before 01/09/1991 B4 Count pupils on roll where Pupil Gender = M and Pupil Part-time Indicator = false and Pupil Date of Birth is between 01/09/1991 and 31/08/92 etc for other age groups B5 Count pupils on roll where Pupil Gender = F and Pupil Part-time Indicator = false and Pupil Date of Birth between 01/09/1991 and 31/08/92 etc for other age groups B5 B7 Count pupil on roll where Pupil Gender = M and Pupil Part-time Indicator = true and Pupil Date of Birth is between 01/09/1991 and 31/08/92 etc for other age groups Count pupils on roll where Pupil Gender = F and Pupil Part-time Indicator = true and Pupil Date of Birth is between 01/09/1991 and 31/08/92 etc for other age groups B8 B9 Count pupils on roll where Pupil Part-time Indicator = false Count pupils on roll where Pupil Part-time Indicator = true B10 Count all pupils on roll, i.e. [B9] plus [B10] B11 Count all pupils on roll where Pupil Date of Birth is before 01/09/2005 B12 B9 B10 B11 B12 8

9. Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 14 C1 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 13 C1 C2 C2 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 12 C3 C3 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 11 C4 C4 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 10 C5 C5 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 9 C6 C6 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 8 C7 C7 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 7 C8 C8 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 6 C9 C9 C10 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 5 C10 C11 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 4 C11 C12 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 3 C12 C13 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 2 C14 C13 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 1 C15 C14 C16 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = R C15 C17 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = N2 C16 C18 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = N1 C17 C19 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = N/A C18 Count all pupils on roll [Should be equal to the sum of C1 to C18] C19 9

10. Pupil's Actual National Curriculum Year Group D1 D2 D1 For all values of Pupil's Actual National Curriculum Year Group between 1 and 14, count all pupils on roll where (age at 31/08/2010 – 4) not = Pupil's Actual National Curriculum Year Group If Pupil's Actual National Curriculum Year Group = N1, count all pupils where age at 31/08/2010 is not between 0 and 4, inclusive If Pupil's Actual National Curriculum Year Group = N2, count all pupils where age at 31/08/2010 is not between 0 and 4, inclusive If Pupil's Actual National Curriculum Year Group = R, count all pupils where age at 31/08/2010 is not between 3 and 5, inclusive D2 10

11. Pupil Ethnicity Code E1 E1 E2 E3 Pupil Ethnicity Description E2 Count of pupils on roll aged 5 and over (Pupil Date of Birth is before 01/09/2005) with that Ethnicity code E3 11

12. Pupil First Language Code E1 E1 E2 E3 Pupil First Language Description E2 Count of pupils on roll aged 5 and over (Pupil Date of Birth is before 01/09/2005) with that First Language E3 12

13. G1 G2 G3 G4 Count of pupils on roll where Pupil Enrolment Status = C (Single Registration) G1 Count of pupils on roll where Pupil Enrolment Status = M (Main - Dual Registration) G2 Count of pupils on roll where Pupil Enrolment Status = S (Subsidiary - Dual Registration) G3 G2 plus G3 G4 13

14. Count of pupils on roll where Pupil Boarder Indicator is present and not equal to N H1 H1 Count of pupils on roll where Pupil Free School Meal Eligibility = true H2 H2 Count of pupils on roll where Gifted & Talented indicator = true H3 H3 Count of pupils with Hours at Setting H4 H4 14

15. I1 I2 I3 I4 Count of pupils on roll with DOB on or before the 31/08/1998 where Connexions Agreement = Yes (Connexions Assent Obtained) I1 Count of pupils on roll with DOB on or before the 31/08/1998 where Connexions Agreement = No (Connexions Assent Refused) I2 Count of pupils on roll with DOB on or before the 31/08/1998 where Connexions Agreement = UNS (Connexions Assent Unsought) I3 Count of pupils on roll with DOB on or before the 31/08/1998 where Connexions Agreement = SNR (Connexions Assent No Reply) I4 15

16. J1 J2 J3 J4 J5 J6 Count of pupils where SEN Provision (know as SEN Status in SIMS) = A (School/Early Years Action) J1 Count of pupils where SEN Provision = P (School/Early Years Action+) J2 Count of pupils where SEN Provision = A or P J3 Count of pupils where SEN Provision = S (Statement) J4 Count of pupils where SEN Provision = A, P or S J5 Count of pupils where SEN Provision = N (No Special Educational Need) J6 16

17. K2 K3 K1 K4 K5 K6 K7 Exclusion Reason Code for Exclusion Category = PERM (Permanent) K1 Description for Exclusion Reason Code K2 Number of exclusions for Exclusion Reason Code K3 Number of pupils with Exclusion Category = PERM and In Care Indicator = true) K4 K5 Number of pupils with Exclusion Category = PERM and SEN Provision = A (School/Early Years Action) K6 Number of pupils with Exclusion Category = PERM and SEN Provision = P (School/Early Years Action+) K7 Number of pupils with Exclusion Category = PERM and SEN Provision = S (Statement) 17

18. L1 L2 L3 L4 L5 L6 L7 Exclusion Reason Code for Exclusion Category = FIXD (Fixed Term) L1 Description for Exclusion Reason Code L2 Number of exclusions for Exclusion Reason Code L3 Number of pupils with Exclusion Category = FIXD and In Care Indicator = true) L4 L5 Number of pupils with Exclusion Category = FIXD and SEN Provision = A (School/Early Years Action) L6 Number of pupils with Exclusion Category = FIXD and SEN Provision = P (School/Early Years Action+) L7 Number of pupils with Exclusion Category = FIXD and SEN Provision = S (Statement) 18

19. M2 M3 M1 M4 M5 M6 M7 Exclusion Reason Code for Exclusion Category = LNCH (Lunchtime) M1 Description for Exclusion Reason Code M2 Number of exclusions for Exclusion Reason Code M3 Number of pupils with Exclusion Category = LNCH and In Care Indicator = true) M4 M5 Number of pupils with Exclusion Category = LNCH and SEN Provision = A (School/Early Years Action) M6 Number of pupils with Exclusion Category = LNCH and SEN Provision = P (School/Early Years Action+) M7 Number of pupils with Exclusion Category = LNCH and SEN Provision = S (Statement) 19

20. N1 N2 N3 N4 N5 N6 N7 N8 N9 N10 N11 N12 N13 Number of pupils included in the Return where possible sessions > 0 AND DOB is between 01/09/1993 AND 31/08/2004 AND Border = N (not a boarder) or is missing (N5/N4)*100 N8 N1 (N6/N4)*100 N9 (N7//N4)*100 N10 Number of pupils included in the Return where possible sessions > 0 AND DOB is between 01/09/1993 AND 31/08/2004 AND Border = N (not a boarder) or is missing AND number of Authorised Absences plus Unauthorised Absences > 0 N2 (N2/N1)*100 N3 Number of possible sessions for pupils counted in N1 above N4 If N4/N1 < 275 or if N4/N1 > 360 display "Average Sessions are not in expected range", otherwise display "OK" N11 Number of authorised absences for pupils counted in N1 above. N5 Number of unauthorised absences for pupils counted in N1 above. If N9 > N8 display "Warning - check", otherwise display "OK" N6 N12 N5+N6 If N10 > 20 display "Warning – check", otherwise display "OK" N7 N13 20

21. P1 P2 P3 P4 P5 P6 P7 Count of pupils on roll where Pupil's Actual National Curriculum Year Group < 12 where at least one Learning Aim is present P1 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group < 12 P2 Count of Learning Aims for Pupils On Roll where Pupils On Roll where Pupil's Actual National Curriculum Year Group < 12 and Learning Aim Completion Status = 0 (Re-sit) P3 Count of Learning Aims for Pupils On Roll where Pupils On Roll where Pupil's Actual National Curriculum Year Group < 12 and Learning Aim Completion Status = 1 (Continuing) P4 Count of Learning Aims for Pupils On Roll where Pupils On Roll where Pupil's Actual National Curriculum Year Group < 12 and Learning Aim Completion Status = 2 (Completed) P5 Count of Learning Aims for Pupils On Roll where Pupils On Roll where Pupil's Actual National Curriculum Year Group < 12 and Learning Aim Completion Status = 3 (Withdrawn) P6 Count of Learning Aims for Pupils On Roll where Pupils On Roll where Pupil's Actual National Curriculum Year Group < 12 and Learning Aim Completion Status = 4 (Transferred) P7 21

22. P8 P1 P9 P2 P10 P3 P11 P4 P12 P5 P13 P6 P14 P7 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 12 where at least one Learning Aim is present P8 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 12 P9 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 12 and Learning Aim Completion Status = 0 (Re-sit) P10 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 12 and Learning Aim Completion Status = 1 (Continuing) P11 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 12 and Learning Aim Completion Status = 2 (Completed) P12 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 12 and Learning Aim Completion Status = 3 (Withdrawn) P13 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 12 and Learning Aim Completion Status = 4 (Transferred) P14 22

23. P8 P15 P1 P9 P16 P2 P10 P17 P3 P11 P18 P4 P12 P19 P5 P13 P20 P6 P14 P21 P7 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 13 where at least one Learning Aim is present P15 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 13 P16 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 13 and Learning Aim Completion Status = 0 (Re-sit) P17 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 13 and Learning Aim Completion Status = 1 (Continuing) P18 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 13 and Learning Aim Completion Status = 2 (Completed) P19 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 13 and Learning Aim Completion Status = 3 (Withdrawn) P20 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 13 and Learning Aim Completion Status = 4 (Transferred)) P21 23

24. P8 P15 P22 P1 P9 P16 23 P2 P10 P17 P24 P3 P11 P18 P25 P4 P12 P19 P26 P5 P13 P20 P27 P6 P14 P21 P28 P7 Count all pupils on roll where Pupil's Actual National Curriculum Year Group = 14 where at least one Learning Aim is present P22 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 14 P23 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 14 and Learning Aim Completion Status = 0 (Re-sit) P24 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 14 and Learning Aim Completion Status = 1 (Continuing) P25 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 14 and Learning Aim Completion Status = 2 (Completed) P26 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 14 and Learning Aim Completion Status = 3 (Withdrawn) P27 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group = 14 and Learning Aim Completion Status = 4 (Transferred) P28 24

25. P8 P15 P22 P29 P1 P9 P16 23 P30 P2 P10 P17 P24 P31 P3 P11 P18 P25 P32 P4 P12 P19 P26 P33 P5 P13 P20 P27 P34 P6 P14 P21 P28 P35 P7 Count all pupils on roll where Pupil's Actual National Curriculum Year Group > 12 where at least one Learning Aim is present P29 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group > 12 P30 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group > 12 and Learning Aim Completion Status = 0 (Re-sit) P31 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group > 12 and Learning Aim Completion Status = 1 (Continuing) P32 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group > 12 and Learning Aim Completion Status = 2 (Completed) P33 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group > 12 and Learning Aim Completion Status = 3 (Withdrawn) P34 Count of Learning Aims for Pupils On Roll where Pupil's Actual National Curriculum Year Group > 12 and Learning Aim Completion Status = 4 (Transferred) P35 25

26. P8 P15 P22 P29 P36 P1 P9 P16 23 P30 P37 P2 P10 P17 P24 P31 P38 P3 P11 P18 P25 P32 P39 P4 P12 P19 P26 P33 P40 P5 P13 P20 P27 P34 P41 P6 P14 P21 P28 P35 P42 P7 Count of Pupils No Longer on Roll where at least one Learning Aim is present P36 Count of Learning Aims for Pupils On Roll where Pupils are No Longer on Roll P37 Count of Learning Aims for Pupils No Longer on Roll, where Learning Aim Completion Status = 0 (Re-sit) P38 Count of Learning Aims for Pupils No Longer on Roll, where Learning Aim Completion Status = 1 (Continuing) P39 Count of Learning Aims for Pupils No Longer on Roll, where Learning Aim Completion Status = 2 (Completed) P40 Count of Learning Aims for Pupils No Longer on Roll, where Learning Aim Completion Status = 3 (Withdrawn) P41 Count of Learning Aims for Pupils No Longer on Roll, where Learning Aim Completion Status = 4 (Transferred) P42 26

27. Thank youfor your time 27