Using Your Gradebook
Open your Course Gradebook from the left menu of the course. You can grade assignments, test/quizzes, assessments, and discussions directly in the Gradebook, and your students can view these grades under their Grades tab as you post them.
A set of menus is available in the top row of the Gradebook that give you flexible control over displaying content, creating new content, and setting various options.
1. Members Filters
Name Display menu
You can sort the list of members in your course to display in ascending or descending alphabetical order by First or Last name. The menu includes the following options:
- First Name, A-Z
- First Name, Z-A
- Last Name, A-Z
- Last Name, Z-A
Course administrators may also use Grading Groups to associate students of the class to group projects, special needs, or other specific criteria.
For instructors who have configured grading groups for their course, an additional drop-down menu displays in the upper-left corner of the gradebook:
- To view materials assigned only to the grading group, filter to that group. The menu will show the number of members in each group in parenthesis.
- To view all materials in the course, filter to All members. For students to whom the material is not assigned, the grade cell is grayed-out and un-editable. This prevents you from accidentally entering grades for students that are not assigned an item in the course.
If you use linked sections, then there will be an additional menu to filter between the linked sections in your course.
2. Grading Period Menu
In the Grading Period menu, select:
- A single grading period to only display the items from that period.
- All Grading Periods to view the calculated grades for the overall and grading period scores. Sub-periods are nested beneath their main grading period.
- Final/Midterm Material Grades to view items for which you have selected the Set as midterm/final check box in the item's Grading options.
- (No grading period) to see items that haven't been assigned a grading period.
3. Categories Menu
While viewing the Gradebook as a course admin, the default view includes all graded materials in the course. To view graded materials within a specific category and the student’s grade for that category, click the drop-down arrow next to All Materials:
All Category Summaries View
The All Materials drop-down also includes an option called All Category Summaries.
If you select a specific grading period and the All Category Summaries option, the gradebook displays one column per grading category that exists in the course. If no items have been graded for a student within a certain category, that category’s column appears, but displays N/A:
Since course materials can only be aligned with the lowest level of grading period in your course, whether a grading period or sub-period, grading category scores are only calculated for those grading periods.
- The All Category Summaries option is only available when you have selected the lowest level of grading period.
- A grading category score is not calculated for grading periods that have sub-periods.
- If the user selects a parent grading period from the grading period drop-down while All Category Summaries is selected, the view changes to the selected parent period with All Materials automatically selected in the category drop-down.
Grading Category Score Columns include:
- The title of the category as the column header
- The calculated category score for the selected grading period
- Note: This is the same score we currently display on the student grade report. It is an average of all of the material scores for materials aligned to that grading period and associated to that grading category.
Grading Category-Specific View
When you filter by a specific grading category using the All Materials drop-down, a column appears to the right of the grading period column with the students’ calculated grading category score within that grading period.
Course Admins can hide the category score columns from their gradebook view using the option in Grade Setup flag called Hide Grading Category score columns.
4. Sort Materials Menu
Choose an option in the Sort Materials menu to select the order in which the grade item columns display:
- Due Date, Ascending: Sort items from left to right with the earliest due dates displayed at the beginning of the gradebook and the most recent at the end.
- Due Date, Descending: Sort items from left to right with items with the most recent due dates at the beginning of the gradebook and the earliest ones at the end.
- Date Created, Ascending: Sort items from left to right with the earliest items you created displayed at the beginning of the gradebook and the most recent at the end.
- Date Created, Descending: Sort items from left to right with the most recent items you created displayed at the beginning of the gradebook and the earliest ones at the end.
Note: Items without assigned due dates display at the beginning of the gradebook list regardless of the selection you make in the Sort Materials menu.
5. View Filter
Select one or more options from the View menu to see additional information about the items in the gradebook.
- Show Full Titles
Select to expand the header row of your gradebook and show the entire title of each graded item.
- Show Grading Scale
This setting controls the display of the scale dropdown menus that appear in gradebook cells when entering grades or overrides.
If enabled, a menu displays in the gradebook cell for any material item that has a point- or percentage-based grading scale.
Disable this setting to remove the scale menu from gradebooks cells.
- Disabling Show Grading Scale does not remove the grading scales from items or affect item grades in any way; it only removes the pop-up menu from gradebook cells.
- The Show Grading Scale setting persists across all of a user's sessions and courses. For example, If you disable it in your Gradebook for Course A, it will be disabled every subsequent time you view the Course A Gradebook, and will also be turned off for your Gradebook in Courses B and C. The setting is unique to users, which means that if co-admins for courses can choose their own setting when viewing the Gradebook.
You can also choose from a number of selections that highlight cells in the gradebook that fit the selected criteria; the number to the right of each option indicates the total number of items matching the criteria.
- Marked "Excused"
Highlight all gradebook items that you've marked excused, indicated by a green hexagon in the table cell:
In the image at the top of this article, for example, Justin Gonzalez's 8-point Energy Essay and 60-point Science in the... assignment are marked Excused.
- Marked "Incomplete"
Highlight all gradebook items that you've marked incomplete, indicated by a half-filled orange hexagon in the table cell:
In the image at the top of this article, for example, Margaret Flores's 55 Point Group Assignment and 60-point Science in the... assignment are marked Incomplete.
Note: Items marked Excused or Incomplete register as blank, null values in the gradebook and are not factored into student grades.
- Marked "Missing"
Highlight all gradebook items that you've marked missing, indicated by an orange outlined hexagon icon in the table cell:
- Marked "Missing" with Submission
Highlight individual cells that you've marked missing, for which students have made a submission. Tip: After applying the view filter, click the item icon to directly open the new submission.
- Graded With New Submission
Highlight all graded items for which the student subsequently turned in another submission.
- Needs Grading
Highlight all past-due gradebook items that still need a grade.
- Not Submitted
Highlight all past-due items for which students still need to submit their work.
- Materials with factor 0
Highlight the columns of items with a factor of 0—that is, items that you don't want to be factored into student grades.
For example, selecting Needs Grading from the menu adds a border around each cell in the gradebook that is past due, but has not yet been given a grade:
6. Add Item Button
Click the plus sign to create graded content directly from the Gradebook:
- Grade Column (No associated course material is added. See here for more information.)
7. Gradebook More Options Menu
Click the three vertical dots to access a menu of additional options for the gradebook:
Select Bulk Edit to view graded assignments, tests/quizzes, assessments, and discussions in a given course. For each graded item you can edit or delete the item's:
- Published/Unpublished status (the green dot in the second column)
- Max points available
- Due Date
- Grading Period
Click the Save Changes button below the bulk editor to update your gradebook with the changes. If you have multiple pages in this area, click Save Changes at the bottom of each page.
Print Grade Reports
Print the Grade Reports for students in your course.
- Select the specific grading period(s) you want to include.
- Select individual students or all students.
- Click Generate Report.
- Print from your browser.
Choose from two formats in which to export your Gradebook:
- As an XLS/CSV version of your Gradebook.
- As an XLS/CSV file that you can use to import your gradebook into other systems.
Click here to learn more about how to export your gradebook.
If the graded items in one course are the same as the graded items in another course, you can import grades from an XLS/CSV file; for example, when students change classes and their grades must be transferred to the new course.
Note: Importing grades is only available to Enterprise instructors.
To mark items as Excused, Incomplete, or Missing, point your mouse at the cell and click the flag that displays:
Read this article for more information on Gradebook Exceptions.
Using the Excused exception with student completion
You can use the Excused exception to bypass materials on which you have set up student completion requirements. For example, if a student is absent and makes up a required assignment with a different make-up project, or a student is new to class and doesn't need to start at the beginning of a folder with completion rules.
Using exceptions with overdue items
Marking an overdue item Excused or Missing removes the item from a student's Overdue notifications. Marking an overdue item Incomplete does not remove the item from a student's Overdue notifications.
To leave a comment:
- Hover your pointer over a cell and click the Comment icon:
- Type your message in the pop-up window that displays.
- Check the box to Display to Student (optional).
- Your comment saves automatically; click the x in the upper-right of the pop-up to close the comment:
The comment icon displays for all cells to which you've added a comment.
Note: Comments and exceptions appear in the student grade report, which you can open from the Graph icon to the right of the student's name. Comments for grading periods and the overall column also appear on student report cards unless you have selected the Hide overall grade from student reports and/or hide grading period grade from student reports check boxes in the course Grade Setup area.
To edit grades directly in the gradebook, click into the cell and add the new grade.
You can also use the tab or arrow keys to navigate the gradebook. Using the Tab key moves your cursor down one row within the same column in the gradebook. When you reach the end of the column, pressing Tab again moves the cursor to the top of the next column.
Highlighting the Active Row and Column
Whether navigating through the gradebook with a mouse or keyboard, the row and column you are working in will be highlighted to make it easier to see which cell you are editing.
Hover over the gradebook cells to highlight the entire column and row that intersect at that cell, including the student name in that row and the material title in the column header.
If a test/quiz or assessment is graded automatically, the calculated grade will display, along with a link to the student's submission. If you change this grade, the override is indicated by an orange pencil in the lower-left corner:
Click the pencil to clear the override.
- Grades automatically save when you modify a cell.
- You can also type any non-numeric character into a cell to assign a 0 for that grade.
Viewing Individual Submissions
Instructors can open and view materials for individual student submissions directly from the gradebook.
|Open and view a submitted assignment.|
|Open and view a graded discussion.|
|Open and view a completed test or quiz.|
Materials More Options Menu
The Materials More Options menu displays in the header row of each graded item and provides additional options for assignments, tests, and discussions:
- Edit — Modify the item details.
- Track Revisions — Shows changes made to a student's grades for assignments or discussions.
Note: Test/quizzes and Assessments do not have the Track Revisions menu option.
- Set All Grades — Adds the same score for all of the grades for that item.
- View Statistics — Shows statistics for the item. For example, highest and lowest grades, average score, and standard deviation.
- Delete — Removes the assignment, test, or discussion from the course section. All grades for the item are also deleted.
Hiding Overall and Grading Period Columns from Students and Parents
Depending on how you’ve set up the Final Grade Settings section on your Grade Setup page, you can choose to not display overall grades or grading period grades from your students and their parents. In the Automatically Calculated Grades section:
- Select Hide overall grade from student report card if you do not want the Overall grading column to display in student report cards, or student overall grades to display in any reports seen by parents.
- Select Hide grading period grades from student reports if you do not want Grading Period columns to display in student report cards, or the student grades for grading periods to display in any reports seen by parents.
Note: Hiding the grading period grade from student reports also hides the category-level grades from the student report.
Adding a Custom Overall Grade Column
You can also add a custom overall grade column to your gradebook from the Final Grade Settings area of the Grade Setup page. Enable the Course override column checkbox in the Control Grading Columns in Gradebook section to add the custom column next to the default Overall grade column. If you enable this feature, the instructor view of the gradebook displays both a custom overall grade column and the calculated overall grade column.
- Changes in the custom column do not affect the calculated grade.
- Custom column grades display in student report cards and any reports seen by parents, while grades in the calculated column are not visible to students or parents.