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 Report Definition File


You will need to run a report definition file within SIMS to extract the required data. Data should be uploaded to MERiT in csv formatted spreadsheet.

Go to manage.testbasecamp.org and log in with your MERiT administrator account.

To download the Report Definition File, go to the Manage school data screen.


Select SIMS IMPORT and download the report definition file under Download our Report Definition File.


You can also download the Report Definition File HERE and save the file to your computer (preferably the Desktop) and unzip it.

Step 2 – Extracting the data

On your SIMS system select Reports > Import



Click Open at the top right of the Import report(s) screen.


 

In the Select report file to import window, navigate to the desktop and select the OptionalTests.RptDef file.

Once selected click Open.



Ensure the checkbox is selected next to Doublestruck_Students Report 

And then click Import.
 



Once the Status has changed from pending… to Imported close the Import report(s) screen by clicking Close.


Select Reports > Run Report from the main menu bar.



In the left-hand Report Browse window, expand Focus and select Student.


Find Doublestruck_Student in the list of reports. Select it and then click Run. The report will be generated for the whole school. This may take several minutes.

 



NB: You must click on Browse to save the file to your Desktop



NB: When you save your file you must remember to save it as a CSV (Comma Delimited). Type .csv at the end of your file name

Click 
Save



You will then return to the Export as text screen

 Select 
OK
 


When the report has been exported, a message will appear. Click OK.



When complete with data, your spreadsheet should look as follows and should be in CSV (Comma Delimited) format.

 


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.

  • You should use the SIMS Data Manager account to run the Report Definition file. This account will have the correct permissions to extract the required data.



Step 3 – Uploading your data

Return to manage.testbasecamp.org and log in with your MERiT administrator account.


Upload your file via the Manage school data screen and select 'Select and upload your file' button.


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 import 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 student
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 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