Skip to content

How Sisra works

How data gets into the reports

ExplanationFor data managers and senior leaders

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.

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

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.

StageWhat happensWhere
1. ExportStudent data, baselines and grades leave the MIS as filesOutside Sisra
2. UploadYou import student data and upload baselines and grades. A file health check reports problems before Sisra saves anythingStudents, KS2 / EAP and Grades in DATA
3. MatchYou link each qualification to its national qualification number (QN) and choose its Expected Attainment Pathway (EAP)Grades > Matching > Qualifications
4. CheckYou clear warnings such as Missing Student Data and Grade Not In MethodGrades Management and Baseline Management
5. PublishYou publish student data, then baselines and EAPs, then grades. Sisra calculates every measure at this pointPublish Students, Publish KS2 / EAP, Publish Grades
6. ReportEach published data set or assessment collection becomes a report for the cohortREPORTS

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.

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.

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:

StatusHeadline figuresOther reports
On RollIncludedIncluded
GuestLeft outIncluded, for example in the Grades area and in residuals
Left SchoolLeft outLeft 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.

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.

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.