MIS: How do I view pupil information as it was in a previous academic year or on a specific date?

MIS

Overview

This article explains how to use the Pupil List to look back at a previous academic year, or at a specific date. You can choose which pupils appear, for example everyone who was on roll in 2025/26, and then show some columns as they were at that time.

This helps you answer questions such as:

  1. "Which pupils were on roll at any point last year?"
  2. "Which class and year group was each pupil in last year?"
  3. "What was each pupil's attendance up to the February half term last year?"
  4. "Who joined or left during a particular term?"

There are two separate settings that control what you see on the page:

  1. The Academic Year in Filters decides which pupils appear in the list. 

  2. The Academic Year and Date Snapshot in Columns decide which year's information the historic columns show. You can use either on its own, or both together.

Prerequisites

  • You must have a role that can view Pupils / All Pupils in Juniper MIS.
  • Historic information is only available for the years your school has recorded in Juniper MIS.

Choose which pupils appear for a previous academic year

Follow these steps to list the pupils who were at your school in a previous academic year:

  1. Select Pupils.
  2. Select All Pupils.
  3. Select Filters.
  4. Expand Quick Filters.
  5. In Academic Year, select the year you want to look at, for example 2025 - 2026. The current academic year is selected by default.
  6. In Status, choose one or more types of pupils to include from:
    • Current shows pupils who were on roll in that year.
    • Leaver shows pupils who left during that year.
    • Admission shows pupils who were admissions in that year.
  7. Select Apply Filters.

The list updates to show the pupils who match your choices for that year.

To see every pupil who was on roll at any point in the year, select both Current and Leaver in Status.

Find pupils who joined, left, or were on roll between two dates

Follow these steps to narrow the list to pupils whose time at your school falls between two dates:

  1. In Filters, expand Quick Filters.
  2. In Enrolment Dates, select one of the following:
    • On Roll Between finds pupils who were on roll at any point between the two dates.
    • Start Between finds pupils who joined your school between the two dates.
    • Left Between finds pupils who left your school between the two dates.
  3. Select a From Date and a To Date.
  4. Select Apply Filters.

The list updates to show only the pupils whose dates match. Select the X next to Enrolment Dates to remove this filter.

Show columns as they were in a previous academic year

Some columns can show information as it was in an earlier year, for example the class a pupil was in or their attendance for that year. Follow these steps to switch these columns to a previous academic year:

  1. Select Columns.
  2. In the Choose which columns you see window, select the Academic Year you want the columns to show, for example 2025 - 2026.
  3. A Showing historic data banner appears at the top of the window. Each column that can show historic information now has a clock symbol next to its name.
  4. Check the columns you want to see. Use Column Search to find a column quickly.
  5. Select Apply.

In the list, the heading of each historic column shows the year you chose and a clock symbol, for example Year Group (2025/26). Columns without a clock symbol always show current information.

Changing the Academic Year in Columns does not change which pupils appear in the list. To see the pupils from that year as well, follow Choose which pupils appear for a previous academic year.

Columns that can show historic information

Section Columns with a clock symbol
Pupil Class, Year Group, House Group and Statutory Age
School Attendance, Persistent Absence and Severe Absence
SEN DAF Indicator

Free school meal, SEN and other social factor columns show current information only, even when a previous year is selected.

Show columns as they were on a specific date

Instead of a whole academic year, you can pick a single date. Follow these steps:

  1. Select Columns.
  2. In Date Snapshot, select the calendar and choose a date, for example 1 February 2026.
  3. Check the columns you want to see.
  4. Select Apply.

The historic columns show information as it was on that date. Attendance shows the figure from the start of that academic year up to the date you chose.

Tips and best practices

  1. Use the two settings together for a full picture of a previous year: set the Academic Year in Filters to find the pupils, then set the same year in Columns to see their class, year group and attendance as they were.
  2. The clock symbol also appears next to the Groups, Pupil, Attendance and SEN sections in Filters. These filters use the academic year you have chosen.
  3. Select Clear Filters in Quick Filters to return to the current academic year and current pupils.
  4. Select Save, then As Report, to keep a previous-year view you use regularly. See MIS: How do I create a pupil list report?
  5. Select Download to export the list with the columns and year you have chosen.

Next steps

After you have the list you need, select a pupil's name to open their record. To analyse attendance for a previous year across classes or year groups, use the Attendance Analysis report instead. See MIS: How do I view attendance by year group / class over a selected period?

Related information

Updated