-
Inconsistencies in user submission attempts (new quizzes) across tables and interface
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…
-
Seeking advice on CD2, ETL and presentation processes
Hey there, My institution is going to be implementing CD2 in SQL Server and Power BI in the not to distant future. I'm reaching out to see if anyone might be interested in sharing techniques, and lessons learned in any of the following: how they orgainzed the data, if and how they went about in dimensional modeling of…
-
Sample Data
I know this gets asked every couple of years, so I guess I'll take up the call this year. We're developing an application that uses CD2. We've been getting by generating fake data on a table-by-table basis as we need it, but we're getting to a point where what we really need is the full CD2 schema with data that's safe for…
-
Canvas Data Access Platform (DAP) Python Client Library Will Not Sync With Postgres Database
I set up a simple command line script to sync DAP tables with our postgres database using the example code here: https://developerdocs.instructure.com/services/dap/lib-index/lib-examples. However, certain tables (like courses) get stuck on an upsert and the process hangs until I kill it. Other tables sync just fine. My…
-
Seeking Advice: Integrating CD2 Data for Student & Instructor Success KPIs
Hello all, Our institution has kicked off an initiative to utilize CD2 data to develop robust student success KPIs and, later, metrics for instructor success. We're looking to learn from those who are already down this path and hear about your success stories in particular! For those of you using CD2 data to measure…
-
Unrecognized Dialect when trying to connect to SQL server
I am trying to run an initdb command using dap and connecting to an existing SQL server DB and Table but receiving an "unrecognized dialect" error. Can someone point out if this is the correct way of setting the connection string in the environment variables: set…
-
syncdb interval exceeded
Hi, We recently had a space issue with the PC where we routinely run a syncdb on the web_logs table in the canvas_logs namespace. The space issue has now been resolved but when I attempt a dap syncdb it is erroring with "The maximum interval for this request should be '30' days. The requested interval was '35' days" Is the…
-
EDUCAUSE Insights: Data and Decision-Making
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
-
New Quizzes now available in CD2/DAP
I just noticed an update (posted about a week ago) to the canvas product roadmap that seems to indicate that "New Quizzes data is now available in DAP/CD2, providing seamless access to key data points for analysis. Institutions can now retrieve quiz performance metrics, student data, and outcomes at scale." However, there…
-
DAP initdb error: missing dependency asyncpg
When I try to run the following command: dap initdb --namespace canvas --table accounts I receive the error: missing dependency: `asyncpg`; you may need to run `pip install pysqlsync` although pysqlsync is installed already. (pysqlsync 0.8.3) Any advice on what steps need to be taken to fix this? Running Python 3.14.0 and…
-
Problems with GraphQL in User Pageviews reports
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
-
Metrics Easy Button
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…
-
Profiling and/or quality assurance testing Canvas data
Has anyone implemented some form of data profiling, quality assurance checks, or similar mechanisms to identify significant changes and/or problems in the data you're bringing in from DAP? If so, would you be willing to share what you're doing as examples? For context, Instructure delivered a change this summer that…
-
Is there a way to average course completion time for a student cohort?
I am aware that Canvas offers a limited analytics suite for courses. I am also aware that you can track the course time spent per student. We would like to average how long it takes our students to complete our courses, but as far as I can tell, there is no display of that average. I also don't think I can find a way to…
-
As an Administrator, how can I enable the Roll Call Attendance Reports in the Analytics Hub?
This is what I currently see, but we do not have that feature enable and it would be highly needed to pull attendance reports across different courses. Many thank in advance. Guido Reverdito