1.0.58

UDP Marts

Cumulative Fields and New Coalescing in Student Activity Score

Version	1.0.58
Release Date	June 14, 2024

Key Features

DSS has added a handful of new fields and metrics in the Student Activity Score marts. These are all additive changes, and no existing queries will break. No existing fields have been renamed.

The purpose for the new fields are to support both in-week score calculations and cumulative score calculations. Currently, the metrics for submissions and assignments_due for a row in the marts are just for the week in scope. We now introduce submssions_cumulative and assignments_due_cumulative to the metrics tables so that activity scores can be calculated from a start-of-term to now perspective.

Mart Table	New Field Name	Datatype	Description
Student Course Metrics	assignments_due_cumulative	INTEGER	The number of assignments due in the course from the first day of the term to the current week, inclusive.
Student Course Metrics	submissions_cumulative	INTEGER	The number of assignments submitted by the student from the first day of the term to the current week, inclusive.
Student Course Section Metrics	assignments_due_cumulative	INTEGER	The number of assignments due in the course from the first day of the term to the current week, inclusive.
Student Course Section Metrics	submissions_cumulative	INTEGER	The number of assignments submitted by the student from the first day of the term to the current week, inclusive.
Course Final	student_activity_score_cumulative	FLOAT	The student activity score for the student in the course for the given week using cumulative assignment and submission metrics.
Course Final	student_activity_score_z_cumulative	FLOAT	The z-score of the student activity score for the student in the course for the given week using cumulative assignment and submission metrics.
Course Final	student_activity_score_octile_cumlative	FLOAT	The octile of the student's average student activity z-score in comparison to the average student activity score for the course using cumulative assignment and submission metrics.
Course Section Final	student_activity_score_cumulative	FLOAT	The student activity score for the student in the course for the given week using cumulative assignment and submission metrics.
Course Section Final	student_activity_score_z_cumulative	FLOAT	The z-score of the student activity score for the student in the course for the given week using cumulative assignment and submission metrics.
Course Section Final	student_activity_score_octile_cumlative	FLOAT	The octile of the student's average student activity z-score in comparison to the average student activity score for the course using cumulative assignment and submission metrics.
Final	avg_student_activity_score_cumulative	FLOAT	The average student activity z-score for the given week in the academic term using cumulative assignment and submission metrics.
Final	student_activity_score_octile_cumulative	FLOAT	The octile of the student's average student activity z-score in comparison to the average student activity score for a cohort of students based on their academic program. Based on cumulative assignment and submission metrics

New Coalescing

We altered some logic in the student activity score tables that limited score calculations only for weeks with non-zero numbers of assignments due. We had this limitation in place to avoid division by 0 since assignments_due is in the denominator for part of the score. However, we now use SAFE_DIVIDE and coalesce to 0 for metrics with missing data.

This allows for score calculations for all weeks in a term. This should make a more consistent timeline of how scores change throughout a term for students.