How Do I Export Grades? (Instructors)

Follow

This article contains information for instructors exporting course-level gradebooks.

Note: If you are part of an Enterprise school, your System Admin may be exporting grades from Schoology at the system level or grades may be automatically syncing to your SIS. Reach out to your school's Support Contact(s) for questions about best practices surrounding final grades at your school or organization.

Gradebook Export Formats

Course instructors can export their gradebooks in two formats:

Gradebook as CSV:

Select this option to download a CSV file version of your gradebook. This spreadsheet is formatted similarly to how it is in Schoology, with the student names vertically and material titles along the top. This export will include Overall, Period, and Sub-Period calculations. It will not include graded items marked as Midterm/Final, but those grades will be calculated into the Overall and Period grades.

CSV for import into other system:

Select this option to download a CSV file with more detailed student data. This spreadsheet is separated by columns for mapping purposes to use to import into another system, such as an SIS gradebook. This export includes graded items marked as Midterm/Final, but will not include Overall, Period, and Sub-period calculations.

Note: Exports for courses which use a Letter Grade scale show the percentage calculation only.

To export your course gradebook:

  1. In your course, click Gradebook in the left menu.
  2. Click the menu icon (three vertical dots) in the upper-right corner.
    J3EPqVgp1w.gif
  3. Select Export in the menu.

Grade Calculation Differences

There are several important differences in how grades are calculated between the two formats.

  Gradebook as CSV CSV for import into
other system
Hidden or Unpublished Materials Not included in Overall or Grading Period grade calculations. Included in Overall or Grading Period grade calculations.
Factors Items with a factor are multiplied by that factor and then included in the final score. Items with a factor are not multiplied by that factor before being included in the final score.
Weighted Categories Impact grade calculations. Do not impact grade calculations.

Be sure to consider these variables when deciding the format in which to export your gradebook.

Midterm/Final Weights 

Exports will contain different information depending on whether Midterm/Final materials are weighted against sub-periods or against all periods.

  Gradebook as CSV CSV for import into
other system
Weighted against sub-periods
  • Midterm/Final(s) are factored into the Overall and Period grades
  • Midterm/Final(s) are included as individual item(s)
Weighted against all periods
  • Midterm/Final(s) are factored into the Overall grade
  • Midterm/Final(s) are included as individual item(s)
Note: Unsubmitted midterm/finals will not factor into Overall and/or Period grades as 0.

Encoding Settings

If you are using Schoology in a double-byte language, such as Japanese, Chinese, or Korean, you may have to change the encoding of the CSV file to correctly display the characters. The steps to do this may vary based on the version of Excel you are using. See the Microsoft Office Support center for further assistance.

Back to top

 


Comments

0 comments

Article is closed for comments.

Powered by Zendesk