How do I Import grades from an Excel (.csv) file into Gradebook2?
Instructors can import grades into the Gradebook2 tool using a formatted .csv file. A properly formatted .csv file containing all of the student information can be downloaded first from the Gradebook2 tool under Tools > Download New item Template.
Use this template to add/calculate your grades in Excel (or some other spreadsheet application) then import the file back into the Gradebook2.
Example of a .csv template file with the new grade information added.
Go to Gradebook.
Select Gradebook2 from the Tool Menu in your site.
Select No-structure gradebook (grades only), then click Browse.
Locate the .csv file on our computer, then click Open (or Select).
Edit the item.
If your Gradebook has categories, you will need to assign the new item to a category before it will be calculated in the course grade.
Right-click the item and select Edit this Grade Item.
This displays the Edit dialog box for this grade item.