OneRoster: courses.csv

Each row in the courses.csv file represents a course, for example, “General Music.”  You can view an example of the courses.csv file in CSV form form or the courses.csv file in spreadsheet form. 

Note:  Quaver does not use any information from the courses.csv file.  We prefer that you submit this file with only the field header titles and no other values.  You may upload a complete data set if you wish, but the values you supply will have no bearing on the user’s experience within the Quaver program.

File HeaderQuaver Requires?Format (max chars)Description/Guidance
sourcedIdnostring (75)This value should assign a unique ID to each course. Course sourcedIds can be used in the classes.csv file to assign classes to the courses listed here. This value must be unique for every row in this file.
statusnostring (0)Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,
dateLastModifiednodate (0)Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,
schoolYearIdnostring (75)The sourcedId of the academic session (school year) in which this course runs. This value must reference a sourcedId in the academicSessions.csv file.
metadata.durationnostring (75)Description of how long the course runs (for example, two weeks, one semester).
titlenostring (100)Name of the course.
courseCodenostring (75)Human readable course code.
gradenostring (50)Grade level of the course (for example,. 9 or range 9-12).
orgSourcedIdnostring (75)sourcedId of the org to which this course belongs. This may be a school or district level organization. This must reference a sourcedId in the orgs.csv file.
subjectsnostring (75)Subject name, relating to course content. If more than one subject is appropriate, use double quotes and separate with commas. For example: “choir, band”.