Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu

Google Sheets: Students Send Tab of Work to Teacher

Posted on July 27, 2015July 29, 2015 by Alice Keeler

One of my favorite tools to teach with is Google Sheets. I create spreadsheets to crowd source information from students, which gives all students 30x more research information to work with. I create spreadsheets to have class discussions. This gives every student a chance to voice their ideas and for students to hear from everyone. A template for this is alicekeeler.com/discussionTab.

Having all students on one spreadsheet makes it easy for me to check the work of all the students. This is one document to open! Try alicekeeler.com/rostertab to quickly create a tab for each student in one spreadsheet document.

TurnInTab

One question I sometimes get is how to keep students from editing the work of other students or how to keep students from viewing the word of other students. I created TurnInTab to help with this issue.

In a nutshell, TurnInTab allows students to do their own work on their own spreadsheet. When they are done working on the spreadsheet, their tab of work is sent to the teachers spreadsheet. This creates one spreadsheet for the teacher to assess with all the students work.

Directions

I typed up the directions into a Google Doc. You copy the teacher template. The script generates a student template that you share with the students. Students check in their spreadsheet before they start to work and turn in their spreadsheet when they are finished with their work.

Click Here for the directions and template.

Related

Related Alice Keeler Blog Posts:

  1. Google Forms: Streamline your Data with FilterRoster Script
  2. Connected Educator Game
  3. Google Classroom: List ALL Your Student Files
  4. Create a Google Drive Folder for Each Student

Continue Reading

Next Post:
Google Sheets: 3 Add-Ons to Try
Previous Post:
Google Classroom: Sharing or Submitting a Google Drive Folder

1 thought on “Google Sheets: Students Send Tab of Work to Teacher”

  1. Hugh says:
    August 16, 2015 at 9:03 am

    Alice, Terrific idea. I just tried this and it will be great to have students working independently without getting distracted by what anyone else is doing. It will also give me more flexibility than using a form for certain assignments because students lose what they typed in forms as soon as they submit it, right?

    Also, is there ANYTHING similar for use with google slides? Could I have each student work independently on a class slideshow and then reveal the final product with all 30 + slides later in the period.

    Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

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

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes