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.



Notes:

  • 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.

u49NrjuFjISo2qOdncMFrjtjMz2XDG46Zw.png


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.


That's it!


Column Title
Data
Required
Purpose
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