Draft and Published assignments both logged with AssessedDate in Outcomes Demonstrations data set?
I'm trying to get the last 5 assessed activities aligned to outcomes and the students' levels out of the data sets, so I can recreate the Mastery View in D2L. I can re-create the regular Mastery View with the overall levels, but now I need to get the activities/levels that feed into the overall.
I am almost able to re-create the data, except there is an issue with assignments that are listed as Draft Saved instead of Published. Either way, a date gets logged in the AssessedDate column in the Outcomes Demonstrations data set, which I am using to pull out the last 5 assessed activities (by ranking by date).
Is there a way to distinguish which are draft and which are actually published (and therefore will show up in the Mastery View) within these data sets?
TLDR - How can I distinguish between draft and published assignment submissions in the data sets for Outcomes?
Best Answer
-
Found the answer to my own question. I have to use the IsGraded column in the Assignment Submissions data set for Published (True) vs. Draft (False) vs. not even touched yet by the instructor (null).