Exam Analysis for Schools: How to Turn Marks into Decisions That Improve Results

A parent writes to the principal: "My child's Mathematics has dropped, and I hear the whole class is weak in it." The principal knows Mathematics in that class was a worry last term. Does anyone have the numbers? The class average, how it compares with English and Science in the same class, how the other sections did, whether it is one bad test or a pattern? Without them the reply is an opinion against an opinion. With them, it is a short, calm answer with a plan.

That is the case for exam analysis. Schools collect marks after every test. Fewer schools turn them into a few pages that every level of the school can act on. This article shows how, using a made-up sample school. The free exam analysis kit at the end gives you the workbook and the guide.

Why analyse exam results at all?

Marks sit in a register and a report card. On their own they say how one child did. They do not say what the school should change. Analysis does, in six ways.

• It replaces perception with evidence. A parent's impression, a teacher's feeling about a class and a leader's worry can all be tested against the same table. Sometimes the numbers confirm the worry. Sometimes they show the problem is smaller, or somewhere else.
• It shows where the problem is. A low school average is not a finding. A low Mathematics average in one section of Class 8, while the other three sections are fine, is. The view you need depends on the question.
• It tells each person where to focus. The principal looks at compartments, the vice principal at classes, the head of department at a subject across classes, the class teacher at their students, the subject teacher at their own marks. Nobody has to dig through a 600-row sheet.
• It finds students early. A child below 50% in three subjects at the first test of the term can be helped in week four. At the final exam it is too late.
• It tests whether support worked. The next exam answers whether the plan made a difference. The same view, compared with last time, gives the answer.
• It makes the school's story honest. When you show parents and the board the pass rate, the spread of marks and what you are doing about the weakest group, you are not defending the school. You are running it in the open.

Used this way, analysis is a tool for quality. It does not rank teachers from one test and it does not label children. It shows where attention will help most.

What does exam analysis show? Four views

Every view starts from the same marks, entered once by the subject teacher. Marks are converted to a common scale of 100 so that a test out of 50 and one out of 80 can sit side by side.

1. Subject-wise: the average, and the shape of the marks

For each subject, the analysis shows the average, the median (the middle student), the highest and lowest marks, the pass rate and the number of students below the school's focus line.

It also shows the bell curve: a chart that counts students in mark bands, 0 to 9, 10 to 19, up to 90 to 100. The shape tells you more than the average.

• A tall hump in the middle with short tails is a class that is moving together.
• A long tail on the left is a group that has been left behind, even if the average looks fine.
• Two humps usually mean two groups in one class, for instance students who joined this year and students who did not. They need different handling.
• A hump pushed against 100 may mean a paper that was too easy. A hump near the pass mark may mean a paper that was too hard, or a topic that was not taught well.

The average says how the class did. The shape says who was in it.

2. Class-wise: the same picture for each class and section

The same measures, by class, and then by section within a class. If 8-A averages 62 in Mathematics and 8-B averages 33, the question for the head of department is useful and specific: what is different in 8-B? Timetable, teacher change, a topic taught late, a mix of students? The analysis does not answer that. It tells you where to ask.

3. Compartment-wise: primary, middle and secondary

Schools are usually run in compartments: primary (Classes 1 to 5), middle (6 to 8) and secondary (9 to 10). Each has a head. Comparing the three on average, pass rate and number below the focus line shows leadership where the system is under strain. The move from primary to middle is one place to look, and the data shows whether your school has a drop there.

4. Late bloomers: the students to focus on

A late bloomer here is a student whose average, or whose mark in a chosen subject, is below the focus line. We suggest 50% as the starting point. A school can set its own. For each student the list shows:

• the subjects below the line, so the help is aimed at the right place;
• the change since the previous test, so a student who is climbing is not treated like one who is sliding;
• the class and section, so the class teacher can see their own group at once.

A student who is behind in marks is often behind in notebook checking and homework too, so one conversation and one next step can cover all three. A weak topic goes back to the lesson plan, as in the RISE lesson plan system.

The word is deliberate. A late bloomer is not a failure. It is a student who has not caught up yet, and the point of the list is that someone in the school knows their name and has agreed one thing to do.

Who reads which view

One analysis is read at six levels. Each level gets its own question and its own action.

Each level looks at less than the one above and acts on something it controls.

