Summary
Grades → Summary shows one class, or a whole year, across all its subjects. Where Grades by Discipline is for entering marks in one subject, the Summary is for reading: how is 9B doing in every subject at once? It is read-only. To change a mark, go to Grades by Discipline.
You need the permission View the summary. To download it you need Export the summary.
Open the Summary
The filter row has Academic year, Class / Year group and Template. Pick them and press Apply. If nothing is selected the page says "Pick a year, class and template to see grades across subjects."
Each row is a pupil. Each group of columns is a subject. Inside a subject you see the final mark MarkBook picks for each reporting period, and a Target group where the template has one (for example "Mathematics target").
The Summary only picks the final mark of each subject. It does not calculate anything across subjects, except the averages a template asks for (see below).
By class or Year view
The switch at the start of the filter row has two positions.
- By class shows one class. This is the view described above.
- Year view shows a whole year group, every pupil with all their subjects. Use it when a year is taught in sets: for example, Year 9 has the sets "Maths 9E", "Maths 9N" and "Biology 9E", each with its own markbook.
A year group is every form class with the same study level in Kinderpedia (for example Y9E, Y9N and Y9A are all Year 9), whatever they are called and whatever template they are graded on. Its name comes from what the classes share ("Y9", "Year 9").
In Year view you pick the Academic year and the Year group. Leave All classes empty to see every pupil of the year group, or pick some of its form classes. Pupils are listed by form class, then by name; the Form column shows each pupil's form class and can be filtered and sorted.
The year view shows every subject the pupils take that year, from every template: the sets they are in, and any markbook where they still hold a mark (a pupil who left a set keeps the marks they earned there). A set shared by several years (an EAL group with Year 9 and Year 10 pupils) shows its Year 9 pupils under Year 9 and its Year 10 pupils under Year 10.
Each pupil's marks come from the set the pupil is in. The cells mean:
| Cell | Meaning |
|---|---|
| A mark | The mark from the pupil's set. |
| — | The pupil is in a set of this subject, but has no mark yet. |
| – on a striped grey cell | The pupil is not in any set of this subject. |
| A pale red cell with a lock | The pupil takes the subject, but you cannot see the marks of that set. |
Who takes a subject comes from the pupils in the set's class in Kinderpedia, not from the marks. A pupil with no marks yet still shows as taking the subject.
Year view never creates a markbook. If a set has no markbook yet, its pupils show – for that subject until a teacher opens the set on Grades by Discipline.
Example
Class 9B, template "Year 9 Secondary", three subjects:
| Student | Maths Target | Maths T1A | English Target | English T1A | Science Target | Science T1A |
|---|---|---|---|---|---|---|
| Alex Popescu | 7 | 6 | 6 | 6 | 7 | 5 |
| Maria Ene | 8 | 8 | 8 | 7 | 7 | 7 |
Alex is a grade under target in Maths and two under in Science. You see that without opening three markbooks.
Choose what to show
| Control | What it does |
|---|---|
| Periods to show | Choose which reporting periods appear. It opens on the current period and the one before it. It appears when there are several. |
| Subjects | Hide subjects you do not need. You can also use Hide this subject in a subject's header. |
| Categories | Hide kinds of columns, for example hide Effort and keep Report Grade. |
| Second scale | Appears when a column has a Scale Conversion. It shows both labels. |
These choices only change your view.
Averages
A template can ask for averages. An administrator picks the column types on Template settings → Averages in the Summary, for example VA and Effort. For each type:
- a row Average under the table shows the average of each column of that type;
- a column Average shows each pupil's average across their subjects.
Only numbers are averaged. A scale with letters and no points has no average. A scale of codes WITH points, for example Progress (AP = 1, EP = 2, BP = 3), is averaged by its points and shown as the level the average rounds to: EP and BP give 2.5, which rounds to 3, so the average is BP, in the colour of BP. A scale of numbers, such as Effort 1 to 4, keeps its number: 1.83. Only what is on screen is counted: hide a period, or filter the pupils, and the averages change. A subject the pupil does not take counts for nothing. It is never a zero.
Both views show the averages. Without a choice on the template, there are none. An average column that has no value for any pupil on the page is not shown: for example the averages of another year's template, when one of its sets holds a few of your pupils.
The averages follow the column TYPE you pick, not its name. If Term 1A uses Effort & Independence and Term 1B uses Effort Grade, they are two types: pick both, or the Term 1A average stays empty.
Round the averages, on the same settings page, rounds every average, the pupil columns and the row under the table alike, on screen and in the Excel files. Choose whole numbers, one decimal or two decimals. Rounding works as in Excel: below the half goes down, the half and above go up, so 1.49 becomes 1 and 1.50 becomes 2. Off, each average shows two decimals. The average columns come after the last subject and before the form tutor's columns (a subject marked Form tutor subject, for example Tutor with Pos, Neg and TC). With no form tutor subject, they come last.
Average row under the Summary, on the same settings page, chooses which column types the bottom row averages, for example only VA while the pupil columns show VA and Effort. Until you change it, it follows the list above. An average takes the colour bands of the columns it averages, so an average VA is coloured as each VA is.
Filter and sort
The Summary uses the same tools as the grid: search by name, the SEN and EAL toggles, criteria chips, a funnel on each column, sorting by clicking a column label, and pinning a pupil. See Filtering & Sorting the Grid.
When column filters are active a line says "Filtered by N columns." with Clear column filters. This matters here because the headers scroll out of sight in a wide summary.
Read a comment
A comment column shows a short marker. Click it to read the full comment in a window with the pupil's name and the period. It opens even if you cannot edit it.
Pupil details
Click a pupil's name (View student details) to open the student card. It shows alerts and the pupil's targets. See Student Flags.
Export
Export opens a menu with three choices:
| Choice | What you get |
|---|---|
| Standard | What is on screen, as CSV, XLSX or PDF, values only. |
| Current year XLSX | The whole year group the screen is on, as one Excel sheet: every pupil of it and every mark they hold. |
| All years XLSX | One Excel file with a sheet for every year group of the school. |
Standard replays your filters, so the file matches what you see. In Year view it has the Form column, a "-" where a pupil does not take a subject, and the Average row last. A locked cell is empty.
Current year XLSX takes the year group of what you are looking at: in Year view, the year group picked; in By class, the year group of the class (Y9E is Year 9; a set such as "Maths 9E" belongs to the year of its pupils). The menu names it. It always takes the whole year group, not only the class or the forms on screen.
Both XLSX files are laid out like a school's own analysis sheet:
- the subject's name over its columns; with one period there are two header rows (subject, then column), and a subject's targets sit after its marks: Effort, Current Grade, MEG, PTG, VA;
- with several periods a third row names the period;
- a column with colour bands, for example VA, keeps its colours, and so do ratings such as Effort; letter grades stay plain;
- "-" on grey where a pupil does not take a subject, a pale red empty cell where you cannot see that set;
- the subject row in each subject's colour from Configuration → Subjects, with white text on a dark colour and black text on a light one;
- the Average row last, the header rows and the name and Form columns fixed when you scroll, a filter on every column.
They keep the periods you chose (matched by name, "Term 1B") and the column types you hid.
All years XLSX opens a window that says how many pupils and year groups the file will hold. Start export shows a progress bar while each year group is read. When it is done, Download file gives you the file. It can take a few minutes for a large school: Remind me later closes the window and keeps working, and a message tells you when the file is ready.
TIP
To colour VA green, orange and red, give the VA column type colour bands, with your school's thresholds. There is a ready −2 to +2 set for value added. Give Effort bands too if its average should be coloured. The Summary, the averages and the Excel files all use those bands.
If the Summary is empty
- A class not on the template. The page tells you the class is not covered by the chosen template. Choose another template, or ask an administrator to add the class to it.
- No subjects visible. You may have hidden all of them. Open the Subjects picker.
- Subjects you cannot open. You see only markbooks you reach: your own, those you lead, and subjects you are allocated to in your classes. See Leadership Roles.
INFO
The Summary's averages are for reading only. No report and no calculation uses them. If you need a calculation inside one subject, use a calculated column.