To Our Amazing Educators Everywhere,
Happy Teacher Appreciation Week!
Attached Excel workbook is able to download details of the course sections and create a new groupset with groups of your choice.
Details of the course sections will be displayed in the columns A to F (see green arrows) after downloading from Canvas using the button Download sections from Canvas. Th columns G to K (see purple arrows) are meant for the groups. The yellow column can be manually filled in with the desired group names for the groups to be created. Clicking the button Create new groupset in Canvas will start creating the groups and add the students from the respective sections.
Note: When students are added to groups, they may receive notifications of new group memberships in case you use it on your production environment in courses which are published.
Compatibility
Enable editing and content
In case Excel displays the following warnings, enable editing and content for the Workbook to work properly:
Settings
First fill in the settings:
Download the details of the sections
To start
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).
Enter the groupset name and the group names
Versions history:
Performance
In case you experience extremely slow performance (a minute per row or so) to the point that Excel is freezing, then make sure the Windows Defender Antimalware Client version is at least 4.18.2102.4. You can check the version on your device following this guide How to Find the Microsoft Defender Version Installed in Windows 10.
Remarks
Download
Download the latest version of this file from this Google Drive folder.
Do not open in Google Docs nor in MS Office online, because that will not work, just first save the file and then open it in the Microsoft Excel application.
Additional tools
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
An amazing Instructure Community member!
To participate in the Instructure Community, you need to sign up or log in:
Sign In