Google Classroom Mapping notes
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 |
Mappings to ODS Tables
| 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 |