How to Report on Students Who Have Not Submitted Assignments?
Hello,
I'm working on an important report for our academics that needs to show a comprehensive list of students and their assignment submission status (Submitted/Not Submitted).
The Challenge
The core issue we are running into is with the Brightspace datasets themselves:
The data only includes records for students who have actually submitted an assignment.
If a student has not submitted, they are entirely absent from the underlying dataset.
Current Report Limitation
Because of this limitation, my calculated field for "Submission Status" can currently only show "Yes." We cannot accurately identify or report on the students who have not yet submitted, as they are simply not present in the data to begin with.
Request for Guidance
Has anyone found a robust workaround or an alternative method within Brightspace to generate a complete class list against an assignment submission status?
We need a way to integrate the full list of enrolled students with the submission data so we can accurately report the "No" status.
Any suggestions on best practices for tackling this data gap would be highly appreciated!
Best Answer
-
I'm not sure what platform you are using to aggregate this data, but for most tasks you are going to need to join multiple tables together.
In this case, you would probably start by joining Organisational Units on to Assignment Summary, then join User Enrolments (this gives one row per student per course per assignment) and left join the Assignment Submissions table on to it, so any non submissions have those fields empty.
Answers
-
Thanks so much, Steve!
This works perfectly, and I was able to generate my complete report. I really appreciate your help getting this sorted out.
(Just to confirm, I used Domo for generating this report.)