How do I track student progress across weekly mock tests?

How do I track student progress across weekly mock tests? Keep every result in batch history, paste each week's export into one master Excel workbook per batch series, and review the trend lines instead of piles of paper. CheckOMR (By Navodaya Study) stores every completed batch permanently — the tracking system is one spreadsheet away.

Batch history: your permanent record

Every batch you run stays on your dashboard with:

• its name and date;
• sheet counts — processed, failed, average score;
• all exports still downloadable: Excel, CSV and marked PDFs.

Six months from now, when a parent asks about the June test, you open batch history, find "Class 10 Mock 12 – Set A/B" and download the exact files from that day. No registers, no cupboards.

The master workbook method

One spreadsheet per batch series is all the analytics most institutes need:

1. Create one workbook per series — e.g. "JNVST Sunday Series 2026".
2. Each test, download the Excel result and paste it as a new column block: one column per test, one row per student.
3. Freeze the student-name column; add a few formula columns — best score, latest score, change since last test.

Within a month you have a complete progress map: who is climbing, who plateaued, who dropped. This five-minute paste replaces the old ritual of merging marks from paper registers.

What to review weekly (15 minutes, not more)

• Biggest gainers and droppers — sort by change-since-last-test. Both lists deserve a conversation: one needs praise, the other a check-in.
• Repeated weak sections — if your papers have sections, watch for the same section dragging the same students down three weeks running.
• Average score of the batch — a falling class average usually means the paper got harder, not the students weaker. Note it next to the column.

Parent conversations become one-click

Because every old export is still downloadable, a parent meeting needs no preparation: open the master workbook, show the student's row across the weeks, attach the marked PDFs of any disputed test. The record is the argument.

Naming discipline makes it all work

The system above only stays fast if batches are named consistently. Pick a pattern and never break it:

• Class 10 Mock 12 – Set A/B
• JNVST Sunday 2026-09-07
• Crash Course Phase 2 Test 04

Batch history is only as searchable as the names you gave it — the tracking habit starts at upload time, not review time.