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

Local Authorities have a statutory duty to collect the KS1 assessment on behalf of schools to submit to STA/DfE. 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

Key Stage 1 Pupil Import Files

Keypas accepts three types of pupil data files, CTF (.xml), KS1 (.xml) and output from the 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