Sooner or later you need to look at one student properly. A report card comment. A student who swears they handed something in. A check that the mark you entered on Tuesday actually saved. Each time, you open the Brightspace gradebook and find a grid built for the whole class, with one student's row somewhere in the middle of it.

The data is all there. The trouble is that a gradebook cell can look the same for very different reasons, and a few of those reasons will mislead you if you read the grid too quickly. This guide covers where to look, what the cells can mean, and the traps that make one student's grades look better or worse than they really are.

One caveat before we start: Brightspace is very configurable. Menu names, which columns you see, and how final grades behave all depend on how your school has set things up and how your course was built. Treat the paths below as a guide, not a script.

Two ways into the Grades tool

The class grid: Enter Grades

Open the Grades tool in your course and the Enter Grades page is usually where you land. Every student down the side, every grade item across the top, often grouped into categories. It is the right place for entering a column of marks after you've graded a set of tests, and for seeing how the whole class did on one item.

It is the wrong shape for one student. You end up tracking a single row across a table that scrolls sideways, and in a course with a lot of items the columns you care about are rarely on screen at the same time. It is easy to read the row above or below by mistake, especially on a laptop.

One student at a time

From Enter Grades you can usually click a student's name to open that student's grades on their own: every grade item for that one person, listed down the page instead of across it. This is the view to use when you're checking your own entries or writing a comment, because you read top to bottom and nothing from the next student gets in the way.

Many installs also have a Preview option in the menu beside a student's name, which shows the grades the way that student sees them. That is not the same as your view. The difference between the two is where most "but it says I have 90%" conversations come from, so it's worth knowing both exist.

A quick habit: when a student or parent questions a mark, check the instructor view and then the student preview, in that order. If they disagree, the cause is almost always a visibility or release setting, not a wrong number.

Blank, zero and exempt are three different things

This is the part that catches the most people. Three cells can look similar at a glance and mean completely different things.

How blank cells count depends on a course setting. In the Grades tool's settings, under calculation options, a course is usually set either to drop ungraded items (blanks are ignored until a score goes in) or to treat ungraded items as 0 (blanks count as zero straight away). Same student, same work, very different running grade. If one student's average looks oddly high or oddly low, check this setting before anything else.

The common trap: with "drop ungraded items" on, a student who hasn't submitted half the work can show a healthy average, because only the marked items count. The grade is accurate for what's been graded. It just isn't the whole picture.

Hidden, unreleased and ungraded items

Not everything in the gradebook is visible to the student, and not everything you see is final.

Items that aren't tied to an assignment or quiz

Most grade items in a typical course are linked to something: an assignment folder or a quiz that feeds marks into the gradebook. But many courses also have columns that stand on their own, created straight in the Grades tool. Presentations, lab practicals, a participation mark, a test written on paper, work marked in another system and typed in by hand.

Those columns behave differently. They have no submission behind them, so there is nothing that tells you whether the student "handed something in". A blank in one of those columns only means no grade has been typed in. When you read one student's grades, keep the two kinds apart in your head: a blank on a linked assignment might be missing work, while a blank on a standalone column is usually just a mark you haven't entered yet.

Final calculated grade vs final adjusted grade

At the far end of the gradebook you'll usually find a final grade, and Brightspace has two kinds.

The final calculated grade is what the gradebook works out from the items, weights and settings in the course. The final adjusted grade is a version a teacher can change by hand, for instance to apply professional judgement at report-card time, without touching the marks on the individual items. Depending on how your course is set up, students see one or the other once it's released.

We won't get into how the calculation works here, because it depends on your grade scheme, weights and categories, and your school may have its own rules. The practical point is simpler: if you change an adjusted grade, write down why. Months later, a final grade that doesn't match the items above it is hard to explain without a note.

Things that make the gradebook misleading

Even with everything entered correctly, a few situations make one student's grades tell the wrong story:

A checking routine for one student

Whatever the reason you're looking, this order works:

  1. Open the student's own grades view, not the class grid.
  2. Scan for blanks on linked assignments and quizzes. Those are the ones that might be missing work. Then confirm by checking the assignment's submission list. The guide to seeing who hasn't submitted covers where that lives.
  3. Scan for zeros and ask whether each one is a real grade or a placeholder.
  4. Check exemptions are on the items you meant to excuse, and only those.
  5. Check the standalone columns for marks you meant to enter and haven't.
  6. Preview as the student if you're about to share anything, so you know what they're looking at.

For a whole class at report-card time, the end-of-year checklist walks through the same checks in bulk, and if missing work is the real question, getting a full list of missing submissions is the faster route than reading gradebooks one row at a time.

Where ClassWatcher fits

The routine above is the part we found ourselves doing over and over, so we built a view for it. On the Pro plan, ClassWatcher's parent report puts every assignment, quiz and grade for one student on one screen: what was submitted, what wasn't, and what it scored, read straight from Brightspace.

Two details matter for the problems above. The report includes other graded work as its own section, meaning gradebook columns that aren't tied to an assignment or quiz, so the standalone marks don't get lost among the linked items. And assignments that aren't due yet are left out, so a student isn't shown as behind on work that isn't due.

To be clear about what it doesn't do: ClassWatcher reads what's in Brightspace and shows it to you. It doesn't calculate grades, it doesn't change any grade in Brightspace, and it never labels anything late.

It's called the parent report because that's where it gets used most, and the parent-teacher interview prep guide covers that side in detail. But it's just as handy for checking your own entries before report cards, or answering a student's "did you get my lab?" in a few seconds.

The free version of ClassWatcher works without an account: open a Brightspace assignment or quiz page and it lists who hasn't submitted. The parent report is part of Pro (CA$19/month). Getting started covers what each plan includes.

Whatever tools you use, the underlying advice holds: read one student down the page rather than across the grid, treat blank, zero and exempt as three different answers, and check what the student sees before you talk about a number.