Unizin Product Documentation
ProductsSupport and TrainingPolicies
  • Unizin Product Documentation
  • Products
    • Content
      • Unizin Engage
        • eReader User Guide
          • Notes, Highlights, and Citations
          • Appearance Settings
          • Download for Offline
          • eReader Layout
          • Keyboard Shortcuts
          • Navigating Your eBook
          • Print
          • Text to Speech
          • Copy and Paste
          • Creating Flashcards
          • Collaboration and Note Sharing
          • Pearson Titles
        • Institution Support
          • Disabled Student Services / Alt-Format
            • Best Practices for Republishing Course Content
            • Disabled Student Services
            • Requesting eTextbook Files for Accessibility Purposes
            • WCAG 2.0 AA evaluation for Engage
            • WCAG 2.0 AA evaluation for EPUB for Engage
          • Institution's Support Responsibilities
        • Caliper 1.1 sensor
        • Release Notes
          • 2.28.22
          • 2019-09-17
          • 2019-05-29
          • 2.26.8
          • 2.26.0
          • 2.25.0
          • 2.22.0
          • 2.21.6
          • 2.21.5
          • 2.20.8
          • 2.20.5
          • 2.20.3
          • 2.19.1
          • 2.18.0
          • 2.17.0
          • 2.14.0
          • 2.12.0
          • 2.11.0
          • 2.9.0
          • 2.8.3
          • 2016-03-17
          • 2016-02-11
          • 2016-01-28
        • Using Analytics (New)
      • Unizin Order Tool
        • Overview of the User Interface
        • Key Concepts
          • Profiles
          • Ordering periods
          • Coordinator permissions
          • Program administrator permissions
        • Courses & Ordering
          • Course filtering
          • Place an order
          • Add sections to a placed order
          • Edit a placed order
          • Cancel an order
          • Reordering
        • Order History
          • Instructor Order History
          • Coordinator and Program Administrator Order History
          • Order Activity
        • Student Choice
          • Student Choice (Program Administrators)
          • Student Choice (Students)
        • Entitlements
          • Entitlements (Program Administrators)
          • Entitlements (Students)
        • Catalog Tool
        • Schedule of Classes
        • Content Request Tool
        • Order Tool Dashboard
        • Vendor Sandbox Tenant
        • Institution Support
        • Implementation
          • SIS Data Integration
            • 1.0 - SIS Integration
            • 2.0 - SIS Integration
          • SSO integration
          • UI customizations
          • Order Feed
            • 1.0 - Order Feed
            • 2.0 - Order Feed
            • 3.0 - Order Feed
          • Publisher report
          • Final declined offers feed
          • Institutional (SIS) Catalog Import
          • Student Price
          • Historical Entitlements Import
        • Release Notes
          • Order Tool Bug Fixes and Enhancements
          • Order Tool Bug Fixes
          • Order Tool Accessibility Improvements
          • Order Feed Improvements
          • Content Request Form Update and Minor Bug Fix
          • Flat Markup Fee Update
          • Ordering Email Receipt Update & Minor Bug Fix
          • Bug Fix for Public Catalog Feature
          • Catalog Search Enhancements
          • Reordering Reminder Email Notifications
          • UX Improvements & Minor Bug Fixes
          • Historical Entitlements Import
          • Student Prices
          • Reordering Feature
          • Email Enhancements
          • Ordering Enhancements
          • Bug Fix for the Institutional Catalog Import
          • Bug Fix for the Final Declined Offers Feed (FDOF)
          • Order Activity Feature and Other Enhancements
          • Bug Fixes for Order History and Report an Issue Features
          • Public catalog feature
          • Minor Bug Fixes for Ordering and Student Choice
          • Entitlements Production Release, Bug fixes, and Minor updates
          • Minor Updates and Bug Fixes for Ordering Workflows
          • Catalog Search Optimization
          • Student Choice
          • Archive Terms Feature and Integration Improvements
          • Introduces the Program Administrator role, Catalog Tool, and Schedule
          • User interface updates and improvements
          • Order feed improvements
          • Order history, UI enhancements
          • Email notification upgrades, UI improvements
          • Order feed changes
          • New features for Course coordinators and upgrades to the UI
          • Changes to the Term, Course, and Section models; introduces a Session
          • Bug fixes, import improvements, and validation improvements
          • Tracking Order History
          • Publisher Reporting
          • Fixes the order feed, automates SIS data importing, and automates the generation of order feed repor
    • Data & Analytics
      • Unizin Data Platform
        • Key concepts
          • Platform overview
          • Data categories
          • Data models
          • Loading schemas
          • Keymap
        • Unizin Common Data Model
          • Academic structures (ERD)
          • Learners (ERD)
          • Course structures (ERD)
          • Course resources (ERD)
          • Learner activities (ERD)
          • Quizzes (ERD)
          • Social (ERD)
          • Course outcomes (ERD)
        • System overview
          • Context data pipeline
            • Context data ingress
            • Batch-ingest application
            • Batch-ingest db server
            • Context store
          • Event data pipeline
            • UDP Caliper endpoint
            • Approval process for implementing Caliper compliant tools
            • UDP Event enricher
            • Event store
        • Data stores
          • Data lake
            • UDP Context store
            • UDP Event store
              • Accessing the Event store
              • Expanded table
                • Expanded table: Canvas edApp mapping
            • Synthetic Data [beta]
              • Viewing Synthetic Data datasets within the BigQuery UI
              • Query Synthetic Data via client libraries
          • Data marts
            • UDP Distributions
            • Interaction sessions
            • Learning Environment Organization
            • File Interaction
            • Last Activity
            • Long Inactivity
            • Course Status
            • Daily Course Grade Record
            • LTI Tool Use
            • LMS Tool Use
            • Tool Usage Metrics
            • Links
            • Taskforce
              • Level 1 Aggregated
              • Level 2 Aggregated
              • Level 2 Course Weekly Distribution Summary
              • Student Term Profile
              • Course Profile
            • Student Activity Score
              • Student Course Metrics
              • Student Course Section Metrics
              • Final
              • Course Final
              • Course Section Final
        • Data integrations
          • Context data integration
            • Loading schema
            • Keymap support
            • Manifest file
            • File requirements
            • Integration mechanics
          • Event data integration
          • SIS data integration
          • LMS data integration
            • Instructure Canvas
        • Release Notes
          • UDP Marts Release Notes
            • 1.0.83
            • 1.0.80
            • 1.0.79
            • 1.0.78
            • 1.0.77
            • 1.0.72
            • 1.0.67
            • 1.0.58
            • 1.0.51
            • 1.0.44
            • 1.0.42
            • 1.0.32
            • 1.0.31
            • 1.0.0
            • Level 2 Taskforce data marts now available
          • 2.0.167
          • 2.0.152
          • 2.0.138
          • 2.0.137
          • 2.0.113
          • 2.0.112
          • 2.0.111
          • 2.0.110
          • 2.0.99
          • 2.0.98
          • 2.0.83
          • 2.0.80
          • 2.0.71
          • 2.0.66
          • 2.0.59
          • 2.0.58
          • 2.0.53
          • 2.0.47
          • 2.0.25
        • Miscellaneous
          • Canvas Data additions, ~Fall 2021
          • Canvas Live Events: from SQS to HTTPS
          • Canvas New Analytics vs. UDP
          • Course Section Enrollment Role Status Mappings
          • Migrating from UDW to UDP
      • Unizin Data Warehouse
        • Implementation Guide
        • Scope of Services
        • Access Provisioning
        • Access Revocation
        • Connecting to the UDW
      • Raw Canvas Data 2
        • Flat Files
        • BigQuery Datasets
    • Hosted Services
      • My Learning Analytics
        • Install MyLA via LTI 1.3
        • Custom configure MyLA
  • Support and Training
    • Professional Development
      • Stepping Stones: A Faculty Development Curriculum for Learning Analytics Use
      • Structured Conversations initiative
    • UDP Self-paced Training
    • Resources Site Broken Links
    • Status Pages
  • Policies
    • General policies
      • Sponsor Teams
      • Browser Support Policy
      • Opt-Out & Invoicing Policy (Order Tool)
    • Support Policy
      • Unizin Engage - SP
      • Unizin Order Tool - SP
      • Unizin Data Platform - SP
      • Unizin Data Warehouse - SP
      • Unizin Data Analysis - SP
      • Pressbooks Hosting - SP
    • Privacy Policy
      • Unizin Engage - PP
      • Unizin Order Tool - PP
      • Unizin Data Platform - PP
      • RStudio service - PP
    • End User License Agreements
      • Unizin Engage - EULA
      • Unizin Order Tool - EULA
    • Terms of Use
      • Unizin Data Platform - ToU
    • Incident Reports
