Using the gradebook>>Exporting and importing grades
You can modify the gradebook data you downloaded from CourseCompass in a spreadsheet application, such as Microsoft Excel, and then upload the revised data to the CourseCompass gradebook. You upload data for one gradebook item at a time. You can update grades within the selected item for specific students or for all students.
Here are some ways you can modify the gradebook with uploaded data:
Add an item to the gradebook and, if you want, upload student grades for that item. For example, you might add an item for class attendance, enter grades for each student, then upload the item and the grades.
Enter or modify grades in an existing item, then upload them to the gradebook.
Modify an item name, then upload it to the gradebook.
You cannot modify and upload the following data:
You cannot import data to the Total and Weighted Total columns, because the data is generated by calculations within the gradebook. You can import data from these columns to a new column in the gradebook, but the data will be static unless you manually change it.
You cannot add student records 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.
Important: To modify gradebook data outside of CourseCompass, first download the gradebook. Do not create a gradebook from scratch and then upload it.
To upload gradebook data:
Click the course name on the My CourseCompass page.
Click Control Panel.
Click Gradebook under Assessment.
Click Upload Grades.
Click Browse.
Locate and select the gradebook file (a .csv file) that you want to upload, then click Open.
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.
Click Submit.
Select a column you want to upload and its destination column in the CourseCompass gradebook:
Under Choose Imported Item, select a column from the file that you want to upload to the gradebook.
Under Choose Existing Item, select the destination column for the uploaded column.
Note: If you want the data to appear in a new column in the gradebook, select Create New Gradebook Item.
Click Submit. At this point, no grades are uploaded or modified. If the import item you selected is different from the existing item you selected, the gradebook item name is modified.
If you are creating a new gradebook item, the Add/Modify gradebook Item page appears. Enter information for the item, such as points possible and gradebook category. Click Submit, then click OK. The new column is added to the gradebook.
Select the students whose grades you want uploaded to the gradebook. Grades in the Source column will replace grades in the Destination column.
Tip: You can use the following links at the top of the page to select students:
Select All selects all the students.
Select None deselects all the students.
Select Inverse selects the boxes that currently are not selected and deselects boxes that currently are selected.
Click Submit, then click OK.
Repeat steps 4–11 for as many gradebook items as you want to upload.