We advise uploading student details before administering the assessments in order to:
• Save time at the start of the assessments as students simply select their name from a drop down menu of pre-loaded names.
• Minimise margin for error which will save time with no need to check and edit student details later.
Preparing the Excel File
You can import student’s details using a CSV export from your school Management Information System.
You can upload this to your Assessment Centre on your Secondary+ secure website.
The file containing student details should have the following information:
* Indicates a required field, other fields are optional and this information may be added at a later stage.
Surname, Forename, Sex and Date of Birth must be included. Other information can be added at a later date.
UPN (Unique Pupil Number)
This should be 13 characters long.
Saving as a CSV File
You can save your file in Microsoft Excel spreadsheet format, or as a CSV file (recommend). To save your spreadsheet as a CSV file, go to "Save as," and from the "Save as type" box select CSV (Comma delimited).
Import Student Details into the Assessment Centre
Once you have created your student details spreadsheet, you can upload the file to the Assessment Centre on the Secondary+ website using the Assessment Admin > Computer Assessments page, then
select 2: Upload Student Details inc. Subject Choices
On the Select Assessment page click on CABT and the academic year you require then OK.
Once in the Assessment Centre you will see the following options. Please select Import to upload student
Once you have clicked on Import you will see the Select Year Group screen.
Select the Year Group of the students you wish to upload from the drop down menu, and then click
Click Choose file to select the file you wish to upload, then indicate whether your file contains column
headers then click Upload to upload the file to the Assessment Centre.
Once the file has uploaded a page will open to prompt you to match the column headers of your file
to CEM headers. This ensures the data you have entered is loaded into the correct place in the CEM
You will see a table with your file column headers on the left and the CEM column headers on the right.
Select the descriptions which best match the contents of your file using the drop down lists in the right
column. Columns left as Ignore will not be loaded into our system. You will see more options to match if
you have included more of the non- required fields in your file.