cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ChadWhite
Community Member

Assessment reporting & API Canvas

Jump to solution

Hello all, We are new to Canvas and are hoping the community can assist with enhancing the Assessment reporting from within Canvas. We would love to hear how others have developed Assessment reporting dashboards by trainer & Course. Any  suggestion - Admin 

Labels (3)
2 Solutions
jerry_nguyen
Community Contributor

@ChadWhite 

You can run SQL queries on Canvas Data (https://community.canvaslms.com/t5/Admin-Guide/How-do-I-use-the-Canvas-Data-Portal-for-an-account/ta...)

I have designed reports for things like pending grading, overdue assessments, identify students at risk by the number of pending submission and the last submission date, etc.

If you're interested and have access to Canvas Data, I can share my SQL queries for you to get started. 

 

View solution in original post

jerry_nguyen
Community Contributor

Here are samples of some of the reports I have developed

- Module progression report. This report shows the status of student's module (Whether they've completed all the requirements)

Canvas_Data_Sample_Report.jpg

- Student's overall progression. This report shows % of submitted assessments and last time they access they system

Canvas_Data_Sample_Report_1.jpg

- At-risk students report based on the number of overdue assessments vs class end date

Canvas_Data_Sample_Report_2.jpg

- Ungraded assessment list.

Canvas_Data_Sample_Report_3.jpg

View solution in original post

14 Replies
jerry_nguyen
Community Contributor

@ChadWhite 

You can run SQL queries on Canvas Data (https://community.canvaslms.com/t5/Admin-Guide/How-do-I-use-the-Canvas-Data-Portal-for-an-account/ta...)

I have designed reports for things like pending grading, overdue assessments, identify students at risk by the number of pending submission and the last submission date, etc.

If you're interested and have access to Canvas Data, I can share my SQL queries for you to get started. 

 

Hi Jerry, 

That would be absolutely awesome, to get an insight into the SQL reporting you have already completed would be great.

Many thanks for sharing.

 

jerry_nguyen
Community Contributor

Here are samples of some of the reports I have developed

- Module progression report. This report shows the status of student's module (Whether they've completed all the requirements)

Canvas_Data_Sample_Report.jpg

- Student's overall progression. This report shows % of submitted assessments and last time they access they system

Canvas_Data_Sample_Report_1.jpg

- At-risk students report based on the number of overdue assessments vs class end date

Canvas_Data_Sample_Report_2.jpg

- Ungraded assessment list.

Canvas_Data_Sample_Report_3.jpg

Hi

I particularly interested in creating weekly UNGRADED ASSESSMENT reports to manage the trainer assessor workload can you advise how you gained this data 

Look forward to hearing from you 

@YvetteBender 

You can discuss with your CSM to gain access to Canvas Data. Basically, there are ways

  • Paying for hosted service

If you're not tech-savvy, this will be the easiest way to get the report. Your data will be hosted externally (E.g. on Amazon Redshift data warehouse). From my understanding, Canvas will handle the whole ETL process (Extract, transform, load) data from Canvas to the hosted database. You can then use any open database connectivity (ODBC) analytics tool to generate custom data visualization and reports. You can read more on Pros & Cons of using this service here: https://community.canvaslms.com/t5/Canvas-Data-Users/To-Redshift-or-Not-to-Redshift-that-is-my-quest...

  • Self-host (No extra cost from Canvas) 

You can set up a local server to download raw data from Canvas, import it to a database (E.g. Postgres, MySQL) then you can run any SQL queries to generate your custom reports. Send me a PM if you want to go down this path, I can assist you with it.  

Hi @jerry_nguyen 

This is amazing!! Yes, would you please share your SQL queries and a brief walkthrough on how to host locally to import to Postgres?

0 Kudos
jerry_nguyen
Community Contributor

@kc800 

  1. Firstly, you will need to set up a Linux machine (E.g. through Virtualbox)
  2. Setup local database and create schema https://community.canvaslms.com/t5/Instructor-Discussion/Our-Canvas-data-journey/td-p/87378
  3. Use canvasDataCli to download and unpack data (Providing that you already had access to Canvas Data): https://community.canvaslms.com/t5/Canvas-Data-Users/How-to-Use-the-CLI-Data-Tool/ta-p/421486
  4. Import data to the database: https://community.canvaslms.com/t5/Canvas-Developers-Group/Managing-Canvas-Data-with-Embulk/ba-p/272...

You can find the query for ungraded list attached below

 

 

Thanks Jerry 

Can we please contact you direct? 

Yvette Bender and Chad White 

Forsythes Training 

0 Kudos

@YvetteBender 

Yes, you can send me a private message with your details.

0 Kudos

Hello, Jerry!

Is there any way you can share the SQL's with me?  I am the Online Academic Counselor at Franciscan University and we just switched to Canvas. Having a report system like this would be amazing. Thank you so much!

0 Kudos
jerry_nguyen
Community Contributor

@DIRWIN45 

You can find the ungraded submissions SQL that I shared on the previous page

0 Kudos
LeisaRobson
Community Participant

@jerry_nguyen Hi there!  Were you able to customise reporting? I have information that led me to believe customised reporting wasn't an option

0 Kudos

@LeisaRobson you can run your own report with Canvas Data (which you have to set up outside of Canvas). You can contact your CSM to get access to Canvas Data

0 Kudos
adamwarecs
Instructure
Instructure

@jerry_nguyen - Awesome work legend!

0 Kudos