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

Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d