CULearn Faculty Support — Exporting the Grade Book for Web Grading

ITS Help Documents >> CULearn >> Faculty Support >> Exporting the Grade Book for Web Grading

Overview

Instructors can upload CULearn grades into the Registrar's web grading system at the end of the semester. To do this you must:

1. Import Student ID numbers into the CULearn Grade Book.
2. Export the Grade Book and customize the .csv file for web grading, by following the instructions below:

Exporting the CULearn Grade Book for Web Grading:

1. From the Teach tab, scroll down to Instructor Tools and click on Grade Book.

2. Click the Export to Spreadsheet button. Note that this can be done from either the Grades, Members, View All, or Custom View tab (but not the SCORM Grades tab).

3. The Export to Spreadsheet screen appears. It will ask you to choose certain options. The image below shows some recommendations. ITS recommends the following:

• Under Members to Export: select All members.
• Under Columns to Export: select All columns. 
• Under Export Format: select the Comma-delimited option (this is a very common format for importing into spreadsheet programs, although the Tab-delimited option will often work well too).
• Under Character Set: select the default Unicode (UTF-8) setting unless you know that your programs need to alternative.

Click the Export button, and select a location to save the new file.

4. Download and save the file to your computer.

Click to enlarge.

5. Open the .csv file in Excel.

6. Rename the CU ID column as SID.

6. Delete all of the columns except for SID and Grade.

7. Save the file. You now have a file that you can upload for Web Grading.

Security precaution: If you plan on keeping this grade book file on your computer, ITS recommends that you encrypt the file.

• Encrypt Files in Office 2003 for Windows
• Encrypt Files in Office 2004 for Macintosh

Learn More

• Importing Student IDs into the CULearn Grade Book.
• The Office of the Registrar's Web Grading website.

Get Help
IT Service Center
303-735-4357 (5-HELP from an on-campus phone)
help@colorado.edu