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
  • Fields
  • Tableau Template Workbook
  • Connecting to Data
  • Tableau Dashboard Filters
  • Tableau Visualizations
  1. Products
  2. Data & Analytics
  3. Unizin Data Platform
  4. Data stores
  5. Data marts

LTI Tool Use

PreviousDaily Course Grade RecordNextLMS Tool Use

Last updated 14 days ago

The mart_general.lti_tool keeps track of use of LTI tools in the learning environment.

BQ Prod Dataset Locations

mart_general

Interactive Mart Dependency Diagram

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

Schema

Field Name
Type
Description

udp_course_offering_id

INTEGER

The UDP ID for the Course offering associated with the LTI tool.

lms_course_offering_id

STRING

The LMS ID for the Course offering associated with the LTI tool.

sis_course_offering_id

STRING

The SIS ID for the Course offering associated with the LTI tool.

udp_person_id

INTEGER

The UDP ID for the person who used the LTI tool.

lms_person_id

STRING

The LMS ID for the person who used the LTI tool.

sis_person_id

STRING

The SIS ID for the person who used the LTI tool.

role

STRING

The role of the person who used the LTI tool, i.e. Learner or Instructor.

academic_term_name

STRING

The name of the academic term, i.e. Fall 2020.

academic_term_start_date

DATE

The start date for the academic term.

academic_organization_array

ARRAY<STRING>

An array of the name of the academic organization(s).

academic_organization_display

STRING

An array of the name of the academic organization(s) written as a comma-separated string.

course_offering_title

STRING

The title of the Course offering associated with the LTI tool, i.e. Linear Algebra.

course_offering_start_date

DATE

The start date of the Course offering associated with the LTI tool.

course_offering_subject

STRING

The subject of the Course offering associated with the LTI tool, i.e. MATH

course_offering_number

STRING

The number of the Course offering associated with the LTI tool, i.e. 310.

course_offering_code

STRING

The code of the Course offering associated with the LTI tool, i.e. MATH 310.

num_students

INTEGER

The number of students enrolled in the Course offering associated with the LTI tool.

udp_course_section_id

INTEGER

The UDP ID of the Course section associated with the LTI tool.

lms_course_section_id

STRING

The LMS ID of the Course section associated with the LTI tool.

sis_course_section_id

STRING

The SIS ID of the Course section associated with the LTI tool.

instructor_name_array

ARRAY<STRING>

An array of the instructors’ names for the Course offering associated with the LTI tool.

instructor_lms_id_array

ARRAY<STRING>

An array of the instructors’ LMS IDs for the Course offering associated with the LTI tool.

instructor_display

STRING

The array of the instructors’ names for the Course offering associated with the LTI tool written as a string.

instructor_email_address_array

ARRAY<STRING>

An array of the instructors' email addresses for the Course offering

instructor_email_address_display

STRING

An array of the instructors' email addresses for the Course offering written as a comma-separated string

event_time

DATETIME

The time that the LTI tool was launched.

event_day

DATE

The date that the LTI tool was launched.

event_hour

INTEGER

The hour that the LTI tool was launched.

launch_app_url

STRING

The URL of the application launched.

launch_app_domain

STRING

The domain of the application launched.

launch_app_name

STRING

The name of the application launched.

tool_name

STRING

The name of the LTI tool.

is_lti_tool

BOOLEAN

A boolean indicating if the tool launched is a LTI tool.

is_redirect_tool

BOOLEAN

A boolean indicating if the tool launched is a redirect tool.

Fields

num_students

The num_students field defines the number of enrolled students in a Course offering. This number is found from the course_section_enrollment table in UDP’s context store, which keeps track of enrollments in course sections. We count the number of enrollments with a role of ‘Student’ or ‘Observer’ and a role status that is not ‘Dropped’, ‘Withdrawn’, or ‘Not-enrolled’.

event_time

The field event_time defines the time the event associated with when the tool launch took place from the LMS. This field is derived from the UDP’s event store.

launch_app_url

This is the fully resolved URL of the launched tool. We pull this from the object.extensions chunk of the JSON Caliper event. Usually the URL comes from the url key of this chunk, but depending on the tool, it can also come from the domain key. We coalesce these values with preference to the url key if it exists.

launch_app_domain

The launch_app_domain is extracted from the domain key of the object.extensions chunk of the JSON Caliper event. Usually, this will be a subset of the full url value. Often, the launch_app_domain field can be useful to group events together in the event that a single tool has multiple resolved URL values.

launch_app_name

The launch_app_name is extracted from the asset_name field of the object.extensions chunk of the JSON Caliper event. This is often a more human-readable name of the tool that is helpful for front-end reporting and visualization.

