Level 2 Course Weekly Distribution Summary
The mart_taskforce.level2_course_weekly_distribution_summary mart aggregates data about a course's performance and activities each week and describes the activity distribution. The schema for this mart largely mirrors that of mart_taskforce.level1_aggregated and mart_taskforce.level2_aggregated; however, this mart gives averages and standard deviations for each field. Questions about "what the average student" is doing in a course can be answered with this mart.
BQ Prod Dataset Locations
mart_taskforce
Interactive Mart Dependency Diagram
Schema
mart/taskforce/level2_course_weekly_distribution_summary
Field Structure and Subcategories
This level 2 table has many fields, so we’ve grouped them together in the following subcategories:
Assignments
Submissions
Assignments
Missing Assignments
Late Submissions
Submission Time Buffer
Published Scores
Discussions
Discussion Threads
Discussion Entries
Learning Environment Activity
View days
Sessions
Tool Launches
File Views
Dependencies
The only dependency for this mart is the mart_taskforce.level1_aggregated. All calculations and fields are based on that mart, and there are no direct dependencies to the UDP itself. As long as the mart_taskforce.level1_aggregated is successfully created, this mart can also be created.
Assignment Weight Groupings
Many fields have names that include tiny, small, medium, large, and major. These classifications are based on the group_weight field in the ‘learner_activity_group’ entity. The cases are as follows:
If the group_weight is null or equal to 0%, the submission is ‘unweighted’.
If the group_weight is less than or equal to 2%, the submission is ‘tiny’.
If the group_weight is greater than 2% and less than or equal to 5%, the submission is ‘small’.
If the group_weight is greater than 5% and less than or equal to 10%, the submission is ‘medium’.
If the group_weight is greater than 10% and less than or equal to 25%, the submission is ‘large’.
If the group_weight is greater than 25%, the submission is ‘major’.
If the group_weight is not null and greater than 0%, the submission is 'weighted'.
These assignment weight groupings are consistent with the groupings for the Level 1 mart.
Average and Standard Deviation Fields
The majority of the schema for mart_taskforce.level2_aggregated are averages and standard deviations based on the distribution of corresponding fields per-course, per-week in mart_taskforce.level1_aggregated. The corresponding table mart_taskforce.level2_aggregated applies these averages and standard deviations (per-course, per-week) for each student and produces z-scores accordingly.
Assignments
Submissions
Fields
avg_num_tiny_submissions
sd_num_tiny_submissions
total_tiny_submissions
num_students_tiny_submissions
avg_num_small_submissions
sd_num_small_submissions
total_small_submissions
num_students_small_submissions
avg_num_medium_submissions
sd_num_medium_submissions
total_medium_submissions
num_students_medium_submissions
avg_num_large_submissions
sd_num_large_submissions
total_large_submissions
num_students_large_submissions
avg_num_major_submissions
sd_num_major_submissions
total_major_submissions
num_students_major_submissions
avg_num_unweighted_submissions
sd_num_unweighted_submissions
total_unweighted_submissions
num_students_unweighted_submissions
avg_num_weighted_submissions
sd_num_weighted_submissions
total_weighted_submissions
num_students_weighted_submissions
avg_num_submissions_without_due_date
sd_num_submissions_without_due_date
total_submissions_without_due_date
num_students_submissions_without_due_date
avg_num_submissions_with_due_date
sd_num_submissions_with_due_date
total_submissions_with_due_date
num_students_submissions_with_due_date
avg_num_submissions
sd_num_submissions
total_submissions
num_students_submissions
Description
These fields describe the distributions for the number of submissions in a course for each week in the term with 4 metrics. The 4 metrics are:
Average
Standard Deviation
Total counts
Total counts of distinct student IDs
Number of Assignments
Fields
avg_num_tiny_assignments
sd_num_tiny_assignments
avg_num_small_assignments
sd_num_small_assignments
avg_num_medium_assignments
sd_num_medium_assignments
avg_num_large_assignments
sd_num_large_assignments
avg_num_major_assignments
sd_num_major_assignments
avg_num_unweighted_assignments
sd_num_unweighted_assignments
avg_num_weighted_assignments
sd_num_weighted_assignments
avg_num_assignments_without_due_date
sd_num_assignments_without_due_date
avg_num_assignments_with_due_date
sd_num_assignments_with_due_date
avg_num_assignments
sd_num_assignments
Number of Missing Submissions
Fields
avg_num_tiny_missing_submissions
sd_num_tiny_missing_submissions
avg_num_small_missing_submissions
sd_num_small_missing_submissions
avg_num_medium_missing_submissions
sd_num_medium_missing_submissions
avg_num_large_missing_submissions
sd_num_large_missing_submissions
avg_num_major_missing_submissions
sd_num_major_missing_submissions
avg_num_unweighted_missing_submissions
sd_num_unweighted_missing_submissions
avg_num_weighted_missing_submissions
sd_num_weighted_missing_submissions
avg_num_missing_submissions
sd_num_missing_submissions
Description
Number of Late Submissions
Fields
avg_num_tiny_late_submissions
sd_num_tiny_late_submissions
avg_num_small_late_submissions
sd_num_small_late_submissions
avg_num_medium_late_submissions
sd_num_medium_late_submissions
avg_num_large_late_submissions
sd_num_large_late_submissions
avg_num_major_late_submissions
sd_num_major_late_submissions
avg_num_unweighted_late_submissions
sd_num_unweighted_late_submissions
avg_num_weighted_late_submissions
sd_num_weighted_late_submissions
avg_num_late_submissions
sd_num_late_submissions
Description
Average Time Buffer in Hours
Fields
avg_avg_time_buffer_hrs_tiny
sd_avg_time_buffer_hrs_tiny
avg_avg_time_buffer_hrs_small
sd_avg_time_buffer_hrs_small
avg_avg_time_buffer_hrs_medium
sd_avg_time_buffer_hrs_medium
avg_avg_time_buffer_hrs_large
sd_avg_time_buffer_hrs_large
avg_avg_time_buffer_hrs_major
sd_avg_time_buffer_hrs_major
avg_avg_time_buffer_hrs_unweighted
sd_avg_time_buffer_hrs_unweighted
avg_avg_time_buffer_hrs_weighted
sd_avg_time_buffer_hrs_weighted
avg_avg_time_buffer_hrs
sd_avg_time_buffer_hrs
Description
Average Published Score Percentage
Fields
avg_avg_published_score_pct_tiny
sd_avg_published_score_pct_tiny
avg_avg_published_score_pct_small
sd_avg_published_score_pct_small
avg_avg_published_score_pct_medium
sd_avg_published_score_pct_medium
avg_avg_published_score_pct_large
sd_avg_published_score_pct_large
avg_avg_published_score_pct_major
sd_avg_published_score_pct_major
avg_avg_score_pct_unweighted
sd_avg_score_pct_unweighted
avg_avg_published_score_pct_weighted
sd_avg_published_score_pct_weighted
avg_avg_published_score_pct_without_due_date
sd_avg_published_score_pct_without_due_date
avg_avg_published_score_pct_with_due_date
sd_avg_published_score_pct_with_due_date
Description
Discussions
Discussion Entry Counts
Fields
avg_discussion_entry_count
sd_discussion_entry_count
avg_discussion_post_count
sd_discussion_post_count
avg_discussion_reply_count
sd_discussion_reply_count
Description
Discussion Counts
Fields
avg_discussion_count
sd_discussion_count
avg_assignment_discussion_count
sd_assignment_discussion_count
avg_threaded_discussion_count
sd_threaded_discussion_count
avg_side_comment_discussion_count
sd_side_comment_discussion_count
Description
Total Discussion Counts
Fields
avg_total_discussion_count
sd_total_discussion_count
avg_total_discussion_count
sd_total_discussion_count
avg_total_threaded_discussion_count
sd_total_threaded_discussion_count
avg_side_comment_discussion_count
sd_side_comment_discussion_count
Description
Average Discussion Entry Length
Fields
avg_avg_discussion_entry_length
sd_avg_discussion_entry_length
avg_avg_discussion_post_length
sd_avg_discussion_post_length
avg_avg_discussion_reply_length
sd_avg_discussion_reply_length
Description
Learning Environment Activity
View Days
Fields
avg_view_days
sd_view_days
Description
Sessions with 10, 20, and 30 Minute Cutoffs
Fields
avg_num_sessions_10min
sd_num_sessions_10min
avg_total_time_seconds_10min
sd_total_time_seconds_10min
avg_total_actions_10min
sd_total_actions_10min
avg_avg_time_seconds_10min
sd_avg_time_seconds_10min
avg_avg_actions_10min
sd_avg_actions_10min
avg_num_sessions_20min
sd_num_sessions_20min
avg_total_time_seconds_20min
sd_total_time_seconds_20min
avg_total_actions_20min
sd_total_actions_20min
avg_avg_time_seconds_20min
sd_avg_time_seconds_20min
avg_avg_actions_20min
sd_avg_actions_20min
avg_num_sessions_30min
sd_num_sessions_30min
avg_total_time_seconds_30min
sd_total_time_seconds_30min
avg_total_actions_30min
sd_total_actions_30min
avg_avg_time_seconds_30min
sd_avg_time_seconds_30min
avg_avg_actions_30min
sd_avg_actions_30min
Description
Tool Launches
Fields
avg_num_tool_launches
sd_num_tool_launches
avg_num_tools_launched
sd_num_tools_launched
launch_app_names
total_tool_launches
Description
The launch_app_name and total_tool_launches are unique to this table. Launch_app_name is of type ARRAY<STRING>, and total_tool_launches is of type ARRAY<INTEGER>. The launch_app_names and total_tool_launches values correspond and represent the total launches for each tool by all students in the course for the week. The values in this array aid in inferring the course_tools_not_launched field in the mart_taskforce.level2_aggregated table.
File Views
Fields
avg_file_views
sd_file_views
avg_num_files_viewed
sd_num_files_viewed
file_ids
total_file_views
Description
The file_ids and total_file_views are unique to this table. File_ids is of type ARRAY<INTEGER>, and total_file_views is of type ARRAY<INTEGER>. The file_ids and total_file_views values correspond and represent the total accesses for each file by all students in the course for the week. The values in this array aid in inferring the course_files_not_viewed field in the mart_taskforce.level2_aggregated table.
Last updated