Category: Importing Data

Articles in this Category

Level 6 shows as error in Key to Success import
You may need to update 4Matrix if Level 6’s are flagged as an error in the Key to Success import. Update 3.7.0.0 (January 2017) will handle Level 6 test scores. The DfE have confirmed that the actua...
Article rated 3.0/5.0
Gender column not recognised
Right click the Gender column header and select Refresh.
Article rated 3.0/5.0
How do I import Key Stage 2 data?
We 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.
Article rated 2.3/5.0
Can I import Mastery statements?
This is not possible to do at the moment, but it is something that we plan to look into in 2017.
Article rated 3.0/5.0
Can I Import Key Stage 2 data for current Year 7 (2016/17)?
It is not possible to import the scaled scores for these pupils. There is currently no published information on how these scores should relate to levels of progress or starting points for Progress 8. ...
Article rated 3.7/5.0
Can I import more than 1 set of Key Stage 2 results for a pupil?
It is not possible to import more than 1 set of Key Stage 2 results into a single pupil record - except for the fact that you can add a custom KS2 result alongside their Test Level, Fine Points and Te...
Article rated 3.0/5.0
Can I use your AWL tools to import and manage KS2 pupils?
4Matrix is designed to support key stages 3, 4 and 5. Although some of our AWL tools may appear to be compatible with any year group, the fundamental processes for importing and managing data, along w...
Article rated 3.0/5.0
Error: (Spreadsheet import) Could not load file or assembly C1.Win.C1FlexGrid2
This is because of a missing (or out of date) file in the 4Matrix directory on the client, C1.Win.C1FlexGrid2.dll A 4Matrix support agent will need to send a copy of this file to the user to add to t...
Article rated 3.0/5.0
Error: SIMS Extract unable to extract pupil details successfully
This may indicate that your SIMS Extract files (which reside with the 4Matrix installation) are corrupt. You should re-install 4Matrix on the affected client or ask us to send you the most recent SIMS...
Article rated 3.0/5.0
Error when trying to paste FFT Extract into 4Matrix
This may be for 2 reasons; Make sure that you have not edited the downloaded file in any way Check that it is the right extract - you need to use the op
Article rated 3.0/5.0
Error when trying to paste Key to Success extract into 4Matrix
Make sure that you have not edited the extract file in any way.  If your file is unedited please contact us for assistance. 
Article rated 3.0/5.0
Fine Grade formats
4Matrix now supports multiple fine grade formats and it is possible to use a mixture of these in the same series (except for KS3 NC Levels).  As well as the standard 1, 2, and 3 to indicate high, mid...
Article rated 3.0/5.0
I can't find a qualification when mapping
There are over 8000 qualifications in the 4Matrix database, but in some cases, you might find that the one you're after is missing. The first thing to do is search by QAN - that's the unique 8 digit c...
Article rated 3.0/5.0
How do I deal with unmatched pupils in Step 5 of import?
There are generally 2 reasons as to why a pupil is unmatched; They are a new pupil to the school (and 4Matrix) and therefore they have no singeing record in the database. Select the pupil, right cli...
Article rated 3.0/5.0
How do I import the KS4 GCSE APS and Overall APS for KS5 Value Added?
Two GCSE APS scores (overall and GCSE only) need to be imported in order for KS5 Value Added to work. These will need to be imported via a spreadsheet, even if you use SIMS. Users will need to create ...
Article rated 3.0/5.0
In what order should I import data into 4Matrix?
Ultimately, it doesn't matter which year group you import first or whether it's contextual data or results/grade data. Users should be aware that 4Matrix can be unstable without any result/grade data ...
Article rated 3.0/5.0
Pupils incorrectly appear in more than 1 class for the same subject
If you find that pupils are incorrectly appearing in more than 1 class for the same subject, you will need to re-import your class data. In the final step of the import, there is a tick box - 'Overwri...
Article rated 3.0/5.0
SIMS Extract tool won't launch
After selecting the 'save to' location, there is another tick box that says ‘run from custom location’. Tick this, and then select another location in the field below (it can be the same as the ...
Article rated 3.7/5.0
SIMS not matching pupils correctly
This might affects schools with hosted SIMS as they have to use the reports from www.4matrix.com/simsreports If there is no MIS ID then the creation of the marksheet generates one automatically, hence...
Article rated 3.0/5.0
Subject column header shows red warning triangle
This is usually displayed for 2 reasons; You already have a subject in your database with the same name but mapped to a different qualification You
Article rated 3.0/5.0
Unhandled Exception error after completing spreadsheet import
This is usually related to either the formatting in the original spreadsheet or a corrupt map file. In Excel, copy the sheet you're working with and paste the data into a new sheet using Paste > Va...
Article rated 3.0/5.0
Validate Data throws lots of errors
The most common reason for this is incorrect subject mappings, whether deliberate or accidental.  For example, you may be importing 9-1 grades for English Language, but you have accidentally chosen t...
Article rated 3.0/5.0
What is a series?
A series is a snapshot of performance - a Y11 Autumn 1 series may refer to teacher assessments that were taken before Autumn half term. Over the course of a year, 4Matrix can be used to analyse, diagn...
Article rated 3.0/5.0
Why has the 'import Key Stage 2 base data' option been removed from the SIMS extract?
Generally, this option would only import the English and Maths test levels. For Progress 8, this is not enough. Fine Points, Test Levels and Teacher Assessments are required. We recommend obtaining yo...
Article rated 3.0/5.0
I can only enter numeric grade 0 for some 9-1 subjects
If the subject is linked to a 9-1 generic 'QAN 0' subject, it is possible to import a numeric grade 0.  However, if the subject is linked to a specific QAN code, a numeric grade 0 is generally not ac...
Article rated 3.0/5.0
SIMS Extract Error: Could not load file or assembly 'AbstractProcesses.DLL'
This error can occur when clicking Run Extract after choosing a location to save a copy of the Extract to. This can mean that there is a problem with the SIMS.INI file and we recommend contacting us ...
Article rated 2.3/5.0
 

 
Powered by Help Desk Software HESK, brought to you by SysAid