Appendix - Importing Data Into Keypas - Key Stage 1 file specs

Local Authorities no longer have a statutory duty to collect the KS1 assessment on behalf of schools to submit to STA/DfE. This is now optional if the LA wishes to offer the facility to schools and if the school wishes to supply the data to the LA. This page remains in place for reference and to facilitate that optional collection. 

Keypas provides a facility for managing the collection and reporting of these assessments.

Keypas, Nova reports and Insight provides all the reports, exports and cleaning routines to allow the LA user to manage the analysis and reporting of these results.

Key Stage 1 

Used for: Importing data submitted by schools

Files available from: Direct from schools

When: June each year

Import route: Import > Key Stage 1

Contains: KS1 Teacher Assessment judgements across Reading, Writing and Maths

Extracts from school MIS: Each school MIS will have a different extraction routine, however it is expected that this will be the same as it was when KS1 was last statutory in 2023. LA who offer support to schools around usage of MIS may be able to provide more details to schools, otherwise schools may need to check with their suppliers. 

Key Stage 1 Pupil Import Files

Keypas accepts three types of pupil data files, CTF (.xml), KS1 (.xml) and output from the (pre-2023) DfE spreadsheet (as .csv). For CTF and KS1 files the file format should look like the examples below.

• nnnDDDD_CTF_nnnLLLL_xxx.xml
• nnnDDDD_KS1_nnnLLLL_xxx.xml
• KS1_DDDD_yy.csv,or,KS1_UUUUUU_yy.csv

Key:

• nnn = LA number
• DDDD = 4 digit DfE number
• UUUUUU = 6 digit URN number
• xxx = Incremental export number
• yy = Year
• LLLL = Fixed value