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 from Administration > Academic Years.

Click +Add to add an academic year.

add_academmic_year.png

 

Please note: You cannot delete an academic year once added, but you can click it to edit the dates. The end date must not overlap with the start date of the next year.

edit_academic_year.png

 

You then need to define the dates for each term. Click +Add to add a term.

add_terms.png

 

Add three terms. Do not add 6 terms as if they were half terms - we will automatically create half terms for you for reporting.

add_a_term.png

terms_set_up_on_group_site.png

 

If you want to amend the dates or delete a term, click into the term and click Edit.

Screenshot_2021-10-12_at_15.46.29.png

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. Go to Administration > Assessments > Annual Policy > Reporting Periods. Arbor uses the end date of the school’s assessment period to determine which Group assessment period it will fall into.

Top Tip: If you want to change the dates for each term, you’ll need to return to the Administration > Academic Years > select year page.

Screenshot_2022-11-28_at_11.33.53.png

 

  • In the example below, you can see that because the school Spring 2 assessment period for the first schools ends within the Summer assessment period, it will be pulled into the Summer assessment period on the MAT MIS.
  • You must also make sure that there isn’t a gap between your terms. If there is a gap, any school assessment periods with end dates that fall between Group assessment periods will not be included in your analysis. In the example below for Pinewood Secondary, the end date of the Spring term assessment period ends between the end date of the Spring and start date of the Summer Group assessment periods, so you won’t be able to analyse any assessment marks recorded for that period.

Screenshot_2022-11-28_at_11.37.56.png

 

You can also change your reporting frequency from termly to half-termly.

change_reporting_frequency.png

 

This will divide each termly assessment period in half. Please note: You are not able to edit the date ranges for half-termly periods, but you can change the names.

divided_assessment_periods.png

 

 

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.