Using the gradebook>>Exporting and importing grades

Exporting gradebook information

You can download and save the gradebook to your computer or to a disk. The downloaded gradebook file is a comma-separated value file (.csv file) that you can edit in an application such as Microsoft® Excel. It contains all the data you see in the spreadsheet view of the gradebook.

You can then upload the gradebook data to your course to update the gradebook.

To export the gradebook:

1. Click the course name on the My CourseCompass page.

2. Click Control Panel.

3. Click Gradebook under Assessment.

4. Click Download Grades.

5. Select a delimiter type for the downloaded file, then click Submit.

6. Click Download.

7. Click Save, or select Save to disk and click OK.

8. Accept the default file name (gb_export.csv), or type a new name. Browse to select a folder, then click Save to copy the file to the selected folder.

9. Click Open to launch Excel (or some other spreadsheet application) and open the .csv file, or click Close to open the file later in a spreadsheet application (see below).  

10. Click OK.

Notes:

• Data from the Total and Weighted Total columns are included in the gradebook download. However, these columns are not included when you upload the file to the gradebook in CourseCompass because the data is generated by calculations within the gradebook.  

• You cannot add students to the downloaded file and then upload them to the gradebook. Students must register in CourseCompass and enroll in a course to be listed in the gradebook for the course.

Opening the gradebook file in a spreadsheet application

Follow these steps to open the exported file in a spreadsheet application. This procedure uses Excel.

1. Launch Excel and select File > Open.

2. Locate and select the downloaded file.  
   
   Tip: If the downloaded file is not listed, enter *.csv in the File Name box, then click Open to display all of the .csv files in that folder.

3. Click Open.

4. If you make changes to the data, select File > Save.

A message informs you that the .csv file may contain features that are not compatible with the comma-separated value (.csv) format. Click Yes to keep the file in the .csv format. When you close the file, Excel asks if you want to save changes to the file. Unless you made further changes to the file after clicking Yes to the first message, click No.