Assignment Counting

[Jeff_F]

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 Enrollment	Detailed 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 ~!