Yes! You Can Have One Sheet per Student in a Google Form Spreadsheet

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

Reading Log multiple students

STEPS for ADDING MULTIPLE SHEET to a SPREADSHEET

  • Open Google Form
  • Click Response

step 1

  • Click Change Response Destination

Step 2-2

  • Click New Sheet in Exisiting Spreadsheet

Step 4

  • Select the Spreadsheet

Step 5

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

Screen Shot 2015-08-24 at 10.35.34 AM

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s