Filtering & Sorting the Grid
A grid of 30 pupils and 40 columns is a lot to read. Filters and sorting show you the part you need. They change only what you see. They never change a mark.
All filters work together. A pupil must pass every active filter to stay in the grid.
Search by name
Type in Search by student name at the top of the pupil column. Use Clear search to bring everyone back.
SEN and EAL
Two toggles in the header of the pupil column show only pupils with SEN (Special Educational Needs) or EAL (English as an Additional Language). The flags come from the pupil's yearly profile. See Student Targets.
Criteria chips
Above the grid you may see chips named after your value types, in two groups: Attainment and Ratings. Click a chip and choose values, then press Apply.
Example: in the Effort chip you tick Needs improvement. The grid shows pupils who have that effort level in any column on screen. The chip asks "does this pupil have this value anywhere?". A column filter (below) asks "does this column have this value?".
Use Clear in the chip to remove it.
Filter one column
Each column header has a small funnel (Filter this column). Click it to open the filter for that column.
- The list shows the values that are in the column, with counts. A scale may have 15 grades, but if the class got only four, you see four.
- Tick one or more values. A pupil stays if they have any ticked value in that column.
- (no mark) is an option. Use it to find pupils who are still missing a mark.
- Select all and Clear selection are at the top. Press Done to close.
Filters on different columns combine with AND. Example: in Term 1A Report Grade tick D and E, and in Term 1A Effort tick (no mark). You see the pupils with a low grade and no effort level yet.
When columns are filtered, a line reminds you: "Filtered by 2 columns." Press Clear column filters to remove all of them.
INFO
Column filters are not saved. If you reload the page, they are gone. This is on purpose: a filter that hides rows and survives a reload is one you forget is on.
If you hide a period, a filter on a column in that period is ignored, so the grid is never empty for a reason you cannot see.
Sort
Click the short label in a column header to sort. Each click cycles: ascending, descending, off.
- The sort uses the points value of the grade, not the alphabet. So A* ranks above A.
- Empty cells go to the bottom in both directions. A missing mark is work not done, not a low grade.
- Pupils with the same value keep their order by name.
- Sort by name returns to the alphabetical list.
- The Export file is sorted the same way as the screen.
Pin a pupil
Use Pin to top on a pupil to keep that row at the top while you work. Unpin removes it.
Hide periods, categories and subjects
On the grid you can hide parts you do not need today.
- Hide this period / Hide this term on a column group.
- The Periods, Categories and Subjects pickers in the filter row. Each shows how many are visible, for example "Periods: 2 of 4".
The grid and the Summary open on the current period and the one before it. The current period is the first one whose due date has not passed. On 27 October, with Term 1A due on 16 October and Term 1B on 14 December, you see Term 1A (the marks just entered) and Term 1B (the one being marked now). In the first period of the year you see that period alone. Hide one to keep the other; your choice stays while you work, and the next visit opens on the current periods again.
- Group columns: By period (Term 1A, Term 1B…) or By type (Report Grade, Effort Grade…).
"Hidden periods are only hidden from your current view. Grades are not deleted."
If your search matches pupils who sit in hidden periods or categories, MarkBook says "N more student(s) match… in periods or categories you've hidden" and offers Show everything.
Second scale
If a column is also shown in a second scale (a Scale Conversion), a Second scale switch appears. It shows both labels, for example "A (10)".
No pupils shown
"No students match your search or filters." Clear the search and the filters. The class is still there.
The Summary uses the same filters
The Summary has the same search, SEN and EAL toggles, criteria chips, column filters and sorting.