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:
I have been teaching in a technology-mediated environment since the days of HyperCard and teach classes in history, online student success, and how to be a health care IT trainer. I am the distance education coordinator at Cosumnes River College and a facilitator for the Online Network of Educators.
In 2019 I was awarded Canvas Educator of the Year. Every day I learn more about Canvas.