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.

Go to Gradebook2.

Go to Gradebook2.

Select Gradebook2 from the Tool Menu in your site.

Click Tools > Download New Item Template.

Click Tools > Download New Item Template.

This displays the Gradebook2 download dialog box.

Select the default All Sections, then click Download.

Select the default All Sections, then click Download.

Depending on your computer settings, you may see another downloading dialog box.

Download the template (.csv file) to your computer.

Download the template (.csv file) to your computer.

Open the downloaded .csv file in your Excel (or other) spreadsheet application.

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.