Markbook generator · Markpilot

How it works · 3 steps

STEP 1 · Upload

Drop your test PDF

A clean test paper (not a marked one). Markpilot extracts each question, estimates marks, tags strands.

STEP 2 · Review

Fix anything Markpilot got wrong

Edit question text, marks, strand, skill. Delete rows that aren't real questions. Takes 1–2 mins.

STEP 3 · Download

Get your marking workbook

Excel file with one row per student, marks per question, automatic class analytics. Mark on any device.

1Upload your test PDF

A clean copy of the test (not a student's marked paper). Markpilot will extract each question, estimate marks, and tag it against your selected curriculum.

Drop PDF here or click to choose Maximum ~60 pages (full practice exams welcome — extract may take 60-180s)

Subject

Year level

Teaching another test-based subject (Health Studies, PE theory, Engineering)? Pick the closest match — the test paper is the primary signal for vocabulary and rigour. Or tell us what you teach so we can prioritise.

How to split questions

2Review questions

Fix anything Markpilot got wrong before generating the spreadsheet. Edit question text, max marks, strand, or skill. Delete rows that aren't real questions.

Q#	Question	Max marks	Strand	Skill

3Generate spreadsheet

Download an Excel file with a marking grid plus auto-calculated class analytics. Open in Excel, Numbers, or Google Sheets.

Number of student rows

Pass mark threshold (%)

Who's marking?

One marking sheet for your class. Most teachers want this.

What you'll get

Marking grid sheet — one row per student, one column per question (with max marks in the header). Total (out of N), %, and grade auto-calculated. Cells highlight green when full marks; red when zero. Data bars on the Total column. Validation rejects marks above the maximum. Picking "Several teachers" mode adds Teacher + Class columns.
Class analytics sheet — mean, median, mode, min, max, standard deviation, plus pass-rate and grade distribution.
Per-question breakdown sheet — for each question: class average, % of students scoring full marks, % scoring zero, and a difficulty rating. Colour scale flags the hardest questions for your class.
By strand sheet — class average per strand (extracted from the test paper, in the subject's natural vocabulary), so you can see at a glance which area the class did well in or struggled with.

Markpilot · Markbook generator

How it works · 3 steps

1Upload your test PDF

2Review questions

3Generate spreadsheet

Workbook downloaded. What next?