How do I add grades and comments to the Gradebook2 spreadsheet?

Once the gradebook is set up and you have added items, you can enter grades and comments via the Gradebook2 spreadsheet panel.

Go to Gradebook2.

Select Gradebook2 from the Tool Menu in your site.

Display in spreadsheet.

Display in spreadsheet.

To display the item in the spreadsheet, check the box next to the item name.

This displays the item's grading column in the spreadsheet panel.

Add a grade.

Add a grade.

To add a grade, click on a cell in the column and enter a score.

Tip: To save the score and move down the column to the next cell, hit the “Enter” key on your keyboard or use your computer's down arrow key.

Note: How you enter scores will depend on how you have set up the gradebook:

  • Points. If the gradebook is set up for points, enter any number that is equal to or less than the total point value (maximum points) for the item. You may enter zero, and you may enter numbers with decimal points, up to five places. You may also enter a negative number.  
  • Percentages. If the gradebook is set up for percentages, you must enter a number from 0 to 100. You may enter numbers with decimal points, up to five decimal places.
  • Letter Grades. If the gradebook is set up for letter grades, enter a letter grade (F to A+) or zero.  

Add a comment.

Add a comment.

To add a comment, right-click (CTRL-Click Mac) the grade cell and select Edit Comments.

This displays the Edit Comments page.

Enter your comments, then click Submit.

Enter your comments, then click Submit.

This saves the grade comments.

Click Close.

Click Close.

This returns the display to the spreadsheet panel.

Example: Yellow triangle in top right of cell indicates there is a comment attached to the grade

Example: Yellow triangle in top right of cell indicates there is a comment attached to the grade

Example: Other spreadsheet indicators

Example: Other spreadsheet indicators
  1. When you click on a cell, the Gradebook displays a blue border around the cell to indicate the cell is active and you may enter a score.
  2. If the score for an item is within the item’s allowed value range, the Gradebook displays a green triangle in the upper left corner of the cell.
  3. If the score is not within the item’s allowed value range, the Gradebook displays a red triangle and a “Request Failed” message, and will not accept the entry.
  4. When a comment has been added with a score, the Gradebook displays a yellow triangle in the upper right corner of the cell.
  5. If the score is for an extra credit item, the Gradebook displays the score in green.
  6. If the score is not included in the course grade calculation, the Gradebook displays the score in gray.
  7. If the score has been excused, or if it is low enough to be dropped in a category for which you have opted to drop one or more lowest-score items, the Gradebook will display the score in red with a strikethrough.

Note: When you enter scores in a category set to drop lowest-score items, the Gradebook does not drop scores until you have at least one more scored item than the number set to be dropped. If a category is set to drop two lowest-score items, for example, you must score three items for the Gradebook to drop the two items with lowest scores.