Powered by GitBook
LogoLogo

Unizin Homepage

  • unizin.org

Data & Analytics

  • Unizin Data Platform
  • Unizin Data Warehouse

Content

  • Unizin Engage
  • Unizin Order Tool

Hosted Services

  • My Learning Analytics

Copyright © 2023, Unizin, Ltd.

On this page
  • BQ Prod Dataset Locations
  • Interactive Mart Dependency Diagram
  • Schema
  • mart/taskforce/level2_aggregated
  • Field Structure and Subcategories
  • Assignments
  • Discussions
  • Learning Environment Activity
  1. Products
  2. Data & Analytics
  3. Unizin Data Platform
  4. Data stores
  5. Data marts
  6. Taskforce

Level 2 Aggregated

PreviousLevel 1 AggregatedNextLevel 2 Course Weekly Distribution Summary

Last updated 5 months ago

The mart_taskforce.level2_aggregated mart aggregates data about a student’s performance and activities in a course on a weekly basis relative to average course and peer behaviors. This table exists alongside mart_taskforce.level2_course_weekly_distribution_summary

BQ Prod Dataset Locations

  • mart_taskforce

Interactive Mart Dependency Diagram

Schema

mart/taskforce/level2_aggregated

Field Name

udp_person_id

INTEGER

The UDP ID of the student.

