cancel
Showing results for 
Search instead for 
Did you mean: 

Assignment Counting

Jeff_F
Community Champion
0 0 177

Back at the start of the year I had the idea to repurpose some of the reports we had previously created to support our residential campuses.  This included a modified version of an early warning report which attempts to identify at risk students vis-à-vis course score, the number of zeroes, discussion participation, and course inactivity.  While we had been using Tableau, we elected to recreate this using the Oracle Business Intelligence tools due to higher license availability.  This way also enabled us to access data within our SIS including student program, minor, etc. and could then use these as filters.  Use of this report has taken off and is helpful for all the various advising and student-success teams.

But in order to fully use and benefit from such an early warning report an instructor must first use Canvas for assignments, set due dates, point values, assignment group weighting, etc.  To help with this I created the following two dashboards to see where assignments are created.  And where they are not. The results can also be summarized to create a visualization.

 

No Assignments w/ # Total EnrollmentDetailed Assignment Counts

Fields:

  • Term                           
  • Submission Types (filtered for Null)
  • Campus                     
  • College                      
  • Workflow State (Course Dim)
  • Canvas Id
  • Code
  • # Tot Enrl (Canvas)
  • Sect.
  • Course URL
  • Faculty Name
  • Email
  • Day of Last Activity At

Fields:

  • Workflow State (Course Dim)
  • College
  • Code
  • Canvas Id
  • Course URL
  • # Tot Enrl (Canvas)
  • Faculty Name
  • Email
  • Day of Last Activity At
  • # Online Upload
  • # Disc.
  • # Quiz & Surveys
  • # External Tool
  • # No Submission Assign.
  • # Other Submission Types
  • # Total of All Assignment Types
  • Sect.

 

The counts of assignments by types can be created a number of ways.  Here is one method for the major types:

  • COUNTD(IF [Submission Types] = 'online_upload' THEN [Id (Assignment Dim)] END)
  • COUNTD(IF [Submission Types] = 'discussion_topic' THEN [Id (Assignment Dim)] END)
  • COUNTD(IF [Submission Types] = 'online_quiz' THEN [Id (Assignment Dim)] END)

Or if you just want a total:

  • COUNTD(IF [Submission Types] != 'null' THEN [Id (Assignment Dim)] END)

----

I am sharing to demonstrate a use case of Canvas Data. Perhaps others have this question as well.  I hope it gives you a few ideas.

Have a wonderful day ~!

Tags (2)