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

5 Time Saving Tips for Teaching with Spreadsheets

Posted on October 6, 2020May 11, 2021 by Alice Keeler

It’s my birthday and everyone knows no one loves a spreadsheet more than I love a spreadsheet! Here are 5 things you can do with a spreadsheet that will save you time!

sheets.new
Copy Sample Spreadsheet

1) Automatic Numbering

Spreadsheets recognize a pattern. Highlight the pattern and grab the fill square to drag the pattern. The fill square is the small square in the bottom right of the highlighted section.

2) Split Text to Columns

How many times have you had a list of student names where the first and last name is together and you needed them split up? Highlight text and use the Data menu to “Split text to columns.” An option will come up next to the highlighted text to let you choose the separator. Usually this is the space between the first and last name. It might be a comma if you have last, first.

3) Hide the Timestamp

One of the best reason to use Google Forms… the responses can go to a spreadsheet. The timestamp when the Form was submitted is awesome, however, it is also takes up room. On the spreadsheet, hover over the column with the “Timestamp” and locate the tiny arrow in the upper right of the column indicator. Choose the option “Hide column.”

4) Freeze the Student Names

As you scroll to the right on a spreadsheet to review student responses to a Google Form you lose being able to see whose name is on the row. Freeze the column with student names so that when you scroll you always know whose work you’re looking at. I will hide the timestamp and the email address and then freeze the column to lock student name to the left of the spreadsheet. Use the View menu and choose “Freeze” to freeze rows and columns.

Alternatively, you can grab the freeze bar to the left of the Column A indicator. Your cursor changes into a grabby hand that you can drag the freeze bar over.

5) Use an Equals Sign

In any cell, type an equals sign and then click on another cell. This is called cell referencing. Whatever is in that cell… put it in this cell. If you are creating a spreadsheet template for students where they respond in different cells, try creating a sheet that has a list of all the student responses in one spot. No scrolling required!

You can use cell referencing across multiple sheets. On your “Answer sheet” sheet, type an equals sign and then click on the tab at the bottom where the first student response is. Click on the cell where the student would respond. Press Enter.

Want to Try a Spreadsheet?

Check out this spreadsheet I made for my students to practice using a spreadsheet. I have conditional formatting to allow them to create a Minecraft Creeper with pixel art. Then use the formula =COUNT(range) to determine how many cells there are in the graphic. =COUNTIF(range, criteria) indicates how many of each color are used in the graphic.

Count Up Checkboxes in Google Sheets

Related

Related Alice Keeler Blog Posts:

  1. Google Sheets: Edit in the Cell
  2. Add a Rubric to Google Classroom with Google Sheets
  3. SUPER COOL Badge Game Updates
  4. Make Tabs FAST in Google Sheets

Continue Reading

Next Post:
Google Classroom: Create an Attendance Check In and Schedule It
Previous Post:
Google Meet: Add a Jam

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