These Python scripts clean and format data in reports downloaded from Brightspace by D2L or Insights Report Builder.
Merges the exported classlist CSV and the export history CSV of an intelligent agent from D2L. The export history does not include usernames or email addresses, while the classlist export only can include usernames and/or email addresses (if enabled by admins). If only usernames are included, this script formats the email addresses properly, including if guest accounts with various domains are used. Output columns are Last name, First name, Email address, and if the user was identified in the intelligent agent (True or False).
Excel workbooks for adding usernames/email addresses to an intelligent agent export history are also available using formulas or Power Query.
The manual way of joining intelligent agents and the class roster using Power Query in Excel is shown in this Intelligent Agents video.
Pivots the data in a learning outcomes data set generated in Insights Report Builder 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. The data flow for generating the outcomes CSV file is available from the brightspace-etl-dataflows repository.
The manual way of creating the text-only pivot table in Excel is shown in this Outcomes data video.
Pivots the data in a Survey report (individual attempts) of Likert questions downloaded from D2L so that the questions are in columns instead of in rows. If there are multiple attempts on the survey, the responses are averaged.
The manual way of cleaning the data and creating the pivot table in Excel is shown in this Survey Report video.