# Level 2 Course Weekly Distribution Summary

* [Interactive Mart Dependency Diagram](#taskforcemartlevel2courseweeklydistributionsummary-interactivemartdependencydiagram)
* [Schema](#taskforcemartlevel2courseweeklydistributionsummary-schema)
* [Field Structure and Subcategories](#taskforcemartlevel2courseweeklydistributionsummary-fieldstructureandsubcategories)
  * [Dependencies](#taskforcemartlevel2courseweeklydistributionsummary-dependencies)
  * [Assignment Weight Groupings](#taskforcemartlevel2courseweeklydistributionsummary-assignmentweightgroupings)
  * [Average and Standard Deviation Fields](#taskforcemartlevel2courseweeklydistributionsummary-averageandstandarddeviationfields)
* [Assignments](#taskforcemartlevel2courseweeklydistributionsummary-assignments)
  * [Submissions](#taskforcemartlevel2courseweeklydistributionsummary-submissions)
  * [Number of Assignments](#taskforcemartlevel2courseweeklydistributionsummary-numberofassignments)
  * [Number of Missing Submissions](#taskforcemartlevel2courseweeklydistributionsummary-numberofmissingsubmissions)
  * [Number of Late Submissions](#taskforcemartlevel2courseweeklydistributionsummary-numberoflatesubmissions)
  * [Average Time Buffer in Hours](#taskforcemartlevel2courseweeklydistributionsummary-averagetimebufferinhours)
  * [Average Published Score Percentage](#taskforcemartlevel2courseweeklydistributionsummary-averagepublishedscorepercentage)
* [Discussions](#taskforcemartlevel2courseweeklydistributionsummary-discussions)
  * [Discussion Entry Counts](#taskforcemartlevel2courseweeklydistributionsummary-discussionentrycounts)
  * [Discussion Counts](#taskforcemartlevel2courseweeklydistributionsummary-discussioncounts)
  * [Total Discussion Counts](#taskforcemartlevel2courseweeklydistributionsummary-totaldiscussioncounts)
  * [Average Discussion Entry Length](#taskforcemartlevel2courseweeklydistributionsummary-averagediscussionentrylength)
* [Learning Environment Activity](#taskforcemartlevel2courseweeklydistributionsummary-learningenvironmentactivity)
  * [View Days](#taskforcemartlevel2courseweeklydistributionsummary-viewdays)
  * [Sessions with 10, 20, and 30 Minute Cutoffs](#taskforcemartlevel2courseweeklydistributionsummary-sessionswith10-20-and30minutecutoffs)
  * [Tool Launches](#taskforcemartlevel2courseweeklydistributionsummary-toollaunches)
  * [File Views](#taskforcemartlevel2courseweeklydistributionsummary-fileviews)

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 <a href="#taskforcemartlevel2courseweeklydistributionsummary-interactivemartdependencydiagram" id="taskforcemartlevel2courseweeklydistributionsummary-interactivemartdependencydiagram"></a>

The following visualization shows the construction of this data mart defined in the [UDP marts](https://gitlab.com/unizin-community/unizin-data-platform/marts) repository. More information on the repository and diagram can be found on [this marts page.](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts)

{% hint style="info" %}
[Click here to open the interactive chart.](https://assets.public.unizin.org/udp-marts/mart/mart__taskforce__level2_course_weekly_distribution_summary.svg)
{% endhint %}

<div data-full-width="true"><figure><img src="https://3709019308-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKYwtHNGgdPXS3PWAlZUr%2Fuploads%2Fgit-blob-714ae5e5b3631a2bad884ee5a2718bf13fc6cfc3%2Flevel2_course_weekly_distribution_summary.png?alt=media&#x26;token=75dc4619-1968-4753-8a9e-9dbf0fe48e3d" alt=""><figcaption><p>mart_taskforce.level2_course_weekly_distribution_summary</p></figcaption></figure></div>

## Schema <a href="#taskforcemartlevel2courseweeklydistributionsummary-schema" id="taskforcemartlevel2courseweeklydistributionsummary-schema"></a>

### **mart/taskforce/level2\_course\_weekly\_distribution\_summary**

<table data-full-width="true"><thead><tr><th width="415.33333333333337">Field Name</th><th width="176">Type</th><th>Description</th></tr></thead><tbody><tr><td>udp_course_offering_id</td><td>INTEGER</td><td>The UDP ID of the course offering.</td></tr><tr><td>week_in_term</td><td>INTEGER</td><td>The week of the academic term.</td></tr><tr><td>week_start_date</td><td>DATE</td><td>The start date of the week of the academic term.</td></tr><tr><td>week_end_date</td><td>DATE</td><td>The end date of the week of the academic term.</td></tr><tr><td>avg_num_tiny_submissions</td><td>FLOAT</td><td>Average number of submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>sd_num_tiny_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>total_tiny_submissions</td><td>INTEGER</td><td>The total number of submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>num_students_tiny_submissions</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>avg_num_small_submissions</td><td>FLOAT</td><td>Average number of submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>sd_num_small_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>total_small_submissions</td><td>INTEGER</td><td>The total number of submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>num_students_small_submissions</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>avg_num_medium_submissions</td><td>FLOAT</td><td>Average number of submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>sd_num_medium_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions classified as 'medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>total_medium_submissions</td><td>INTEGER</td><td>The total number of submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>num_students_medium_submissions</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions classified as ‘medium', or making up a small percentage of the student’s final grade.</td></tr><tr><td>avg_num_large_submissions</td><td>FLOAT</td><td>Average number of submissions classified as 'large', or making up a large percentage of the student’s final grade.</td></tr><tr><td>sd_num_large_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions classified as 'large', or making up a large percentage of the student’s final grade.</td></tr><tr><td>total_large_submissions</td><td>INTEGER</td><td>The total number of submissions classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>num_students_large_submissions</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions classified as 'large', or making up a large percentage of the student’s final grade.</td></tr><tr><td>avg_num_major_submissions</td><td>FLOAT</td><td>Average number of submissions classified as 'major', or making up a major percentage of the student’s final grade.</td></tr><tr><td>sd_num_major_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions classified as 'major', or making up a major percentage of the student’s final grade.</td></tr><tr><td>total_major_submissions</td><td>INTEGER</td><td>The total number of submissions classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>num_students_major_submissions</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions classified as 'major', or making up a major percentage of the student’s final grade.</td></tr><tr><td>avg_num_unweighted_submissions</td><td>FLOAT</td><td>Average number of submissions without a defined weight.</td></tr><tr><td>sd_num_unweighted_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions without a defined weight.</td></tr><tr><td>total_unweighted_submissions</td><td>INTEGER</td><td>The total number of submissions without a defined weight.</td></tr><tr><td>num_students_unweighted_submissions</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions without a defined weight.</td></tr><tr><td>avg_num_weighted_submissions</td><td>FLOAT</td><td>Average number of weighted submissions.</td></tr><tr><td>sd_num_weighted_submissions</td><td>FLOAT</td><td>Standard deviation for the number of weighted submissions.</td></tr><tr><td>total_weighted_submissions</td><td>INTEGER</td><td>The total number of weighted submissions.</td></tr><tr><td>num_students_weighted_submissions</td><td>INTEGER</td><td>Number of distinct person_id values for the number of weighted submissions.</td></tr><tr><td>avg_num_submissions_without_due_date</td><td>FLOAT</td><td>Average number of submissions without a due date.</td></tr><tr><td>sd_num_submissions_without_due_date</td><td>FLOAT</td><td>Standard deviation for the number of submissions without a due date.</td></tr><tr><td>total_submissions_without_due_date</td><td>INTEGER</td><td>The total number of submissions without a due date.</td></tr><tr><td>num_students_submissions_without_due_date</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions without a due date.</td></tr><tr><td>avg_num_submissions_with_due_date</td><td>FLOAT</td><td>Average number of submissions with a due date.</td></tr><tr><td>sd_num_submissions_with_due_date</td><td>FLOAT</td><td>Standard deviation for the number of submissions with a due date.</td></tr><tr><td>total_submissions_with_due_date</td><td>INTEGER</td><td>The total number of submissions with a due date.</td></tr><tr><td>num_students_submissions_with_due_date</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions with a due date.</td></tr><tr><td>avg_num_submissions</td><td>FLOAT</td><td>Average number of submissions.</td></tr><tr><td>sd_num_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions.</td></tr><tr><td>total_submissions</td><td>INTEGER</td><td>The total number of submissions.</td></tr><tr><td>num_students_submissions</td><td>INTEGER</td><td>Number of distinct person_id values for the number of submissions.</td></tr><tr><td>avg_num_tiny_assignments</td><td>FLOAT</td><td>Average number of assignments classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>sd_num_tiny_assignments</td><td>FLOAT</td><td>Standard deviation for the number of assignments classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>avg_num_small_assignments</td><td>FLOAT</td><td>Average number of assignments classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>sd_num_small_assignments</td><td>FLOAT</td><td>Standard deviation for the number of assignments classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>avg_num_medium_assignments</td><td>FLOAT</td><td>Average number of assignments classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>sd_num_medium_assignments</td><td>FLOAT</td><td>Standard deviation for the number of assignments classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>avg_num_large_assignments</td><td>FLOAT</td><td>Average number of assignments classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>sd_num_large_assignments</td><td>FLOAT</td><td>Standard deviation for the number of assignments classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>avg_num_major_assignments</td><td>FLOAT</td><td>Average number of assignments classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>sd_num_major_assignments</td><td>FLOAT</td><td>Standard deviation for the number of assignments classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>avg_num_unweighted_assignments</td><td>FLOAT</td><td>Average number of assignments without a weight.</td></tr><tr><td>sd_num_unweighted_assignments</td><td>FLOAT</td><td>Standard deviation for the number of assignments without a weight.</td></tr><tr><td>avg_num_weighted_assignments</td><td>FLOAT</td><td>Average number of assignments with a weight.</td></tr><tr><td>sd_num_weighted_assignments</td><td>FLOAT</td><td>Standard deviation for the number of assignments with weights.</td></tr><tr><td>avg_num_assignments_without_due_date</td><td>FLOAT</td><td>Average number of assignments without a due date.</td></tr><tr><td>sd_num_assignments_without_due_date</td><td>FLOAT</td><td>Standard deviation for the number of assignments without a due date.</td></tr><tr><td>avg_num_assignments_with_due_date</td><td>FLOAT</td><td>Average number of assignments with a due date.</td></tr><tr><td>sd_num_assignments_with_due_date</td><td>FLOAT</td><td>Standard deviation for the number of assignments with a due date.</td></tr><tr><td>avg_num_assignments</td><td>FLOAT</td><td>Average number of assignments.</td></tr><tr><td>sd_num_assignments</td><td>FLOAT</td><td>Standard deviation for the number of assignments.</td></tr><tr><td>avg_num_tiny_missing_submissions</td><td>FLOAT</td><td>Average number of 'tiny' submissions identified as missing.</td></tr><tr><td>sd_num_tiny_missing_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'tiny' submissions identified as missing.</td></tr><tr><td>avg_num_small_missing_submissions</td><td>FLOAT</td><td>Average number of 'small' submissions identified as missing.</td></tr><tr><td>sd_num_small_missing_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'small' submissions identified as missing.</td></tr><tr><td>avg_num_medium_missing_submissions</td><td>FLOAT</td><td>Average number of 'medium' submissions identified as missing.</td></tr><tr><td>sd_num_medium_missing_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'medium' submissions identified as missing.</td></tr><tr><td>avg_num_large_missing_submissions</td><td>FLOAT</td><td>Average number of 'large' submissions identified as missing.</td></tr><tr><td>sd_num_large_missing_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'large' submissions identified as missing.</td></tr><tr><td>avg_num_major_missing_submissions</td><td>FLOAT</td><td>Average number of 'major' submissions identified as missing.</td></tr><tr><td>sd_num_major_missing_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'major' submissions identified as missing.</td></tr><tr><td>avg_num_unweighted_missing_submissions</td><td>FLOAT</td><td>Average number of unweighted submissions identified as missing.</td></tr><tr><td>sd_num_unweighted_missing_submissions</td><td>FLOAT</td><td>Standard deviation for the number of unweighted submissions identified as missing.</td></tr><tr><td>avg_num_weighted_missing_submissions</td><td>FLOAT</td><td>Average number of weighted submissions identified as missing.</td></tr><tr><td>sd_num_weighted_missing_submissions</td><td>FLOAT</td><td>Standard deviation for the number of weighted submissions identified as missing.</td></tr><tr><td>avg_num_missing_submissions</td><td>FLOAT</td><td>Average number of submissions identified as missing.</td></tr><tr><td>sd_num_missing_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions identified as missing.</td></tr><tr><td>avg_num_tiny_late_submissions</td><td>FLOAT</td><td>Average number of 'tiny' submissions identified as late.</td></tr><tr><td>sd_num_tiny_late_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'tiny' submissions identified as late.</td></tr><tr><td>avg_num_small_late_submissions</td><td>FLOAT</td><td>Average number of 'small' submissions identified as late.</td></tr><tr><td>sd_num_small_late_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'small' submissions identified as late.</td></tr><tr><td>avg_num_medium_late_submissions</td><td>FLOAT</td><td>Average number of 'medium' submissions identified as late.</td></tr><tr><td>sd_num_medium_late_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'medium' submissions identified as late.</td></tr><tr><td>avg_num_large_late_submissions</td><td>FLOAT</td><td>Average number of 'large' submissions identified as late.</td></tr><tr><td>sd_num_large_late_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'large' submissions identified as late.</td></tr><tr><td>avg_num_major_late_submissions</td><td>FLOAT</td><td>Average number of 'major' submissions identified as late.</td></tr><tr><td>sd_num_major_late_submissions</td><td>FLOAT</td><td>Standard deviation for the number of 'major' submissions identified as late.</td></tr><tr><td>avg_num_unweighted_late_submissions</td><td>FLOAT</td><td>Average number of unweighted submissions identified as late.</td></tr><tr><td>sd_num_unweighted_late_submissions</td><td>FLOAT</td><td>Standard deviation for the number of unweighted submissions identified as late.</td></tr><tr><td>avg_num_weighted_late_submissions</td><td>FLOAT</td><td>Average number of weighted submissions identified as late.</td></tr><tr><td>sd_num_weighted_late_submissions</td><td>FLOAT</td><td>Standard deviation for the number of weighted submissions identified as late.</td></tr><tr><td>avg_num_late_submissions</td><td>FLOAT</td><td>Average number of submissions identified as late.</td></tr><tr><td>sd_num_late_submissions</td><td>FLOAT</td><td>Standard deviation for the number of submissions identified as late.</td></tr><tr><td>avg_avg_time_buffer_hrs_tiny</td><td>FLOAT</td><td>Average for the average time buffer in hours for submissions classified as 'tiny'.</td></tr><tr><td>sd_avg_time_buffer_hrs_tiny</td><td>FLOAT</td><td>Standard deviation for the average time buffer in hours for submissions classified as 'tiny'.</td></tr><tr><td>avg_avg_time_buffer_hrs_small</td><td>FLOAT</td><td>Average for the average time buffer in hours for submissions classified as 'small'.</td></tr><tr><td>sd_avg_time_buffer_hrs_small</td><td>FLOAT</td><td>Standard deviation for the average time buffer in hours for submissions classified as 'small'.</td></tr><tr><td>avg_avg_time_buffer_hrs_medium</td><td>FLOAT</td><td>Average for the average time buffer in hours for submissions classified as 'medium'.</td></tr><tr><td>sd_avg_time_buffer_hrs_medium</td><td>FLOAT</td><td>Standard deviation for the average time buffer in hours for submissions classified as 'medium'.</td></tr><tr><td>avg_avg_time_buffer_hrs_large</td><td>FLOAT</td><td>Average for the average time buffer in hours for submissions classified as 'large'.</td></tr><tr><td>sd_avg_time_buffer_hrs_large</td><td>FLOAT</td><td>Standard deviation for the average time buffer in hours for submissions classified as 'large'.</td></tr><tr><td>avg_avg_time_buffer_hrs_major</td><td>FLOAT</td><td>Average for the average time buffer in hours for submissions classified as 'major'.</td></tr><tr><td>sd_avg_time_buffer_hrs_major</td><td>FLOAT</td><td>Standard deviation for the average time buffer in hours for submissions classified as 'major'.</td></tr><tr><td>avg_avg_time_buffer_hrs_unweighted</td><td>FLOAT</td><td>Average for the average time buffer in hours for unweighted submissions.</td></tr><tr><td>sd_avg_time_buffer_hrs_unweighted</td><td>FLOAT</td><td>Standard deviation for the average time buffer in hours for unweighted submissions.</td></tr><tr><td>avg_avg_time_buffer_hrs_weighted</td><td>FLOAT</td><td>Average for the average time buffer in hours for weighted submissions.</td></tr><tr><td>sd_avg_time_buffer_hrs_weighted</td><td>FLOAT</td><td>Standard deviation for the average time buffer in hours for weighted submissions.</td></tr><tr><td>avg_avg_time_buffer_hrs</td><td>FLOAT</td><td>Average for the average time buffer in hours for all submissions.</td></tr><tr><td>sd_avg_time_buffer_hrs</td><td>FLOAT</td><td>Standard deviation for the average time buffer in hours for all submissions.</td></tr><tr><td>avg_avg_published_score_pct_tiny</td><td>FLOAT</td><td>Average for the average published score on assignments for submissions classified as 'tiny'.</td></tr><tr><td>sd_avg_published_score_pct_tiny</td><td>FLOAT</td><td>Standard deviation for the average published score on assignments for submissions classified as 'tiny'.</td></tr><tr><td>avg_avg_published_score_pct_small</td><td>FLOAT</td><td>Average for the average published score on assignments for submissions classified as 'small'.</td></tr><tr><td>sd_avg_published_score_pct_small</td><td>FLOAT</td><td>Standard deviation for the average published score on assignments for submissions classified as 'small'.</td></tr><tr><td>avg_avg_published_score_pct_medium</td><td>FLOAT</td><td>Average for the average published score on assignments for submissions classified as 'medium'.</td></tr><tr><td>sd_avg_published_score_pct_medium</td><td>FLOAT</td><td>Standard deviation for the average published score on assignments for submissions classified as 'medium'.</td></tr><tr><td>avg_avg_published_score_pct_large</td><td>FLOAT</td><td>Average for the average published score on assignments for submissions classified as 'large'.</td></tr><tr><td>sd_avg_published_score_pct_large</td><td>FLOAT</td><td>Standard deviation for the average published score on assignments for submissions classified as 'large'.</td></tr><tr><td>avg_avg_published_score_pct_major</td><td>FLOAT</td><td>Average for the average published score on assignments for submissions classified as 'major'.</td></tr><tr><td>sd_avg_published_score_pct_major</td><td>FLOAT</td><td>Standard deviation for the average published score on assignments for submissions classified as 'major'.</td></tr><tr><td>avg_avg_score_pct_unweighted</td><td>FLOAT</td><td>Average for the average score on unweighted assignments.</td></tr><tr><td>sd_avg_score_pct_unweighted</td><td>FLOAT</td><td>Standard deviation for the average score on unweighted assignments.</td></tr><tr><td>avg_avg_published_score_pct_weighted</td><td>FLOAT</td><td>Average for the average score on weighted assignments.</td></tr><tr><td>sd_avg_published_score_pct_weighted</td><td>FLOAT</td><td>Standard deviation for the average score on weighted assignments.</td></tr><tr><td>avg_avg_published_score_pct_without_due_date</td><td>FLOAT</td><td>Average for the average published score on assignments for submissions without a due date.</td></tr><tr><td>sd_avg_published_score_pct_without_due_date</td><td>FLOAT</td><td>Standard deviation for the average published score on assignments for submissions without a due date.</td></tr><tr><td>avg_avg_published_score_pct_with_due_date</td><td>FLOAT</td><td>Average for the average published score on assignments for submissions with a due date.</td></tr><tr><td>sd_avg_published_score_pct_with_due_date</td><td>FLOAT</td><td>Standard deviation for the average published score on assignments for submissions with a due date.</td></tr><tr><td>avg_avg_published_score</td><td>FLOAT</td><td>Average for the average published score on assignments for all submissions.</td></tr><tr><td>sd_avg_published_score</td><td>FLOAT</td><td>Standard deviation for the average published score on assignments for all submissions.</td></tr><tr><td>avg_avg_published_score_pct_tiny_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for submissions classified as 'tiny' .</td></tr><tr><td>sd_avg_published_score_pct_tiny_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions classified as 'tiny'.</td></tr><tr><td>avg_avg_published_score_pct_small_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for submissions classified as 'small' </td></tr><tr><td>sd_avg_published_score_pct_small_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions classified as 'small'.</td></tr><tr><td>avg_avg_published_score_pct_medium_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for submissions classified as 'medium' </td></tr><tr><td>sd_avg_published_score_pct_medicum_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions classified as 'medium'.</td></tr><tr><td>avg_avg_published_score_pct_large_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for submissions classified as 'large'</td></tr><tr><td>sd_avg_published_score_pct_large_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions classified as 'large'.</td></tr><tr><td>avg_avg_published_score_pct_major_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for submissions classified as 'major'.</td></tr><tr><td>sd_avg_published_score_pct_major_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions classified as 'major'.</td></tr><tr><td>avg_avg_published_score_pct_unweighted_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for unweighted submissions</td></tr><tr><td>sd_avg_published_score_pct_unweighted_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions without a weight.</td></tr><tr><td>avg_avg_published_score_pct_weighted_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for submissions with a non-zero weight f</td></tr><tr><td>sd_avg_published_score_pct_weighted_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions with a non-zero weight.</td></tr><tr><td>avg_avg_published_score_pct_without_due_date_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for submissions without a due date</td></tr><tr><td>sd_avg_published_score_pct_without_due_date_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions without a due date.</td></tr><tr><td>avg_avg_published_score_pct_with_due_date_cumulative</td><td>FLOAT</td><td>Cumulative average for the average published score on assignments for submissions with a due date</td></tr><tr><td>sd_avg_published_score_pct_with_due_date_cumulative</td><td>FLOAT</td><td>Standard deviation for the cumulative average published score on assignments for submissions with a due date.</td></tr><tr><td>avg_avg_published_score_cumulative</td><td>FLOAT</td><td>Cumulative average of the avg_published_score field from the Level 1 Aggregated table.</td></tr><tr><td>sd_avg_published_score_cumulative</td><td>FLOAT</td><td>Standard deviation of the avg_published_score field from the Level 1 Aggregated table.</td></tr><tr><td>avg_discussion_entry_count</td><td>FLOAT</td><td>Average for the number of discussion entries posted by a student.</td></tr><tr><td>sd_discussion_entry_count</td><td>FLOAT</td><td>Standard deviation for the number of discussion entries posted by a student.</td></tr><tr><td>avg_discussion_post_count</td><td>FLOAT</td><td>Average for the number of discussion posts posted by a student.</td></tr><tr><td>sd_discussion_post_count</td><td>FLOAT</td><td>Standard deviation for the number of discussion post posted by a student.</td></tr><tr><td>avg_discussion_reply_count</td><td>FLOAT</td><td>Average for the number of discussion replies posted by a student.</td></tr><tr><td>sd_discussion_reply_count</td><td>FLOAT</td><td>Standard deviation for the number of discussion replies posted by a student.</td></tr><tr><td>avg_discussion_count</td><td>FLOAT</td><td>Average for the number of discussions interacted with by students.</td></tr><tr><td>sd_discussion_count</td><td>FLOAT</td><td>Standard deviation for the number of discussions interacted with by students.</td></tr><tr><td>avg_assignment_discussion_count</td><td>FLOAT</td><td>Average for the number of discussions associated with an assignment interacted with by students.</td></tr><tr><td>sd_assignment_discussion_count</td><td>FLOAT</td><td>Standard deviation for the number of discussions associated with an assignment interacted with by students.</td></tr><tr><td>avg_threaded_discussion_count</td><td>FLOAT</td><td>Average for the number of threaded discussions interacted with by students.</td></tr><tr><td>sd_threaded_discussion_count</td><td>FLOAT</td><td>Standard deviation for the number of threaded discussions interacted with by students.</td></tr><tr><td>avg_side_comment_discussion_count</td><td>FLOAT</td><td>Average for the number of side comment discussions interacted with by students.</td></tr><tr><td>sd_side_comment_discussion_count</td><td>FLOAT</td><td>Standard deviation for the number of side comment discussions interacted with by students.</td></tr><tr><td>total_discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of discussions available in the course offering.</td></tr><tr><td>avg_total_discussion_count</td><td>FLOAT</td><td>Average for the total number of discussions available in the course offering.</td></tr><tr><td>sd_total_discussion_count</td><td>FLOAT</td><td>Standard deviation for the total number of discussions available in the course offering.</td></tr><tr><td>avg_total_discussion_count</td><td>FLOAT</td><td>Average for the total number of discussions associated with assignments available in the course offering.</td></tr><tr><td>sd_total_discussion_count</td><td>FLOAT</td><td>Standard deviation for the total number of discussions associated with assignments available in the course offering.</td></tr><tr><td>avg_total_threaded_discussion_count</td><td>FLOAT</td><td>Average for the total number of threaded discussions available in the course offering.</td></tr><tr><td>sd_total_threaded_discussion_count</td><td>FLOAT</td><td>Standard deviation for the total number of threaded discussions available in the course offering.</td></tr><tr><td>avg_side_comment_discussion_count</td><td>FLOAT</td><td>Average for the total number of side comment discussions available in the course offering.</td></tr><tr><td>sd_side_comment_discussion_count</td><td>FLOAT</td><td>Standard deviation for the total number of side comment discussions available in the course offering.</td></tr><tr><td>avg_avg_discussion_entry_length</td><td>FLOAT</td><td>Average for the average length of a student's discussion entries.</td></tr><tr><td>sd_avg_discussion_entry_length</td><td>FLOAT</td><td>Standard deviation for the average length of a student's discussion entries.</td></tr><tr><td>avg_avg_discussion_post_length</td><td>FLOAT</td><td>Average for the average length of a student's discussion posts.</td></tr><tr><td>sd_avg_discussion_post_length</td><td>FLOAT</td><td>Standard deviation for the average length of a student's discussion posts.</td></tr><tr><td>avg_avg_discussion_reply_length</td><td>FLOAT</td><td>Average for the average length of a student's discussion replies.</td></tr><tr><td>sd_avg_discussion_reply_length</td><td>FLOAT</td><td>Standard deviation for the average length of a student's discussion replies.</td></tr><tr><td>avg_view_days</td><td>FLOAT</td><td>Average for the number of view days in the LMS.</td></tr><tr><td>sd_view_days</td><td>FLOAT</td><td>Standard deviation for the number of view days in the LMS.</td></tr><tr><td>avg_num_sessions_10min</td><td>FLOAT</td><td>Average for the number of sessions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>sd_num_sessions_10min</td><td>FLOAT</td><td>Standard deviation for the number of sessions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>avg_total_time_seconds_10min</td><td>FLOAT</td><td>Average for the total time spent in the LMS in seconds, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>sd_total_time_seconds_10min</td><td>FLOAT</td><td>Standard deviation for the total time spent in the LMS in seconds, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>avg_total_actions_10min</td><td>FLOAT</td><td>Average for the total number of actions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>sd_total_actions_10min</td><td>FLOAT</td><td>Standard deviation for the total number of actions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>avg_avg_time_seconds_10min</td><td>FLOAT</td><td>Average for the average amount of time spent in the LMS in seconds, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>sd_avg_time_seconds_10min</td><td>FLOAT</td><td>Standard deviation for the average amount of time spent in the LMS in seconds, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>avg_avg_actions_10min</td><td>FLOAT</td><td>Average for the average number of actions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>sd_avg_actions_10min</td><td>FLOAT</td><td>Standard deviation for the average number of actions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>avg_num_sessions_20min</td><td>FLOAT</td><td>Average for the number of sessions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>sd_num_sessions_20min</td><td>FLOAT</td><td>Standard deviation for the number of sessions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>avg_total_time_seconds_20min</td><td>FLOAT</td><td>Average for the total time spent in the LMS in seconds, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>sd_total_time_seconds_20min</td><td>FLOAT</td><td>Standard deviation for the total time spent in the LMS in seconds, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>avg_total_actions_20min</td><td>FLOAT</td><td>Average for the total number of actions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>sd_total_actions_20min</td><td>FLOAT</td><td>Standard deviation for the total number of actions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>avg_avg_time_seconds_20min</td><td>FLOAT</td><td>Average for the average amount of time spent in the LMS in seconds, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>sd_avg_time_seconds_20min</td><td>FLOAT</td><td>Standard deviation for the average amount of time spent in the LMS in seconds, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>avg_avg_actions_20min</td><td>FLOAT</td><td>Average for the average number of actions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>sd_avg_actions_20min</td><td>FLOAT</td><td>Standard deviation for the average number of actions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>avg_num_sessions_30min</td><td>FLOAT</td><td>Average for the number of sessions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>sd_num_sessions_30min</td><td>FLOAT</td><td>Standard deviation for the number of sessions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>avg_total_time_seconds_30min</td><td>FLOAT</td><td>Average for the total time spent in the LMS in seconds, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>sd_total_time_seconds_30min</td><td>FLOAT</td><td>Standard deviation for the total time spent in the LMS in seconds, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>avg_total_actions_30min</td><td>FLOAT</td><td>Average for the total number of actions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>sd_total_actions_30min</td><td>FLOAT</td><td>Standard deviation for the total number of actions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>avg_avg_time_seconds_30min</td><td>FLOAT</td><td>Average for the average amount of time spent in the LMS in seconds, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>sd_avg_time_seconds_30min</td><td>FLOAT</td><td>Standard deviation for the average amount of time spent in the LMS in seconds, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>avg_avg_actions_30min</td><td>FLOAT</td><td>Average for the average number of actions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>sd_avg_actions_30min</td><td>FLOAT</td><td>Standard deviation for the average number of actions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>avg_num_tool_launches</td><td>FLOAT</td><td>Average for the total number of LTI tool launches.</td></tr><tr><td>sd_num_tool_launches</td><td>FLOAT</td><td>Standard deviation for the total number of LTI tool launches.</td></tr><tr><td>avg_num_tools_launched</td><td>FLOAT</td><td>Average for the total number of LTI tools launched.</td></tr><tr><td>sd_num_tools_launched</td><td>FLOAT</td><td>Standard deviation for the total number of LTI tools launched.</td></tr><tr><td>avg_file_views</td><td>FLOAT</td><td>Average for the number of file views.</td></tr><tr><td>sd_file_views</td><td>FLOAT</td><td>Standard deviation for the number of file views.</td></tr><tr><td>avg_num_files_viewed</td><td>FLOAT</td><td>Average for the number of files viewed.</td></tr><tr><td>sd_num_files_viewed</td><td>FLOAT</td><td>Standard deviation for the number of files viewed.</td></tr><tr><td>file_ids</td><td>ARRAY&#x3C;INTEGER></td><td>Array of file IDs that have been interacted with in the course offering.</td></tr><tr><td>total_file_views</td><td>ARRAY&#x3C;INTEGER></td><td>Array of the number of views for each file in the course offering; aligns with the IDs in file_ids.</td></tr><tr><td>launch_app_names</td><td>ARRAY&#x3C;STRING></td><td>Array of tool names for which activity exists in the course offering.</td></tr><tr><td>total_tool_launches</td><td>ARRAY&#x3C;INTEGER></td><td>Array of the number of launches for each tool in the course offering; aligns with the strings in launch_app_names.</td></tr></tbody></table>

## Field Structure and Subcategories <a href="#taskforcemartlevel2courseweeklydistributionsummary-fieldstructureandsubcategories" id="taskforcemartlevel2courseweeklydistributionsummary-fieldstructureandsubcategories"></a>

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 <a href="#taskforcemartlevel2courseweeklydistributionsummary-dependencies" id="taskforcemartlevel2courseweeklydistributionsummary-dependencies"></a>

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 <a href="#taskforcemartlevel2courseweeklydistributionsummary-assignmentweightgroupings" id="taskforcemartlevel2courseweeklydistributionsummary-assignmentweightgroupings"></a>

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 <a href="#taskforcemartlevel2courseweeklydistributionsummary-averageandstandarddeviationfields" id="taskforcemartlevel2courseweeklydistributionsummary-averageandstandarddeviationfields"></a>

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 <a href="#taskforcemartlevel2courseweeklydistributionsummary-assignments" id="taskforcemartlevel2courseweeklydistributionsummary-assignments"></a>

#### Submissions <a href="#taskforcemartlevel2courseweeklydistributionsummary-submissions" id="taskforcemartlevel2courseweeklydistributionsummary-submissions"></a>

**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:

1. Average
2. Standard Deviation
3. Total counts
4. Total counts of distinct student IDs

More detailed descriptions of the original submission fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-numberofsubmissions)

#### Number of Assignments <a href="#taskforcemartlevel2courseweeklydistributionsummary-numberofassignments" id="taskforcemartlevel2courseweeklydistributionsummary-numberofassignments"></a>

**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

These fields describe the distributions for the number of assignments in a course for each week in the term. The more detailed descriptions of the original assignment fields can be found in the [documentation for *mart\_taskforce.level1\_aggregated.*](#taskforcemartlevel2courseweeklydistributionsummary-numberofassignments)

#### Number of Missing Submissions <a href="#taskforcemartlevel2courseweeklydistributionsummary-numberofmissingsubmissions" id="taskforcemartlevel2courseweeklydistributionsummary-numberofmissingsubmissions"></a>

**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**

These fields describe the distributions for the number of missing submissions in a course for each week in the term. The definitions of the original missing submissions fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](#taskforcemartlevel2courseweeklydistributionsummary-numberofmissingsubmissions)

#### Number of Late Submissions <a href="#taskforcemartlevel2courseweeklydistributionsummary-numberoflatesubmissions" id="taskforcemartlevel2courseweeklydistributionsummary-numberoflatesubmissions"></a>

**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

These fields describe the distributions for the number of late submissions by a student in a course for each week in the term. The definitions of the original late submissions fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](#taskforcemartlevel2courseweeklydistributionsummary-numberoflatesubmissions)

#### Average Time Buffer in Hours <a href="#taskforcemartlevel2courseweeklydistributionsummary-averagetimebufferinhours" id="taskforcemartlevel2courseweeklydistributionsummary-averagetimebufferinhours"></a>

**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**

These fields describe the distributions for the average time buffer in hours for submissions by a student in a course for each week in the term. The definitions of the original time buffer fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-averagetimebufferinhours)

#### Average Published Score Percentage <a href="#taskforcemartlevel2courseweeklydistributionsummary-averagepublishedscorepercentage" id="taskforcemartlevel2courseweeklydistributionsummary-averagepublishedscorepercentage"></a>

**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
* avg\_avg\_published\_score
* sd\_avg\_published\_score
* avg\_avg\_published\_score\_pct\_tiny\_cumulative
* sd\_avg\_published\_score\_pct\_tiny\_cumulative
* avg\_avg\_published\_score\_pct\_small\_cumulative
* sd\_avg\_published\_score\_pct\_small\_cumulative
* avg\_avg\_published\_score\_pct\_medium\_cumulative
* sd\_avg\_published\_score\_pct\_medium\_cumulative
* avg\_avg\_published\_score\_pct\_large\_cumulative
* sd\_avg\_published\_score\_pct\_large\_cumulative
* avg\_avg\_published\_score\_pct\_major\_cumulative
* sd\_avg\_published\_score\_pct\_major\_cumulative
* avg\_avg\_score\_pct\_unweighted\_cumulative
* sd\_avg\_score\_pct\_unweighted\_cumulative
* avg\_avg\_published\_score\_pct\_weighted\_cumulative
* sd\_avg\_published\_score\_pct\_weighted\_cumulative
* avg\_avg\_published\_score\_pct\_without\_due\_date\_cumulative
* sd\_avg\_published\_score\_pct\_without\_due\_date\_cumulative
* avg\_avg\_published\_score\_pct\_with\_due\_date\_cumulative
* sd\_avg\_published\_score\_pct\_with\_due\_date\_cumulative
* avg\_avg\_published\_score\_cumulative
* sd\_avg\_published\_score\_cumulative

Description

These fields describe the distributions for the average published score percentage of submissions by a student in a course for each week in the term. The description of the average published score fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-averagepublishedscorepercentage)

### Discussions <a href="#taskforcemartlevel2courseweeklydistributionsummary-discussions" id="taskforcemartlevel2courseweeklydistributionsummary-discussions"></a>

#### Discussion Entry Counts <a href="#taskforcemartlevel2courseweeklydistributionsummary-discussionentrycounts" id="taskforcemartlevel2courseweeklydistributionsummary-discussionentrycounts"></a>

**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

These fields describe the distributions for the number of discussion entries posted by a student in a course for each week in the term. The definitions of the original discussion entry count fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-discussionentrycounts)

#### Discussion Counts <a href="#taskforcemartlevel2courseweeklydistributionsummary-discussioncounts" id="taskforcemartlevel2courseweeklydistributionsummary-discussioncounts"></a>

**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

These fields describe the distributions for the number of discussions a student has interacted with in a course for each week in the term. The definitions of the original discussion count fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-discussioncounts)

#### Total Discussion Counts <a href="#taskforcemartlevel2courseweeklydistributionsummary-totaldiscussioncounts" id="taskforcemartlevel2courseweeklydistributionsummary-totaldiscussioncounts"></a>

**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

These fields describe the distributions for the total number of discussions in a course for a given week in the term. The definitions of the original total discussion count fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-totaldiscussioncounts)

#### Average Discussion Entry Length <a href="#taskforcemartlevel2courseweeklydistributionsummary-averagediscussionentrylength" id="taskforcemartlevel2courseweeklydistributionsummary-averagediscussionentrylength"></a>

**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**

These fields describe the distributions for the average length of the discussion entry messages for a student in a course for a given week in the term. More detailed descriptions of the average discussion entry lengths can be found in the [documentation for *mart\_taskforce.level1\_aggregated.*](#taskforcemartlevel2courseweeklydistributionsummary-averagediscussionentrylength)

### Learning Environment Activity <a href="#taskforcemartlevel2courseweeklydistributionsummary-learningenvironmentactivity" id="taskforcemartlevel2courseweeklydistributionsummary-learningenvironmentactivity"></a>

#### View Days <a href="#taskforcemartlevel2courseweeklydistributionsummary-viewdays" id="taskforcemartlevel2courseweeklydistributionsummary-viewdays"></a>

**Fields**

* avg\_view\_days
* sd\_view\_days

Description

These fields describe the distributions for the number of days a student viewed the learning environment for a course in a given week. The definition of the view days field exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-viewdays)

#### Sessions with 10, 20, and 30 Minute Cutoffs <a href="#taskforcemartlevel2courseweeklydistributionsummary-sessionswith10-20-and30minutecutoffs" id="taskforcemartlevel2courseweeklydistributionsummary-sessionswith10-20-and30minutecutoffs"></a>

**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

For this mart, we define sessions using three different time cutoffs: 10 minutes, 20 minutes, and 30 minutes. We define the time spent in a session by adding up the duration of events in the session. These fields describe the distributions for the number of sessions, total time spent, total number of actions, average time spent, and average number of actions for all three time cutoffs for a student in a course for a given week in the term. The definitions of the base session, time, and action fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-sessionswith10-20-and30minutecutoffs)

Please visit our [separate interaction session mart documentation page here](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/interaction-sessions) for a visual example and more information about interaction sessions too.

#### Tool Launches <a href="#taskforcemartlevel2courseweeklydistributionsummary-toollaunches" id="taskforcemartlevel2courseweeklydistributionsummary-toollaunches"></a>

**Fields**

* avg\_num\_tool\_launches
* sd\_num\_tool\_launches
* avg\_num\_tools\_launched
* sd\_num\_tools\_launched
* launch\_app\_names
* total\_tool\_launches

Description

These fields describe the distributions of the LTI tools launched by students in the learning environment of a course for each week in the term. More detailed definitions of LTI launches exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](#taskforcemartlevel2courseweeklydistributionsummary-toollaunches)

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 <a href="#taskforcemartlevel2courseweeklydistributionsummary-fileviews" id="taskforcemartlevel2courseweeklydistributionsummary-fileviews"></a>

**Fields**

* avg\_file\_views
* sd\_file\_views
* avg\_num\_files\_viewed
* sd\_num\_files\_viewed
* file\_ids
* total\_file\_views

Description

These fields describe the distribution of files accessed by students in the learning environment of a course for each week in the term. More detailed definitions of files and file views exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](#taskforcemartlevel2courseweeklydistributionsummary-fileviews)

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.