Indiana University
University Information Technology Services
What are archived documents?

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.


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

Note: To complete these procedures, 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 System (SIS).

To export grades for all graded items, see Viewing and exporting all student grades.

Calculating course grades

Note: 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.

Note: When you use Calculate Course Grades to do the course grade calculation, all blank scores are converted to zeroes. 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 at Protecting Data. Also, if you store such information on your local computer, see Secure Your Computer.

For more on handling sensitive data, see:

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 contain only the information visible from the view options you select.

  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 ID", "Student Name", "Section ID", and "Course Grade".

This is document aqzt in domains all, oncoursecl, sakai-all, and sakaiht.
Last modified on January 21, 2014.

I need help with a computing problem

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

I have a comment for the Knowledge Base

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.