Import Results

To access the import results section enter NFER Classroom Tools, select the NFER Tests Analysis Tool and then select which pupils you would like to import results for. For help doing this please see Selecting pupils to work with.

Then press the ‘Import results’ button on the right-hand side menu. You will be taken to a new page, as pictured below.

Importing results is a useful function for adding historical data for your pupils without having to select each individual test. We recommend that it is not be used as a frequent data entry method.

To begin, click the green ‘Download template’ button. This will download an Excel document, save this in a location of your choice on your computer.

The Excel document will look similar to the below, and will have all pupils in that year group populated into it as well as column headers for all available NFER Tests.

You are not able to upload pupil results in any format other than by using this template as pupils are matched by their unique PupilID allocated by the system.

You cannot make any changes to your pupil’s data here. Any changes must be done in the administration section Uploading pupil data from CTF.

Enter test results and the date each test was taken in the relevant columns.

The score format should be a number written in digits, and, where there are multiple papers, it is the combined total of all papers.

The date should be written in format DD/MM/YYYY.

Errors in format will mean the spreadsheet will fail to upload.

When completed, save the file and return to the Online Hub, log in and navigate to the import results page.

Click the blue 'Browse' button and find your completed saved file on your computer. The box to the left of the button will populate with the selected file name.

Press the green upload button below and the file will upload.

If you are trying to import results for assessments you have previously entered data for, in enter by pupil, enter by question or enter by total data entry screens a message will appear.

The import function will not overwrite any data that has previously been entered manually into the system.

The import of these results will be stopped and the tests will appear on the download failed results sheet, which is explained below.

If you are importing results where you have previously imported results but not entered data manually in enter by pupil, enter by question or enter by total, a warning message will appear, as pictured below.

Press ‘Cancel’ to go back without importing any results. Press ‘Continue’ if you are happy for the new results to be imported and the previous imported results will be replaced.

You may see a new button appear called 'Download failed results'. This button signifies that some scores have not been imported.

Click this button to download the file as an Excel document, open the file to see the failed result imports.

Results will be separated by pupil and assessment. A reason the import failed will be shown in the column at the end.

This spreadsheet will show both assessment columns that were left empty and assessment columns where you have previously entered data using the ‘enter data’ function and have not been overwritten.

A list of reasons and what they mean can be seen below:

If scores have failed to import due to not having a date provided, or having a score that exceeds the maximum available score you will need to amend your spreadsheet and re-upload, or enter the scores for these pupils individually.

Only staff with ‘SchoolAdmin’ or ‘AdminTeacher’ permission level will be able to import results.

Successfully imported results, will be accessible immediately through the ‘view results’ and ‘generate reports’ areas of the NFER Tests Analysis Tool.

Imported results will not appear on the ‘enter data’ pages as these pages work on test level and not on ‘qualification level’, which combines multiple test results.