Having all the students answer on one spreadsheet

You start with this spreadsheet:

Go ahead and enter the names in the first column (you don't need

email addresses since you can share this as edit in Google Classroom).

Then go ahead and create a template- what do you want the students to have?

It doesn't have to be an image (as in my example) you could provide questions

or prompts.

Once you run the Roster Template, this is is what you get:

You will get a tab for each student complete with the drawing you shared.  

While I used a fairly simple one, you could ask the students to expand their

thoughts. I think this would be great to use for younger learners.

For complete directions (as well as a copy of the first spreadsheet), please

see Alice Keeler’s blog post here.