-
curiosity within Canvas Live Events - can you help explain it?
I've been using Canvas Live events (Caliper format) to find instances of files being downloaded in Canvas courses. However, recently it's come to my attention that these events may refer to files with names that do not exist as such within the course's file area. More specifically, I've seen recent live events (raw data)…
-
Date format of New Analytics lateAssignment report not interpretted by Excel correctly
Hi Everyone, One of our school admin team contacted us. She noticed that the New Analytics>LateAssignments reporting generates a time/date format that our setup of Excel does not immediately recognise. E.g. this is the result: Submitted DateGraded DatePosted Date 11:59.019:14.539:22.1 11:50.0 54:55.2 From a CSV file where…
-
DAP Canvas Data 2 replication error--invalid syntax
We've been cloning Canvas data successfully for months using DAP2, but recently noticed this sync failure, which looks to be coming from DAP code. When I run this directly in a query editor it balks at the newline separators and the quotes as well as the comma separating the two add value clauses. File…
-
Strategies for Using Canvas Data 2 to Improve Student Retention (Discussion/Ideas)
Hi everyone, I’m looking for ways to evaluate and improve student retention at our university, and I’m particularly interested in leveraging data from Canvas Data 2 as well as other sources to identify and support struggling students. At the moment, I’m exploring the best ways to analyze and apply data effectively to flag…
-
When is "learning_outcome_link_created" event fired?
I've checked "learning_outcome_link_created" check box and then added an already created outcome into a course via "Find" button, however I don't get any "learning_outcome_link_created" event fired - am I looking at the wrong event? Is there any event Canvas fires when an outcome is "linked" a course? Thanks!
-
How to get HTTP debugging info when using Python dap client library
Hello, when using the Python dap client library (not the CLI), is there a way to get access to the HTTP request / response headers and bodies for debugging? Example: I sometimes get errors like "malformed HTTP response" or "invalid_client" but no other information in the stacktrace. It would be helpful to see the HTTP…
-
DAP Client v1.3.0 -> MS SQL Server
Hello, With the deployment of the 1.3.0 client, I've decided to TRY and migrate from Postgres into my native SQL Server environment. I have successfully initialized ~88 tables, but I know that's not enough. I'm seeing an issue within the Assignments table that probably exists in other tables. The script that's creating the…
-
Replicating/Automating Built In Reports using Canvas Data 2
We created python scripts using CD2, and import data locally, and would like to create SQL views that are identical to some of the built in reports. One report, for instance, is the report named Students Access Report. Is there any way to get an SQL query, or some design information, regarding how that report can be…
-
CD2 Pulling out which students have been assigned to a particular assignment
Hi all, Looking for some help on how on which table contains the details of who an assignemnet has been assigned to. I have looked under submissions but this does not seem to be a complete list. If anyone can help and share some insight on how and where I can get this info from CD2 it would be appreciated.
-
CD2 - Courses relating (joining) to a Main Program/ MainCourse
Currently looking at canvas.courses table. I want to link all the courses / modules to their respective main Programs so that different programs can be analysed separately. For instance - a computer science Y1 main program could have 6 modules/courses (database, AI, ML, QC, ANN, DS) Is there a way these "sub" courses can…
-
User Emails (or Student IDs ) CD2
Hi, Does anyone know a way to find student IDs or user emails from CD2? I have checked users and accounts tables in the canvas namespace - but they don't have "email" column. I only have the primary key of userID and accountID and only their full name. Is there some other place that I should be looking? Thanks Z
-
Course Navigation Items
With CD1 I used to be able to get a list of all the items in the navigation bar for a course. In the CD2 documentation it says that I should be able to find this information in the Courses table... * tab_configuration (Annotated[bounded_str, JsonStringToJsonObject(), SpecialConversion()] | None) – A JSON serialized list…
-
Interpreting context_module_progressions in Canvas Data 2
We're doing some reporting on student progress in modules, and the data we see in context_module_progressions doesn't entirely match our expectations. * Sometimes a student enrolled in the course doesn't have a record in context_module_progressions. What determines when they get a record? * Some progress records have…
-
Join the Stepping Stones HigherEd Community: A shared LA curriculum
The Unizin Faculty Development subcommittee is thrilled to announce the launch of the Stepping Stones Community, a public Google Group. This community will serve as a hub for our HigherEd peers worldwide to connect, collaborate, and share resources related to the Stepping Stones learning analytics curriculum adoption and…
-
Analytics, report, missing assignments
When I use new analytics, go to run a report for missing work, is there a wat to set a date range? I know I can pull the data in to excel and sort, but is there a way to do this within Canvas?