Attached Excel workbook is able to download data from Canvas (exclusively using Get API calls) to create an overview of all group sets, its groups and its members in a course.
Group sets and groups are displayed (vertically) in column A and B (see Settings).
Additional information received from Canvas (for each group set, group and member) is available via cell comments (raw data delivered via the API).
In case Excel displays the following warnings, enable editing and content for the Workbook to work properly:
First fill in the settings:
To start downloading
In the top-left corner the download progress is displayed in percentages.
To cancel the download process click the button Download data from Canvas again (only while download progress is less than 100%, otherwise downloading would start again).
If in Settings, Content column B can be set to blank, but if a type of content is selected, an extra column containing that information is added:
If in Settings, List groups is set to Horizontal, group sets and groups will be displayed in row 5 and 6 respectively instead of column A and B:
Group leaders will be displayed in italics.
To easily distinguish the group members, the cell background colour can be set as default in cells I2 and J2.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.