This article contains information for instructors exporting course-level gradebooks.
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:
- In your course, click Gradebook in the left menu.
- Click the menu icon (three vertical dots) in the upper-right corner.
- 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 |
|
---|---|---|
Overall / Grading Period Grade |
Overall or Grading Period grade calculations are included in the report. |
Overall or Grading Period grade calculations are not included in the report. |
Hidden or Unpublished Materials | Not included in the report but do impact grade calculations. | Not included in the report. |
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 | Do 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 |
|
|
Weighted against all periods |
|
|
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.
Comments
0 comments
Article is closed for comments.