lms_person_id

STRING

The LMS ID of the student.

udp_course_offering_id

INTEGER

The UDP ID of the course offering.

lms_course_offering_id

STRING

The LMS ID of the course offering.

week_in_term

INTEGER

The week of the academic term.

week_start_date

DATE

The start date of the week of the academic term.

week_end_date

DATE

The end date of the week of the academic term.

num_tiny_submissions_z

FLOAT

Z-score for the number of submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.

num_small_submissions_z

FLOAT

Z-score for the number of submissions classified as ‘small’, or making up a small percentage of the student’s final grade.

num_medium_submissions_z

FLOAT

Z-score for the number of submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.

num_large_submissions_z

FLOAT

Z-score for the number of submissions classified as ‘large’, or making up a large percentage of the student’s final grade.

num_major_submissions_z

FLOAT

Z-score for the number of submissions classified as ‘major’, or making up a major percentage of the student’s final grade.

num_unweighted_submissions_z

FLOAT

Z-score for the number of unweighted submissions.

num_weighted_submissions_z

FLOAT

Z-score for the number of weighted submissions.

num_submissions_without_due_date_z

FLOAT

Z-score for the number of submissions without due dates.

num_submissions_with_due_date_z

FLOAT

Z-score for the number of submissions with due dates.

num_submissions_z

FLOAT

Z-score for the total number of submissions.

num_tiny_assignments_z

FLOAT

Z-score for the number of assignments classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.

num_small_assignments_z

FLOAT

Z-score for the number of assignments classified as ‘small’, or making up a small percentage of the student’s final grade.

num_medium_assignments_z

FLOAT

Z-score for the number of assignments classified as ‘medium’, or making up a medium percentage of the student’s final grade.

num_large_assignments_z

FLOAT

Z-score for the number of assignments classified as ‘large’, or making up a large percentage of the student’s final grade.

num_major_assignments_z

FLOAT

Z-score for the number of assignments classified as ‘major’, or making up a major percentage of the student’s final grade.

num_unweighted_assignments_z

FLOAT

Z-score for the number of unweighted assignments.

num_weighted_assignments_z

FLOAT

Z-score for the number of weighted assignments.

num_assignments_without_due_date_z

FLOAT

Z-score for the number of assignments without due dates.

num_assignments_with_due_date_z

FLOAT

Z-score for the number of assignments with due dates.

num_assignments_z

FLOAT

Z-score for the total number of assignments.

num_tiny_missing_submissions_z

FLOAT

Z-score for the number of missing submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.

num_small_missing_submissions_z

FLOAT

Z-score for the number of missing submissions classified as ‘small’, or making up a small percentage of the student’s final grade.

num_medium_missing_submissions_z

FLOAT

Z-score for the number of missing submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.

