9 STEPS
1. Open your Google Sheet. Click and highlight the area you want a specific student to edit (if you want the student to rank their confidence, as in this example, you'll need to select those cells too).
2. Click Data
3. Click Protected sheets and ranges o
4. Click Set permissions
5. Click Enter names or email addresses and enter the email address of the student you want to be able to edit this cell.
6. Click Done
7. Click Close (in this case, the student was not added as the email used was fake. You should see the student's name / picture under "choose who can edit" at this point.
8. Click and highlight the next cells you want to give a student access to and repeat this process. It is labor intensive to start, but once set up, could easily be reused over the course of the year.
9. That's it. You're done. Now only specified students can edit specified parts of your google sheet.
