Contents

Resource Mapping

Google Classroom Resource	Data Model Entity	Business Logic Notes
courses.courseWork	Assignment	-
courses.courseWork.studentSubmissions	AssignmentSubmission	-
-	LMSGrade	This information is not being extracted at this moment, the generated files will be empty.
courses	LMSSection	-
courses.aliases	LMSSection	Aliases map to LMSSection.SISSectionIdentifiers. Only one is used, with preference to aliases prefixed with "EdFiLMS.". Aliases with that prefix should map to a section identifier in the Ed-Fi ODS/API.
students, teachers	LMSUser	The students and teachers are separated in two resources.
-	LMSSystemActivity	This information is not being extracted at this moment, the generated files will be empty.
courses.courseWork.studentSubmissions	LMSSectionActivity	-
-	LMSUserLMSSectionAssociation	This information is mapped from students, teachers and courses information.

Google Classroom Enumerations

The following enumerations and value sets for Google Classroom are based on the Google Classroom API documentation.

Enumeration	System Values	Equivalent LMS UDM Attribute
courses.CourseState	COURSE_STATE_UNSPECIFIED ACTIVE ARCHIVED PROVISIONED DECLINED SUSPENDED	LMSSection.LMSSectionStatus
courses.courseWork.CourseWorkType	COURSE_WORK_TYPE_UNSPECIFIED ASSIGNMENT SHORT_ANSWER_QUESTION MULTIPLE_CHOICE_QUESTION	Assignment.AssignmentCategory
courses.courseWork.studentSubmissions.SubmissionState	SUBMISSION_STATE_UNSPECIFIED NEW CREATED TURNED_IN RETURNED RECLAIMED_BY_STUDENT	AssignmentSubmission.SubmissionStatus
invitations.CourseRole	COURSE_ROLE_UNSPECIFIED STUDENT TEACHER OWNER	User.UserRole

Object	Google Classroom API elements	ODS Column
User	User.profile.emailAddress	edfi.StudentEducationOrganizationAssociationElectronicMail.ElectronicMailAddress

Section	CourseAlias.alias beginning with "EdFiLMS."	edfi.Section.SectionIdentifier

Assignment	CourseWork.id + CourseWork.courseId	lmsx.Assignment.AssignmentIdentifier
	"Google"	lmsx.Assignment.LMSSourceSystemDescriptorId
	CourseWork.title	lmsx.Assignment.Title
	CourseWork.workType	lmsx.Assignment.AssignmentCategoryDescriptorId
	CourseWork.description	lmsx.Assignment.AssignmentDescription
	CourseWork.scheduledTime	lmsx.Assignment.StartDateTime
	None	lmsx.Assignment.EndDateTime
	CourseWork.dueDate + CourseWork.dueTime	lmsx.Assignment.DueDateTime
	CourseWork.maxPoints	lmsx.Assignment.MaxPoints

Submission	StudentSubmission.id + StudentSubmission.courseId + StudentSubmission.courseWorkId	lmsx.AssignmentSubmission.AssignmentSubmissionIdentifier
	StudentSubmission.state	lmsx.AssignmentSubmission.SubmissionStatusDescriptorId
	StudentSubmission.state + StudentSubmission.updateTime	lmsx.AssignmentSubmission.SubmissionDateTime
	StudentSubmission.assignedGrade	lmsx.AssignmentSubmission.EarnedPoints
	StudentSubmission.assignedGrade	lmsx.AssignmentSubmission.Grade