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 Spreadsheet: Copy To

Posted on December 17, 2013 by Alice Keeler

If you are like me, you love Google Forms. I dislike collecting papers so as much as possible I collect work and information from students using a Google Form. All of the responses go to an easy to evaluate spreadsheet. Grading bliss!

It is now the end of the semester and I have a LOT of spreadsheets. In looking for evidence of student work and progress over the semester I look through the spreadsheets to capture one part of the picture for each student.

One Spreadsheet to Rule Them All

Create a new spreadsheet to collect the evidence from the other spreadsheets.

Arrow on the Tab

From the spreadsheets of student data you will want to send the tab of data to your “master spreadsheet.” Hover over the tab and notice a small arrow shows up. Click on the arrow to reveal a menu of options.

Copy To

Choose “Copy to…”

Copy to will send a copy of the tab to a different spreadsheet. Doing this for each spreadsheet will collect all of your data in your “master spreadsheet.”

Word of Caution

If your spreadsheet has formulas that link to other tabs (such as a pivot table) the copied tab will not work in the “master spreadsheet.”

In the case of a pivot table or other formulas, create a new sheet in the original spreadsheet.

On the tab of data click on the “awesome box.” The “awesome box” is located to the left of the column and row indicators. Clicking on the “awesome box” will cause the entire sheet to be selected.

Copy the entire sheet (Control C on a PC, Command C on a Mac.)

On the new sheet right click in cell A1 and choose “Paste special” and “Paste values only.”

This creates a sheet of the data but strips the formulas. You can then “Copy to…” this new tab of static data to the “master spreadsheet.”

Related

Related Alice Keeler Blog Posts:

  1. Collaborating on Agenda Template
  2. Google Classroom: Sorting Student Scores by Student Last Name
  3. Gamification: Creating a Level Up for Your Students
  4. Elise Legaspi Shares How She Uses TemplateTab with Students

Continue Reading

Next Post:
Google Spreadsheets: Transpose in 2 easy steps
Previous Post:
5 Chrome Extensions for Teachers – Part 5

2 thoughts on “Google Spreadsheet: Copy To”

  1. Pingback: 07: 2015-03-03 CI100 | CSUF CI 100 Keeler
  2. Pingback: 07: 2014-03-03 CI225 | CSUF CI225

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