By default, all Gradebooks begin with the Spreadsheet view. This preference can be changed in your Gradebook preferences, as described in the Setup Gradebook Preferences lesson. The Spreadsheet View is a great way to see all your students and assignments at a glance, enter large amounts of data at once, and jump off into assignments or students easily without changing screens or to other views.
Where to Start
- Click the Gradebook tab.
- Select My Gradebooks.
- Click on the title your Gradebook.
If your default view is not the Spreadsheet view, go to the View tab and select Spreadsheet.
Spreadsheet View Basics
- Hover your mouse over the assignment name to Edit, Fill Down (Scores), Manage Links (to Assessments when applicable), Delete or Duplicate the assignment information.
- Hover over the Tag icon to see any Tags associated to the assignment.
- Type an X to indicate an assignment as Excused. This Custom Mark is automatically available for all gradebooks.
Basic tips when entering assignments and scores:
- Press Enter on your keyboard after typing each scores it will automatically place you in the next box down.
- Press Tab you will move 1 box to the right. The student's grade/mark will not update until you stop for a few seconds and/or press enter.
- Every score is Saved automatically after you enter it. This can be disabled in your Gradebook preferences.
- Light gray colored boxes indicate assignments are not currently counting towards a student's grade either due to the assignment due date or the grading period has passed.
- Dark gray colored boxes indicate assignments that occurred before or after a student is actually in a class (they are referred to as Schedule Date Exception).
Navigating Spreadsheet View
- Change your Input Mode. To learn about the different options, visit Understand How Points, Scores, and Percentages Work.
- Select column heading arrows to sort rows by the data in that heading .
- Select a student's name to jump to the Student List view
- Use Column Per Page to set how many assignments appear on the spreadsheet.
- The icons below each assignment name correspond to the Category of the assignment (Points-Based only).
- Class Averages are available for overall and each individual assignment.
- Select the Student Icon to access the student's profile
- To print a quick and ready (as of today) progress report, select the Download icon.
Next Steps
Learn about the other views and how they'll make you a GradeBook super star by visiting Enter Assignments Using the Student List View and Assignment View.