Preparing EAP Baselines
Once you have decided upon the EAP baselines to use, you must ensure the file contains Student ID, Student Name, Subject, and Grade information (this can be either as a broadsheet, or the grades in a single column, such as in the examples shown below), and that the file is saved in Excel. Analytics accepts files saved in CSV, XLSX, XLS or XML format.
We also recommend using clear subject names to ensure your EAP baselines are treated separately to your official KS2 data. For example, you could use ‘KS2 Maths’ for your KS2 Maths Scaled Scores and ‘KS4 Target – Maths’ for your EAP Baseline. You should also split out subjects with different grade types using the subject name if necessary.
| Broadsheet Example |
Grade List Example |
|
Files which have qualifications/subjects in separate columns, students down the left, and grades scattered throughout.
|
Files where all the grades are contained in a single column. This may be useful if your file contains additional columns.
|
| For guidance on how to extract data from your MIS, please see the article linked here - Extracting and Preparing Grades or AtL Data (Admin). |
Uploading EAP Baselines
Once the file is prepared and saved in either CSV, XLSX, XLS or XML format, upload your EAP Baselines by clicking DATA > key stage 3/4 > Select cohort > KS2 / EAP > Uploads > Upload Grades File.
You will then be asked to select the relevant upload type, based on what format your Excel file is currently in. The two upload types are Broadsheet and Grade List, and both of these formats are individually explained below.
-
Uploading from Broadsheet
If your file is a Broadsheet, you will need to first select the row which contains the titles of each subject. In the majority of cases this will be row '1', but you should check this in your file to make sure.
Next, choose your file, enter a clear file title to identify the contents of the upload (this will only be visible in DATA to allow you to distinguish between your KS2 / EAP baseline files), and click Upload.
You will then be taken to the Column Mapping - Baseline Data screen:
On this page, you should ensure the Student ID and Student Name columns are correctly mapped, then select the first and last qualification columns, based on your file.
Once all columns are mapped correctly, click Continue with the Upload.
-
Uploading from Grade List
If your file has each score in a single column, you would use the Grade List option.
Next, choose your file, enter a clear file title to identify the contents of the upload (this will only be visible in DATA to allow you to distinguish between your KS2 / EAP baseline files), and click Upload.
You will then be taken to the Column Mapping - Baseline Data screen:
On this page, you should ensure the Student ID and Student Name columns are correctly mapped, then select the columns containing the Qualification Name, and the Grade/Level.
Once all columns are mapped correctly, click Continue with the Upload.
-
Completing the Upload
During the upload process, Analytics will perform a file health check, which will inform you of issues found in the file. We recommend checking this, as well as checking the number of students and qualifications listed in the upload summary are as you expect for this file.
If there are issues, then you can view further details by clicking ‘Show/Hide Warnings’. You can click ‘Cancel the upload’, address the issues and then re-upload the amended file. For more information on these potential issues, see here - EAP File Health Check Issues (Admin).
However, if you are happy with the file (or want to address issues in Analytics where possible) and you have checked the upload summary, click ‘Continue with the upload’
Confirm Upload Qualification Names
When uploading subsequent baseline grade files containing subject names that have not been uploaded previously for that cohort, the Confirm Upload Qualification Names page will prompt you to merge these with existing baseline subjects or create these as new subjects.
If the subject you’re uploading grades for has not been uploaded before for that cohort and is therefore new, select ‘New’ in the SISRA Qualification dropdown. (This is most common if you are uploading Target grades for the first time after having previously uploaded the official KS2 data).
However, if this subject exists for the cohort, but has been named slightly differently in the Baseline Management page compared to your file, you can merge these together by selecting the appropriate qualification from the SISRA Qualification dropdown.
| For more information on the Confirm Upload Qualification Names page, please see our guide on this here. |
Once you have completed the selections for all qualifications shown, click ‘Complete the upload’. Any new subjects will need to then be set up in the Baseline Management section.
Once completed, you will see your file has been uploaded and there are a number of options available to manage your file. Here you can export your grades list to Excel, edit the title or date of your file via the blue pencil icon, see a preview of the files contents via the eye icon, or permanently delete the file via the red x icon.
| Now that your baselines have been uploaded, the next step is to check Baseline Management to set these up. See the following guide for more info - KS3/4: Setting up EAP baselines (Admin). |
Thanks for reading!
Related to
Updated