courses.csv

ManageBac Subject Groups and Subjects are represented in courses.csv.

Column Order and Optionality

The columns of the classes.csv file must be in the following order:

	Column Name	Required?	Can be blank?	Explanation
1	sourcedId	yes	no	Required by OneRoster
2	status	yes	must be blank for bulk, must be populated for delta	Follows OneRoster convention
3	dateModified	yes	must be blank for bulk, must be populated for delta	Follows OneRoster convention
4	schoolyearSourcedId	yes	yes	MB does not use this field
4	title	yes	no	Required by OneRoster
5	courseCode	yes	yes	MB does not use this field
6	grades	yes	yes	MB does not use this field
7	orgSourcedId	yes	no	Required by OneRoster
8	subjects	yes	yes	Optional
9	subjectCodes	yes	yes	Optional
10	metadata.managebac.levels	yes	yes	Optional
11	metadata.managebac.selfTaught	yes	yes	Optional
12	matadata.managebac.languageLevels	yes	yes	Optional
13	matadata.managebac.phases	yes	yes	Optional
14	matadata.managebac.snsBasedOn	yes	yes	Only required by MB for IB PYP Subjects

Relational Columns

ManageBac Subject Groups are associated to a Program, and the following describes the relationship:

Column Name	Description	On Import
sourcedId	Uniquely identifies the record	Used referentially
orgSourcedId	The associated Program or curriculum	Cannot be created or changed

Import Validations

• orgSourcedId resolves to a type -> ext:program row in orgs.csv

Export Behavior

• All rows will include orgSourcedId value

Core Columns

Each row in courses.csv represents an individual Subject Group, and child Subjects are represented through lists across multiple columns. Details about Subjects are given listed via the subjects and subjectCodes, and applicable metadata.managebac.* columns.

Column Name	Description
title	The name of the Subject Group represented in this row
subjects	List of subjects names that are grouped under this Subject Group
subjectCodes	Optional list of subject codes, grouped under this Subject Group. May be empty.
metadata.managebac.levels	Some subject groups require a level value per subject
metadata.managebac.languageLevels	Some subject groups require a language level per subject
metadata.managebac.phases	Some subject groups require a phase per subject
metadata.managebac.selfTaught	Some subject groups have a self-taught option
metadata.managebac.snsBasedOn	Some subjects require Scope & Seq per subject

Import Validations

• The subjects column has different validations for Programs, since some programs allow for the creation of custom subjects (such as Middle School) and others do not (such as IB Diploma):

Program	Allows creation of new subject	Import Validation
IB DP	no	Each listed subject must match IB DP Subject title
Primary School	yes	Listed subjects that do not match are created
Middle School	yes	Listed subjects that do not match are created
High School	yes	Listed subjects that do not match are created

• If subjectCodes is not blank, its contents must match subjects as a parallel array; the order and length are signficant.

• The core metadata.* columns, if present, must also be a parallel array that matches subjects, where the order and length are signficant

• The core metadata.* columns have existence requirements and value validations depending on the Program the given row is associated to. A row's Program is defined via the orgSourcedId column, where the following table indicates when it is required, and what are the legal case-sensitive values:

Column	Row associated to Program	Required	Values
Levels
metadata.managebac.levels	IB DP	Yes	"HL" | "SL"
metadata.managebac.levels	IB CP	Yes	"HL" | "SL"
metadata.managebac.levels	High School	Yes	"HL" | "SL"
metadata.managebac.levels	Middle School	Yes	"HL" | "SL"
metadata.managebac.levels	Primary School	Yes	"HL" | "SL"
metadata.managebac.levels	Pearson EdExcel Int'l GCSE	Yes	"Higher" | "Foundation"
metadata.managebac.levels	Pearson Edexcel Advanced	Yes	"A" | "AS"
metadata.managebac.levels	Cambridge IGCSE	Yes	"Extended" | "Core"
Language Levels
metadata.managebac.languageLevels	IB DP	Yes	"Literature" | "Language and literature" | "ab initio" | "B"
Phases
metadata.managebac.phases	IB MYP	Yes	"1" | "2" | "3" | "4" | "5" | "6"
Scope & Sequence
metadata.managebac.snsBasedOn	IB PYP	Yes	"phases" | "years"
Self-Taught
metadata.managebac.selfTaught	IB DP	Yes	"self-taught"

Column and Program combinations not delineated above are not required and can be left blank.

Import Behaviors

• In Bulk Import mode, all enabled subjects not listed in subjects for the associated Program, will be disabled

Export Behaviors

• All enabled Subject Groups are exported

Non-core Columns

Column Name	Description	On Import
schoolYearSourcedId	Subject Groups are not linked to Academic Years	Ignored
courseCode	Subject Groups do not have human-readable code	Ignored
grades	Grade is specified in classes.csv	Ignored

The following columns values depend on the import or export mode:

Column Name	Bulk	Delta
status	Must be present but emtpy	Must be present and either "active" or "tobedleted"
dateLastModified	Must be present but empty	Must be present and a date

Example File

sourcedId	status	dateLastModified	schoolYearSourcedId	title	courseCode	grades	orgSourcedId	subjects	subjectCodes	metadata.managebac.levels	metadata.managebac.selfTaught	metadata.managebac.languageLevels	metadata.managebac.phases	metadata.managebac.snsBasedOn
e1cb...18e5				Language and literature			6a9d...2d8f_myp	English
b65f...9e9f				Studies in language and literature			6a9d...2d8f_diploma	English		"HL,SL"	self_taught	"Literature,Language and literature"
9804...166b				Language acquisition			6a9d...2d8f_diploma	English		"HL,SL"		"ab initio,B"
7825...74c3				Language acquisition			6a9d...2d8f_myp	English					"1,2,3,4,5,6"
63f6...3098				Individuals and societies			6a9d...2d8f_diploma	Business & Management,Economics,Environmental Systems & Societies,Geography,History,Philosophy,Psychology,Social and Cultural Anthropology,World Studies		"HL,SL","HL,SL","HL,SL","HL,SL","HL,SL","HL,SL","HL,SL","HL,SL","HL,SL"
af0a...bb9e				Individuals and societies			6a9d...2d8f_myp	Business Management,Civics,Economics,Geography,Government,History,Individuals and Societies,Integrated Humanities,Philosophy,Political Science,Psychology,Sociology/Anthropology,World Religions
06aa...88f7				Sciences			6a9d...2d8f_myp	Biology,Chemistry,Earth Science,Environmental Science,Health Science,Life Science,Physical Science,Physics,Sciences,Sport Science
9afd...981e				Sciences			6a9d...2d8f_diploma	Biology,Chemistry,Computer Science,Design Technology,Environmental Systems & Societies,Food Science and Technology,Physics		"HL,SL","HL,SL","HL,SL","HL,SL","HL,SL","HL,SL","HL,SL"
0a0a...6197				Mathematics			6a9d...2d8f_myp	Extended Mathematics,Mathematics,Standard Mathematics
e1cf...aaf4				Arts			6a9d...2d8f_myp	Arts,Dance,Expressive Arts,Film,Media Arts,Music,Performing Arts,Theatre,Visual Arts
6311...3507				Arts			6a9d...2d8f_diploma	Dance,Film,Music,Other Elective,Theatre,Visual Arts		"HL,SL","HL,SL","HL,SL","HL,SL","HL,SL","HL,SL"
ab87...9eed				Physical and Health Education			6a9d...2d8f_myp	Physical and Health Education
73ca...301c				Core			6a9d...2d8f_diploma	Theory of Knowledge
7525...1d5b				Design			6a9d...2d8f_myp	Design,Digital Design,Product Design