This article aims to explain how to format the core baselines received from GIAP into a file suitable for Analytics.
1 / Student IDs
GIAP only provides each student’s UPN within the export for KS4 baselines. Therefore, if you are using a different student ID within your files in Analytics, you will need to add this to your Excel file before importing.
If you have a list available of each student, their UPN, and the student ID you’re using in Analytics, you could add a new column into your GIAP export file, then use a VLOOKUP formula (or similar) to enter your appropriate IDs for each student.
You can see more information on how to use the VLOOKUP formula in our article here: How to use VLOOKUP formulas in Excel
Once you’ve done this, copy the new column and then paste this as values into a separate spreadsheet to remove the formulae.
|
Please note, the Support team are not able to provide desktop support for Excel. |
2 / Student Names
In the GIAP export, student names are provided in separate columns (columns D and E by default). However, to import these successfully into Analytics, these must be merged into one column. To do this, add a new column to the file, then enter the following formula:
=CONCATENATE(D2,” ”,E2)
Please note, you must include a space in between the speech marks.
Once you have done this, drag the formula down the column for all students. Then, copy the column, and paste this as values in column B of your separate spreadsheet to remove the formulae.
3 / GCSE APS and Overall APS
GIAP provide each student’s Overall APS in column AY (KS4_PTSPE_PTQ_EE) and their GCSE APS in column AZ (KS4_GPTSPE_PTQ_EE).
You can copy and paste these columns as values in columns C & D of your separate spreadsheet.
4 / Run your file through the add-in
You can then run your file through the Analytics Excel Add-In using ‘Prepare from Broadsheet’, to ensure this is in a 4 column list of Student ID, Student Name, Baseline, and Points and saved as a CSV (MS DOS) format.
| Note: We have previously been made aware that in some cases, GIAP might not be calculating APS exactly in line with the DfE for Value Added. There is potential that they are incorrectly not including unapproved qualifications, or limiting qualifications included to those sat in the respective reporting year. If you use the data from here, we recommend double checking this is calculating accurately for each student and treating VA figures with caution. We'd then recommend reimporting the core baselines from the DfE Checking Exercise once this eventually becomes available. |
Thanks for reading!