Anyone have sql queries for clicks, views for assignments by college. And other metric queries for external ,tools used, submissions in a day by college. If you have a starting point of queries please help.
In the Canvas Data (2018-12-11) release, an identifier that is a reserved word in some systems (such as AWS Redshift) was introduced in some Outcomes Tables. The ‘percent’ column in the learning_outcome_result_fact and learning_outcome_question_result_fact tables can cause complications in your imports.
If you are using an SQL database where ‘percent’ is a reserved word you may want to consider using a different identifier for the column name. If you would like to use ‘percent’ as the column name, to resolve any resulting complications, escape the ‘percent’ columns in the learning_outcome_question_result_fact and learning_outcome_result_fact tables by putting quotation marks around the column names in your SQL queries and DDL statements.
The Version numbers were recently updated to accommodate some data type fixes with Outcomes data. ‘Precision’ was updated to ‘Double Precision’ for consistency with other data types in Canvas Data. Additionally, the Catalog data schema preview was rolled back because an invalid data was included.
We're proud to introduce a Canvas Network course being offered FREE by Jing Qi and Brian Reid of Dartmouth College. The course is titled "Analytics in Course Design: Leveraging Canvas Data," and will help faculty and instructional designers explore Canvas Data and visualization techniques to make informed decisions about Canvas course design.
Dr. Jing Qi serves as the LMS and Learning Analytic Specialist at Dartmouth College. She holds a bachelor's degree in Computer Science, and a doctorate degree in education. Using her solid background in computer science, extensive experience in educational data mining, and strong interest in data visualization, she integrates the core elements of learning analytics and instructional technology in the exploration of Analytics in Instructional Design.
Brian Reid, Ph.D
Dr. Brian Reid works as an Associate Director of Information Technology at Dartmouth's Geisel School of Medicine where he supports curricular applications. With a background in chemistry and educational technology, he has been creating data visualizations for three decades. Dr. Reid has written software to animate molecular motion, visualize mathematical models, plot biological and geological data, and simulate lab experiments. His most recent efforts have focused on visualizing curricular data at the Geisel School of Medicine.