Assignments via Google Forms and Canvas Grades

[ProfessorBeyrer]

I use a Google Form for assignments where I want students to have a choice on how to complete it and if I want more control over what students submit than is allowed with Canvas assessment options. The challenge I have with entering data into the Canvas gradebook is that the list of students in Canvas does not match the list of entries on the Google Sheet where form results are collected. This has been bugging me until I figured out how to use the SIS ID as a sort key in both locations.

This works for me because my college is a Google Suite for Education client, we use single sign-on, and our students' Gmail addresses begin with their student ID number.

In the embedded video I show how to make the SIS ID appear in the Canvas gradebook and sort by that field. I also show how to sort the Google Sheet by email address:

[nm2234]

needs to be taken out of this crooked context and run a while forth rite denial going on here?