Skip navigation
All Places > Instructional Designers > Blog > 2016 > April > 12

While it's awesome that Canvas can import SCORM files (thank you!), it can be frustrating if you want to see the learners' responses and not just a final score. Here's a pretty cool work around. It requires jQuery and a Google spreadsheet, but I'm not a coder and I found it to be fairly simple.

Take a look: Here is the elearning module (SCORM file) and here is the Google Spreadsheet that the answers feed to. My example-SCORM file is not in Canvas, but it can be as it works the same way.

 

I found the instructions on eLearning Heroes, this is Articulate Storyline's community.

 

A couple of things I have learned:

  • Only text variables will feed to the spreadsheet. quiz question responses, T/F variables, and number variables wouldn't feed for me. Also, it needs to be an original variable. In other words, it can't be a variable set to equal another variable.
  • If you want to feed quiz questions to the spreadsheet, just set a variable to adjust according to the quiz question response. If you need help with this, let me know I'd be happy to share a template.
  • Use the Google spreadsheet template provided in the instructions. It has the correct code in the Script Editor and makes life a lot easier.
  • Don't forget to make your spreadsheet public.
  • Double and triple check that your variables, JavaScript, and column headers are identical. They are case sensitive.

I can't think of any other roadblocks I ran into, but I'd be happy to help if you get stuck.

 

 

Source: elearning Heroes Blog: Bastiaan Timmer's post, Articulate Storyline: Export to Google Drive

I had an instructor ask me recently whether it was possible to create an assignment in the Grade Book via an Excel upload. I couldn't find an answer by searching the community, so I tested it out myself. I figured that I should share the results of my testing and the steps for anyone who might be interested.

 

Note:

This is probably best for an on-ground or hybrid course since the assignment is created in Canvas as a "no submission" assignment by default.

 

Steps:

  1. Export current gradebook
  2. Add a column to your file
  3. Add a title for the assignment and points possible in the appropriate fields
  4. Input student grades for assignment (if you don't have grades available yet, type a space into the field; you'll get an error message if you don't put anything in the field)
  5. Save your file as a .CSV
  6. Import file into grade book (note: you will be prompted to confirm that you are creating a new assignment)

 

Good luck!

Filter Blog

By date: By tag: