To Our Amazing Educators Everywhere,
Happy Teacher Appreciation Week!
Attached Excel workbook is able to download data from Canvas (exclusively using Get API calls) to create an overview of all assignments in all courses you specify using Course SIS IDs.
The worksheet contains the following columns to be filled with data from the API as specified in Assignments - Canvas LMS REST API Documentation :
sis_course_code | assignment_group_id | only_visible_to_overrides |
course_code | due_date_required | locked_for_user |
workflow_state | max_name_length | lock_explanation |
course_name | turnitin_enabled | quiz_id |
ass. id | vericite_enabled | anonymous_submissions |
assignment_name | grade_group_students_individually | freeze_on_copy |
published | peer_reviews | frozen |
points_possible | automatic_peer_reviews | frozen_attributes |
description | peer_review_count | use_rubric_for_grading |
due_at | peer_reviews_assign_at | rubric_settings |
lock_at | intra_group_peer_reviews | rubric |
unlock_at | needs_grading_count | omit_from_final_grade |
submission_types | position | moderated_grading |
grading_type | post_to_sis | grader_count |
group_category_id | integration_id | final_grader_id |
has_overrides | integration_data | grader_comments_visible_to_graders |
course_id | muted | graders_anonymous_to_graders |
created_at | has_submitted_submissions | grader_names_visible_to_final_grader |
updated_at | grading_standard_id | anonymous_grading |
html_url | unpublishable | allowed_attempts |
submissions_download_url |
Analytics
On the Analytics tab a diverse set of calculations are present:
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 assignment details of all courses you specify
You can find Course SIS IDs:
In column A under sis_course_code you can enter a list of Course SIS IDs of which you want to receive details of the assignments:
The list of Course SIS IDs must be a consecutive list and also be part of the table which starts in cell A5.
When you have entered your list of Course SIS IDs to the first column, click Download data from Canvas to start the download progress. Any remaining data in the table from a previous run will be deleted from the sheet and any duplicates in the list of course SIS ID's will be deleted. The button Clear worksheet does the same regarding cleaning up the worksheet. It takes an average of one second per course to download the data. Clicking the Download data from Canvas button again before all the data has been downloaded will ask you if you want to abort the download.
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