Champlain College developed a Course Analysis Tool to be used in our QA process for online courses. The tool is built entirely on top of Google Spreadsheets and pulls data directly from Canvas via the API. We will present the features of the tool and share it with participants.
Presenter: Josh Blumberg - Champlain College
Location Map & Room: SILVERADO 1
Login to "Add a comment" below!
Hope everyone enjoys the presentation.
To use it:
1. You will need to make your own copy of the spreadsheet.
2. In your own copy, follow the instructions on the ReadMe tab
3. Don't share you spreadsheet with anyone... even colleagues. It is very important to keep your Canvas API Token secure.
Hope you enjoy, drop us a note if you find a creative use for it or if you make any cool additions!
@jblumberg Thank you again for a great presentation! When we QA courses, we also check our courses in various supported browsers on various supported platforms (such as Firefox on the Mac and Windows, etc.). Does this tool have a way to do that? If not, is this something you all check another way in your QA process?
I would suggest that you work to identify what causes issues in some browsers versus others. It would be extremely tedious to test every page of every course in every browser. If you can identify those elements likely to cause problems than the course analysis tool may be able to help!
Once you have identified the html likely to cause a problem, add it to the search tab... now you can search for pages containing this search term. When found, there is a link in the spreadsheet right back to the course... this can save you time in your testing by directing you to the affected pages only.
For instance, I have '<iframe src="http:' as a search term... this will look for iframes that don't have the https... it also takes advantage of the fact that the WYSIWYG modifies your html moving the 'src' attribute to be the first attribute automatically.
Not a perfect solution... but it may help.
If you do find some helpful search terms, please share them here... I am very curious to see how other institutions end up using the tool!
Instructure changed some of their code for pagination again... this broke the tool. A fix is already posted, but if you have a copy already, then just get yourself a new copy here (same link as before):
p.s. Anyone at Instructure want to mention to the engineers to stop tweaking the way pagination of API calls works (All that was changed is the word "link" became "Link" ... capitalization)!
We don't use many quizzes in our online courses so we didn't add a separate tab for quizzes.
It would be a good thing now that I look at it. All of the settings for a quiz are nicely returned by the API. It would look a lot like the discussions tab does, there are a bunch of settings for quizzes that would be nice to check for consistency.
It wouldn't include any information about what questions are part of the quiz. From what I can tell, I can't see a current way of getting this from the API (strange!).
I'll add this to the backlog for the next time we do a bigger overhaul of the tool.
That would be awesome. We look at the settings to ensure that instructors are using the best settings to ensure security. This alone would save me hours. The question information is not as important for what we do.