1.0.58
UDP Marts
Cumulative Fields and New Coalescing in Student Activity Score
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.
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.
Last updated