How Sisra works
How data gets into the reports
Sisra Analytics has no live link to your MIS. A Sisra administrator exports files, uploads them into a cohort and publishes them, and the reports change only when they publish. This page follows your data from the MIS to the reports, and on to Sisra Data Collaboration and Sisra Multi-School.
No live link to the MIS
Section titled “No live link to the MIS”Sisra keeps its own copy of each cohort’s data. It does not read pupils, students or grades from your MIS. Administrators export files from the MIS, or from another system, and upload them as .csv, .xlsx, .xls or .xml files.
The one automatic link is for staff. Staff records come from your MIS through Wonde, or from Juniper MIS, so that staff can sign in through Juniper Portal. They carry no pupil, student or grade data. Give staff access to Sisra explains how access works.
This has two consequences:
- the reports are only as up to date as the last file uploaded and the last publish
- every file for a cohort must use the same Student ID for each person, because Sisra matches files by Student ID
Cohorts
Section titled “Cohorts”Sisra stores each year group as a cohort, named after the academic year in which it finishes year 11 (KS3/4) or year 13 (KS5). So 26/27 (Current Yr 11) holds the pupils who sit their GCSEs in summer 2027. A KS3/4 cohort keeps everything from year 7 to the GCSE results in one place. A KS5 cohort covers years 12 and 13.
Each August Sisra moves the labels on a year. 27/28 (Current Yr 10) becomes 27/28 (Current Yr 11), and cohorts that have sat their final exams become Leavers. There is no roll over button: Start a new academic year lists the jobs to do in the autumn.
Every page in DATA works on one key stage and one cohort, chosen under Key Stage and Year 11 in (Year 13 in at KS5). A cohort’s menu has three sections: Students, KS2 / EAP (KS4 / EAP at KS5) and Grades. A cohort can hold up to 650 pupils or students, and Juniper Education can raise a KS5 cohort to 2,500. A KS3/4 cohort can have up to 140 qualifications.
From the MIS to the reports
Section titled “From the MIS to the reports”| Stage | What happens | Where |
|---|---|---|
| 1. Export | Student data, baselines and grades leave the MIS as files | Outside Sisra |
| 2. Upload | You import student data and upload baselines and grades. A file health check reports problems before Sisra saves anything | Students, KS2 / EAP and Grades in DATA |
| 3. Match | You link each qualification to its national qualification number (QN) and choose its Expected Attainment Pathway (EAP) | Grades > Matching > Qualifications |
| 4. Check | You clear warnings such as Missing Student Data and Grade Not In Method | Grades Management and Baseline Management |
| 5. Publish | You publish student data, then baselines and EAPs, then grades. Sisra calculates every measure at this point | Publish Students, Publish KS2 / EAP, Publish Grades |
| 6. Report | Each published data set or assessment collection becomes a report for the cohort | REPORTS |
Matching tells Sisra what each qualification is. The QN brings in the DfE’s details, such as the qualification type and discount code, which the headline measures depend on. The EAP sets the qualification’s grade method, and so which grades and points it uses. Match qualifications in KS3/4 and Match qualifications in KS5 explain the page.
A new cohort must publish in order: student data, then baselines and EAPs, then grades. Publish data to the reports gives the steps.
What publishing does
Section titled “What publishing does”Publishing is where Sisra makes the numbers. For each pupil or student it works out their points, measures and expected grades, and stores them. A report then adds up or averages those stored values for the group you choose, such as a class or everyone with one filter value.
So a report never shows a change you have not published. If you correct a grade, change a baseline or edit the Matching page, the reports keep the old figures until you republish. When to republish lists what to republish after each kind of change.
Headline measures, such as Attainment 8 and Progress 8, are calculated only when a data set is published with Headlines on. At KS3/4 you also choose a DfE Rules from: year. Without headlines, a data set still publishes its grades, EAP comparisons and residuals.
Publishing runs in a queue in the background. While a cohort waits in the queue, its pages in DATA are locked, and so is CONFIG for the whole school. Sisra gives no fixed time for publishing, and queues are longest on results days.
Which student data a report uses
Section titled “Which student data a report uses”Every report for a cohort uses the most recently published student data, whenever its grades were published. Filters show each person’s latest values, not their values on the day of the assessment. A pupil recorded as an Armed Forces child in year 9 also shows as one in the cohort’s year 7 reports.
Classes work the same way, with KS3 and KS4 classes kept apart. A report for a KS3 term uses the latest KS3 classes, and a report for a KS4 term the latest KS4 classes. So a year 8 term 1 report always shows the KS3 classes from the most recent import. By default KS3 is years 7 to 9: Key stages, report settings and colour themes explains how to move the boundary.
Each person’s status decides whether they count:
| Status | Headline figures | Other reports |
|---|---|---|
| On Roll | Included | Included |
| Guest | Left out | Included, for example in the Grades area and in residuals |
| Left School | Left out | Left out |
At KS5, statuses such as Year 12 Only and On Roll Aged 18 also decide who counts in the 16 to 19 measures. How Sisra calculates the KS5 measures explains the rules.
What reaches Sisra Data Collaboration
Section titled “What reaches Sisra Data Collaboration”Sisra Data Collaboration pools the KS4 exam results of schools that opt in. Each school can then compare its results with the others’. In 2026, the first figures were available at 3:45pm on GCSE results day. It collects only from KS3/4 Exams data sets, and only from publishes made after the results arrive and before a collection window closes.
For each pupil, the opt-in page lists what is collected:
- the gender, disadvantaged and SEN values from your key filter mapping
- KS2 scaled scores for English reading and maths
- grades and headline figures from the Exams data set
Each pupil’s row is given a random ID, and no names or school identifiers go with it. Pupils with the status Guest or Left School are not collected.
What reaches Sisra Multi-School
Section titled “What reaches Sisra Multi-School”If your trust uses Sisra Multi-School, Sisra passes on each publish that meets the trust checks. Multi-School then builds trust figures from the schools’ published data, with the DfE rules and estimates each school chose when it published. How trust figures are calculated explains what that means for trust figures.
At KS3/4, a publish reaches Multi-School only if:
- it was published with headlines, for year 10 term 1 or later
- the cohort is 21/22 or later
- the cohort’s key filters are mapped and its qualifications are matched to QNs
- its grade type is not Not Listed (excluded from MAT reporting)
- Juniper has linked your school to the trust
At KS5, the MAT Contribution section of the publish dialog shows whether a data set will reach the trust, and if not, why not. Get school data into Multi-School gives the steps for both key stages.