For PUMA, PIRA, PIRA for Scotland, and NTS, you can export all of a term’s results for your whole school in one spreadsheet.
To do this, select Gap Analysis – School Export from the Marksheets screen:
Then select the product, term and academic year from the dropdowns and select 'Generate':
The spreadsheet will then be created and downloaded to your computer. Please note - each year group’s data will be displayed on a different tab.
Please note that the Whole School Gap analysis export considers all attempts of a given pupil for the selected paper. This means that multiple attempts will have an effect on the class average displayed.
Furthermore, students attempting a paper outside of the test cycle, e.g. taking an Autumn paper in the Summer term, will not be represented in the Whole school Gap analysis export. This is because the test taken dates for each paper is a set value that must fall within a specific date range, attempts of a paper outside of this data range may skew the class average and are therefore not included.
Unlike our other MARK reports, the whole school export looks for both the data range and the test paper (Autumn, Spring or Summer), so when you select ‘Autumn’ it ensures it only shows Autumn test papers taken in the autumn date range. Students who have taken papers outside of the date range will still show in the correct marksheet in MARK.