Using Oncourse CL Gradebook, how do I calculate and export course grades?

Note: To complete the procedures in this document, you must be assigned a role having the necessary permissions. To determine your role, follow the directions in Participant roles. To view a list of permissions associated with a given role, see Permissions, roles, and tools. For a basic understanding of roles and permissions, see Permissions and roles: Overview.

Using Gradebook, you can calculate course grades, and then export them to a CSV file or a file customized for import into Indiana University's Student Information Systems (SIS).

Calculating course grades

Note: As of December 2008, letter grades in Gradebook are referred to as non-calculating grades. Non-calculating grades may be any string of text up to eight characters. If you want your grades calculated automatically, you must enter them as either points or percentages. See Changing the grade entry, type, and scale in Gradebook, How changes in the Gradebook tool affect data for previous semesters, and How changes in the Gradebook tool affect grade entry for current and future semesters.

Note: If you use points and have imported gradebook items with Gradebook Item Point Values less than or equal to 0 (zero), those gradebook items will not be included in the course grade calculation. (You cannot create an item with a value of less than or equal to zero in the Gradebook.)

Note: When you use Calculate Course Grades to do the course grade calculation, all blank scores are converted to zeros. This process is irreversible.

To calculate course grades:

1. In your site's menubar, click Gradebook.
   
   
2. Near the top, click Course Grades.
   
   
3. Below the Grading Table, click Calculate Course Grades.
   
   
4. On the confirmation page, click Continue.

   Note: This action is irreversible; however, you can use the "Grade Override" column to manually override the calculated course grade.

   You will receive a confirmation that course grades have been calculated.

Exporting course grades

If you plan to export and maintain local offline copies of any student information (including but not limited to names, University ID numbers, or grades), you are responsible for taking adequate security measures to handle and safeguard such data, as it remains sensitive university data.

The University Information Policy Office (UIPO) has more information on its web page about protecting sensitive institutional data.

For more on handling sensitive data, see:

• What is sensitive data and how is it protected by law?
• What is institutional data?

To export course grades:

1. In your site's menubar, click Gradebook.
   
   
2. Near the top, click Course Grades.
   
   
3. Use the "View" drop-down list to view specific groups or sections, or use the search field to find specific students.

   Note: The resulting export file will reflect the view options you select. It will contain only the information that is visible on the page.

4. To export a CSV file, click Export Course Grades. Your browser will prompt you to open the file or save it to your computer.

   To export a file that's customized for importing into SIS, click Export for SIS.

   Note: The default filename format for your export file will be course_grade_[courseID]__date.*. The exported fields and the names of the .xls and .csv column headers are "Student Name", "Student ID", and "CourseGrade".

You can also export scores from the All Grades view; see Using Gradebook to view and export student grades.

Comments/Questions/Corrections