You are an IGCSE student with several subjects, each with papers (Papers or Components) of different weights, mock exams behind you and a target for each subject. You want to know: where am I now in each subject, how far am I from the grade I want, and what do I need in the papers I have not tried yet? The free IGCSE subject tracker answers those questions from two records you type: subjects and papers. The template and its page are in Arabic.
The problem it solves
Your marks are spread over papers with different weights and maximum marks, so a simple percentage does not tell you where you stand. To know how much you need for an A in Physics, you must work out what you earned, what remains and what you need in the rest, and redo it with every new mock. On top of that, grade boundaries change between sessions and subjects, so a figure you memorized may not suit your session.
How it works, step by step
- In Settings write your name and the session, then replace the example grade boundaries with the official ones the board published for your session.
- In Subjects write each subject and pick your target grade from the list.
- In Papers write each subject's papers: subject, paper, weight, maximum mark and your mock mark. Leave the mark empty for a paper you have not tried.
- The sheet works out each paper's percentage, points (weight times percentage) and status.
- For each subject it works out the predicted percentage and grade, then the percentage needed for the target, the gap, the missing points and the average needed in the remaining papers.
- Summary ranks the subjects below target by gap, so you know where to start.
What each sheet does
- Settings: the name and session, and the boundaries table from A* to G and U as percentages, titled "example, check the board's official boundaries for the session", with a warning if its order breaks.
- Subjects: each subject's target and an optional boundary offset, then the predicted percentage and grade, gap, missing points, needed average and status: on target, below, no mock, or data to check.
- Papers: the main record, with each paper's percentage, points and status, warning about an unknown subject or a mark above the maximum.
- Summary: counts of subjects by status and a priority list of subjects below target.
Why it matters
Final revision time is limited, and knowing which subject is furthest from its target helps you spread it. When the average needed in the remaining papers is above 100%, the target is out of reach at this level, and you decide whether to push harder or revise it. The sheet promises no grade; it turns mock marks into comparable numbers.
We did not write any grade boundaries as if official. They are examples you edit yourself, because the exam board publishes the official ones for each session and subject.
A quick walk-through with the sample sheet
The numbers below come from the sample sheet, not real statistics; its weights and boundaries are examples. It has eight subjects. Mathematics scored 82%, so its predicted grade is A and it is on target. English Language has one paper at 65%, which reads as C against a target of B; it lacks 31 points and needs 77.5% in the remaining paper. Physics targets A* with boundaries three percentage points above the table, so it needs 93% and sits at 80.5%, lacking 12.5 points with no paper left. Chemistry sits at 55% against a target of B, lacks 26 points and needs 130% in its remaining paper, shown in red as out of reach at this level.
Biology has no mock, Computer Science has weights summing to 90 and is flagged, and History has no target. The summary shows two subjects on target and three below, in the order Chemistry, Physics, English.
The online version
The same tracker works online: it opens on the ready example, you change any cell and see the result at once, add a paper from a form, and import or export an .xlsx file. Your data stays in your browser. Try it from the template page.
Who it suits
- An IGCSE student following their position after each mock.
- A parent who wants to see which subjects need support.
- A tutor following several students, one file each.
The sheet is a calculation tool that relies on the boundaries and weights you type, not an official reference or a prediction from the board or school. Take weights from each subject's official syllabus and boundaries from the board's announcement for your session. For planning revision there is the study planner, and for school exams the exam schedule.