Download
Mock test tracker (Excel)
A ready-made spreadsheet that calculates section scores and accuracy as you log each mock, with a summary sheet showing your trend.
Download mock tracker
What is inside
- Mock log
- One row per mock. Enter correct and wrong answers per section; scores and accuracy calculate automatically.
- Summary
- Average, best and latest score per section, and accuracy across all mocks.
- How to use
- Marking assumptions and how to change them if the official scheme changes.
How to use the tracker
- Open the file in Excel, or upload it to Google Sheets.
- On the Mock log sheet, add one row per mock: the date, the mock name, and the number of correct and wrong answers in each section. Split wrong answers into MCQ and non-MCQ, because only wrong MCQs carry a negative mark.
- Scores, accuracy and totals calculate automatically. Do not type into the grey formula columns.
- The Summary sheet shows your average, best and most recent score per section, and accuracy across all mocks.
Changing the marking scheme
The marks for a correct answer, a wrong MCQ and a wrong non-MCQ live in three cells at the top of the How to use sheet. Every formula points to them, so if the official scheme changes, update those cells and the whole workbook recalculates.
Want something quicker?
The online CAT mock analyser does the same calculations in your browser and adds a short interpretation of your results.