The most recent content from our members.
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…
Wondering if anyone has any suggestions regarding some "time series-like" analytics for enrollments total_activity_time and active user counts? I'm conscious that CD2 is "eventual consistency" so time series analysis of things like weekly total_activity_time and overall active user count trends arent possible. There's no…
Note: Relying on my DBA since some of this is a bit over my head. Our scheduled "dap syncdb" process keeps blowing up our CPU. Our DBA used an "explain plan" to see where our performance issue are. Below is the SQL running a loop while sorting through a huge number of rows (18,589,175,389,900). Any assistance with this…
Confession: I am not a developer or an SQL expert, but I can view certain kinds of code, sort of learn it, and make adjustments as needed. Otherwise, I rely heavily on ChatGPT, particularly when it comes to SQL. 😁 That said, I was wondering if someone more experienced with SQL than I might be able to please look over the…
Wondering if anyone can suggest how to extract the equivalent of the grade book total letter grade? In the scores table, scores.course_score is a boolean value where true "represents the overall score for the course referred to in the enrollment". But it doesn't provide the letter grade. Instead it just links to the…
I've started a Git Repo dedicated to Canvas Data Queries: reynlds-illinois/canvas_data_queries: Canvas Data queries through Athena on AWS. (github.com) Over the next few days I'll be uploading everything I've written so far. I'm also going to be collecting various queries within this community and adding them to it. If…
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.