Count assignments using Turnitin external tool

Jump to solution
Community Explorer

Most of our external tools are activated at the root account level. The question I have been asked is how many assignments use a particular external tool (in this case, Turnitin). So there is an assignment and the instructor has set the submission type to External Tool and chosen Turnitin from the list.

I've looked at the assignment_dim table and can see the submission_types column so I filter on the 'external_tool' value. But I cannot figure out how to identify which external tool the assignment uses.

Does anyone know how I can find out using Canvas Data how many assignments use a particular external tool?

1 Solution

I was looking through this today and filtering for only external_tool submission types will return more results than just turnitin enabled assignments if your institution uses more than just one LTI as a source to submit to. In Canvas Data, we are missing a field titled external_tool_tag_attributes which would provide the URL for the external tool. If we were provided this, then you could filter off that URL if it contains "turnitin".

Since this is present currently only in the Canvas API, I have just created a feature request for the data team to add the external_tool_tag_attribute fields to Canvas Data.

TL;DR you can find turnitin enabled assignments through the API, but not through Canvas Data at this point Smiley Sad

View solution in original post