Knowing how to compute MPS takes five minutes to learn and saves arguments for the rest of the year. After every summative test and term examination, someone asks for the class’s MPS — the coordinator, the school head, a division report. The mean percentage score is one of the simplest numbers in assessment, yet it is computed wrongly surprisingly often, especially when sections are combined or tests have different lengths.
This guide shows how to compute MPS step by step, with worked examples for one class, several sections, single items, and whole competencies. It also explains how to read the result, what to do with it, and how to set it up in a spreadsheet. A short Filipino guide is included near the end.
The 10-second answer: MPS = (mean score ÷ highest possible score) × 100. Equivalently, MPS = total of all learners’ scores ÷ (number of examinees × highest possible score) × 100. If 10 learners scored a total of 286 on a 40-item test, the MPS is 286 ÷ (10 × 40) × 100 = 71.5%. When combining sections, add up their total scores first — never average their MPS values.
What MPS is, and what it is not
MPS answers one question: on average, what percentage of the test did this group get right? It describes a group’s performance on a test. That makes it useful for comparing competencies, sections, and tests over time, and it is why schools and divisions collect it after major assessments.
MPS is often confused with three other numbers, and mixing them up leads to wrong conclusions:
| Number | What it measures | Example |
|---|---|---|
| Mean score | The average raw score | 28.6 out of 40 |
| MPS | The average score as a percentage of the test | 71.5% |
| Passing rate | The share of learners who reached a cut-off | 6 of 10 learners got 75% or more |
| A learner’s grade | One learner’s weighted, transmuted result across all components | Not an MPS at all |
Two classes can have the same MPS and very different passing rates. A class where everyone scores about 70% and a class split between 95% and 45% can both average around 70%. That is why MPS works best alongside the passing rate and an item analysis, not instead of them.
How to compute MPS: the formula
There are two common ways to write the formula. They always give the same answer, so use whichever matches the numbers you already have.
Form 1: MPS = (mean score ÷ highest possible score) × 100
Form 2: MPS = total score of all examinees ÷ (number of examinees × highest possible score) × 100
- Mean score is the sum of the scores divided by the number of learners who took the test.
- Highest possible score (HPS) is the maximum points on the test — the number of items for a one-point-per-item test, or the total points if some items are worth more.
- Number of examinees counts only learners who actually took the test. A learner who was absent is not a zero in the MPS; they simply did not take it.
Form 2 is the safer one when you combine groups, because it works directly with totals and avoids averaging averages.
Worked example: one class
The easiest way to learn the formula is to compute it once by hand. Here are ten learners’ scores on a 40-item summative test.
| Learner | Score (out of 40) |
|---|---|
| 1 | 34 |
| 2 | 28 |
| 3 | 31 |
| 4 | 22 |
| 5 | 37 |
| 6 | 25 |
| 7 | 30 |
| 8 | 19 |
| 9 | 33 |
| 10 | 27 |
| Total | 286 |
- Add the scores: 286.
- Find the mean: 286 ÷ 10 = 28.6.
- Divide by the highest possible score: 28.6 ÷ 40 = 0.715.
- Multiply by 100: MPS = 71.5%.
Using Form 2 gives the same result: 286 ÷ (10 × 40) × 100 = 286 ÷ 400 × 100 = 71.5%.
Worked example: combining several sections
This is where most MPS reports go wrong. When sections have different numbers of learners, averaging their MPS values gives each section the same weight, so a small section counts as much as a large one. The correct way is to combine the totals.
| Section | Examinees | Mean (out of 40) | Total score | MPS |
|---|---|---|---|---|
| A | 40 | 29 | 40 × 29 = 1,160 | 72.50% |
| B | 30 | 26 | 30 × 26 = 780 | 65.00% |
| Combined | 70 | 1,940 | 1,940 ÷ (70 × 40) × 100 = 69.29% |
Simply averaging the two MPS values — (72.50 + 65.00) ÷ 2 — gives 68.75%, which understates the grade level’s result because it treats Section B’s 30 learners as if they were 40. The gap grows when section sizes are more uneven. Always add the totals, then divide once.
MPS per item and per competency
The class MPS tells you how the test went overall. Breaking it down by item and by competency tells you what the class has and has not learned, which is the information you can actually teach from.
Item MPS
For a one-point item, the MPS is simply the percentage of examinees who got it right. If 27 of 40 learners answered item 12 correctly, its MPS is 27 ÷ 40 × 100 = 67.5%. This is the same figure as the item’s difficulty index expressed as a percentage, which is one reason MPS and item analysis work so well together — our item analysis guide covers difficulty and discrimination in full.
Competency MPS
To find the MPS for a competency, add up the points learners earned on that competency’s items and divide by the points possible. Suppose items 1–10 cover one competency and 40 learners took the test: the possible total is 40 × 10 = 400 points. If the class earned 248 of them, the competency’s MPS is 248 ÷ 400 × 100 = 62%. Your table of specifications tells you exactly which items belong to which competency, so keep it beside you when you do this.
How to read an MPS: the mastery levels
A number only becomes useful once you know what it means. Many schools and divisions describe MPS with a seven-level mastery scale like the one below. Confirm the scale your school or division uses, as some use their own bands.
| MPS range | Descriptive level |
|---|---|
| 96–100% | Mastered |
| 86–95% | Closely approximating mastery |
| 66–85% | Moving towards mastery |
| 35–65% | Average |
| 15–34% | Low |
| 5–14% | Very low |
| 0–4% | Absolutely no mastery |
Read the class MPS against this scale, then read each competency’s MPS the same way. A class at 71.5% overall is “moving towards mastery,” but if one competency sits at 38% inside that figure, that competency is where the next lessons should go.
What MPS target should you aim for?
Many schools set a target MPS for summative tests — often 75%, matching the passing grade — and ask for an action plan when a class falls below it. A target is useful as a trigger for action, but it is not a verdict on the teacher or the learners.
Keep two cautions in mind. First, MPS depends on the test as much as the learners: a test with many very difficult items lowers the MPS even when learning was good, which is why item analysis should come before conclusions. Second, raising MPS by making the test easier defeats its purpose. The goal is a fair test and better learning, not a bigger number.
What to do after computing MPS
MPS earns its place when it changes what happens in class. A short, practical response by level is usually enough.
- Competencies at 86% and above: move on, with a brief spiral review later in the term.
- Competencies between 66% and 85%: reteach the specific items most learners missed, using a different approach than the first time.
- Competencies below 66%: plan a focused reteaching block and a short follow-up check. Look at the items first — if a single badly written item dragged the competency down, fix the item rather than the class.
- Individual learners consistently below expectations: under DO 15, remediation starts as early as Week 5, right after the first summative test. Our guide to a remediation plan that actually runs shows how to organise it.
Common MPS mistakes
Most MPS errors are small, quiet, and repeated every term. Checking for these takes a minute and keeps reports consistent across sections.
- Averaging section MPS values instead of combining totals.
- Counting absent learners as zero, which lowers the MPS for a reason that has nothing to do with learning.
- Using the number of items as the HPS when some items are worth more than one point.
- Combining different tests by raw score — each test should get its own MPS.
- Rounding too early. Keep full precision until the final step, then round to two decimal places.
- Treating MPS as a grade. It describes a group on one test; grades follow the class record’s weighted computation.
Computing MPS in Excel or Google Sheets
If you already record scores in a spreadsheet, MPS is a single formula. Assuming scores are in cells B2 to B41 and the test has 40 points, either of these works:
=AVERAGE(B2:B41)/40*100=SUM(B2:B41)/(COUNT(B2:B41)*40)*100
Leave absent learners’ cells empty, not zero — AVERAGE and COUNT skip empty cells, which is exactly what you want. For an item where each learner’s answer is recorded as 1 (correct) or 0 (wrong) in column C, the item MPS is =COUNTIF(C2:C41,1)/COUNT(C2:C41)*100.
Paano kunin ang MPS (gabay sa Filipino)
Para sa mga gurong mas komportable sa Filipino, narito ang buong proseso sa maikling paraan. Pareho ang pormula; ang mahalaga ay tama ang bilang ng kumuha ng pagsusulit at ang pinakamataas na posibleng iskor.
- Pagsamahin ang iskor ng lahat ng kumuha ng pagsusulit. Huwag isama ang mga lumiban.
- Hatiin sa bilang ng kumuha para makuha ang mean o average na iskor.
- Hatiin ang mean sa pinakamataas na posibleng iskor (halimbawa, 40 kung 40 ang aytem).
- I-multiply sa 100. Iyan ang MPS.
Halimbawa: 286 ang kabuuang iskor ng 10 mag-aaral sa pagsusulit na may 40 aytem. 286 ÷ 10 = 28.6; 28.6 ÷ 40 = 0.715; 0.715 × 100 = 71.5%. Kung pagsasamahin ang dalawang seksyon, pagsamahin muna ang kabuuang iskor at bilang ng mag-aaral bago hatiin — huwag i-average ang MPS ng bawat seksyon.
MPS and item analysis in Skoolari
Skoolari computes these numbers as you record scores, so the MPS report is ready the moment the last paper is checked. In DepEd mode, the class record shows a Test/Exam Result Analysis for every test column: the number of examinees, the highest possible score, how many learners got 75% and above or below 75% (with percentages), the mean, median, standard deviation, MPS, and the highest and lowest scores.
For item-level results, the Auto-Grade tab’s Item Analysis (sex-disaggregated) report shows, for each item, how many learners got it right and wrong split by male and female, its difficulty index, and its discrimination index from the upper and lower 27% — with a plain-language remark on items that are too easy, too hard, or weak at separating learners. If your school asks for sex-disaggregated figures, our guide to sex-disaggregated data in education explains why and how they are reported.
You can try it with a free account; see the plans page for what each plan includes. And if you are still building the test itself, start with our guides to how to construct a test and the periodical test with answer key and TOS.
Frequently asked questions
These are the questions about how to compute MPS that come up most often in grade-level meetings. Each answer applies to summative tests and term examinations alike.
Should absent learners be counted as zero?
No. MPS describes the learners who took the test. Count only examinees; a learner who takes a make-up test later is added when they have a score.
What if items have different point values?
Use the total points of the test as the highest possible score, not the number of items. A test with 40 one-point items and two 5-point essays has an HPS of 50.
Is MPS the same as the passing rate?
No. MPS is the average percentage score; the passing rate is the share of learners who reached a cut-off such as 75%. Report both — together they show both the level and the spread of performance.
How many decimal places should MPS have?
Two decimal places is the common convention, such as 69.29%. Round only at the final step so that rounding errors do not build up.
Mastery scales, MPS targets, and report formats vary by school and division. Check your school’s current requirements before submitting an MPS report.