AnsweredAssumed Answered

How can I tell if an Attempt was created by the student or professor?

Question asked by km28576 on May 13, 2019
Latest reply on May 16, 2019 by km28576

I am working on a query to identify the last time a student submitted an assignment. I use the ATTEMPT table fairly heavily, but have discovered that if an instructor enters a grade of 0 for a non-submitted discussion thread, that gets recorded as an attempt with a grade of 0. When it is an assignment (other than a discussion) there is no attempt record created so it is not an issue for those.

 

Ultimately I need to know when the student last submitted something. Does anyone have a query that might help with this problem?

Outcomes