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
You will then return to the Export as text screen
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.
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.
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.
|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|