Kevin Wright

Quiz Scores by Student and Course

Blog Post created by Kevin Wright on Oct 18, 2017

Being a content provider and not an educational institution, measuring the effectiveness of our course and student performance presented a challenge for us. We do not have teachers reporting grades to us, there is no one we can check in with, this is all work that had to be extracted from Canvas. This is how Canvas Data simplified this process for us. 

 

As mentioned in the title, we needed to know the quiz scores across our entire LMS for every class and every student. This required four unpacked Canvas Data files:

  1. Quiz Submission Fact
  2. User Dimension
  3. Quiz Dimesnion
  4. Course Dimension

These files were queried into Excel 2018. 

 

Afterwards, two separate merges had to take place. 

 

  • Quiz Submission & User ID
    • By User ID

The picture below shows the columns that were included

This image shows the columns that were included in the merge of the Quiz Submission and User ID

Note that NewColumn.name.1 is the name of the quiz. 

 

  • Merge one with Course Dimensions
    • By Course ID

The picture below shows the columns that I left included

 

This image shows the columns that were included in the merge of Merge One and Course Dimensions

 

Some of the columns picture above are custom. For example, the average column is Score/(points possible). The index gives a count of the students. 

 

What this left me with is a new query with the ability to sort through the results by course, course ID, term. With the information to be able to identify the student and add more information. 

 

For example, in our case, we held a series of webinars before each lesson, we were able to identify the teachers who did and did not attend the webinar, sort through them, and compare the averages between the two to judge the effectiveness of our webinars. 

Outcomes