Accessing 4Matrix from Outside School

There are several ways in which this can be achieved, and we have put together a document to help users decide on which option is best for their school. 

You can download the document from this link: https://www.4matrix.com/news/remoteaccess

In-light of the current situation, we are extending the free-use period of 4Matrix Infinity for all schools until September 2020.


Import Fix

There is a fix available for an error which occurs when attempting to import data via a spreadsheet into an existing series in which results or custom field data has already been imported.

Please visit https://www.4matrix.com/news/importfix for more details.


 Importing Key Stage 2 Data

Solution

We strongly recommend importing data from Key to Success where possible. You can download your KS2 Test Levels and Teacher Assessments from Key To Success (K2S) and import them into 4Matrix.

The following notes can be used to import or re-import key stage prior attainment data. If updating KS2 data, importing blank values for a pupil will not overwrite existing data so all existing data must be removed first. Use the 'Clear Column' function to do this. We recommend creating a backup of existing data first, using the Edit Markbook > File > Export option before clearing any data from this tool.

 

Instructions for Key to Success import

  • Select 'Key to Success' and 'Searchable Pupil Data'
  • Paste the UPNs for the Year 11 cohort (maximum 200 UPNs)
  • Download the KS2 CSV file(s)
  • Once you have the .csv file, open it and copy the entire spreadsheet. Do not edit the spreadsheet in any way!
  • In 4Matrix, go to Admin > Spreadsheet > Key To Success (BETA) and follow the remaining steps.
  • As part of the copy and paste process, 4Matrix will automatically remove unwanted columns and 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 in the 2019/20 academic year are the last cohort to use the 'legacy' key stage 2 values of Test Levels, Fine Points and TA.

Current Y7-Y10 pupils in the 2019/20 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: 09/04/2020.

 
Was this article helpful? yes / no
 

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies