| Literature DB >> 32935030 |
Matthew Alexander Jay1,2, Louise McGrath-Lone1,3, Ruth Gilbert1.
Abstract
INTRODUCTION: The National Pupil Database (NPD) is a record-level administrative data resource curated by the UK government's Department for Education that is used for funding purposes, school performance tables, policy making, and research. PROCESSES: Data are sourced from schools, exam awarding bodies, and local authorities who collect data on an on-going basis and submit to the Department for Education either termly or yearly. DATA CONTENTS: NPD contains child-level and school-level data on all pupils in state schools in England (6.6 million in the 2016/17 academic year). The primary module is the census, which has information on characteristics and school enrolment. Other modules include alternative provision, exam attainment, absence and exclusions. Data from children's social care are also available on children referred for support and those who become looked after. Children's records are linkable across different modules and across time using a nationally unique, anonymised child-level identifier. Linkage to external datasets has also been accomplished using child-level identifiers.Entities:
Year: 2019 PMID: 32935030 PMCID: PMC7482519 DOI: 10.23889/ijpds.v4i1.1101
Source DB: PubMed Journal: Int J Popul Data Sci ISSN: 2399-4908
Figure 1: Overview of datasets.NPD National Pupil Database; DfE Department for Education; GDPR General Data Protection Regulation; SEN Special Educational Needs
| Tiers (old system) | Identifiability risk | Sensitivity |
|---|---|---|
Tier 1 (highly sensitivity child-level that requires justification as to why it is needed and why Tier 2 is not sufficient) Tier 2 (highly sensitive that requires justification as to why the data item is needed) Tier 3 (school-level data) Tier 4 (child-level as standard in NPD extracts) | 1 (instant identifier) 2 (meaningful identifier) 3 (meaningless identifier) 4 (non-identifier that has a high risk of identification associated with it) 5 (other) | A (not used outside DfE) B (highly sensitive) C (sensitive not captured as part of a special GDPR category) D (sensitive captured as part of a special GDPR category, e.g. SEN) E (other) |
SC School Census; PRU Pupil Referral Unit Census; EY Early Years Census; AP Alternative Provision; LA local authority) There have been changes in some of these variables over time and details may vary for different censuses. * Includes SC, PRU, EY and AP. Identifiability and sensitivity levels are explained in Table 1.
| Variable | Census | Identifiability | Sensitivity | Details / less sensitive alternatives |
|---|---|---|---|---|
| Pupil matching reference | All* | 3 | E | Anonymised child-level identifier based on Unique Pupil Number with salience only to NPD. A non-anonymised version and the Unique Pupil Number are available (both identifiability 2). |
| Gender | All* | 5 | E | |
| Date of birth | All* | 4 | E | Lower tier age variables include month and year of birth, age at start of academic year and month part of age at start of academic year (all identifiability 5). |
| Names | All* | 1 | E | Forenames, surnames, middle names and former surname. |
| Ethnicity | All* | 4 | D | Also available as ethnic groups major and minor. |
| Postcode | All* | 4 | E | Census output area and lower-layer super output areas also available (same sensitivity and identifiability). |
|
| ||||
| Language | SC, PRU | 4 | D | Also available as first language, except in PRUs (identifiability 5), and language group major and minor (identifiability 5). |
| Free school meals | SC, PRU, AP | 5 | C | Whether child recorded as eligible for free school meals. Available as currently eligible and eligible over the past 3 or 6 years or ever. |
| Special educational needs | All* | 5 | D | Available are primary and secondary need type. Special educational needs provision (i.e. whether the child receives support, a statement or an Education, Health and Care Plan) is also available. |
| Absences | SC (supplied separately) | 4-5 | C-E | Data on the number of possible sessions per term, the number of authorised absences and the number of unauthorised absences as well as reasons for absences. |
| Exclusions | SC (supplied separately) | 4-5 | C-E | Data on the number of sessions excluded from and the category of exclusions (fixed or permanent), as well as reasons for exclusions. |
| Dates of joining and leaving | SC, PRU | 5 | E | Dates that the pupil joined and left the school. |
| Unique reference number | SC, PRU, EY | 4 | E | DfE school unique reference number. |
| Establishment code | SC, PRU | 5 | E | Establishment code assigned by the DfE. |
| LA-establishment code | SC, PRU | 4 | E | Local authority code and establishment code joined together. |
| LA | All* | 5 | E | Code identifying the local authority that the school reports to. |
| Output areas | SC, PRU | 4 | E | Based on the child’s postcode, either the 2001 or 2011 versions depending on academic year. Census output areas and lower-layer super output areas available. |
| Home LA | SC, PRU | 5 | E | The local authority in whose area the child lives. |
EYFSP Early years foundation stage profile; KS Key Stage; GCSE General Certificate of Secondary Education; GNVQ General National Vocational Qualification; GCE General Certificate of Education
| Stage | Ages (School years) | Details |
|---|---|---|
| EYFSP | 3-5 (Early years / reception) | There are 13 subscales scored 0-9, which measure communication; physical development; personal, social and emotional development; literacy; mathematics; understanding the world; and expressive arts and designs. Assessment is by the class teacher on the basis of classroom observations. Data are available on the overall score, each subscale score and each element that makes up the scores. |
| KS1 | 5-7 (Years 1-2) | Tests at Key Stage 1 include teacher-assessed English reading, spelling, punctuation and grammar, science and mathematics. Data on whether the child underwent each test and the level achieved are available. |
| KS2 | 7-11 (Years 3-6) | Children sit tests in the same subjects at the end of Key Stage 2 as at Key Stage 1. The level achieved as well as the actual marks are stored in NPD. |
| KS3 | 11-14 (Years 7-9) | Key Stage 3 exams are no longer administered in England. Between 1998 and 2013, children sat externally-marked English, mathematics and science exams and the scores from these tests are available in NPD. |
| KS4 | 14-16 (Years 10-11) | Includes GCSEs, GNVQs and other GCSE equivalents. Two files are available: an indicator file which contains an overall summary of each pupil’s main exam results and a results file which contains data on qualifications achieved by each pupil. Measures therefore include summaries such as whether a child achieved the English baccalaureate in addition to the subject-specific results. KS4 data are also available on children in private schools |
| KS5 | 16-18 (Years 12-13) | Children typically take the GCE, (also known as Advanced Subsidiary (AS) and Advanced (A) levels) before applying to university. Data on pupils in both schools and colleges are included and only students who complete two years of study (i.e. to Advanced level) are included. Data on individual subjects are available. Note that until 2013, participation in education beyond 16 in England was optional. Since then, children have a duty to remain in education or training until they are 17, and until 18 from 2015, though this need not necessarily be towards AS or A levels. KS5 data are also available on children in private schools. |
ONS Office for National Statistics. Sources: Department for Education [20] and ONS mid-year estimates [21].
* Only aggregate data are available for children in independent (private) schools.
| 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | |
|---|---|---|---|---|---|---|---|
| ONS estimate, ages 5-15 | 6,680,298 | 6,701,384 | 6,736,870 | 6,795,108 | 6,872,599 | 6,970,434 | 7,100,054 |
| School Census | 6,168,470 | 6,192,170 | 6,233,560 | 6,307,060 | 6,388,827 | 6,491,811 | 6,612,292 |
| Pupil referral units | 13,720 | 13,230 | 12,630 | 12,525 | 13,195 | 14,583 | 15,229 |
| Alternative provision | 18,305 | 17,670 | 17,790 | 15,555 | 15,551 | 16,149 | 16,640 |
| Independent schools* | 423,370 | 422,695 | 424,485 | 423,370 | 424,038 | 425,414 | 426,436 |
| Total | 6,623,865 | 6,645,765 | 6,688,465 | 6,758,510 | 6,841,611 | 6,947,957 | 7,070,597 |
| % of all children | 99.2% | 99.2% | 99.3% | 99.5% | 99.5% | 99.7% | 99.6% |