Courses: Gradebook


Using Your Gradebook

Access your Course Gradebook from the left menu of your Course to update assignments, test/quizzes, assessments, and discussions. Students can view these grades under their Grades tab. 

Perform the following actions from within Gradebook:

  • To customize the columns in your Gradebook and student grade reports, see Grade Setup.
  • Gradebook is not supported in courses containing more than 10,000 members.

View and Filter Items 


The set of menus available in the top row of your Gradebook provides flexible control over displaying content, creating new content, and setting various options.

  1. Members Menus
  2. Grading Period Menu
  3. Categories Menu
  4. Sort Materials Menu
  5. View Menu

Members Menus

Name Display

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


Note: The default view is Last Name, A-Z. This will display names in the format: Smith, John. To make navigation among courses easier, the view selected for each section will save within your browser session. If you change browsers or clear your cookies, the view will reset to default (Last Name, A-Z).

Grading Groups

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.

Linked Sections

If you use linked sections, then there will be an additional menu to filter between the linked sections in your course.


Back to top

Grading Period Menu

In the Grading Period menu, select:

      • A single grading period to display only 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 checked Set as midterm/final in the item's Grading options.
      • (No grading period) to see items that haven't been assigned a grading period.
Note: This filter defaults to the current Grading Period. If your course is not currently active, this view will default to All Grading Periods, which does not show individual graded materials.

Back to top

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:


Note: The Categories in this list are configured in the Grade Setup page. If a material does not have a grading Category, it will appear in the (Ungraded) view. You cannot enter grades, comments, or exceptions into the Gradebook for an item that is designated as (Ungraded).

Back to top

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:


Note: This option continues to display the overall and grading period columns if the course is configured to display those columns, but materials are not listed in this view.

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 that displays on the student grade report. It is an average of all of the scores for materials aligned to that grading period and associated with that grading category.

Grading Category-Specific View

When you filter for 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.


Back to top

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.

Back to top

View Menu

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.

Highlight Cells

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.
      • Marked "Missing"
        Highlight all gradebook items that you've marked missing, indicated by an empty orange hexagon in the table cell:

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:


Back to top

Edit Materials


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 and discussions. This option is not available for test/quizzes and assessments.
        • 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.

Add Materials


Click in the top row of your Gradebook to create graded content:

      • Assignments
      • Discussions
      • Test/Quizzes
      • Grade Column (No associated course material is added. See here for more information.)

Back to top

Edit Grades

To edit grades directly from your Gradebook, click into the cell and add the new grade.

You can also use the tab or arrow keys to navigate your 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: pencil.png

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.

Back to top

View Submissions

Instructors can open and view materials for individual student submissions directly from the Gradebook.

Icon Description
View_Assignment_Icon.png Open and view a submitted assignment.


Open and view a graded discussion.


Open and view a completed test or quiz.
View_Assessment_Icon.png Open and view a completed assessment. 

Back to top

Add Comments

To leave a comment:

      1. Hover your pointer over a cell and click the Comment icon:
      2. Type your message in the pop-up window that displays.
      3. Check the box to Display to Student (optional).
      4. 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 graph_icon.png 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.

Back to top

Mark Exceptions

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 (Enterprise only)

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.

Back to top

More Options Menu


Click the three vertical dots to access a menu of additional options for the Gradebook.

Note: This menu will only appear if there are graded materials within the course. 

Bulk Edit

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 items:

  • Name
  • Published/Unpublished status (the green dot in the second column)
  • Category
  • Max points available
  • Factor
  • Scale/Rubric
  • 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.

Back to top

Print Grade Reports

Print Grade Reports for students in your course.

  1. Select the specific grading period(s) you want to include.
  2. Select individual students or all students.
  3. Click Generate Report.
  4. Print from your browser.


Back to top


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.

Back to top


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.

Back to top




  • Avatar
    Randy Hall

    Some of  The images on the lower bottom of the page are not loading for me. For example, under the viewing individual submissions section, the images for each of the icons are not loading.  Can someone check on this? 

    Comment actions Permalink
  • Avatar
    Yimei Shao

    Hi Randy, 

    Thank you for bringing that to our attention!

    We've updated the images and other aspects of the article to make it more accessible. 

    I hope you find these changes helpful! 


    Yimei Shao
    Knowledge Management Associate
    Schoology, Inc.

    Comment actions Permalink

Article is closed for comments.

Powered by Zendesk