COVID-19: Reporting for MATs

In response to concerns around COVID-19, the Department for Education (DfE) has released some helpful resources outlining how schools should respond.

Based on the guidance from the DfE, we've outlined some guidance for schools in this article.

For full details on what the virus is, how to help prevent it from spreading, what to do if someone is a confirmed case, take a look at the DfE's COVID-19: guidance for educational settings

DfE Helpline

For further questions about the Coronavirus, phone 0800 046 8687 Monday - Friday 8am - 6pm

For your reference, you can see any changes we've made in this version history:

Screen_Shot_2020-03-24_at_11.38.13.png 

 

If you have a MAT MIS site, you can use these Custom Report Writer templates to report on the Coronavirus situation in your schools at the group level:

 

Student demographics reports

Our out-of-the-box report for vulnerable students

We have created a Custom Report that is available across all Group MIS sites. This is to give you contextual information based on students demographics. Any users with access to Custom Report Writer can see these reports. 

To view this go to Analytics > Custom Report Writer and the report is called Students with SEN and Key Worker Parents - COVID-19.

Canalot_Multi_Academy_Trust.png

Students with guardians who are key workers

If you want to identify which students have guardians are Key Workers, schools can use our out-of-the-box identifier, and you can then report on this field in a custom report on the Group MIS with our custom report.

This report shows all of your students where all of their primary guardians are Key Workers. 

Screen_Shot_2020-03-20_at_10.34.24.png

Students with Free School Meals

Click here to download the report.

This report shows only students who have Free School Meal, including their school and eligibility dates.

Screen_Shot_2020-03-20_at_11.14.53.png

Students with SEN Statuses

Click here to download the report.

This report shows only students who have a SEN status, including their school and any SEN needs. 

Screen_Shot_2020-03-20_at_10.53.58.png

 

Staff Child protection students

Click here to download the report.

This report shows only students who have been given a Child Protection Status.

Screen_Shot_2020-03-20_at_11.00.13.png 

 

Staff absence report

We have created a Custom Report that is available across all Group MIS sites. This is to give you Staff Absence Information. This report shows all of your staff members who are absent due to the effects of the Coronavirus, as detailed in this article's section on Staff Absences. It also shows their school, details of their absence, how long the absence is ongoing, and the number of working days lost so far this term.

Any users with access to Custom Report Writer can see these reports. To view this go to Analytics > Custom Report Writer and the report is called Group Staff Absence Report for COVID-19.

Screen_Shot_2020-03-20_at_10.42.56.png

 

Our other available reports

Please note: As the DfE have advised schools to stop taking attendance in the normal way as of 23rd March 2020, these reports will only display data until Friday 20th March.

If you need to change the date range of these reports see our article Viewing, Editing or Scheduling a Report 

Reports showing student attendance codes 

I Codes Today report

Click here to download the report.

This report shows only students who have been given an I code today and shows their school, name, reg form, year group and the number of Roll Call marks today that have been I marks. 

Screen_Shot_2020-03-18_at_14.16.41.png   

Y Codes Today report

Click here to download the report.

This report shows only students who have been given a Y code today and shows their school, name, reg form, year group and the number of Roll Call marks today that have been Y marks.

Screen_Shot_2020-03-18_at_14.18.25.png

Y & I Codes Today report

Click here to download the report.

This report shows students names alongside their school, reg form, year group, the number of Roll Call marks today that have been Y marks and the number of Roll Call marks today that have been I marks.

Top Tip: Click the column headers to sort your report if needed.

Screen_Shot_2020-03-18_at_14.24.21.png

 

 

Comparative attendance code reports

Number of Y and I Codes per school Yesterday vs Today Report

Click here to download the report.

This report is grouped by school, and shows the number of Y and I codes today and yesterday.

Screen_Shot_2020-03-18_at_14.33.10.png

Percentage Present, Y & I Codes per school Yesterday vs Today Report

Click here to download the report.

This report is grouped by school, and shows the percentage of presents today and yesterday, and the percentages of Y and I codes today and yesterday.

Screen_Shot_2020-03-18_at_14.49.55.png

 

 

Importing our other available reports

For all the reports below, click the link to download the report. Do not open the file

How to import your report

Go to Analytics > Custom Report Writer and select to Create new report. Click the option to Import a report.

Screen_Shot_2020-03-18_at_14.07.01.png

 

Click Browse to select the file from your computer then click Upload to import it into your site.

Don't worry that your file has 'fakepath' in its name. This is a completely safe file and this naming convention is used to protect the identity of the computer it was uploaded from.

Screen_Shot_2020-03-18_at_14.07.43.png

 

0 out of 0 found this helpful
I'm still stuck!

Comments

0 comments

Please sign in to leave a comment.