tool_name

Unizin has compiled a list of common tools that are used across the consortium. The tool_name field does not exist natively in the Caliper event, but instead is a mapping table we crafted to further help with grouping and organizing LTI tool launches. Both the launch_app_name and launch_app_url fields are used for this mapping to tool_name, with the preference being launch_app_url. Currently 940 URLs and 313 app name values are mapped to tool_name values; if a value shows up that is not in the managed mapping table, a value of ‘unknown tool’ is returned.

This field alongside launch_app_name is intended to be the most useful for visualization and reporting. The launch_app_name field comes directly from the Caliper event, and the tool_name field comes from Unizin’s managed list.

is_lti_tool & is_redirect_tool

We separate LTI tool launches from Redirect tool launches. Two areas of the event are critical to determine whether the event in scope is an LTI tool launch or a redirect launch:

  • The domain key from object.extensions.[‘com.instructure.canvas’]

  • The url key from object.extensions.[‘com.instructure.canvas’]

Domain key
URL key

is_lti_tool

Is not null or blank

is_redirect_tool

Is null or blank

Tableau Template Workbook

As a starting point for visualization for this data mart, Unizin has created a Tableau template workbook available for download here:

Unizin does not provide active, production support for the visualizations, filters, and aggregations in the Tableau workbooks. They are intended to be used as-is, but modifications are welcome! However, we will provide support related to connecting to source data and any issues with the Bigquery -> Tableau workflow.

Once downloaded, ownership of the workbook is transferred to the user. Unizin does not host the workbook on a Tableau Server instance.

Connecting to Data

Tableau Dashboard Filters

The following fields are used as filters in the Tableau Workbook:

  • Academic Organization - The academic department name.

  • Launch App Name - The list of tools that are used.

  • Course Offering Code - The course code of the course offering.

  • Academic Term - The academic term of the course; the default selection is the current term.

These filters are in scope for all visuals in the dashboard.

Tableau Visualizations

These metric cards provides a quick summary of tool usage across courses. It highlights the total number of tool launches, unique users, distinct tools used, and courses where tools were launched. This shows the overall adoption and engagement with LTI tools at the institution.

The tool usage patterns show when and how often LTI tools are used, helping to identify peak usage times and trends over time. It offers insights into usage patterns across days and hours, supporting decisions around tool support and optimization.

Courses are grouped by the number of unique LTI tools they use, helping reveal patterns in tool adoption. The distribution also highlights engagement levels across courses and shows how widely tools are being integrated into the learning experience.

Students are categorized based on the number of unique LTI tools they have interacted with. The chart displays the percentage of students in each group, helping to understand engagement depth and how broadly tools are being utilized by the student population.

Tool usage breakdown across the week shows how the LTI tool usage is distributed across each day of the week, This helps identify which days see higher engagement, supporting scheduling decisions and resource planning.

Tools usage at different times displays tool usage by hour across all days, helping identify peak hours of engagement.

Top 15 most frequent tools used per day highlights the most commonly used LTI tools for each day of the week. This view helps identify which tools drive the most daily engagement and supports decisions around tool prioritization.

This visualization shows the top 15 most tools that are used the most in different courses. It helps to see which tools are most popular and commonly used by students in their courses.

This chart tracks the total number of tool launches each day for different tools, showing how usage changes over time. This helps to identify patterns and fluctuations in tool engagement during the course.

This table displays usage patterns, such as the average number of launches per course or student, for different tools. It helps provide insights into overall engagement of tools at the institution.

Academic data overview displays overall tool usage metrics for courses, as well as contextual data about the course, such as department, course title, and instructors. This overview provides insights into how LTI tools are utilized across various courses and departments, helping to understand engagement and tool adoption in academic settings.

Is not equal to ''

Is equal to ''

The default data connection in the workbook is to Unizin's synthetic data. After downloading the workbook, the first step will be to transfer the connection to your own production UDP data. Here is a to help with this process; Tableau also has a for replacing data sources. For any issues connecting to source data, please contact support@unizin.org.

Metric Cards
Hourly Timeline
Course Distribution
Student Distribution
Daily Timeline
Frequent Tools Used Per Day
Frequent Tools Used Per Course
Daily Tool Usage Trend
Tools Used Per Student and Course
Academic Data Overview
guide document
published doc
https://www.edu-apps.org/redirect
https://www.edu-apps.org/redirect
UDP marts
this marts page.
Click here to open the interactive chart.
91KB
LTI Tools Dashboard.twbx
LTI Tools Dashboard Tableau Template Workbook
mart_general.lti_tool
Hourly usage distribution