Markbook generator · Markpilot

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 ~30 pages

Subject

Country

Curriculum

Year level

Question granularity

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 (%)

What you'll get

Marking grid sheet — one row per student, one column per question (with max marks in the header). Total, %, 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.
Class analytics sheet — mean, median, mode, min, max, standard deviation, plus pass-rate and grade distribution.
Question Level Analysis (QLA) sheet — per-question average, % scoring full marks, % scoring zero, and a difficulty index. Conditional colour scale flags the hardest questions for the class.
By strand sheet — class average per AC v9 strand (Number, Algebra, Measurement, Space, Statistics, Probability), so you can see at a glance which strand the class smashed or struggled with.

Markpilot · Markbook generator

1Upload your test PDF

2Review questions

3Generate spreadsheet

Workbook downloaded. What next?