SpreadsheetsTeacher Markbook and Gradebook Spreadsheet
Instant downloadEditable
£4.89£5.49 on Etsy · buy direct and save 10%
Buy now: instant downloadChristmas offer: 10% off with code XMAS10 at checkout, until 24 December 2026.
Or get every ThextonLabs product, including this one, in one go (new products included). See the Everything Pass
- Instant digital download, nothing is posted
- Files: PDF, XLSX
- Use on phone, tablet or computer
- Personal use licence
Checkout is handled securely by Stripe. Your download link appears straight after paying. See refunds & licence.
★★★★★
“Very happy with my purchase, instructions for download was easy to understand”
Etsy buyer review
Type the marks. The markbook does the rest: weighted averages, grades, working-at vs target and missing work, for up to 6 classes.
Most gradebook templates are American: letter grades, semesters and one class per file. This one is made for UK teachers. It comes with GCSE 9-1, A-level A* to E and primary WTS / EXS / GDS grade scales (plus simple Emerging to Mastered bands), and you set the % boundaries yourself, so it matches your department. Each class picks its own scale, so your Year 11s, Year 13s and a primary class can all live in one file. A US edition (letter grades with + and -, A-F and standards-based 1 to 4) is included. Works in Google Sheets AND Excel.
WHAT'S INSIDE (10 tabs)
- 6 class tabs: class name and grade scale, up to 16 assessments (name, date, out of, weight) and 36 pupils with notes (SEN, PP, EAL), target grade and marks. Type raw marks: the weighted average %, grade now, above / on / below target, pieces done and missing work fill in. Type abs for absent and it won't count against them
- Class average, highest and lowest mark and number marked for every assessment
- Low and high marks are colour coded (you choose the %)
- Overview: every class side by side (pupils, assessments, class average, average grade, above, on and below target, missing work), plus a list of the pupils furthest below their target
- Pupil Report: pick a pupil from the dropdown for one page with every mark, %, grade and how it compares with the class average, and a comment box. Print it or save it as a PDF for parents' evening or report writing
- Grade Scales: 4 editable scales, up to 14 grades each
- Setup and Start Here: plain-English instructions
Comes with 3 sample classes so you can see how it works, and instructions for clearing them.
WHAT YOU GET
- 2 versions: UK (markbook, GCSE, A-level and primary scales, dd/mm/yyyy) and US (gradebook, letter grades, mm/dd/yyyy)
- Quick Start guide (PDF)
HOW IT WORKS
- Your download page opens straight after paying: download the files from there
- Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets
- Excel: just open it (Excel 2010 or later, Windows or Mac, or Excel for the web)
- Type in the cream cells. Everything else updates on its own
- A Quick Start PDF walks you through setup in 5 minutes
GOOD TO KNOW
- Plain formulas only: no macros, no add-ins, no subscriptions
- Formula cells are locked so you can't break them by accident (no password, so you can unlock and customise)
- Apple Numbers and LibreOffice aren't officially supported
PLEASE NOTE
- This is a DIGITAL download. Nothing physical will be shipped.
- Personal use only. Please don't share or resell the files.
The GCSE and A-level boundaries are examples to get you started: exam boards set new ones every year, so type the ones your department uses. Grades are a guide to working-at level, not official exam grades.
Designed by Thexton Labs. Artwork and layouts were created with our own code, with the help of AI tools.