Class test analyser: find what to reteach from one test
Paste a whole batch's topic-wise marks from Excel or Google Sheets and get a teaching plan, reteach groups, a gap map and printable student reports — in your browser.
- Who it's for
- Coaching teachers, subject heads and institute owners.
- What it helps with
- Turn one test's marks for a whole class into a reteach plan and student groups in minutes.
- Written by
- Heramb.study editorial team
- Last reviewed
After a test, most teachers know the class "did badly in equilibrium". What takes hours is the next step: which students, how many, and whether to reteach everyone or pull out a small group. This tool does that arithmetic for a whole batch from the marks you already have.
What you need
- Topic-wise marks for one test — most test series and answer-sheet tallies can produce this.
- A spreadsheet with one row per student and one column per topic. Use roll numbers rather than names where possible.
- Optionally a MAX row with each topic's maximum marks; otherwise values are treated as percentages.
Class test analyser
Runs in your browser — marks you type, paste or upload aren't sent to us
Teaching at a founding institute? · Register your institute (free)
- Put one student per row and one topic per column — roll numbers are better than names.
- Optionally add a MAX row under the header with each topic's maximum marks. Without it, values are read as percentages.
- Leave a cell blank or write AB if the student was absent.
Only total marks? While checking, also write each section's total (e.g. Physics / Chemistry / Maths) — 3 numbers per sheet — and paste those as the columns. You still see weak subjects and which students need help.
Import marks — no retyping
Upload the marks file — your own sheet, or the result export from your test platform, ERP or Google Form. Title rows, names, phone numbers, totals and ranks are removed automatically. The file is read on this device and never uploaded.
Up to 500 students and 40 topics. Everything stays in your browser.
Marks are question-wise, or right/wrong from OMR or an online test?
How to read the teaching plan
| Label | Rule | What it usually means |
|---|---|---|
| Reteach to whole class | At least a third of students who attempted the topic scored below 50% | The explanation or the practice didn't land for many students — revisit it for everyone |
| Small-group recap | Some, but fewer than a third, below 50% | A 15–20 minute recap with just that group is usually more efficient |
| Maintain | Nobody below 50% | Keep the topic in mixed practice so it stays fresh |
The one-third threshold is a practical rule of thumb, not a research standard — adjust your judgement for very hard papers. Before reteaching, check the answer sheets for the type of mistake using our guide to repeated mistakes: a class-wide slip under time pressure needs timed practice, not a new explanation.
After you reteach
Run a short follow-up check on the same topics two to four weeks later, then compare fairly with the assessment comparison guide. Share individual progress with the progress report template.
Privacy
Excel and CSV files you upload, and data you paste, are processed only in your browser — they aren't sent to Heramb.study, and nothing is saved when you close the page unless you save it to the tracker on this device. Two optional imports work differently: a Google Sheet link is fetched through our server and passed straight to your browser without being stored, and a photo or PDF (only after you tick the consent box) is sent to our AI provider to read the table. If your institute is connected, only anonymous counts — never marks or names — are recorded. Printed reports should be handled under your institute's data-protection policy.
Sources
- Black, P. & Wiliam, D. (1998). Assessment and classroom learning. Assessment in Education: Principles, Policy & Practice, 5(1), 7–74. doi.org/10.1080/0969595980050102
Spotted an error? Report it — we correct mistakes and update the review date.