num_large_missing_submissions_z

FLOAT

Z-score for the number of missing submissions classified as ‘large’, or making up a large percentage of the student’s final grade.

num_major_missing_submissions_z

FLOAT

Z-score for the number of missing submissions classified as ‘major’, or making up a major percentage of the student’s final grade.

num_unweighted_missing_submissions_z

FLOAT

Z-score for the number of unweighted missing submissions.

num_weighted_missing_submissions_z

FLOAT

Z-score for the number of weighted missing submissions.

num_missing_submissions_z

FLOAT

Z-score for the total number of missing submissions.

num_tiny_late_submissions_z

FLOAT

Z-score for the number of late submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.

num_small_late_submissions_z

FLOAT

Z-score for the number of late submissions classified as ‘small’, or making up a small percentage of the student’s final grade.

num_medium_late_submissions_z

FLOAT

Z-score for the number of late submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.

num_large_late_submissions_z

FLOAT

Z-score for the number of late submissions classified as ‘large’, or making up a large percentage of the student’s final grade.

num_major_late_submissions_z

FLOAT

Z-score for the number of late submissions classified as ‘major’, or making up a major percentage of the student’s final grade.

num_unweighted_late_submissions_z

FLOAT

Z-score for the number of unweighted late submissions.

num_weighted_late_submissions_z

FLOAT

Z-score for the number of weighted late submissions.

num_late_submissions_z

FLOAT

Z-score for the total number of late submissions.

avg_time_buffer_hrs_tiny_z

FLOAT

Z-score for the average submission time buffer in hours for submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.

avg_time_buffer_hrs_small_z

FLOAT

Z-score for the average submission time buffer in hours for submissions classified as ‘small’, or making up a small percentage of the student’s final grade.

avg_time_buffer_hrs_medium_z

FLOAT

Z-score for the average submission time buffer in hours for submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.

avg_time_buffer_hrs_large_z

FLOAT

Z-score for the average submission time buffer in hours for submissions classified as ‘large’, or making up a large percentage of the student’s final grade.

avg_time_buffer_hrs_major_z

FLOAT

Z-score for the average submission time buffer in hours for submissions classified as ‘major’, or making up a major percentage of the student’s final grade.

avg_time_buffer_hrs_unweighted_z

FLOAT

Z-score for the average submission time buffer in hours for unweighted submissions.

avg_time_buffer_hrs_weighted_z

FLOAT

Z-score for the average submission time buffer in hours for weighted submissions.

avg_time_buffer_hrs_z

FLOAT

Z-score for the average submission time buffer in hours for all submissions.

avg_published_score_pct_tiny_z

FLOAT

Z-score for the average published score percentage for submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.

avg_published_score_pct_small_z

FLOAT

Z-score for the average published score percentage for submissions classified as ‘small’, or making up a small percentage of the student’s final grade.

avg_published_score_pct_medium_z

FLOAT

Z-score for the average published score percentage for submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.

avg_published_score_pct_large_z

FLOAT

Z-score for the average published score percentage for submissions classified as ‘large’, or making up a large percentage of the student’s final grade.

avg_published_score_pct_major_z

FLOAT

Z-score for the average published score percentage for submissions classified as ‘major’, or making up a major percentage of the student’s final grade.

avg_score_pct_unweighted_z

FLOAT

Z-score for the average score percentage for unweighted submissions.

avg_published_score_pct_weighted_z

FLOAT

Z-score for the average published score percentage for weighted submissions.

avg_published_score_pct_without_due_date_z

FLOAT

Z-score for the average published score percentage for submissions without due dates.

avg_published_score_pct_with_due_date_z

FLOAT

Z-score for the average published score percentage for submissions with due dates

avg_published_score_z

FLOAT

Z-score for the average published score percentage for all submissions.

avg_published_score_pct_tiny_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions classified as ‘tiny’

avg_published_score_pct_small_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions classified as ‘small’

avg_published_score_pct_medium_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions classified as ‘medium’

avg_published_score_pct_large_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions classified as ‘large’

avg_published_score_pct_major_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions classified as ‘major’

avg_published_score_pct_without_due_date_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions without a due date

avg_published_score_pct_with_due_date_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions with a due date.

avg_published_score_pct_unweighted_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions without a weight

