A quick explanation of the different columns expected in the courses.csv tab.
| Column Field Header | Required | Format | Description |
|---|---|---|---|
| sourcedId | Yes | GUID | Unique ID for the course |
| status | Yes for Delta | Enumeration | See section 4.13.8 (OneRoster, 20a) for the enumeration list. This must NOT be used for Bulk mode. |
| dateLastModified | Yes for Delta | DateTime | The date that this record was last modified. This must NOT be used for Bulk mode. |
| schoolYearSourcedId | No | GUID Reference | SourcedId of an AcademicSession with type of "schoolYear" |
| title | Yes | String | Name of the course |
| courseCode | No | String | Human readable course code |
| grades | No | List of Strings | Grade(s) for which the class is attended. The permitted vocabulary is from CEDS (Version 5) for the Entry Grade Level Element https://ceds.ed.gov/elements.aspx |
| orgSourcedId | Yes | GUID Reference | SourcedId of an org to which this course belongs |
| subjects | No | List of Strings | Subject name(s) in human readable form. If the 'subjectCodes' attribute is present, then the subjects and subjectCodes list must have the same length and have order significance. The vocabulary is from SCED (School Codes for the Exchange of Data) (Version 4) for the "Course Title" field: https://nces.ed.gov/scedfinder. If the value of the "Course Title" contains commas, then those commas must be removed. For example, the "Course Title" for "SCED Course Code" "03210" is "Science, Technology, and Society", this must be represented as "Science Technology and Society". |
| subjectCodes | No | String | Subject code(s) in machine readable form. If the 'subjects' attribute is present, then the subjects and subjectCodes lists must have the same length and have order significance. For deployments in the USA, this vocabulary should be a School Courses for the Exchange of Data (SCED) code: https://nces.ed.gov/scedfinder |