Identify Assignments with Plagiarism Review

[jcoots]

Is there a way to identify assignments that have selected Plagiarism Review using Canvas Data?

[stimme]

Hi  @jcoots ‌, I have found this information using the requests table. It works once originality reports have been generated, because tools using the plagiarism framework make API calls to associate them with their submissions. You can find how many originality reports have been associated with assignments using something like

SELECT assignment_id
, COUNT(*) AS reports 
FROM requests 
WHERE http_method = 'POST'
AND web_application_controller = 'lti/originality_reports_api'
AND web_application_action = 'create'
GROUP BY assignment_id ;

Because the requests table gets so large, I also insert requests with 'originality_reports' in the URL into a separate table for speedy querying.

[jcoots]

Thanks heaps

[kylecage0]

I would like to know if there is a way to see a list of which assignments are using the Plagiarism Review setting without having to go into every assignment, click Edit, and scroll down to that section of the assignment settings. 

I would like to be able to see this BEFORE the students begin submitting their assignments so the requests table option that stimme proposed above would not work. 

[Jeff_F]

@jcoots  If the template model is used a keyword can be added to the assignment title or assignment description.  The title may be better as it is shorter and easier to filter.