MiVideo: Export Interactive Video Quiz (IVQ) Scores and Import Into Canvas Gradebook

Environment

Canvas
MiVideo

Issue

The MiVideo quiz score was not sent to Gradebook. Grade passback will not occur if the quiz is not published in an Assignment (eg was published in Media Gallery instead), the quiz was embedded as a thumbnail embed, or there was an LTI issue that prevented the passback.

Resolution

How to manually export scores from quiz analytics and import into Gradebook.

Only media owners and co-editors can view quiz results.

  1. Go to the Gradebook in your course and filter by the quiz assignment.
  2. Click Export. > Export Current Gradebook View.
  3. Open the Gradebook CSV file.
  4. Delete all columns except
    • Student
    • ID
    • SIS User ID
    • SIS Login ID
    • Section
    • the column that contains the assignment name
  5. Delete row 2 containing Points Possible.
  6. If on the spreadsheet, delete the Test Student row.
  7. On the SIS User ID column right click > Format > Custom > 00000000
  8. Navigate to Account > My Media > click the analytics icon next to the media item, or navigate to the Media page > Actions > Analytics.
  9. Select the Quiz Users tab.
  10. Export last attempt. 
  11. Open the analytics CSV file. 
  12. Copy and paste the entire sheet into a new tab in the Gradebook export CSV.
  13. The analytics CSV shows the scores as a percentage. If your assignment has a point value:
    1. Create a new column without a title in the Gradebook CSV file and copy the scores from the Final Score (Latest) % column from the analytics CSV into this column. You will want to use an XLOOKUP function similar to =XLOOKUP(D2, 'Sheet1'!A:A, 'Sheet1'!H:H, -1) (https://support.microsoft.com/en-us/excel/functions/xlookup-function).
    2. Click G1 (the column containing your copied scores) and Sort > Largest to Smallest.
    3. Delete all rows that have a score of -1.
    4. In the the column that contains the assignment name, use a function to convert the percentage into points similar to =score/assignment point value.
  14. If your assignment has a percentage value, 
    • Copy the scores from the Final Score (Latest) % column from the analytics CSV into the column with the assignment name. You will want to use an XLOOKUP function similar to =XLOOKUP(D2, 'Sheet1'!A:A, 'Sheet1'!H:H, -1) (https://support.microsoft.com/en-us/excel/functions/xlookup-function).
    • Click F1 (the column containing your copied scores) and Sort > Largest to Smallest.
    • Delete all rows that have a score of -1.
  15. Save the Gradebook CSV. 
  16. Go back to Gradebook and click Import.
  17. Upload the Gradebook CSV file and click Upload Data.
  18. If the CSV has an untitled column, Canvas will want to know what to do with the column, select Bogus ignore it and Continue.
  19. Canvas will show what the grades will look like, click Save changes.

Resources and Questions

For additional questions, please contact the ITS Service Center.

Print Article

Related Services / Offerings (1)

This service is U-M’s cloud-based media streaming service. This content management service helps organize, catalog, share, search, and publish multimedia content.​​​​​​​This form is for MiVideo customers to request assistance