Entering Grades
Grades are entered in the course gradebook, on the course's Grades tab. Staff and lecturers with permission to change grades see Course grades: Manage course grades, where every cell is editable. Everyone else with access sees Course grades: See course grades, a read-only copy.
The Gradebook
Each row is a student registered for the course. The columns are:
| Column | Content |
|---|---|
| Profile columns | Name and Email/ Student ID by default. Staff who can change grades can pick other profile columns. |
| Calculated Grade | The weighted sum of the partial grades, for reference. Shown when the course has partial grades and the final grade is not qualitative. |
| One column per grade | Headed <label>. <weight>%. The final grade column has no weight. |
| Status | The grade status: Pass and Fail buttons, or a list of statuses. |
| Custom transcript course name | Shown only when the calendar uses custom course names. |
| Notes and Feedback | Free text per student. |
| Updated by | Who last changed the row, and when. |
| History | Opens the row's earlier versions. |
Entering Values
Type a value in a cell; it saves when the cell loses focus.
- Values must fit the grade's scale. A value outside it is rejected with a message such as "Grade must be between 0 and 100".
- Grades are typed with the institution's decimal separator, so
6,5is accepted when the separator is a comma. Grades are always stored with a dot. - Formula grades cannot be typed; they are calculated. See Grade Setup.
- Published grades are read-only until they are unpublished. See Publishing Grades.
Grade Status
The Status column records the outcome of the registration. With the three default statuses, it shows Pass and Fail buttons; selecting the active button again clears the status. When the institution has added its own statuses, a list of status labels replaces the buttons. See Grade Settings.
The status decides whether the student is awarded the course's credits once the final grade is published. With automatic assignment on, entering the final grade sets Pass or Fail from the pass grade (see Grade Setup); a status set by hand stays until the final grade changes.
The status, notes and feedback are locked once the final grade is published.
Notes and Feedback
Notes and Feedback take free text, with a read more link for long entries. Feedback appears to the student with their grades; notes do not appear in the student views.
Resits
When the institution has resit grades on, a grade that already has a value can take a resit grade:
- When the scale has no resit cap, a + button adds a resit field next to the original.
- When the scale has a cap, a RESIT button opens the Resit grade window. It shows the cap, for example "This resit grade capped at 60 (60% of maximum grade)", the Original grade and a Resit grade field. A resit above the cap needs a Justification for passing the resit cap. SAVE RESIT stores it and REMOVE RESIT deletes it.
The resit replaces the original wherever the grade is used (formulas, the calculated grade, automatic status, the transcript) when it is at least as good as the original. A tie goes to the resit. The value that is not used is shown struck through.
Note: The cap percentage is recorded when the resit is entered. Changing the scale's cap later does not change resits already saved.
Importing Grades
Import grades from CSV in the actions menu opens the Import grades window:
- Select Download CSV file to get a template with the course's students and the right column headers.
- Fill in the file and choose it under Upload a CSV file.
- Pick the Separator in .csv file: Comma ,, Semi-Colon ;, Colon : or Tab.
- Select Import.
| Column | Use |
|---|---|
| Email or the student ID field | Identifies the student. At least one is required. |
| One column per grade, by label | The grade value. A weight suffix in the header (Exam . 60%) is ignored. |
| Status or Pass | Fail | A grade status, by name or label. Not defined clears the status. |
| Notes, Feedback | Free text. |
Empty cells are skipped. Grades that are already published are not changed, and nor are the status, notes and feedback of a student whose final grade is published.
The import is all or nothing. When any row fails, for example an unknown student or status, nothing is saved and the window offers a CSV of the rows with an Error reason column to correct and import again.
Note: On a course whose grades come from Canvas, only the Status, Notes and Feedback columns are imported.
Exporting Grades
The actions menu has two exports:
| Export | Content |
|---|---|
| Export | A CSV with the visible profile columns, one column per partial grade, the final grade, Status, Notes, Feedback and Publication (Published or Not published). Grades use the institution's decimal separator, so the file can be edited and imported back. |
| Export Exam Board Report | A spreadsheet with First name, Last name, Email and the student ID (or the picked profile columns), each partial grade, the final grade, Grade and Publication. Grade is the grade status label or, when the student has no status, the grade band their final grade falls into on the class study plan. |
Grade bands are set on the study plan; see Transcript Grade & Degree Class.
Grade History
The history icon at the end of a row loads the registration's earlier versions as read-only rows under the student, so staff can see who changed what. Every change to grades, status, notes and feedback is recorded.