Tuesday, February 12, 2019

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.

No comments:

Post a Comment