Connect and collaborate with peers to explore data, analytics, product features, and best practices.
Sign in to enhance your access to articles, forums, and events—and to participate by sharing insights, engaging in discussions, and connecting with your network of edtech peers.
Data and Analytics Group
On the new_quizzes.quizzes table, all of my institution's records have either "unpublished" or "uninitialized" values in the workflow_state column. The documentation for this type lists "published" as a possible value. It seems like all of my institution's published New Quizzes have the "uninitialized" value. What does…
I recently received a data dump of ALL rubric data from our Canvas instance so that I could analyse how our rubrics are being set up. One field I was interested to investigate was the ratio of rubrics using point vs using ranges. This field seems to be captured by "criterion_use_range" and contains values TRUE (i.e. is…
The new_quizzes.quizzes table has a practice_quiz boolean field described as "whether the quiz is a practice quiz." The does not correspond to a configurable field, as far as I can tell. I wonder, how is this field's value determined? What is a practice new quiz?
Introduction and Research Context In complex humanitarian emergencies, the static deployment of resources often fails to address the rapidly shifting vulnerabilities of affected populations. My research project focuses on developing an algorithmic Explosive Ordnance Risk Education (EORE) Prioritization System for the…
We are getting this error today when syncing the web_logs table and the sync fails. I have never seen this one. 'invalid input value for enum canvas_logs.web_logs__web_application_context_type: "SisBatch"' Has anyone else seen this?
Hello everyone, I was wondering if there is a way for the Canvas LMS to track the specific amount of time that a student spends on each assignment in a course. I am not referring to page views, I'm referring to gathering the date, time in minutes, seconds, and hours that a student spent working on each assignment in a…
In our CD2 Assignments table, we're noticing a weird discrepancy: - ran a query in 2/2025 and saw 50 assignments in one class from 2018 - ran the query in 2/2026 and there were fewer (only 40 assignments) We looked at the Assignments table, specifically at the ts field. On 10/1/25, 100% of the records in that table (6.5…
Hi — I've been struggling to initialize our "submissions" table using the dap CLI and I've narrowed down the problem to Python 3.14. I'm able to successfully run the same exact initdb command (on the same EC2 instance) under Python 3.13 and 3.12. On Python 3.14.2, the import successfully processes about 34 million records…
Hi Community, We are currently diving into the Admin Analytics to provide data-driven feedback to our higher education programs regarding course design and student engagement. Specifically, I am looking at the "Interactions by Category" chart (see attached screenshot). To interpret the data correctly, we are trying to…
I am trying to migrate a cd2 / dap web_logs database from my local machine to a google cloud virtual machine. I created a postgres dump of the local database, uploaded it to the cloud, and used postgres restore. Now I am trying to syncdb and get the following error. ✗ ERROR: Operation syncdb failed. Reason: Table not…
We are working on a project to import grades from Canvas into Banner. During the testing phase we discovered a few students who show the correct grade in the gradebook but when we pull Canvas Data the grade is different. When we go to the gradebook and export grades we get the same incorrect grade as Canvas Data. When we…
Our organization has been asked to provide data and reporting on student activity in Canvas, essentially the number of times a student has accessed courses and resources. The activity is stored in the "web_logs" table which records granular actions, similar to api calls and http requests. There is an abundance of noise in…
Hey folks I've finally managed to wrestle all of my DAP queries into Power Bi dataflows, and it was quite an ordeal. I'm currently using dataflows with DAP as a surrogate databasing solution as we do not currently have access to a SQL server that can store our info, otherwise I would probably be fetching this data using…
Looking for any insight as to why my CD2 submissions table and API submissions are returning an 'attempt' number that is different from CD2 submissions_version and from the New Quizzes moderate page. Also, extra attempts are always NULL even after attempts are added via New Quizzes moderate (possibly related to New Quizzes…