School Data (pupil and teacher information) needs to be entered into the MERiT System so that your teachers can enter marks and get reports.
We have tried to make this process as simple as possible and it requires just a few minutes of your time to get set up.
Step 1 – Download the Import Template Spreadsheet
Go to manage.testbasecamp.org
Data should be uploaded to MERiT in a csv formatted spreadsheet.
You can download a correctly formatted, empty spreadsheet HERE.
Step 2 – Completing the Spreadsheet
See the table below for details of the required and optional data needed.
When complete with data, your spreadsheet should look as follows.
- You will have the option to select specific classes from the spreadsheet before you finalise the upload. This saves you the trouble of filtering out irrelevant classes when exporting data from your school management system initially.
- Each student will be listed multiple times in the spreadsheet, once for each class they are in.
- The column titles must be accurately named. Do not merge columns - e.g. Legal Forename and Surname must be separate.
Step 3 - Uploading your data
When you have created the data file, save it in CSV format (tab delimited) and upload your file using the 'Select and upload your file' button in the MANAGE SCHOOL DATA section of the site.
You will then be presented with a list of classes from your data set.
You can choose those you wish to use - data associated with any classes you do not select will not be stored by our system.
Use the filter list to locate specific classes.
Once you have made your selections, click 'Finalise upload'.
You will be presented with a summary of your input that shows what data has been uploaded, how many accounts have been created, as well as identifying any warnings or errors encountered.
|UPN||Universal Pupil Number||Mandatory||To uniquely identify the pupil|
|Adno||Admission Number||Mandatory||A fallback to identify the pupil|
|Legal Forename||Pupil Name||Mandatory||Used in reporting|
|Surname||Pupil Name||Mandatory||Used in reporting|
|Middle name(s)||Pupil Name||Optional||Used in reporting|
|Gender||Pupil Gender||Mandatory||Used in reporting|
|DOB||Pupil Date of Birth||Mandatory||A fallback to identify the pupil|
|Ethnicity||Pupil Ethnicity code||Optional||Used in reporting|
|Eligible for free meals||Pupil Eligibility for free meals||Optional||Used in reporting|
|FSM Ever 6||Identifies pupils who have been eligible for free meals in the last six years||Optional||Used in reporting|
|Pupil Premium Indicator||Pupil Eligibility for pupil premium funding||Optional||Used in reporting|
|SEN Status||Identifies pupils with special educational needs||Optional||Used in reporting|
|In LEA Care||Identifies looked after children||Optional||Used in reporting|
|Year taught in Code||Pupil year group||Mandatory||Used to group the pupils by year group for reporting|
|Reg||Pupil registration group||Mandatory||Used to group pupils by registration group for reporting|
|Supervisor||Teacher name||Mandatory||Used to associate registration groups with teacher accounts|
|Class||Class name/code||Mandatory||Used to group pupils by class for reporting|
|Teacher||Teacher name||Mandatory||Used to associate classes with teacher accounts|
|Work Email||Teacher email||Optional||Used to deliver login credentials to teachers|