Google Classroom Mapping notes
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 |
| LMSSection.LMSSectionStatus |
| courses.courseWork.CourseWorkType |
| Assignment.AssignmentCategory |
| courses.courseWork.studentSubmissions.SubmissionState |
| AssignmentSubmission.SubmissionStatus |
| invitations.CourseRole |
| 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 |