avg_published_score_pct_weighted_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage for submissions with a non-zero weight

avg_published_score_cumulative_z

FLOAT

Z-score for the cumulative average published score percentage

discussion_entry_count_z

FLOAT

Z-score for the number of discussion entries posted by the student.

discussion_post_count_z

FLOAT

Z-score for the number of discussion posts posted by the student.

discussion_reply_count_z

FLOAT

Z-score for the number of discussion replies posted by the student.

discussion_count_z

FLOAT

Z-score for the total number of discussions interacted with by the student.

assignment_discussion_count_z

FLOAT

Z-score for the total number of discussions associated with an assignment interacted with by the student.

threaded_discussion_count_z

FLOAT

Z-score for the total number of threaded discussions interacted with by the student.

side_comment_discussion_count_z

FLOAT

Z-score for the total number of side comment discussions interacted with by the student.

total_discussion_count_z

FLOAT

Z-score for the total number of discussions available in the course offering.

total_assignment_discussion_count_z

FLOAT

Z-score for the total number of discussions associated with assignments available in the course offering.

total_threaded_discussion_count_z

FLOAT

Z-score for the total number of threaded discussions available in the course offering.

total_side_comment_discussion_count_z

FLOAT

Z-score for the total number of side comment discussions available in the course offering.

avg_discussion_entry_length_z

FLOAT

Z-score for the average length of the student’s discussion entries.

avg_discussion_post_length_z

FLOAT

Z-score for the average length of the student’s discussion posts.

avg_discussion_reply_length_z

FLOAT

Z-score for the average length of the student’s discussion replies.

view_days_z

FLOAT

Z-score for the number of view days in the LMS.

num_sessions_10min_z

FLOAT

Z-score for the number of sessions in the LMS, with a 10 minute cutoff when calculating sessions.

total_time_seconds_10min_z

FLOAT

Z-score for the total time spent in the LMS in seconds, with a 10 minute cutoff when calculating sessions.

total_actions_10min_z

FLOAT

Z-score for the total number of actions in the LMS, with a 10 minute cutoff when calculating sessions.

avg_time_seconds_10min_z

FLOAT

Z-score for the average amount of time spent in the LMS in seconds, with a 10 minute cutoff when calculating sessions.

avg_actions_10min_z

FLOAT

Z-score for the average number of actions in the LMS, with a 10 minute cutoff when calculating sessions.

num_sessions_20min_z

FLOAT

Z-score for the number of sessions in the LMS, with a 20 minute cutoff when calculating sessions.

total_time_seconds_20min_z

FLOAT

Z-score for the total time spent in the LMS in seconds, with a 20 minute cutoff when calculating sessions.

total_actions_20min_z

FLOAT

Z-score for the total number of actions in the LMS, with a 20 minute cutoff when calculating sessions.

avg_time_seconds_20min_z

FLOAT

Z-score for the average amount of time spent in the LMS in seconds, with a 20 minute time cutoff when calculating sessions.

avg_actions_20min_z

FLOAT

Z-score for the average number of actions in the LMS, with a 20 minute cutoff when calculating sessions.

num_sessions_30min_z

FLOAT

Z-score for the number of sessions in the LMS, with a 30 minute cutoff when calculating sessions.

total_time_seconds_30min_z

FLOAT

Z-score for the total time spent in the LMS in seconds, with a 30 minute cutoff when calculating sessions.

total_actions_30min_z

FLOAT

Z-score for the total number of actions in the LMS, with a 30 minute cutoff when calculating sessions.

avg_time_seconds_30min_z

FLOAT

Z-score for the average amount of time spent in the LMS in seconds, with a 30 minute cutoff when calculating sessions.

avg_actions_30min_z

FLOAT

Z-score for the average number of actions in the LMS, with a 30 minute cutoff when calculating sessions.

num_tool_launches_z

FLOAT

Z-score for the total number of LTI tool launches.

num_tools_launched_z

FLOAT

Z-score for the total number of LTI tools launched.

file_views_z

FLOAT

Z-score for the number of file views.

num_files_viewed_z

FLOAT

Z-score for the number of files viewed.

course_tools_launched

ARRAY<STRING>

Array of tool names launched by the person in the course for the week

course_tools_not_launched

ARRAY<STRING>

Array of tool names not launched by the person in the course for the week

course_files_viewed

ARRAY<INTEGER>

