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 Google Sheets Functions to Know

Posted on April 1, 2022April 1, 2022 by Alice Keeler

My motto: “The answer is always a spreadsheet.” Here are 5 formulas that can help you get more out of using Google Sheets.

Make a Copy of Sample

1. Month()

I use Google Forms, which means I have Google Sheets with a timestamp. The problem is that the timestamp contains the date and the time which makes it hard to count how many were submitted on a particular day. Use =Month(A2) and =Day(A2) to get the month and day

Want More Help with This? Become a Premium Member

$12 per Month: Cancel Anytime

2. Unique

I use a Google Form to record students going to the bathroom, or checking out books, or so many things! The students very well might fill out the same Form more than one time. In the spreadsheet, I have a list of all the times a student went to the bathroom, but how do I know which students used the restroom? Using the formula =UNIQUE() I can condense a lengthy list to remove repeated values.

3. GoogleTranslate

Here is a function you will not find in Excel. Sometimes you are in need of translating multiple things for parents or students. Use =GOOGLETRANSLATE(A2) to translate whatever language is in A2 into English. English is the default translation.

Try my Template

I have created a template using the =GOOGLETRANSLATE formula so that whatever language is typed into column A it will automatically translate into “all” languages. (all supported by Google Translate). Suggestion to delete the columns you do not want to translate into.

alicekeeler.com/translatechat

4. RandBetween

I personally use this a LOT. It allows me to generate random numbers for a variety of purposes. =randbetween(1,30) lets me choose a random student on my roster for example.

5. Filter

Sometimes you want to display information, perhaps from a Form, in a filtered view. If multiple teachers use the same Google Form for passes then you may want to only see the list of students who were sent to you.

Use spreadsheet formulas
  • [Template] Translate Meeting Chat to ALL Languages
  • Embrace Cheating Tools
  • Coding Google Apps – Get Started
  • You Can Copy Paste, So You Can Code
  • 5 Basics to Know for Coding

Related

Related Alice Keeler Blog Posts:

  1. 8 Google Forms Formative Assessment Tips
  2. 4 Tips for Sorting in Google Sheets
  3. Gamify Your PD: Badges and Level Up
  4. Google Sheets: Create Tabs Quickly

Continue Reading

Next Post:
Google Docs: Pinning Table Headers
Previous Post:
Start Grading – Faster in Google Classroom

You must log 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