I’m discovering not many teachers know multiple student sheets can be added to one spreadsheet. Due to the time it takes for setting this up I don’t recommend doing this for all Google Forms. However due to the nature of a reading log it is well worth taking the time to set up a sheet per student. The trick is you will need to create one Google Form per student, and then add a sheet into an existing Spreadsheet.

This is how to add multiple sheets to one spreadsheet

STEPS for ADDING MULTIPLE SHEET to a SPREADSHEET

• Open Google Form
• Click Response

• Click Change Response Destination

• Click New Sheet in Exisiting Spreadsheet

• Select the Spreadsheet

IF ALL GOES WELL YOU SHOULD HAVE MULTIPLE SHEETS IN ONE SPREADSHEET