templateTab

I love spreadsheets and I love students collaborating. This comes together by using Google Sheets spreadsheets.

Template

alicekeeler.com/templatetab

Roster

After making a copy of templateTab, paste your roster into column A. I recommend that you have a spreadsheet in your Google Drive that has a list of your students names and email addresses. This makes it easy to copy and paste your roster when you need it.

Graphic Organizer

The second tab in the spreadsheet allows you to design a graphic organizer. A copy of this graphic organizer will be made for every student. This will be in the SAME spreadsheet.

Run templateTab

Use the menu to run templateTab. This creates a named sheet for each student on the roster. Each sheet is a copy of the graphic organizer.

To see a sample Click Here.

Google Classroom

After running templateTab attach the file in Google Classroom as “Students can edit file.” This immediate allows all students in the class to collaborate on the document. Students can protect their tab by clicking on the arrow on the tab and choosing “Protect sheet.”

Not Google Classroom

If you are not a Google Classroom user, change the sharing settings on the document to “Anyone with the link can edit.” Distribute the link.

Steps

1) Click on blue share button

2) Click on “Get sharable link.”

3) Click on arrow next to “can view” and choose “More…”

4) Click on “On – Anyone with the link” and then change from “Can view” to “Can edit.”