Your privacy choices

KiwiBee uses optional Google Analytics, Google Ads, and Meta Pixel cookies to understand adult visitors, measure completed sign-ups, and improve campaigns. Essential cookies always stay on. OpenAI’s ChatGPT Ads Pixel also measures page views and completed enquiries after advertising consent, and may use hashed contact details for matching. Privacy policy

Skip to main content
Excel template

Mock Exam Tracker

What's inside

A preview of the first rows. The file adds drop-down lists, formulas that fill in by themselves and room for more rows.

Mock exam results

Enter marks out of the maximum. Percentages and change appear automatically.

Subject
Class
No.Student nameMarks availableTarget %Mock 1 marksMock 2 marksMock 3 marksMock 1 %Mock 2 %Mock 3 %Change first to latestGap to targetFollow-up
Example: Linh Nguyen800.7445258None
Example: Omar Haddad800.754845Revision plan

Sheet: Mock results · 30 rows

How to use it

  1. Enter the subject, class and maximum marks at the top.
  2. List your students and their target percentage.
  3. Type the marks for Mock 1, Mock 2 and Mock 3.
  4. Read the percentages and the Change column, and choose a follow-up action for each student.

About this document

Track mock exam results for a class or year group. Enter each student's marks for up to three mocks; the sheet works out percentages, the change from the first mock and whether they are on target.

Comments

    Mock Exam Tracker – Free Excel Template | KiwiBee