Importing 2021 Multiplication Tables Check (MTC) scores into Insight

The Multiplication Tables Check (MTC) was optional for year 4 pupils this year but many schools took the opportunity to run a trial before it becomes statutory in summer 2022. Having completed the assessment this term, the DfE has now released the results for download and schools will want to import this data into Insight. There are a number of options, the easiest of which is to upload the CTF file into Insight.

Option 1: Uploading CTF file of MTC results into Insight

This is the quickest and simplest option. Click Admin > Manage Pupils > Update Pupils > CTF File and upload the CTF file of MTC results.

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:

Click next and select the data you want to import using the dropdown menus provided, i.e:

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 certain 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 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. We will be carrying out analysis of the scores and will publish further updates in the near future.

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 contact support.


How did we do?


Powered by HelpDocs (opens in a new tab)