• BLOG
  • ALL ACCESS
    • ALL ACCESS Login
    • Teachable Log in
  • PODCASTS
    • The Shake Up Learning Show
      • Listen
      • Subscribe
    • The Google Teacher Podcast
    • Kasey as a Guest
  • RESOURCES
    • AI Resources & Tools
    • Video Library
    • FREE Downloads
    • Choice Boards
    • Google Resources
    • Google Classroom
  • BOOKS
    • Blended Learning with Google
    • Google from A To Z
    • Shake Up Learning Book
      • Dynamic Learning Workshop
      • Book Study
    • Bulk Discounts
    • Learn More
  • WORK WITH US
    • About Kasey Bell
    • ALL ACCESS for Schools
    • Sponsorship and Advertising
  • CONTACT
    • Connect on Social
    • Copyright Policy
    • Privacy Policy
↑

Shake Up Learning

Empowering Educators with Time-Saving EdTech Tips, Tools, and Strategies

  • BLOG
  • ALL ACCESS
    • ALL ACCESS Login
    • Teachable Log in
  • PODCASTS
    • The Shake Up Learning Show
      • Listen
      • Subscribe
    • The Google Teacher Podcast
    • Kasey as a Guest
  • RESOURCES
    • AI Resources & Tools
    • Video Library
    • FREE Downloads
    • Choice Boards
    • Google Resources
    • Google Classroom
  • BOOKS
    • Blended Learning with Google
    • Google from A To Z
    • Shake Up Learning Book
      • Dynamic Learning Workshop
      • Book Study
    • Bulk Discounts
    • Learn More
  • WORK WITH US
    • About Kasey Bell
    • ALL ACCESS for Schools
    • Sponsorship and Advertising
  • CONTACT
    • Connect on Social
    • Copyright Policy
    • Privacy Policy

Empowering K12 Classrooms with Google Sheets (Part 1) – SULS0206

October 31, 2023 by Kasey Bell

  • Share
  • Tweet

Empowering K12 Classrooms with Google SheetsIn this episode, join Shake Up Learning team member Sarah Kiefer and me for Part 1 of an in-depth discussion on Google Sheets.

We dive into innovative approaches to harnessing the power of Google Sheets in K12 education.

We explore Sarah’s outstanding Google Sheets presentation, a tool crafted to enrich educators and students by strengthening their foundational grasp of Sheets and elevating their classroom learning experiences.

And stay tuned for Part 2 of this jam-packed series!

[ctt template=”1″ link=”hc7OY” via=”yes” ]Empowering K12 Classrooms with Google Sheets (Part 1)[/ctt]

Listen to the full podcast episode:

This episode is sponsored by Kognity.

I’m so excited to take part in Engage by Kognity happening on November 9th! This full-day online event is packed with inspirational speakers and great sessions. Engage is created for anyone and everyone involved in High School Science Education and offers three different session tracks. The Science Pedagogy track, the Elevate Teaching track as well as a Leadership track. Make sure to catch my session: The Teacher’s Guide to Choice Boards: Empower & Engage Students! Also, don’t worry if you can’t attend live, you’ll get access to the recordings as well. If you sign up at kognity.com/engage using my code SHAKEUPLEARNING you can attend completely for free!

Empowering K12 Classrooms with Google Sheets (Part 1)

Google Sheets is often overlooked by educators and students, but it has the potential to revolutionize the way we approach teaching and learning. In this episode, Sarah Kiefer shares her passion for using Google Sheets in the classroom and how it can be a game-changer. This blog post will take you through some key insights from the podcast and show you how to harness the full potential of Google Sheets in your teaching.

*Related: FREE Templates for Teachers: Where to Find Them and How to Create Them

Redefining Google Sheets

Google Sheets often conjures images of data collection and number crunching, which may not seem very exciting to most educators and students. However, Sarah Kiefer believes that Google Sheets can be a versatile and engaging tool for all ages. It’s not just about data; it’s about how you use it.

