How do I download a Gradebook2 Template?
In order to import grades from an Excel spreadsheet, instructors must use a template that organizes the rows and columns of the spreadsheet in a proper format for importing. The Gradebook2 tool provides a mechanism for download a blank template that can be used for grading and importing back to the Gradebook2 tool.
This template can also be used for the Feedback tool (See What is the Feedback tool?)
Select the default "All Sections", then click Download.
Open the downloaded .csv file in your Excel (or other) spreadsheet application.
The template is set up with the proper columns and the information about your students (ID and Name). Change the Column Header name to the name of your new grade item and add grades to column.
Note: you may add additional grade columns.
Save the file (as a .csv) file and import the grades to the Gradebook (See: How do I Import grades from an Excel (.csv) file into the Gradebook2?)