Importing Multiplication Tables Check (MTC) scores into Insight
This help guide shows you how to import MTC scores into Insight. There are a number of options, the easiest of which is to upload the CTF file.
Option 1: Uploading CTF file of MTC results into Insight
This is the quickest and simplest option. Click Enter Data > Statutory Assessments > Multiplication Tables Check.
Then click Choose file, select the CTF file you have downloaded from the MTC portal, and click the Upload button to import the MTC results into Insight.
Option 2: Enter the scores manually
If you are having problems uploading the CTF file, you can simply enter the scores manually. Click Enter Data > School Assessments and make the following selections:
Click Load Mark Sheet and enter the scores:
Option 3: Copy and paste from Excel
It is unlikely that schools will use this option to upload their MTC scores - if the scores have been successfully downloaded from the DfE portal then schools should be able to use option 1. However, if you are having problems uploading the CTF file, then Insight's Excel Assessments tool can be used to upload the data. Follow these steps:
Open the downloaded CTF (.xml) file containing the MTC scores
When presented with these options, select 'As an XML table':
and click OK if presented with this option:
You should now have your MTC scores in a readable Excel table, from which you can transfer data to Insight.
Click Enter Data > Excel Assessments
Copy and paste the data into Insight
First, copy the names of the Y4 pupils from the MTC data table in Excel. Forename and last name will be in separate columns but Insight will allow you to select both at once. Copy and paste the contents of both name columns into the yellow box provided:
Then select the name order (i.e. Surname Forename) when prompted, and click next:
This will match the pupils in the table to those in the Insight database. Check the pupils, manually matching if required, and click next:
Click next and select the data you want to import using the dropdown menus provided. You can add an optional 'assessed on' date at this point:
Click next and copy and paste the column of scores from the MTC data table onto the yellow box provided:
If all data is matched correctly, the final screen should look as follows:
Make sure you click the Save Assessments button.
Viewing the data
Once imported, the data can feed into your reports. For example, you could add a column of MTC scores to a table or headlines report, which can be grouped to show averages for various pupil groups. If you recorded the scores of practice MTCs leading up to the actual test, Insight can show the change in score over time.
The data will also be visible in the relevant pupil pages:
Here, the score (20) is not evaluated (colour-coded) because no thresholds have been applied to the mark scheme. This is because, unlike other statutory assessments, there is no pass mark for the MTC. However, we recognise that schools may want to set thresholds to highlight those pupils that are, for example, below average or in the lowest national quintile. Take a look at this help guide for further details.
We hope this help guide has been useful. If you are having difficulty importing your MTC data - or require help with anything else - please do get in touch via the help menu in Insight.