The following is a breakdown of possible metrics and visualizations to include in the LMS Starter Kit initial release.
Assumptions
Below is a breakdown of expected data that will be available for the Power BI dashboard visualizations. Some data will be sourced from a Student Information System and others from the LMS Toolkit Extractors. Core Ed-Fi data is under the edfi schema and LMS Starter Kit data is under the edfilms schema.
| Schema | Table | Field | Notes |
|---|---|---|---|
| edfi | Section | SectionIdentifier | Could also pull SectionName, LocalCourseCode, or CourseTitle via CourseOffering → Course reference. |
| edfi | CourseOffering | LocalCourseCode | Via Section → CourseOffering |
| edfi | Course | CourseTitle | Via Section → CourseOffering → Course |
| edfi | EducationOrganization | NameOfInstitution | For School via Section → School reference. |
| edfi | Section | SessionName | |
| edfi | Section | SchoolYear | |
| edfi | Student | StudentUniqueId | |
| edfi | Student | FirstName | |
| edfi | Student | LastSurname | |
| edfi | StudentSchoolAssociation | EntryGradeLevel | Pull CodeValue or ShortDescription via the EntryGradeLevelDescriptor → Descriptor reference. |
| edfi | StudentEducationOrganizationAssociation | Sex | Pull CodeValue or ShortDescription via the SexDescriptor → Descriptor reference. |
| edfi | StudentEducationOrganizationAssociation | HispanicLatinoEthnicity | |
| edfi | StudentEducationOrganizationAssociationRace | Race | Pull CodeValue or ShortDescription via the RaceDescriptor → Descriptor reference. |
| edfi | StudentEducationOrganizationAssociation | LimitedEnglishProficiency | Pull CodeValue or ShortDescription via the LimitedEnglishProficiencyDescriptor → Descriptor reference. |
| edfi | StudentSectionAssociation | StudentUSI | |
| edfilms | Assignment | SectionIdentifier | |
| edfilms | Assignment | AssignmentIdentifier | |
| edfilms | Assignment | StartDateTime | |
| edfilms | Assignment | DueDateTime | |
| edfilms | AssignmentSubmissionType | SubmissionType | Pull CodeValue or ShortDescription via the SubmissionTypeDescriptor → Descriptor reference. |
| edfilms | AssignmentSubmission | AssignmentIdentifier | |
| edfilms | AssignmentSubmission | StudentUSI | |
| edfilms | AssignmentSubmission | SubmissionDateTime | |
| edfilms | AssignmentSubmission | SubmissionStatus | Pull CodeValue or ShortDescription via the SubmissionStatusDescriptor → Descriptor reference. |
| edfilms | AssignmentSubmission | Grade | For average calculations, this will need to be cast as a decimal. |
Proposed Dashboard Content
For the LMS Starter Kit, the downstream dashboard should include some general information with drill down capabilities and targeted visualizations and tables around the student-centric metrics that can be derived from the underlying data.
Aggregation Hierarchy
Given all levels of data are present, the data may be aggregated up to each of the levels described in the diagram below.
Sample Dashboards
The following two dashboard mock ups represent possible visualizations for Assignment and Grade metrics at an Education Organization level and at an individual Student level. Notes have been added in green for the various visualizations to provide more details.
Education Organization and Section Dashboard View
Student and Section Dashboard View
