Courses: Gradebook

Using Your Gradebook

Open your Course Gradebook from the left menu of the course. You can grade assignments, tests/quizzes, 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. Gradebook Menu

Switch among the following options:

Note: Depending on the settings at your school, you may not have access to some of these options.

Back to top

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.

Back to Top

3. Categories Menu

Filter the Gradebook to only show grade items that belong to a grading Category, which you define in your Grade Setup page.

Back to top

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.

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.

Note: Items marked Incomplete register as blanks 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 has not yet been given a grade:

 Back to top


6. Add Item Button

Click the plus sign to create graded content directly from the Gradebook:

  • Assignments
  • Discussions
  • Test/Quizzes
  • Grade Column (no associated course material necessary)

7. Gradebook More Options Menu

Click the three vertical dots to access a menu of additional options for the gradebook:

  • Bulk Edit

Select Bulk Edit to view graded assignments, tests/quizzes, and discussions in a given course. For each graded item you can edit or delete the item's:

    • Name
    • Published/Unpublished status (the green dot in the second column)
    • Category
    • Max points available
    • Factor
    • Scale
    • Due date
    • Grading period
    • Desc. (Description)

Click the Save Changes button below the bulk editor to update your gradebook with the changes.

  • Print Grade Reports

Print the Grade Reports for students in your course.

  • Export

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.

  • Import

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: This is only available to Enterprise instructors.

Back to top

Marking 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

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. 

Adding 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  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.

Editing Grades

To edit grades directly from the gradebook, click in the cell and add the new grade. 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. You can also use the tab or arrow keys to navigate the gradebook. Note that 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, press Tab again moves the cursor to the top of the next column.

If a test or quiz is graded automatically, the grade will already display. 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.

Back to top

Viewing Individual Submissions

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

Icon Description
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: Tests and quizzes 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.

Back to top

Adding a Custom Overall Grade Column

You can also add a custom grade column to your gradebook from the Final Grade Settings section. Enable the Add a custom overall grade column checkbox in the Custom Overall Grade section to add the custom column next to the Overall grade column. If you enable this feature, your 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. Grades in the calculated column are not visible to students or parents.

Grading Groups

Course administrators may also use grading groups to associate students of the class to group projects, special needs, or other specific criteria.

An additional drop-down menu displays in the upper-left corner of the gradebook for instructors who use grading groups:

Click any option in the menu to filter your gradebook for only students in those groups.

For more information, read the article in the Help Center on Schoology Grading Groups.

Back to top

Powered by Zendesk