cover.png                                                   

                                         

Tableau Pre-Defined Reports Catalog

Table of Contents

Course Status Ratio        3

Breakdown of Canvas Features        4

Breakdown of Canvas Assessments        5

Submission Times (Month/Hour)        6

Teacher Comments        7

Enrollment Ratio        8

Quiz Question Types        9

Login Times (Month/Hour) (Option 1 of 2)        10

Login Times (Weekday/Hour) (Option 2 of 2)        11

LTI Activation Usage        12

Discussion Post Totals        13

Number of Course Withdrawals (Option 1 of 2)        14

Number of Course Withdrawals (Option 2 of 2)        15

Teacher Enrollment Last Login        16

Student Course Enrollment Last Login        17

Browser Breakdown        18

Teacher Average Grading Time        19

Student Course Grade Group Totals        20

Student Participation Snapshot        21

Student to Teacher Discussion Post Totals        22

Students Missing Submissions and Current Amount of 0 Grade for Assignments        23

Course Status Ratio

This query helps admins determine the number of courses currently being utilized in Canvas.

Questions answered: Were all courses published for this term? Which courses aren't using Canvas? Develop a plan to have every course published in Canvas.

CourseStates.png

Filterable by:

Account

Enrollment Term

Workflow State

Exported Data Columns:

Course_canvas_id

        Course_name

        Course_code

        Course_start_at

        Course_conclude_at

        Course_workflow_state

        Account_name

        Enrollment_term_canvas_id

        Enrollment_term_name

        enrollment_term_sis_id

        Term_start_date

Term_end_date

Breakdown of Canvas Features

This chart breaks down all published assignments, discussions, and quizzes in courses, accounts, and terms.

   

Questions Answered: What features are being utilized by instructors? Are they being used as a substitute to traditional methods? Are features augmenting your classrooms? How have features begun to modify or redefine the way your faculty teaches? Look at the most active courses and compare with the least active. Then, create a plan to deepen usage in the less active courses.

breakdown_canvas_features.png

Filterable by:

Account

Enrollment Term

Course

Exported Data Columns:

Course_canvas_id

        Course_name

        Account Name

Enrollment_term_name

Assignment  (count)

Discussion (count)

Quiz (count)

Breakdown of Canvas Assessments

This chart breaks down all gradable assignment, discussion, and quiz assessments in courses. This data excludes no-submission and on-paper-submission types.

Question Answered: How many courses are doing active student learning? How many courses are expecting students to interact with the course?

breakdown_canvas_assessments.png

Filterable by:

Account

Enrollment Term

Course

Exported Data Columns:

Course_canvas_id

        Course_name

        Account Name

Enrollment_term_name

Assignment (count)

Discussion (count)

Quiz (count)

Submission Times (Month/Hour)

This query helps show when students are most active in Canvas and submitting assignments. The ability to drill down to the course level and filter by term and account, help narrow down areas that may require to submit more often.

Question Answered: How many students are submitting assignments through Canvas? Which courses require the most submissions from their students?

submissionTime-month-hour.png

Filterable by:

Account

Enrollment Term

Course Name

Drill down capability to day of month

Exported Data Columns:

Course_canvas_id

Course_name

Course_code         Course_workflow_state

Account_name

Enrollment_term_canvas_id

Enrollment_term_name

Enrollment_term_sis_id

        Term_start_date

Term_end_date

User_name

Submission_time

Teacher Comments

This query helps admins determine how often teachers are leaving submission comments within courses

Questions answered: Are teachers interacting and providing feedback on student submissions?

submissionComments.png

Filterable by:

Account

Enrollment Term

Top N Course

Exported Data Columns:

Course_canvas_id

        Course_name

        Course_code

        Course_start_at

        Course_conclude_at

        Course_workflow_state

        Account_name

        Enrollment_term_canvas_id

        Enrollment_term_name

        enrollment_term_sis_id

        Term_start_date

Term_end_date

Comment_text

Comment_created_at

Comment_author_id

Enrollment Ratio

This query provides a quick visual on the ratio of teacher enrollments to student enrollments within an account, and term. It also provides visual data on courses that contain larger student enrollments as indicated by a large circle.

Questions Answered: Are there courses that have significantly larger student enrollments than other? Are there enough teacher enrolments to cover the amount of students in an account?

EnrollmentRatio.png

Filterable by:

Account

Enrollment Term

Drill down by course

Exported Data Columns:

Course_canvas_id

Course_name

Course_code

Count of student enrollment in course

Count of teacher enrollment in course

Quiz Question Types

The greater the split of question types, the more likely students are required to demonstrate higher learning

Question Answered: Are instructors demonstrating higher learning in their quiz questions or are all questions simply multiple choice?

QuizQuestionTypes.png

Filterable by:

Account

Enrollment Term

Course

Exported Data Columns:

Course_canvas_id

        Course_name

        Course_code

        Account Name

        Enrollment_term_name

Quiz_name

Question_type_totals per quiz

Login Times (Month/Hour) (Option 1 of 2)

This query provides a visual breakdown of when students are most active throughout the year

login-times(month:hour).png

Filterable by:

Account

User

Course

Exported Data Columns:

        User_name

        Login_time

        Account_name

        Course_name

Login Times (Weekday/Hour) (Option 2 of 2)

This query provides a visual breakdown of when students are most active during the week. It may be useful to compare this data to when students are also submitting assignments.

LoginWeekHour.png

Filterable by:

Account

User

Course

