D2L Brightspace Tips: Mastery View of Learning Outcomes Data Export and Pivot

If you are using the Standards tool with Learning Outcomes in your D2L courses, the Mastery View in the grade book does not currently have an export option. To generate a CSV file of the data in this view, use this SQL code with the Outcomes data sets in Analytics Builder, adjusting it where needed to work with your institution's data.

Pivot Mastery View Data

Once you have exported the data from Analytics Builder, the following video shows how to pivot the data so that it matches the Mastery View table in D2L. Students are in rows, outcomes are in columns, and the mastery levels are the values.

Creating a PivotTable in Excel with text-only data is possible, but there are several extra steps. You must create a table from your data and add it to the Data Model, then add a Measure in the PivotTable. This is only possible with the Windows version of Excel using an Excel (not CSV) file.

Direct link to Outcomes Data PivotTable to re-create Mastery View video

Formula from video: =CONCATENATEX(Table1,Table1[MasteryLevel])

A Python script to pivot the data without using Excel can also be downloaded.