Preparing the Excel file
You can import students’ details using a CSV export from your school Management Information System (MIS).
You can also use the Excel templates in the Assessment Centre by going to import and clicking on the required format of example file:
(Navigation to this page can be found in article: Import pupil details into Secondary+)
There is also the option to include subject choices. In this case the spreadsheet must conform to
one of our accepted broadsheet formats with one row per student. See example below:
Format 1: Qualification and subject name as header
Format 2: Qualification name and subject name in line with text
This list can be in either a comma separated file (CSV recommended), or a Microsoft Excel spreadsheet
format. Subject choices should be formatted as Qualification;Subject.
Alternatively any of the symbols @ # % & + =! Can be used in place of ;.
If the qualification is a GCSE (9-1), please indicate this on the spreadsheet.
All headers with a red asterisk are mandatory information fields on your CSV spreadsheet, other fields are optional and this information may be added at a later stage.
Saving as a CSV file
We recommend you use an Excel spreadsheet and save it as a CSV (Comma delimited) file.
Import Student Details into Secondary+
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 OK.
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.
You will also be asked to specify the file format for the subject data. Select the relevant option that matches your file format
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.
Remember: Surname, Forename, Gender and Date of Birth (DOB) must be included. Other information can be added at a later date.
Subject Choice will only appear for Yellis cohorts where subject choices are contained in the upload file.
Format 1: ‘Qualification and subject name as header’. You will see Subject 1, Subject 2, Subject 3…
matched to CEM header Subject Choice.
Format 2: ‘Qualification name and subject name as inline text’. You will see the qualification and subject
name matched to CEM header Subject Choice.
Once all relevant headers have been assigned, click NEXT.
You will be asked to map the qualification type(s) in your file with CEM recognized qualifications.
The relevant qualification can be selected from the drop down list.
IGCSE subjects will need to be mapped to GCSE qualification type. GCSE (9-1) subjects should be mapped to GCSE (9-1).
Once you have mapped the qualification types click OK.
You will then see the Map Subjects Screen.
To map the Subjects in the file you have uploaded to the CEM recognized Subjects select the relevant
subject using the dropdown menu.
Once you have mapped your subjects click OK.
Please check that all your columns/headers, qualifications and subjects are mapped correctly,
including those that have mapped automatically.
Remember: any value mapped to ignore will NOT be loaded into our system.
If there are any errors with your data they will be flagged up at this point and you will have the opportunity to correct them before the upload is complete.
If there are no errors, a table will appear with all your students’ details listed. There are options to
Edit or Delete student information as shown below:
Once you have checked these details and made any necessary amendments click NEXT.
If there are any duplicate students in our database you will see a Candidates Matching page:
You must now select Update or Include against each student record.
Selecting Update will allow you to add missing information to an existing record (needed when adding
information not included in your first upload for example Subject Choices).
Selecting Include will create an additional student record (only use this option if there is no existing student record).
Once this is done click FINISH to complete upload.