Analysing assessments on the MAT MIS

With our assessment features in MAT MIS, MAT Assessment Leads can standardise the way you manage assessments across your trust. In this article, you’ll find out how to align assessment and reporting periods across your trust, and analyse progress across your schools with our central analysis page.

Setting up your MAT MIS reporting settings

Step 1 - Check your Data Sharing Agreements

You’ll need to make sure you have an active data-sharing agreement set up between your MAT MIS site and your school’s sites to allow the data to be populated.

You can check they have been confirmed by following the instructions in this article.

If you don’t have active data-sharing agreements for all your schools, you won’t be able to see their assessment data.

Screenshot_2021-01-19_at_13.28.58.png

Step 2 - Check your assessments and import custom assessments

To make sure all your assessments can be analysed, check all your schools’ assessments appear on the Administration > Assessments > Assessment Framework > Assessment Catalogue page.

This page will show by default any assessments set up using our templates available in the setup process, such as Progress 8 or EYFS curriculum assessments.

To show any custom summative assessments on this page to allow you to analyse them, you must export them from the school’s MIS then import them into your MAT MIS. Use this article to export them, then import them using the Import Assessment Template button.

Screenshot_2022-11-28_at_11.11.59.png

Step 3 - Add years and terms

To enable you to report on your assessments for different years and terms, you’ll need to define the dates for them. You can see how to do this here: Academic years and terms on the MAT MIS

Step 4 - Check your Reporting Periods and reporting frequency

Finally, you’ll need to check that your schools’ assessments will fall into the right assessment period. You can see how to do this here: Assessment Reporting Periods on the MAT MIS

 

 

Analysing your assessments

You can analyse your summative assessments of the same type across your schools from Analytics > Assessment > Analysis.

Using the Grade Distribution page

Using the filters, you can choose what assessments to look at:

  • Academic year - The academic year you’d like to report on.
  • Students in... - Select a specific year group, demographic, ethnicity or gender to drill down into your data. You can combine these, to show students who are Year 10 and Femae for example.
  • Reporting period - Choose the reporting period (term or half-term) you defined for the MAT MIS. You’ll only be able to report on the marks that fall within this assessment period.
  • Assessments - Choose the assessments to analyse marks for. All your schools will have needed to set up the assessment on their site to be able to pull this information in.
  • Grade set - Select the assessment to be able to choose the grade set you want to analyse for.
  • Group by - Choose Curriculum Grade to see a breakdown for each year group.
  • Display baselines - Choose whether to include a grade distribution for your assessment baselines.

In this example, I have chosen to look at Year 10s doing computer science, compared to the baselines.

Please note: Any filters you have applied at the top level will also apply to the drill-downs, so in the example below I am only looking at Year 10s. Click the Back button to change your filters and drill down again to analyse different data.

y10_computer_science_example.png

y10_computer_science_grade_distribution.png


Click a measure to drill down to see the distribution for each school.

They will be ordered with the schools with the highest average mark at the top and the lowest average grade at the bottom. Please note: Blank marks and not required marks are not included.

drill_down_into_grade_distribution.png

 

Toggle between the Chart and Table views to allow you to download or Live Feed your report.

Screenshot_2022-11-28_at_11.17.54.png

 

Using the Attainment Over TIme page

Using the filters, you can choose what assessments to look at:

  • Academic year - The academic year you’d like to report on.
  • Assessment - Choose the assessment to analyse marks for. All your schools will have needed to set up the assessment on their site to be able to pull this information in.
  • Students in... - Select a specific year group, demographic, ethnicity or gender to drill down into your data. You can combine these, to show students who are Year 10 or Female for example.
  • Group by - Choose to display results by year, demographic, ethnicity or gender. 

In this example, I have chosen to look at Year 10s doing Maths, with no grouping applied.

Please note: Any filters you have applied at the top level will also apply to the drill-downs, so in the example below I am only looking at Year 10s. Click the Back button to change your filters and drill down again to analyse different data.

Screenshot_2021-11-22_at_14.59.31.png

 

Click a measure to drill down to see the distribution for each school for a particular assessment period.

They will be ordered alphabetically by school from top to bottom, showing only the schools that have this assessment set up. Please note: Blank marks and not required marks are not included.

Screenshot_2021-11-24_at_16.39.41.png

 

Click into a school to bring up a slide over where you can view more information.

You can then click into a student from here. If you have permission to log into their school site, you can click the green button to jump right to their profile on the school site.

Screenshot_2021-11-24_at_16.43.09.png

 

Toggle between the Chart and Data views to allow you to download or Live Feed your report.

Screenshot_2022-11-28_at_11.19.56.png

 

Using the Cohort and Mark Level Analysis pages

Use these pages to collate your summative assessment marks within an academic year across all of your schools. 

  • Use Cohort Level Analysis for one row per assessment for each school
  • Use Mark Level Analysis for one row for each student

These pages are particularly useful if you're not using our PowerBI connector, as you don't need to pull data from individual schools or set up Custom Reports!

Top Tips:

  • The table is limited to 1000 results, but all records are included if you use the Download button.
  • If there are too many results, try clicking into the filter bar to reduce your query down to look at certain schools or assessments before exporting.

Screenshot_2022-11-28_at_11.21.24.png

Was this article helpful?
1 out of 1 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.