A sample exam dashboard

The sample below belongs to a made-up school. The names and numbers are invented. It shows the filters a school leader would use: compartment, class, class with section and subject. Change a filter and every chart and table changes with it.

What to notice:

• The bell curve for a subject, with the 50% line and the class average marked.
• The class-wise bars that turn red when a class or section sits below the line.
• The compartment cards that put primary, middle and secondary side by side.
• The late bloomers list, lowest first, with the subjects below the line and the change from the previous test.

The mark entry screen feeds all of it. The subject teacher enters marks once, per class and subject. The converted mark and the grade are calculated, and everything else follows. HAL Edge, HAL's education management system, has a dedicated module for exam management and exam analysis. It is customizable and supports multiple boards, including IGCSE, Advanced, CBSE and the Philippine board, so grade bands, pass marks and report formats follow your board and your school.

A worked example, step by step

Take the made-up Class 8 in the sample workbook, with sections 8-A and 8-B, and the Mathematics paper of the third periodic test.

1. Marks go in. Subject teachers enter marks for 8-A and 8-B by Tuesday. Missing marks are chased the same day.
2. The head of department opens subject-wise. The Class 8 Mathematics average is 47, well below the 63 average of English in the same classes. Her question: is it the whole class or one section?
3. She opens the sections. 8-A averages 62. 8-B averages 33 and has a long left tail on the bell curve.
4. She looks at the late bloomers in 8-B. Eight students are below 50 in Mathematics. Two of them were already below 50 overall at the previous test, and three have fallen since.
5. She asks the right questions. She checks the lesson plans for the two weeks before the test. A chapter was covered in three periods, not six, because of school events. She also checks that the paper matched what was taught.
6. Support is agreed. The subject teacher re-teaches the chapter in two extra periods. The class teacher speaks to the eight students and their parents, with the numbers in hand. Each student gets one target.
7. Next test. The same view shows whether 8-B moved, and whether the eight did.

Nothing in these steps needed a meeting of the whole school. Each person looked at the view that fit their job.

The routine after every exam

Use school days, and adjust to your calendar.

A short rule keeps it fair: compare a class with its own earlier tests and with similar groups. One test is a signal. Two or three in the same direction are a pattern.

Using the numbers well

Four cautions keep the analysis helpful.

• Check the paper. If a class scored very high or very low in every section, look at the paper before the teaching.
• Mind small groups. A section of ten students can swing on a single bad day. Read the trend.
• Do not rank people on one test. Teachers who teach the harder topic or the weaker group will always look worse on a single number. Use the analysis to start conversations and support teachers.
• Marks are only as good as the marking. Agree a marking scheme and moderate a sample of scripts for the key subjects.

Download the free exam analysis kit

The kit has two files.

• A PDF guide with the four views explained, the six levels, the after-exam routine, a worked example and printable action sheets.
• An Excel workbook where you paste the marks. It converts them to a common scale, assigns grades, and builds the subject-wise, class-wise and compartment-wise views, the spread of marks and the late bloomers list. The pass mark, the focus line and the grade bands are settings on one sheet, because every school defines its own. Some schools pass at 33, others at 35 or 40.

Frequently asked questions

What is exam analysis in a school?

Exam analysis turns marks into information a school can act on. It shows the average and spread by subject, class and compartment, and lists the students who need support, so each person in the school knows where to focus.

What should a school look at in exam results?

Start with the average, the median, the pass rate and the number of students below a focus line, for each subject, class and section. Add the spread of marks as a bell curve, a compartment comparison and a list of late bloomers.

What is a bell curve in exam results?

A chart that counts students in mark bands. Most students usually fall near the middle, with fewer at the top and bottom. The shape shows whether a class is moving together, has a group left behind or is made of two groups.

Who should see the exam analysis?

Everyone who can act on it, each with the view that fits their job: the principal sees compartments, the vice principal classes, heads of department subjects, class teachers their students and subject teachers their own marks and topics.

Who is a late bloomer?

A student whose average or subject mark is below the school's focus line. This kit suggests 50% as a starting point. The list is there to give each student a named person and one agreed target, not to label the child.

Is the exam analysis kit free?

Yes. The kit is a free download: a PDF guide and an Excel workbook that converts marks, builds the four views and lists late bloomers.