Audience: School and District Admins with School and District subscriptions
Administrators can export Gradebook reports for their district or school in a OneRoster aligned format.
OneRoster is a standard that helps schools share student information between different systems. It makes sure things like student names, classes, enrollments, and grades can move smoothly from one system to another.
With OneRoster, your school’s Student Information System (SIS) can connect with your Learning Management System (LMS) and other learning tools. This allows grades and assignments to be shared across systems.
How to download Gradebook reports
-
District Admins: District Dashboard > District Admin Tools > select Export Gradebook Report.
School Admins: School Dashboard > Admin Tools > School Data > Export Gradebook Roster Report. - Select the dates for the export and tap the Export button.
Please note that there is a maximum of 4 months date range that can be entered.
💡 We recommend exporting grades every marking period. - You will receive an email with the Gradebook report.
Understanding CSV fields
Below is a data crosswalk of a Seesaw CSV to OneRoster 1.2 Standards
| OneRoster Field | Corresponding Activity Export Field | Seesaw Name | Required | Format | Description |
| sourcedId | ItemId GUID | Sourced ID | Yes | GUID | Unique ID for the result. |
| dateLastModified | Student Post Last Modified | Date Last Modified | Yes for Delta | DateTime |
The date that this record was last modified. [ISO8601] format and resolution of YYYY-MM-DDTHH:MM:SS.sssZ MUST be used. This MUST NOT be used for the Bulk mode. |
| lineItemSourcedId | PromptId GUID | Line Item Sourced ID | Yes | GUID Reference | Unique identifier of the lineItem. |
| studentSourcedId | Student ID | Student ID | Yes | GUID Reference | Unique identifier of the student (user). References a record that is/was created in the users.csv file with type of 'student'. |
| scoreStatus |
Complete + overall score: scoreStatus = fully graded Complete + no overall score: scoreStatus = submitted Not Complete: scoreStatus = not submitted |
Score Status | Yes | Enumeration |
Permitted values are: { exempt | fully graded | not submitted | partially graded | submitted } This vocabulary may be extended. |
| score | Overall Score | Overall Score | No | Float | A floating point number (the range should be consistent with that defined in the associated lineItem resultValueMin and resultValueMax fields). |
| scoreDate | Student Post Created Date | Student Post Create Date | Yes | Date | The date the result was submitted and/or the 'scoreStatus' was changed. |
Understanding Student ID fields
| Seesaw | Clever | Classlink | Wonde |
| Student ID | SIS_ID | Sourced ID | MIS_ID |
| N/A | Clever ID | Sourced ID | Wonde ID |
- Seesaw Student ID is created by Admin when creating accounts via CSV roster import.
- Student ID is added or replaced in Seesaw by corresponding ID from 3rd party roster source when roster sync begins.
- Clever ID is created by Clever.
- Wonde ID is created by Wonde.
- Classlik Sourced ID is created by District.