User guide Adding class lists

To ensure you have an accurate cohort before a school session, Mavis allows you to import individual school class lists. Mavis will update the cohort list with any contact details provided and automatically identify and movers in and out.

Class lists from each school can be uploaded using the following template:

Class lists for each school are uploaded separately, and each school can only have one class list.

Uploading a class list file

First, you need to reformat the class list provided by the school ready for upload:

1. Navigate to the relevant Excel file for the school and open it. If there are multiple tabs in the Excel sheet, the records need to be combined into a single table.
2. If present, remove the helper text row from the table (row 2).
3. Go to File > Save a copy and then choose the format CSV UTF-8 (Comma delimited) (.csv) and save it.

In Mavis:

1. Go to Programmes.
2. Go to HPV.
3. Go to the correct school.
4. Select Import class list.
5. Choose the .csv version of the class list and select Continue. If there are any validation issues, Mavis will not import the file. Correct the issues listed and try again.
6. Wait for the file to finish importing.

Reviewing children who have moved schools

When importing class lists, Mavis will automatically identify if a child’s school has changed and raise this on the School moves page.

To review a child changing school, follow the instructions on this page of the user guide:

• Reviewing school moves