I know how to import a SCORM package into a Canvas course but what if a person loses their source course and only has the SCORM package thats in the Canvas course. Is ther a way to download it from Canvas?
... View more
Wish you could bypass requirements/prerequisites for a single student and give the student a zero or let the student go back later to complete the assignment? Using this hack, originally suggested by @tom_gibbons you now can! Problem If an Instructor is using requirements and prerequisites in their course and a students hasn't met all of the requirements for a Module then they can get locked out of the next Module (or content items). Technically an Instructor can have a student go back and submit the assignment or excuse the student from the assignment (enter EX in the gradebook), but what if the Instructor doesn't want the student to submit the assignment and instead wants to give the student a zero for the missing work? Or, what if the Instructor would like the student to be able to move forward, but still complete the missing assignments later? Solution If you are trying to bypass graded assignments (assignment, discussion, or quiz) that have a requirement (submit or score at least) here are the quick directions. Examples and the process is explained in more detail further down. Step 1: Excuse the student from the Module requirements that are blocking them from moving forward. This is done by putting an EX in as the grade for those assignments. Step 2: Refresh the page (Grades/Speedgrader) and then delete the EX grade so that it shows back up as blank for the grade. What this does is clear the requirement for the student. In addition, the grade for the assignment is now blank which allows the student to go back and submit the assignment later on or the Instructor to give the student a zero (for a zero see information below!). Step 3 (optional): If you would like to give the student a zero for the assignments you need to first excuse the student from all assignments that are blocking them from going on to the next Module. Then you can go back and give the student zero's on these assignments. If you don't excuse all of the assignments before giving the zeros then the next Module won't unlock. This gets especially tricky if you have it set that "students must move through requirements in sequential order" and also have required content that aren't graded assignments (Pages, Files, URL's). In this case you might need to work with the student to have them meet these requirements first before you excuse the graded requirements. Yet, ultimately it will still work (Yes, I played around with a number of scenarios to make sure!). Video The following video was made in response to a question (on 9/7/2017) about will just entering zero work to bypass the requirements and prerequisites. I show how entering zero doesn't work and how using the EX workaround does work - Bypassing Requirements and Prerequisites Examples The following are examples showing how this bypass would work in different scenarios. **Something that might help Instructors as they are using (and trying to bypass) requirements and prerequisites is to check a students progress through the Modules. See the following guide for more information - How do I use modules to view the progress of students in a course? Example 1: Only the graded assignments in the Start Here Module are required before students can get into the Week 1 Module. Students can work through the content in any order. Below is how the Module looks to the student; the red circles are because the graded assignments weren't submitted before the due date. This is the view after I go into the gradebook and enter an EX for the graded assignments in this Module. Notice the student can now access the Week 1 Module. This is the view after I remove the EX from the gradebook and make it blank instead. Notice that the graded assignments go back to being red (because they are overdue), but the student still has access to Week 1. If I now entered a zero for these assignments the student would still have access to Week 1 because it was already unlocked. Example 2: All content in the Start Here Module is required before students can get into the Week 1 Module. Students can work through the content in any order. There are graded and non-graded requirements. Below is how the Module looks to the student; the red circles are because the graded assignments weren't submitted before the due date. This is the view after I go into the gradebook and enter an EX for the graded assignments in this Module. Notice the student still can't access Week 1 because they still need to go in and "view" the "Read First" and "Course Resources" pages. This is the view after the student views the two required pages. Week 1 is now unlocked. **To make it easier it would probably work best if the student viewed the two non-graded assignments before the Instructor excused the graded assignments. This is the view after I remove the EX from the gradebook and make it blank instead. Notice that the graded assignments go back to being red (because they are overdue), but the student still has access to Week 1. **Important note, the student must meet all requirements for non-graded items before the Instructor switches the EX for the graded assignments to a blank grade. Otherwise the next Module will not unlock! Example 3: All content in the Start Here Module is required before students can get into the Week 1 Module. Students must move through the requirements in sequential order. There are graded and non-graded requirements. Below is how the Module looks to the student; the red circles are because the graded assignments weren't submitted before the due date. Notice the "Read First" page must be viewed before the student can access the "Course Resources" page. This is the view after I go into the gradebook and enter an EX for the graded assignments in this Module. Notice the student still can't access Week 1 because they still need to go in and "view" the "Read First" and "Course Resources" pages, which must be done in order. In addition, notice that even though there is a green check mark for the graded assignments, the student can't access them because the ungraded assignment requirements haven't been met yet. This is the view after the student views the two required pages. Week 1 is now unlocked. **To make it easier it would probably work best if the student viewed the two non-graded assignments before the Instructor excused the graded assignments. This is the view after I remove the EX from the gradebook and make it blank instead. Notice that the graded assignments go back to being red (because they are overdue), but the student still has access to Week 1. In addition, if the student was going to submit the assignments they would still need to do them in order. **Important note, the student must meet all requirements for non-graded items before the Instructor switches the EX for the graded assignments to a blank grade. Otherwise the next Module will not unlock! Considerations Depending on how they are set-up, bypassing requirements and prerequisites can sometimes be tricky. Yet, with the right combination of things I was able to bypass all of the scenarios I tried; I only provided examples for three, but I tested more than that. The biggest thing to remember though is that this is not an authorized Canvas work-around. This is a hack that was figured out in response to a need that Canvas hadn't allowed for in their normal programming. Because this is ultimately a hack it could stop working at any time if Canvas was to update/change something. So enjoy the ability to bypass requirements and prerequisites, but know it could potentially go away at any time and with no warning!
... View more
Over the past few months, I've helped answer a handful of questions re: people wanting to set up a campus club or group in Canvas that lives outside of any course. The club/group isn't tied to any one course. For example, we have a Multicultural Club, an Auto Technicians Club, an Accounting Club, and a Chiropractic Specialist Club (to name a few) in our Canvas instance. In order to set this up, you need to have Admin access to your Canvas instance. If you don't have this kind of access, speak to someone who is at your school. Here's what you get: Home, Announcements, Pages, People, Discussions, Files, Conferences, and Collaborations. Here are the steps to setting this up: Go to your Admin Pages (Managed Account) of Canvas. Go to your Admin Pages (Managed Account) of Canvas. Click People on the left nav. On the upper right corner of the screen, click on the More People Options (three dots) button. Select View user groups. Click the + Group Set button to name your group set (for example, "Clubs"). Click the + Group button to add the name of a group within that Group Set. Begin adding people to the Group by clicking on the round + icon next to the name of the group. You can search for a person's name or their e-mail address. Click on the cog wheel to set the Group Leader. At this time, there can only be one Leader per group. Keep in mind that if you have the same person in multiple groups, it will be necessary to first create an additional Group Set (step #5) since an individual cannot currently be assigned to two or more Groups within the same Group Set.
... View more
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.
MS Office 2010 on MS Windows (tested on 2010 version 14.0.7184.5000, higher versions work most likely, but are not tested)
MS Office 2011 on Mac OS X (tested on 2011 version 14.7.3. Excel 2016 for Mac barely supports VBA and is therefore not supported)
Enable editing and content
In case Excel displays the following warnings, enable editing and content for the Workbook to work properly:
First fill in the settings:
the Canvas url of your institution (e.g. https://yourinstitution.instructure.com )
an API access token (check How do I obtain an API access token for an account?)
Download the details of the sections
find the course ID of the course in the address bar
fill in the Course ID in the worksheet at cell B2 (e.g. 200)
click the button Download sections from Canvas to create the sections report
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
enter a name for the groupset (one that not yet exists) at cell E2
for each group to be created, enter unique names in the yellow column. Optionally use the shortcuts fro choosing the groupset name + section name or only the section name Tip: if you want to fill all the cells with the same structure of names, drag the corner of a cell to auto fill
Check all the details before you proceed (you can only create a new groupset with groups using this workbook, updating an existing groupset is not possible)
Click the button Create new groupset in Canvas
1.0 (march 16, 2019)
1.1 (December 16, 2020)
Updated the processing of API pagination (Instructure changed the method regarding the enrolments API) to accommodate for both the old and the new method.
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.
Disclaimer: use this workbook at your own risk (I cannot be held responsible for any undesired consequences). This Excel workbook only reads from Canvas AND never writes to Canvas. It should not have any negative effect on Canvas in terms of integrity or performance.
First try it on your test environment https://yourinstitution.test.instructure.com (slow performance is expected and may cause time-out errors) before using it on production
Always check the results in Canvas or in case your student(s) get accounted for their activities in groups as Canvas is the most reliable source
Suggestion: save the workbook as a template (xltm file) after entering the settings so you can always start with a fresh and clean workbook so you will be prompted to save it. Keep in mind that if you don't save the file in a macro-enabled workbook format (xlsm), running the report again will not work any more as it requires the macro functionality to run.
I created this workbook largely in my own spare time (for fun, to learn, to help, to share and because I can), so huge amounts of support can't be expected
Leave your comments in case you are using it, if it makes your work easier or more fun
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.
Automated progress report of students in modules
Automated report of assignments in courses
Automated report of group sets, groups and members in a course
Download data to Excel using VBA and the API (workbook with code attached)
... View more
Have you ever wanted to do a live demonstration of New Analytics with a real course but couldn't because of student privacy issues? Fake students in a fake course don't generate realistic usage. New Analytics pulls information from the production instance so you cannot hop over to beta and change the names. Making a video and blurring out names doesn't have the same impact as presenting live. What can one do?
I've written a Firefox browser extension that anonymizes the user's name, email, sortable name, short name, and optionally removes the avatars so that you can give a live demonstration without worry about accidentally showing student information. The extension is loaded temporarily so that New Analytics reverts back to normal after restarting Firefox.
... View more