Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

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.

💥 FREE OTIS WORKSHOP

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

Join Alice Keeler for this session as we learn how to revolutionize your assessment strategies. We will dive into the essentials of crafting high-quality rubrics that go beyond traditional scoring methods to offer rich, meaningful feedback. We’ll learn about the components of an effective rubric and how to mathematically ensure the accuracy of your assessments.

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