To set your Canvas url and the API key, click on the Settings button and fill in the required fields.

It is up to you to add code to populate the areas where the headers and the data need to go. The purpose of this workbook is to offer you the ability to extend the code to download other course and student related data as documented in as you see fit.ĭata of the students are populated in the left two columns and the remaining available data is added in the cell comments. You can set your Canvas url and API key in a secure way and it enables you to download a list of students in a course.

You can even build a template and send it to your teachers and tas, so the only thing they have to do is to click a button to update the data (without compromising the security of the API key).Īttached macro enabled Excel workbook contains the VBA code to download data using the Canvas API. In this case a VBA enabled Excel workbook template like Automated progress report of students in modules comes in handy. Lets say students need to complete a course with modules as a prerequisite for another course, your teachers may want to periodically check their progress in these modules. Instead of working with csv files, downloading data directly from Canvas into Excel with a click of a button can be a huge advantage.

This is all great, but updating it periodically may require quite some manual work each time.Īdditionally this may be too difficult and time consuming for teachers and tas. In most cases you want to apply some analysis of that data, which may require importing it into excel, sorting and filtering data and create formulas and graphs to create some sort of a dashboard. Meant to run manually from available macros via the Developer tab.

Excel for mac vba 201