Appendix: Insight Data Sources & Significance Methodology

NCER -  Content Editor
NCER - Content Editor
  • Updated

Data Sources

Check the table below for information about the datasets currently being used by Insight.

Insight works on cached data, this means you'll find pages load quickly, but you may have to wait until the following morning before it includes data you have imported via Keypas.

 Ac. Year 2017/18Ac. Year 2018/19Ac. Year 2019/20Ac. Year 2020/21Ac. Year 2021/22Ac. Year 2022/23Ac. Year 2023/24Ac. Year 2024/25Ac. Year 2025/26
Absence & ExclusionsDfE (F)DfE (F)KeypasKeypasDfE (F)DfE (F)DfE (F)KeypasKeypas
EYFSPKeypasKeypasNot availableNot availableKeypasKeypasKeypasKeypasKeypas
PhonicsKeypasKeypasKeypasKeypasKeypasKeypasKeypasKeypasKeypas
KS1DfE (F)DfE (F)Not available Not availableDfE (F)DFE (F)Keypas (Optional)Keypas (Optional)Keypas (Optional)
KS2**DfE (F)**Not availableNot availableDfE (F)DfE (F)DfE (F)DfE (A) 
KS4**DfE (F)**Not yet availableNot yet availableDfE (F)DfE (F)DfE (F)DfE (A) 

* The earliest 2 academic years are for trend values only.

Note: 19/20 and 20/21 were affected by Covid-19 and there were no attainment results apart from Phonics (Autumn) and KS4.

NPD Versions

F = Final

A = Amended

U = Unamended

KS1 to KS2 Progress Quintile methodology (from 2026 onwards)

From 2026 KS1 to KS2 progress results has been banded into quintiles. The methodology for these quintiles is is shown below and applies to reading, writing and to maths. 

Quintiles are based on percentile rankings and are calculated at the LA level and the school level (depending on the user's selected scope in Insight). 

Percentile rankings range from 1 - 100 where 1 represents the highest achieving LA or schools. 

Mapping percentiles to quintiles. 

Quintiles are created by grouping percentile rankings into five equal bands of 20% each. This approach is applied directly to the existing percentile rankings as used in insight. 

The mapping is as follows:

  • 0-20% = Quintile 1 (top 20%)
  • 21-40% = Quintile 2
  • 41-60% = Quintile 3
  • 61-80% = Quintile 4
  • 81-100% = Quintile 5 (bottom 20%)

For example, a school or pupil group with a percentile ranking of 47 would fall into Quintile 3.