1.0.44

UDP Marts

Long Inactivity Mart and Student Activity Score at Course Offering and Course Section Levels

Version	1.0.44
Release Date	Februrary 20, 2024

Key Features

A new data mart called Long Inactivity is deployed to all production tenants. This data mart surfaces currently enrolled students in courses with a most recent timestamp of activity 5 days or more in the past. This mart also captures currently enrolled students who have no activity in the LMS course at all.

The Student Activity Score datamart now computes a score at course offering and course section levels. The original student activity score table remains, calculating the score at a term level. A brief description of the tables is as follows:

• Final - this table existed previously and computed the student activity score across all course enrollments

• course_final - this table is new and computes the score per course_offering a student is enrolled. The z-scoring is based only on the other students enrolled in the course_offering.

• course_section_final - this table is new and computes the score per course_section in which a student is enrolled. The z-scoring is based only on the other students enrolled in the course_section. This table is the lowest granularity for which the score is calculated.

• student_course_metrics - this table existed previously and surfaces all the individual score components per student, per course upon which the student activity score is calculated. This table fuels both final and course_final.

• student_course_section_metrics - this table is new and surfaces all the individual score components per student, per course section upon which the student activity score is calculated. This table fuels course_section_final.

The documentation for the Student Activity Score now has nested pages to reflect the multiple tables that now exist for the score.