We recommend importing data from Key to Success where possible.

4Matrix update 3.9.4.9 (November 2018) removed the FFT import option as the data comes 'pre-calculated' from them and we are unable to verify the calculations used.

You can download your KS2 Test Levels and Teacher Assessments from Key To Success (K2S) and import them into 4Matrix.

If you already have data in your Markbook tool (Admin > Edit Markbook) then please make a copy of this first for future reference by exporting it (File > Export). You should then remove the data from the Markbook by clicking on a grade/value in each column and using the Delete function in the top right.

Instructions for Key to Success import

• A .csv file can be downloaded from https://www.keytosuccess.education.gov.uk/

• Users will need to log in and download the file - you'll need to have the UPNs for the year group to hand.

• Once you have the .csv file, open it and copy the entire spreadsheet

• Then, go to Admin > Spreadsheet > Key To Success (BETA) and follow the remaining steps.

• As part of the copy and paste process, 4Matrix will automatically calculate Fine Points, Fine Level and TA, in accordance with the latest guidance from the DfE's KS4 accountability guide.

• You should not need to edit or change any of the settings as you work through the import, as all relevant columns will be mapped, and any remaining un-mapped columns will be dropped as you complete steps 4 and 5 of the import. The only intervention required will be if you have any pupils with a Test Level 6 - please contact us if this is the case.

Notes:

Y11 and Y10 in the 2018/19 academic year are the last 2 cohorts to use the 'legacy' key stage 2 values of Test Levels, Fine Points and TA.

Current Y7-Y9 pupils in the 2018/19 academic year use the new Scaled Scores format. This can be imported using the instructions above, but please note, you will not see a Progress 8 score for these pupils as there is currently no guidance on using scaled scores for this measure. Please refer to our news page and article http://www.4matrix.com/node/6222 for more information.

Article updated: 07/12/2018