Empowering K12 Classrooms with Google Sheets (Part 1) – SULS0206
The post Empowering K12 Classrooms with Google Sheets (Part 1) – SULS0206 appeared first on Shake Up Learning.
In 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!
Empowering K12 Classrooms with Google Sheets (Part 1)
Click To TweetListen to the full podcast episode:
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 (embedded below). 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.
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.
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.
*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.
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. amzn_assoc_tracking_id = "onamzshauplea-20";amzn_assoc_ad_mode = "manual";amzn_assoc_ad_type = "smart";amzn_assoc_marketplace = "amazon";amzn_assoc_region = "US";amzn_assoc_design = "enhanced_links";amzn_assoc_asins = "1735601829";amzn_assoc_placement = "adunit";amzn_assoc_linkid = "1ce5fc5690dbd8854e38ad67ff9acaab";
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. amzn_assoc_tracking_id = "onamzshauplea-20";amzn_assoc_ad_mode = "manual";amzn_assoc_ad_type = "smart";amzn_assoc_marketplace = "amazon";amzn_assoc_region = "US";amzn_assoc_design = "enhanced_links";amzn_assoc_asins = "1946444693";amzn_assoc_placement = "adunit";amzn_assoc_linkid = "466c832d7f153310abe0b1338c2e19df";
More Coming in Part 2!
We couldn’t fit it all into ONE episode and blog post, so stay tuned for next week’s episode and 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.
About Sarah KieferSarah Kiefer is a Technology Integration Specialist. She spent 14 years in the classroom and now supports two elementary buildings and helps teachers & students use technology in meaningful ways. 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 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 2023. 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.
The post Empowering K12 Classrooms with Google Sheets (Part 1) – SULS0206 appeared first on Shake Up Learning.
