Quiz Availability Dates

Blog Post created by fernerj@erau.edu Expert on Mar 11, 2018

This Tableau workbook provides a report that details the status of quiz availability dates within courses. This is primarily used to confirm settings for midterm and final exams prior to the term start. If the availability date is specified, the report shows that date under 'Unlock At (Quiz Dim)'.  Otherwise, this column shows 'null'.  Included in the report is a red x mark for when there is no 'available from' date set and a hyperlink that points to the quiz page.  


availability dates



Computed columns:



Midterm or Final

(Quiz Type)

IF CONTAINS([Title (Assignment Dim)],"Final")then "Final"
ELSEIF CONTAINS([Title (Assignment Dim)],"Midterm")then "Midterm"
ELSEIF CONTAINS([Title (Assignment Dim)],"Mid-term")then "Midterm"
else "" END

Quiz Date Set?

IIF(ISNULL([Unlock At (Quiz Dim)]), 'Date Not Set', 'Date Set')

Assignment Link

'https:// xyz.instructure.com/courses/'+ STR([Canvas Id (Course Dim)]) + '/assignments/' + STR([Canvas Id (Assignment Dim)])


IF [Crse No.] < '500' then "UG"



Data source tables and filters:


data source



Important notes:

  • Our Sis Source Id field from the course_section_dim is split into six parts in order to create fields for our Term, Course Prefix, Course Number, Section, Location code, etc.  You will likely need to rework this if you intend to use the attached Tableau workbook as a starting point. 
  • The report is published to Tableau Online and the quality team uses this as part of pre-term checks.
  • Upon opening the .twb file in Tableau, you will be prompted to provide a password to access the data source.  Because you don't have access to our data source, you'll need to click on the "Edit Connection" button.  Once the connection information is updated to access your Redshift data source you should be able to begin editing the workbook.  See attached files for information on connecting to other data sources.



We thank the Canvas Data team for their support and welcome all suggestions and derivative works.