Array of file IDs accessed by the person in the course for the week

course_files_not_viewed

ARRAY<INTEGER>

Array of file IDs not accessed by the person in the course for the week

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.

Z-Score Fields

The majority of the schema for mart_taskforce.level2_aggregated are z-score fields based on the distribution of corresponding fields per-course, per-week in mart_taskforce.level1_aggregated. The corresponding table mart_taskforce.level2_course_weekly_distribution_summary surfaces the averages and standard deviations (per-course, per-week) needed to calculate the z-scores for this table. We use the standard normalization formula to compute the z-scores.

Assignments

Number of Submissions

Fields

  • num_tiny_submissions_z

  • num_small_submissions_z

  • num_medium_submissions_z

  • num_large_submissions_z

  • num_major_submissions_z

  • num_unweighted_submissions_z

  • num_weighted_submissions_z

  • num_submissions_without_due_date_z

  • num_submissions_with_due_date_z

  • num_submissions_z

Description

Number of Assignments

Fields

  • num_tiny_assignments_z

  • num_small_assignments_z

  • num_medium_assignments_z

  • num_large_assignments_z

  • num_major_assignments_z

  • num_unweighted_assignments_z

  • num_weighted_assignments_z

  • num_assignments_z_without_due_date

  • num_assignments_z_with_due_date

  • num_assignments_z

Description

Number of Missing Submissions

Fields

  • num_tiny_missing_submissions_z

  • num_small_missing_submissions_z

  • num_medium_missing_submissions_z

  • num_large_missing_submissions_z

  • num_major_missing_submissions_z

  • num_unweighted_missing_submissions_z

  • num_weighted_missing_submissions_z

  • num_missing_submissions_z

Description

Number of Late Submissions

Fields

  • num_tiny_late_submissions_z

  • num_small_late_submissions_z

  • num_medium_late_submissions_z

  • num_large_late_submissions_z

  • num_major_late_submissions_z

  • num_unweighted_late_submissions_z

  • num_weighted_late_submissions_z

  • num_late_submissions_z

Description

Average Time Buffer in Hours

Fields

  • avg_time_buffer_hrs_tiny_z

  • avg_time_buffer_hrs_small_z

  • avg_time_buffer_hrs_medium_z

  • avg_time_buffer_hrs_large_z

  • avg_time_buffer_hrs_major_z

  • avg_time_buffer_hrs_unweighted_z

  • avg_time_buffer_hrs_weighted_z

  • avg_time_buffer_hrs_z

Description

Average Published Score Percentage

Fields

  • avg_published_score_pct_tiny_z

  • avg_published_score_pct_small_z

  • avg_published_score_pct_medium_z

  • avg_published_score_pct_large_z

  • avg_published_score_pct_major_z

  • avg_score_pct_unweighted_z

  • avg_published_score_pct_weighted_z

  • avg_published_score_pct_without_due_date_z

  • avg_published_score_pct_with_due_date_z

  • avg_published_score_z

  • avg_published_score_pct_tiny_cumulative_z

  • avg_published_score_pct_small_cumulative_z

  • avg_published_score_pct_medium_cumulative_z

  • avg_published_score_pct_large_cumulative_z

  • avg_published_score_pct_major_cumulative_z

  • avg_score_pct_unweighted_cumulative_z

  • avg_published_score_pct_weighted_cumulative_z

  • avg_published_score_pct_without_due_date_cumulative_z

  • avg_published_score_pct_with_due_date_cumulative_z

  • avg_published_score_cumulative_z

Description

Discussions

Discussion Entry Counts

Fields

  • discussion_entry_count _z

  • discussion_post_count_z

  • discussion_reply_count_z

Description

Discussion Counts

Fields

  • discussion_count_z

  • assignment_discussion_count_z

  • threaded_discussion_count_z

  • side_comment_discussion_count_z

Description

Total Discussion Counts

Fields

  • total_discussion_count_z

  • total_assignment_discussion_count_z

  • total_threaded_discussion_count_z

  • total_side_comment_discussion_count_z

Description

Average Discussion Entry Length

Fields

  • avg_discussion_entry_length_z

  • avg_discussion_post_length_z

  • avg_discussion_reply_length_z

Description

Learning Environment Activity

View Days

Fields

  • view_days

Description

Sessions with 10, 20, and 30 Minute Cutoffs

