topic Re: Export Assignment Standard Scores via PowerQuery in Community Forum

Export Assignment Standard Scores via PowerQuery

jlserpe — Thu, 15 May 2025 17:50:53 GMT

I am trying to export assignment standard score using a PowerQuery. All the fields I need are in the StandardGradeScetion table which are storecode, calculatedgrade, standardid, and studentsdcid. I need to include the assignment name associated with each score in the StandardGradeSection table.

I see that the AssignmentSection and Assignment tables have the Assignment name. Does anyone know what tables I need to join to the StandardGradeSection table to get to the assignment name?

Thanks

Re: Export Assignment Standard Scores via PowerQuery

Pamela329Lac — Fri, 16 May 2025 09:23:07 GMT

Hello!

To include the assignment name in your PowerQuery export, you'll need to join the StandardGradeSection table with the AssignmentSection and Assignment tables. The likely join path is:

StandardGradeSection → AssignmentSection (using standardid or studentsdcid as the key)

AssignmentSection → Assignment (using assignmentid as the key)

Re: Export Assignment Standard Scores via PowerQuery

jlserpe — Fri, 16 May 2025 14:11:34 GMT

Thanks for your quick response! In the AssignmentSection table (attached), I don't see either a standardid or studentdcid to join the StandardGradeSection to. Any suggestions what I am missing?

Thanks