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
    • Google Developer Expert
    • Developer Spotlight
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Make a Test
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Missing From (Google Forms™)
      • Fresh Form Tab
      • Bingo
      • CalAdd
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Audience Participator
      • Document Outline by Alice Keeler
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • GC Rubric
      • Add-a-Date
      • Clear Rectangle
      • DelCal
      • QuickShare Screenshot
      • Roster Extras for Schoolytics
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu

Category: Sheets

How Do You Highlight Cells of the Same Color

How Do You Highlight Cells of the Same Color

Posted on February 27, 2023February 27, 2023 by Alice Keeler

AliceKeeler Select the Cells is a Google Sheets Add-on designed to help teachers select cells with a background color more efficiently. With this add-on, teachers can single-click on any cell in a range that has a background color and automatically select all the other cells in that range with the same color. How Do You Highlight Cells of the Same Color

Read more

What! That is cool… Format Painter in Google Sheets

Posted on January 6, 2023January 6, 2023 by Alice Keeler

This is going to be amazing… and easy Use format painter in Google Sheets. It is truly fun to magically apply formatting in multiple places across your spreadsheet.

Read more

Sheets: Automating Sorting from Google Forms

Posted on January 5, 2023January 5, 2023 by Alice Keeler

If you use a Google Form and want to automate sorting in Google Sheets so that each time you open the spreadsheet you do not have redo the sorting here is a tutorial by Alice Keeler queen of spreadsheets.

Read more

How to Use XLOOKUP in Google Sheets

Posted on September 12, 2022September 12, 2022 by Alice Keeler

Do you have a table of student data and need to lookup the guardian name for example? In this how to use XLOOKUP in Google Sheets Alice Keeler shows you how to return values in a table based on a look up value.

Read more

How to Create a Spreadsheet in Google

Posted on August 25, 2022August 25, 2022 by Alice Keeler

Spreadsheets can be made using Google tools. If you wan to know how to create a spreadsheet in Google here are some tips from the Queen of Spreadsheets Alice Keeler

Read more

Bingo Ice Breaker with Alice Keeler

Posted on August 18, 2022August 18, 2022 by Alice Keeler

Have fun with a Bingo Ice Breaker! Try out this free Add-on by Alice Keeler to create a fun activity to get students or participants up out of their seats and getting to know each other.

Read more

FASTER! Create Rubrics for Google Classroom

Posted on July 28, 2022August 1, 2022 by Alice Keeler

Rubrics for Google Classroom are slow to create and hard to reuse. Try GC Rubric by Alice Keeler to create faster and better rubrics for Google Classroom.

Read more

Fast – Add Student Birthdays to Google Calendar

Posted on July 25, 2022July 27, 2022 by Alice Keeler

Add multiple Google Calendar events at once. CalAdd by Alice Keeler makes it fast to add student birthdays to Google Calendar. Or any list of calendar events.

Read more

How to Lock Areas of a Google Doc

Posted on July 12, 2022July 12, 2022 by Alice Keeler

You want to restrict editing on PART of a Google Doc. This step by step guide will show you a hack for how to lock areas of a google doc.

Read more

For Goodness Sake Only Put In Once in Google Sheets

Posted on June 17, 2022June 17, 2022 by Alice Keeler

The Rule of One! Only Put In Once in Google Sheets!! Here is how to handle if you need something twice or more in a spreadsheet.

Read more

Grab a Spreadsheet Cell from Each Student

Posted on May 26, 2022May 30, 2022 by Alice Keeler

Finally! A way to grab a spreadsheet cell from individual student spreadsheets. This allows you to easily review all students responses to a question in one place.

Read more

How to Update Student Spreadsheets

Posted on May 22, 2022May 22, 2022 by Alice Keeler

You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is how to update student spreadsheets.

Read more

Something Fun for the End of the Year

Posted on May 16, 2022May 17, 2022 by Alice Keeler

What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my template!

Read more

Collaborate with Students – reuse TemplateTab

Posted on May 13, 2022May 22, 2022 by Alice Keeler

Reuse TemplateTab to collaborate with students and have less paperwork to grade.

Read more

COUNTA in Google Sheets™

Posted on May 5, 2022May 5, 2022 by Alice Keeler

How to use COUNTA in Google Sheets. This helpful formula works differently than COUNT. I will explain how.

Read more
  • 1
  • 2
  • 3
  • 4
  • …
  • 23
  • Next
Alice Keeler is a mom of 5. High School math teacher. Author. Keynote Speaker/Teacher Trainer Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard

Find ALL My Blog Posts

Link to List

Google Classroom Books

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

My Referral Links

Sticker Mule: $10 Credit

BirdSend Newsletter

3 Months Premium Mote

©2023 Teacher Tech | Theme by SuperbThemes