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:
- Quiz Submission Fact
- User Dimension
- Quiz Dimesnion
- 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
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
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.