Exported Data Columns:

        User_name

        Login_time

        Account_name

        Course_name

LTI Activation Usage

This reports allows admins to see which LTI tools are being activated most at either the account, or course level.

LtiActivation.png

Questions Answered: Which LTI tools are your instructors actually using? Are the LTIs that are being paid for, being used to justify cost? Are there LTI tools that you should focus on encouraging instructors to use more often?

Filterable by:

Account

LTI workflow state

Where the LTI is activated (course/account)

Exported Data Columns:

LTI Name

Activation_target_type

Course_name

Account_name

Number_of_activations

Discussion Post Totals

This query allows admins a quick look at which courses are actively using discussions as either a submission type, or a way of communication.

Question Answered: How often do instructors utilize discussions as a teaching tool? What courses facilitate discussions the best/worst?

TotalDiscussionPosts.png

Filterable by:

Account

Enrollment Term

Course

Date Range

Exported Data Columns:

Course_canvas_id

        Course_name

        Course_code

Account Name

Enrollment_term_name

Discussion Topic

Discussion Type (graded/non-graded)

Number of Course Withdrawals (Option 1 of 2)

This query calculates a withdraw (concluded student) as being at least more than 0 days before the course has ended (this value can be edited in a calculated field).

Questions Answered: Which students are constantly withdrawing from courses after signing up? Is there a trend of courses that are experiencing higher withdrawal rates than others?

StudentWithdrawals1.png

Filterable by:

Account

Enrollment Term

Exported Data Columns:

User_name

Course_name

Drop_date

Number of Course Withdrawals (Option 2 of 2)

This query calculates a amount of withdrawals per course within an account or enrollment term.

Questions Answered: Which students are constantly withdrawing from courses after signing up? Is there a trend of courses that are experiencing higher withdrawal rates than others?

CourseWithdrawals2.png

Filterable by:

Account

Enrollment Term

Exported Data Columns:

User_name

Course_name

Drop_date

Enrollment Term

Account Name

Teacher Enrollment Last Login

This query provides an intractable crosstab that breaks down the last time a teacher has logged into a course. The data can be filtered by enrollment term, or by a range of dates.

Questions Answered: Are your teachers logging into Canvas often to interact with their online students?

teacher_last_login2.png

Filterable by:

Enrollment Term

Range of Dates

Exported Data Columns:

Name (teacher’s username)

Course_name

Course_sis_id

Last_login

Student Course Enrollment Last Login

This query provides an intractable crosstab that breaks down the last time a student has logged into a course. The data can be filtered by enrollment term, or by a range of dates.

Questions Answered: Are students logging into classes frequently? This may help with auditing when trying to withdraw students who have not accessed their course within the first few weeks of a semester.

student-last-login.png

Filterable by:

Enrollment Term

Range of Dates

Exported Data Columns:

Name

Course_name

Course_sis_id

Last_login

Browser Breakdown

This query provides a breakdown of how users are accessing your Canvas instance.

Questions Answered: This can be used to compare if your students are accessing Canvas more often through mobile devices. If so, does instructional design need to change to accommodate that platform?

user-agent-breakdown.png

Exported Data Columns:

Browser Type

Count of records

Teacher Average Grading Time

This query provides a calculation on the average time it takes a teacher to grade assignments within their course. The average time is calculated by the average difference between when the assignment was due and when it was graded.

Questions Answered: Are your teachers providing timely feedback? Which teachers are consistently taking longer than others to provide students their grades?

teacher-avg-grade-time.png

Filterable by:

Teacher Name

Term

Exported Data Columns:

Teacher

Course

Assignments

Due Date

Graded At Date

Number Graded

Average Time

Student Course Grade Group Totals

This query provides a breakdown of all courses a student is enrolled with the assignment group grades splitted out.

Questions Answered: How is this student performing in all classes and assignment groups?

student_group_grade.png

Filterable by:

Student name or SIS ID

Term

Exported Data Columns:

Student

Course

Course grade

Assignment group name

Assignment group weight

Assignment title

Student Score - Integer

Student Score - Percent

Student Participation Snapshot

This query provides a breakdown of how often students are participating in a course.

Questions Answered: Are students submitting submission comments, discussion posts, or actively monitoring their grades? How do these items relate to their grade in the course?

stduent-participation.png

Filterable by:

Course

Exported Data Columns:

Class Name

Student Name

Student Current Grade

Student Final Grade

Discussion Post Count

Submission Comment Count

Gradebook View Count

Student to Teacher Discussion Post Totals

This report provides a breakdown of how often students are submitting to discussion posts, and if teachers are responding within those discussion posts.

Questions Answered: Are students receiving feedback from their teacher when using the discussion feature in Canvas? Which teachers respond more often than others?

2017-04-26_1309.png

Filterable by:

Course

User

Exported Data Columns:

Teacher Name

Class Name

Section

Discussion Title

Student Discussion Post Count

Teacher Discussion Post Count

Students Missing Submissions and Current Amount of 0 Grade for Assignments

This report helps determine which students are at risk with having a high amount of unsubmitted assignments, or many 0s within a course. This can help faculty intervene earlier in the semester when these students were identified.

Questions answered: Which students are falling behind? Do certain courses have a higher rate of unsubmitted, or 0 scores, than others? How does this student compare to others in their course or term?

Filterable by:

Course

Enrollment Term

Student

Exported Data Columns

Course_name

Student name

Current score

Final score

Number of Unsubmitted Assignments

Number of 0s in the Course

Term

Account