We even put in some conditional formatting to change the color of the students' responses so at a glance the teacher can get a good read on how students think they're doing. We talked about sorting the data to clump a student's responses together so sorting columns. But then another colleague showed me a Google Sheets add-on he uses called RowCall that looks at your data, finds a common denominator, like a student's name, and creates a new tab on the bottom of the sheet with all of that student's data. He uses it for his bathroom pass so he can quickly see how many trips a student has been taking to
Even slicker is the fact that the newly tabbed sheets will update too with new data.