Group assignments - Identifying non-submitters

Hi,
We're just looking into building an Insights/Domo report to identify students that have not submitted assignments. We use Release Conditions and Special Access so in order to work out who hasn't submitted we need to know who is eligible to submit, so this is not necessarily every student on the Class List. We can work this out for Individual submissions but for Group Assignments, only students who are enrolled in a Group which belongs to the Group Category that is linked to an assignment can see the submission box and submit, so these are the eligible students. Unfortunately I can't find anything in the DataHub relating to Group Categories.
Has anyone had this issue and overcome it?
Looks like the other option might be via API as this does seem to know about Group Categories.
Thanks,
Tim
Comments
-
If I am understanding the goals correctly, it seems the available DS are missing two, if not more elements. The Assignment Summary DS doesn't include which group category is selected for a group assignment. And the Enrollments DS or Organizational Units DS doesn't include any reference to group categories (only the groups inside the category). One brute-force method might be to rename all the group codes such that they contain reference to the specific course and group category. Then use the enrollments DS to find students enrolled in specific groups and parse the group code to pull reference to the course and category. Then also co-op the Assignment category to also include reference to group category code (or this could be hidden in the assignment instructions instead at the very end). Not a very scalable approach I imagine, and prone to data entry errors. Hope the API approach offers something more stable.