Custom Rubric Dataset with Assignment Title & Instructor Feedback – Need Help with Table Connections

Alena.R.854

Hello,

I'm working on creating a custom rubric dataset that includes some information from the advanced rubric dataset and additional fields like instructor feedback. My goal is to be able to link rubric data to the assignment title to track rubric usage, grades, and feedback from different course sections.

Here's where I'm stuck:

1. I don’t see a field that connects the rubric data to the assignment ID (DropboxID or assessmentID, etc), which makes it difficult to link rubrics back to specific assignment titles, especially since the same rubric is used for multiple assignments across various sections within a course. I see that Rubric tables have ActivityObjectID but I can't find how this connects to the DropboxID..
2. Without being able to use advanced dataset in the QuickSight, I'm unsure which tables or fields to use to make these connections, particularly with assignment IDs/titles.

Has anyone found an effective way to make these connections, or could anyone point me towards the relevant tables/fields that might enable this link?

Thank you!

Jennifer.W.973

@Alena.R.854 Hi Alena, the ActivityObjectId in Rubric Assessment can be joined to DropboxId in the Assignment data sets. You can see which rubrics have been added to a course just using the Rubric Objects data set since it has an OrgUnitId field; but it looks like in order to see which activities (assignments, discussions, etc.) the rubric has been added to, the rubric needs to be assessed for at least one user - and then it will appear in Rubric Assessment so you can join it back to the other activity data sets using ActivityObjectId.