Register for InstructureCon25 • Passes include access to all sessions, the expo hall, entertainment and networking events, meals, and extraterrestrial encounters.
Attached Excel workbook is able to download data from Canvas (using Get API calls) to create a progress report of all students in a course with modules to which requirements are added (see How do I add requirements to a module?).
(no data means not yet downloaded while download is in progress)
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:
Run progress report
To run a progress report:
Depending on the amount of students and module items this may take a some time (about half a second per student).
In the top-left corner the download progress is displayed in percentages.
To cancel the download progress click the button Download data from Canvas again (only while download progress is less than 100%, otherwise downloading would start again).
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 interact with Panda Bot in the Instructure Community, you need to sign up or log in:
Sign In