How do I add grades and comments to the Gradebook2 spreadsheet?
To set-up your Gradebook see:
- How do I create a non-weighted Gradebook?
- How do I create a non-weighted Categories Gradebook?
- How do I create a Weighted Categories Gradebook?
Once the Gradebook is set-up and you have entered graded items, you can add grades and comments via the Gradebook2 spreadsheet panel.
Checkmark the graded item to display the grade column in the spreadsheet.
To add a grade, click in the grade cell and enter 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.
To add a comment, right-click (CTRL-Click Mac) the grade cell and select "Edit Comments".
To release the item grades and comments to students, right-click (CTRL-Click Mac) the grade item and select "Edit this Item".
Checkmark Release Scores and click Save/Close.
This changes the item color to Blue and releases the item scores to the students.
Example: Other spreadsheet indicators
- 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.
- 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.
- 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.
- When a comment has been added with a score, the Gradebook displays a yellow triangle in the upper right corner of the cell.
- If the score is for an extra credit item, the Gradebook displays the score in green.
- If the score is not included in the course grade calculation, the Gradebook displays the score in gray.
- 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.