Fields

  • num_sessions_10min_z

  • total_time_seconds_10min_z

  • total_actions_10min_z

  • avg_time_seconds_10min_z

  • avg_actions_10min_z

  • num_sessions_20min_z

  • total_time_seconds_20min_z

  • total_actions_20min_z

  • avg_time_seconds_20min_z

  • avg_actions_20min_z

  • num_sessions_30min_z

  • total_time_seconds_30min_z

  • total_actions_30min_z

  • avg_time_seconds_30min_z

  • avg_actions_30min_z

Description

Tool Launches

Fields

  • num_tool_launches_z

  • num_tools_launched_z

  • course_tools_launched

  • course_tools_not_launched

Description

The course_tools_launched and course_tools_not_launched are unique to this table. Both of these fields are of type ARRAY<STRING>. The course_tools_launched array field is a concatenated list of all launch app names seen for the course, week pair for a student. The course_tools_not_launched array field is inferred based on all the launch app names launched for the course for that week across all students. The results in the course_tools_not_launched field are the launch app names that at least one other student in the class launched but the student in scope for the row did not launch.

File Views

Fields

  • file_views_z

  • num_files_viewed_z

  • course_files_viewed

  • course_files_not_viewed

Description

The course_files_viewed and course_files_not_viewed are unique to this table. Both of these fields are of type ARRAY<INTEGER>. The course_files_launched array field is a concatenated list of all file IDs seen for the course and week pair for a student. The course_files_not_viewed array field is inferred based on all the file IDs viewed for the course and week across all students. The results in the course_files_not_viewed field are the file IDs that at least one other student in the class viewed but the student in scope for the row did not view.

The following visualization shows the construction of this data mart defined in the repository. More information on the repository and diagram can be found on

These fields present the Z-scores for the number of submissions by a student in a course for each week in the term. More detailed descriptions of the original submission fields exist in the .

These fields present Z-scores for the number of assignments for a student in a course for each week in the term. The more detailed descriptions of the original assignment fields can be found in the .

These fields present Z-scores for the number of missing student submissions in a course for each week in the term. The definitions of the original missing submissions fields exist in the .

These fields present the Z-scores 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 .

These fields present the Z-scores 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 .

These fields show the Z-scores 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

These fields present the Z-scores 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 d

These fields present the Z-scores for the number of discussions a student has interacted with in a course for each week in the term. The discussion count fields used to compute these Z-scores are defined in the

These fields present the Z-scores 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

These fields present the Z-scores 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

The view_days field shows the Z-score 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

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 present the Z-scores 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

Please visit our for a visual example and more information about interaction sessions too.

These fields focus on the LTI tools launched by a student in the learning environment of a course for each week in the term. More detailed definitions of LTI launches exist in the

These fields focus on the files viewed by a student in the learning environment of a course for each week in the term. More detailed definitions of files and file views exist in the

UDP marts
this marts page.
Click here to open the interactive chart.
separate interaction session mart documentation page here
Interactive Mart Dependency Diagram
Schema
Field Structure and Subcategories
Dependencies
Assignment Weight Groupings
Z-Score Fields
Assignments
Number of Submissions
Number of Assignments
Number of Missing Submissions
Number of Late Submissions
Average Time Buffer in Hours
Average Published Score Percentage
Discussions
Discussion Entry Counts
Discussion Counts
Total Discussion Counts
Average Discussion Entry Length
Learning Environment Activity
View Days
Sessions with 10, 20, and 30 Minute Cutoffs
Tool Launches
File Views
documentation for mart_taskforce.level1_aggregated.
mart_taskforce.level2_aggregated
documentation for mart_taskforce.level1_aggregated
documentation for mart_taskforce.level1_aggregated
documentation for mart_taskforce.level1_aggregated
documentation for mart_taskforce.level1_aggregated
documentation for mart_taskforce.level1_aggregated
documentation for mart_taskforce.level1_aggregated.
ocumentation for mart_taskforce.level1_aggregated.
documentation for mart_taskforce.level1_aggregated.
documentation for mart_taskforce.level1_aggregated.
documentation for mart_taskforce.level1_aggregated.
documentation for mart_taskforce.level1_aggregated.
documentation for mart_taskforce.level1_aggregated.
documentation for mart_taskforce.level1_aggregated.