templateTab: Collaborate with Students using Spreadsheets

templateTab
templateTab: Collaborate with Students using Spreadsheets

templateTab

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.
templatetab copy roster

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.
design graphic organizer in templatetab

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.
menu run template tab

templatetab one per student

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
blue share button

2) Click on “Get sharable link.”
get a sharable link

3) Click on arrow next to “can view” and choose “More…”
anyone with the link can edit go to more

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

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Discount applies until you cancel!! 
Normally $12 a month, save 58%!! 

Monthly installments of only $4.99 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.