How to Report on Students Who Have Not Submitted Assignments?

Question

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!

Steve.B.446 · Accepted 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.