1 / 19

Understanding the National Pupil Database: Content, Structure, and Data Processing

The National Pupil Database (NPD) is a comprehensive repository that includes data from various educational assessments and progress tests across Key Stages. This resource outlines the data structure, which connects individual pupil records with their test results and other educational indicators. It explains the data collection processes, key timelines, and how the Department for Education and Skills (DfES) utilizes this information for analysis and policy-making. Key stages of assessment included are Foundation Stage, Key Stage 1-5, with detailed timings for data submission and release.

ingo
Download Presentation

Understanding the National Pupil Database: Content, Structure, and Data Processing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. National Pupil Database: Current content & structure Anna Barker Data Services Group DfES

  2. National Pupil Database: Current content & structure • What data is included? • How does the data link together • The data collection process • Release schedule • Current access to data • How DfES uses data

  3. What data is included within NPD? Year 7 Progress Test Results Keys: PupilID, Academic Year, Lea/Estab Key Stage 3 Results Keys: PupilID, Academic Year, Lea/Estab Key Stage 4 Indicators Key Stage 4 Results Key Stage 2 Results Keys: PupilID, Academic Year, Lea/Estab Key Stage 4 Candidate Keys: PupilID, Academic Year, Lea/Estab Core Pupil Keys: PupilID, Academic Year, Lea/Estab, Pupil postcode Key Stage 5 Results Key Stage 1 Results Keys: PupilID, Academic Year, Lea/Estab Key Stage 5 Candidate Keys: PupilID, Academic Year, Lea/Estab Key Stage 5 Indicators Foundation Stage Profile Keys: PupilID, Academic Year, Lea/Estab Information Learner Record - Aims Keys: PupilID, Academic Year, Lea/Estab PLASC Keys: PupilID, Academic Year, Lea/Estab, Pupil postcode

  4. NPD: The Data Collection Process 2005

  5. NPD: The Data Collection Process 2005 • Pupil Level Annual School Census (PLASC) • Schools complete census –20th January • Deadline for school returns – 17th February • Data cleaning – March - April • Closure of database - May • Extract of PLASC provided to NPD – 25th May • PLASC data matched into NPD – 16th June

  6. NPD: The Data Collection Process 2005 • Key Stage 1 (Version 1 & Version 2) • Schools complete KS1 assessments - 30th June • Local Authorities submit data to DfES – 31st July • KS1 version 1 extract provided to NPD – 10th August • KS1 NPD version 1 available on request – 13th September • Local Authorities chased - Autumn Term • KS1 version 2 provided to NPD – End January 06 • KS1 NPD version 1 available on request – Beginning March 06

  7. NPD: The Data Collection Process 2005 • Year 7 Progress Test (Y7) data • Tests carried out – 9th May – 13th May • Mark sheets provided to marker – 2 days after tests • Tests marked – June/July • Y7 data extracted provided to NPD – 22nd August • Y7 data matched into NPD – 13th September • Y7 NPD data available for release – 27th September

  8. NPD: The Data Collection Process 2005 • Key Stage 2 (KS2) data • Tests administered – 9th May – 13th May • Datafeed provided to AAT matching contractor – 15th August • Data extract provided to NPD – 9th September • Unamended KS2 NPD available for release – 25th October • Schools provide amendments to AAT checking contractor – Beginning October • Amended KS2 extract provided to NPD – 11th November • Amended KS2 NPD available for release – 16th December • Errata changes taken on board – February 06 • Data extract provided to NPD – 24th February 06 • Final KS2 NPD available for release – 7th April 06

  9. NPD: The Data Collection Process 2005 • Foundation Stage Profile (FSP) data • Schools complete FSP assessments - 30th June • Local Authorities submit data to DfES – 31st August • FSP extract provided to NPD – 23rd September • FSP data matched into NPD – 20th October • FSP NPD data available on request – 31st October

  10. NPD: The Data Collection Process 2005 • Key Stage 4 (KS4) & Key Stage 5 (KS5) data • Entry data collected from Awarding Bodies – May 2005 • Result data collected from Awarding Bodies – August 2005 • Unamended KS4 & KS5 data provided to NPD – 26th September • Unamended KS4 & KS5 data available for release – 11th November • Amendments provided by schools/colleges – Mid October • Amended KS4 & KS5 extracts provided to NPD – 9th December • Amended KS4 & KS5 NPD available for release – February ’06 • Errata changes provided by schools/colleges –January/February 06 • Final KS4 & KS5 data extract provided to NPD – 18th April 06 • Final KS4 & KS5 NPD available for release – End May 06

  11. NPD: The Data Collection Process 2005 • Key Stage 3 (KS3) data • Tests administered – 9th May – 13th May • KS3 English scripts sent to schools – Mid August • KS3 English review outcomes to schools – End Nov • Data extract provided to NPD – 1st December • Unamended KS3 NPD available for release – 31st January ‘06 • Amendments provided by schools – End February 06 • Amended KS3 data extract provided to NPD – 15th March 06 • Amended KS3 NPD available for release – Beginning May 06 • Errata changes provided by schools– March/April 06 • Final KS3 data extract provided to NPD – 26th May 06 • Final KS3 NPD available for release – 7th July 06

  12. NPD: Release Schedule • PLASC data – Beginning of July • Version 1 KS1 data – Mid September • Y7 Progress Test data – End September • Unamended KS2 data – Mid October • Foundation Stage Profile data – End October • Unamended KS4 & KS5 data – Mid November • Amended KS2 data – Mid December

  13. NPD: Release Schedule • Unamended KS3 data – End January • Amended KS4 & KS5 data – End February • Version 2 Key Stage 1 data – Beginning March • Amended Key Stage 3 data – Beginning May • Final Key Stage 2 data – Beginning April • Final Key Stage 4 & Key Stage 5 data – End May • Final Key Stage 3 data – Beginning July

  14. NPD: Current Access Arrangements • Process • Internal & External users formally request data extracts • Declaration form is completed • Request logged • Data dispatched • Problems • Resource intensive • Bottle necks

  15. NPD: Current DfES Uses of the data • Statistical First Release: National Curriculum Assessment and GCSE/GNVQ Attainment by Pupil Characteristics, in England. • Residency based analyses • Contextualised Value Added

  16. Any Questions? Contact Details: E-mail - Anna.Barker@dfes.gsi.gov.uk

More Related