Shop / Spreadsheets / Teacher Markbook and Gradebook Spreadsheet
Spreadsheets

Teacher Markbook and Gradebook Spreadsheet

Instant downloadEditable
£4.89

£5.49 on Etsy · buy direct and save 10%

Buy now: instant download

Christmas 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.

You might also like

Teacher Markbook and Gradebook Spreadsheet£4.89 · instant download
Buy now: instant download