Consolidated MPS Excel Template for Term Result Analysis

The Consolidated MPS Excel Template helps teachers and mathematics coordinators organize term assessment results by grade level. It brings learner counts, percentages, and summary statistics into one worksheet for review and reporting. The sample uses Mathematics, Term 1, and SY 2026–2027, with school details and figures that you should replace before use.

A clear summary gives a teaching team a starting point for discussing assessment results. However, the figures need to come from checked class records. Use this workbook to consolidate those results, then review the underlying scores and skills before deciding what support learners need.

What the Consolidated MPS Template Includes

The Excel file contains one worksheet named TERM 1. Its school header includes sample division, district, and school names. Below the assessment title are two tables, followed by “Prepared by” and “Noted” signatory fields.

  • A. Criterion Reference Result: Grade level, total number of cases, and learner counts and percentages above or below the displayed 75% benchmark.
  • B. Norm Reference Level: Number of test items, mean, median, standard deviation, and mean percentage score (MPS).
  • Summary rows: A Total/Average row in the first table and an Average row in the second table.
  • Grade-level rows: Grades 7–12 appear in both tables. Sample figures are entered for Grades 7–11, while Grade 12 is blank.

How to Use the Consolidated MPS Workbook

First, save a working copy and replace the sample school information, subject, term, school year, names, and positions. Keep an unchanged master file so you can start another report without carrying over old figures.

Next, gather the assessment summaries for each grade level. Confirm the number of learners included and use the same reporting basis throughout the table. Check how your school treats scores exactly equal to 75%, since the supplied column labels say “above” and “below.” Clarify the headings before entering the counts.

In the first table, enter the total cases and the count meeting your agreed benchmark. Existing formulas calculate the remaining count and the two percentages. Preserve these formula cells, and check the results against your source records. Empty or zero totals can cause division errors, so review unused rows carefully.

Then enter the number of items, mean, median, standard deviation, and MPS in the second table. The sample MPS cells contain entered values; they are not formulas linked to the mean and number of items. Calculate and verify each replacement value before entering it.

Check the Summary Formulas Before Reporting

The supplied total and average formulas cover Grades 7–11 and exclude the blank Grade 12 row. If you add Grade 12 results, extend the relevant formula ranges in both tables and verify the totals. Simply typing into the Grade 12 row will not include it in the existing summaries.

Also, the second table averages the grade-level statistics directly. Its MPS average is an unweighted average of the listed MPS values. Review whether that matches your reporting purpose, especially when grade levels have different learner counts or tests. An average of grade-level medians or standard deviations is not a pooled statistic for all learners.

Fictional Example of Reading the Results

For illustration only, suppose 40 learners take a 50-item assessment and the mean score is 30. The MPS is 30 ÷ 50 × 100, or 60%. If 8 learners meet the agreed benchmark, they represent 20% of the group. These measures describe different things: average test performance and the proportion meeting a benchmark.

Enter 60% in a percentage-formatted MPS cell, then confirm that it displays correctly. Avoid entering 60 as a plain number in that cell, which could display as 6,000%. The example is fictional and does not describe a real class.

Use the Results to Plan Follow-Up

Review the consolidated figures alongside item analysis, classwork, and other assessment evidence. A grade-level MPS can highlight an area for discussion, but it does not identify the specific skill each learner needs to practice. Check the underlying work before choosing activities or groups.

For junior high school mathematics support, the Numeracy Intervention Plan for Key Stage 3 offers a related planning resource. Set a focused learning goal and check progress after providing support.

Editing and Printing Tips

Open the XLSX file in Microsoft Excel or a compatible spreadsheet editor. Review formulas and percentage formatting after any conversion or layout change. Before printing, check the print area, page orientation, scaling, and signatory placement in print preview. Keep completed reports and source score records secure, and share them only with authorized staff.

Download the Consolidated MPS Excel Template

Use the download card below to access the editable workbook through Google Drive. Save your own copy, replace all sample entries, and review the formulas before preparing your school’s report.

Consolidated Term Result Analysis (MPS)
XLSX • 99.0 KB • 580 downloads
Download

Leave a Comment