Progress vs target
Progress vs target shows, subject by subject, which pupils are above, on or below their target. It is the first tab of Analytics, for heads of year, heads of department and senior leaders.
Choose what to read
The filters are required, in this order. Each choice decides what the next one offers.
| Filter | What it means |
|---|---|
| Template | The markbook template of a year, for example Y11 MarkBook. Each template has its own columns. |
| What to compare | The column set against the target. A template with a value added column (VA) offers it first, and it is chosen for you. A template can also offer a grade, such as Current Grade, when one of its targets sits on the same grade scale. Ratings, such as Learning 1–4, are never offered. |
| Target | Only when you compare a grade: MEG, FFT or PTG. The target your VA formula uses is chosen for you. |
| Term | The term whose marks are read. The latest term that holds marks is chosen for you. The list shows the terms that hold marks; while no term holds any yet, it shows every term, so you can see what is missing in each. |
Year group and Classes are optional. They narrow the report to some pupils.
MarkBook remembers your choices at this school, in this browser.
Read the result
- The difference of a pupil is their VA (the value in their grid cell), or their grade minus their target, in the grade scale's points.
- Above, On target and Below mean a difference above 0, equal to 0 or below 0.
- At the top: the pupils counted, the share of results above or on target, the results below target, and the year's average difference. The averages are rounded as the template's Round the averages setting says.
- Subjects lists the three weakest and the three strongest averages. Trend by term shows the year's average for each term that holds marks.
- By subject: one card per subject. Click Above, On target or Below to list only those pupils. The table names each part once (for example CG, MEG, VA), and each row shows the pupil's values.
- By pupil: one row per pupil and one column per subject. A dash means the pupil does not take the subject. Average is the pupil's mean difference across the subjects they take, and the Average row at the bottom is the mean of each column for the pupils on screen.
- Click a column name to sort it: once for lowest first, again for highest first, a third time to go back to form and name. Pupils who do not take the subject stay at the bottom.
- Click the funnel next to a column name to filter it: tick the values to keep. Filters on several columns add up. The Average row follows the filters.
- Click a pupil to open their sheet: the difference on every subject and term, with the marks read. With the right permission, Log intervention records an action, as on the At-risk tab.
Example: in Biology, Term 1B, a pupil with Current Grade C and MEG B has a difference of −1 and is listed under Below.
INFO
Some scales give more points to a lower grade (A* = 1). MarkBook turns the difference around on such a scale, so Above always means a better grade than the target.
A subject whose grade and target sit on different scales shows a grey card, Not comparable, and is not counted anywhere.
When there is nothing to show
Instead of an empty page, the tab shows a checklist. Each required filter is ticked, or has Choose here →, which takes you to that filter. Under it, the tab says why:
| Message | What to do |
|---|---|
| The template has nothing to compare | The template has no VA column and no grade on the scale of its targets (for example Y7 & Y8, with ratings and letter targets). Use Open Distribution to see the ratings, or add a Current Grade or VA column to the template. |
| No marks to compare yet | The count of pupils who have each part, for example CG 0 · MEG 214. The report appears when teachers enter the missing part. |
| You cannot open the markbooks | Choose the classes you lead, or ask an administrator for access. |
Export
Export Excel downloads one workbook: a sheet for each subject (pupil, form, the marks read, the difference and its status, coloured), and a By pupil sheet with each pupil's Average and an Average row (for every pupil, whatever the filters on screen). Every sheet starts with the template, the comparison, the target and the term. You need the Export analytics permission.