Work out averages and totals in a table
Make a row or column of a table work out an average, a total, the highest, the lowest or a count. It fills itself in as you type scores.
- Open Theme Studio and go to the page with the table.
- Click or tap the table, then select Edit cell text in Properties. Strips appear above the table and down its left side.
- Click or tap the strip above a column, or beside a row, to select all of it.
- In Properties, under Calculate, pick Average, Total, Highest, Lowest or Count.
- Select Done when you're finished.
Back in your planner, type scores as usual. A calculated column works out the scores to its left, back to the last calculated column, so a first-quarter average and a second-quarter average can sit side by side. A calculated row does the same with the scores above it.
Scores can be written as 95, 95% or 18/20, with a decimal point or a comma. Blank cells and words like ABS or EX are skipped, not counted as zero.
Good to know
Calculated cells are shaded and fill themselves in, so they can't be typed in. The top cell of a calculated column, and the first cell of a calculated row, stay yours for a label, like Average. The top row and the first column can't be calculated.
Tip
Where a calculated row meets a calculated column, the corner shows the class's overall number.
Good to know
To stop, select the row or column again and pick Off. Anything typed there before comes back.
Updated September 27, 2026
Was this helpful?
Related articles
- Keep grades in the gradebookThe Grades section gives you gradebook pages. Type names and scores, fill names from your roster, and keep a page per subject or term.
- Change a page's designIn Theme Studio, go to the page, select what you want to change, then move it, resize it or restyle it in Properties.
- Format cells in a tableClick or tap in a table cell, then use the Text toolbar to change its font, size, color, bold, italic, underline or alignment, on a computer or a phone.
- Why did a new Untitled theme appear?Changing a ready-made theme saves your changes as your own copy, usually named Untitled, so the original stays as it was.