Sarah Kiefer had the opportunity to present on Google Sheets at a recent conference. Instead of creating a traditional slide deck, she decided to build her presentation entirely within a Google Sheet. This choice allowed her to showcase the versatility of Google Sheets beyond data collection. With this unique approach, she demonstrated that Google Sheets can be a dynamic tool for creating engaging classroom activities.

➡️ ➡️ Get a copy of Sarah’s Google Sheet! Template Link

Creating a Google Sheets Presentation

The presentation Sarah created within Google Sheets is a testament to the application’s capabilities. She started with a cover sheet that resembled a typical presentation slide. She merged cells, inserted images, and added links, showcasing that Google Sheets can be as visually appealing and functional as other Google applications.

Google Sheets for the Classroom Presentation

Mastering the Basics

Sarah understands that not everyone is familiar with the terminology and features in Google Sheets. That’s why she dedicated a tab to the basics, offering a comprehensive glossary of essential terms, toolbars, and tabs. This resource can serve as a cheat sheet for those new to Google Sheets or as a reference point for students.

Google Sheets Basics

*Related: 15+ Ways for Teachers to Use Google Sheets in the Classroom

Data Capture with Google Sheets

One common use of Google Sheets is data capture. Sarah shared a template used in her previous school district to collect and analyze data for incoming kindergarteners. The data capture sheet made it easy for teachers to input student information, and it could be accessed by grade-level teams and administrators. Google Sheets simplifies data management and provides a centralized location for collaborative efforts.

Data Capture Sheet

Google Forms Integration

Google Forms are often underutilized in conjunction with Google Sheets. Sarah highlighted the power of Google Forms for collecting data from students or team members. She emphasized the importance of planning your form to get the data you want and highlighted how Google Forms’ recent improvements make data visualization even more accessible.

Google Forms Collection

Expanding the Possibilities

While Google Sheets excels at managing data, it offers much more. The presentation explores advanced functions like personalized email, Flippity activities, and creating to-do lists within Google Sheets. These features demonstrate the endless possibilities of Google Sheets for classroom activities.

More Coming in Part 2!

We couldn’t fit it all into ONE episode and blog post, so don’t miss the second half of Sarah’s ideas and resources!

Unleash the power of Google Sheets in your classroom and see the positive impact it can have on teaching and learning.

Sarah KieferAbout Sarah Kiefer

Sarah Kiefer is a classroom technology teacher in a new district. She has spent the last 7 years supporting students and teachers use technology in meaningful ways and 14 years in the classroom before that. Sarah is a wife and mom to three daughters and blogs at www.TechYouCanDo.com.

Current Certifications: Google Certified Educator Level 1, Google Certified Educator Level 2, Google Certified Coach, Google Certified Trainer, Google Certified Innovator, Wakelet & WeVideo Ambassador; Mote Certified Educator; Master Screencaster.

Sarah’s most popular presentation topics: Google tools, Schoology, WeVideo, Wakelet

Work with us!– Bring Sarah or one of the Shake Up Learning Trainers to your school or event.

© Shake Up Learning 2025. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kasey Bell and Shake Up Learning with appropriate and specific direction to the original content on ShakeUpLearning.com. See: Copyright Policy.

  • Share
  • Tweet

Filed Under: Blended Learning, episodes, Free Resources for teachers, Google, Google Sheets, Inspiring Interviews, Shake Up Learning Show Podcast, Templates Tagged With: google sheets

SUMMER LEARNING SERIES
11 Bible Verses for Struggling Teachers
The best Learning books of all time

Brilliantly

SAFE!

shakeuplearning.com

Content & Links

Verified by Sur.ly

2022
  • Contact Shake Up Learning
  • Privacy Policy
Copyright ©2025, Shake Up Learning. All Rights Reserved.
Design by Pixel Me Designs
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT