SOMETHIN' TO TECH ABOUT
  • Home
  • Blog
  • About
  • Remote Learning
  • PD and More
    • PD Menu
    • Summer PD
  • Wakelet
    • Newsletter
  • Store
    • Free

Blog

Google Sheets - Your Data Powerhouse

9/6/2019

0 Comments

 
Google Sheets - Your Data Powerhouse
Google Sheets often gets a reputation for the “difficult” or maybe the “least used" app in G-Suite waffle.  But that doesn’t need to be the case all the time! In today’s episode we will share ways students and teachers currently use Sheets in the classroom and then ways you can tech it up a notch when it comes to your knowledge and usage of Google Sheets. 
We are excited to  haveEmily McDonald as today's guest from Chattanooga, Tennessee! 


Emily and her dog, TrigEmily and Trig

​Emily McDonald is a high school mathematics teacher at Red Bank High School in Chattanooga, Tennessee. RBHS is a Title 1 school that is 1:1 with Chromebooks. Emily currently teaches Algebra 2, Calculus, and Dual Enrollment Probability & Statistics. Emily enjoys incorporating technology to promote creativity and exploration in mathematics. Emily is a Level 1 and Level 2 Google Certified Educator and a Google Certified Trainer. Other certifications include EdPuzzle Coach, CK-12 Certified Educator, Screencastify Certified Genius, and EquatIO Level 1 Certified User. Emily has presented at several EdTechTeam Summits in the southern region as well as other regional and state professional development conferences. 
Twitter: @EMcDonaldEDU 
Email (personal): mcdonald.emily.ann@gmail.com 

Episode notes:

Ways Educators Can Benefit from Google Sheets:
  • Tips from Emily  - New features in Sheets
  • Add a class roster, then use Check Marks to keep track of  beginning of year forms and other ungraded items.
  • Organize, sort, and filter test score data.
  • Create  charts and graphs with ease.
  • Freeze rows and columns to work with large data sets. 


Using Google Sheets with Students:
  • Self paced learning activity (could be used for PD with adults as well!)
  • Track scores over time  - students track their own keyboarding data - make a copy and edit to suit your content.
  • Manage a budget - a student activity facilitated by Emily - make a copy for your students. 
  • Create Pixal Art using Conditional Formatting


Tech it Up a Notch - Google Sheets Tips:
  • Use Scripts to send specific email to multiple recipients - Scripts Example
  • Explore the Add-ons Menu and use Sheets to automatically create flashcards, certificates of completion or PD attendance, send confirmation email, manage badging  and more!
    • Autocrat
    • Flippity
    • Form Mule
    • Magic Digital Badges


Share your Google Sheets ideas, successes,  and templates in the comments below.  Would you like to be a guest on our show?  Complete this Google Form and you might join us in a future episode of Somethin To Tech About!

0 Comments



Leave a Reply.

    Categories

    All
    Blog
    Chrome Browser
    Chrome Extensions
    Communication
    Digital
    Digital Writing
    Feedback
    Google Docs
    Google Drive
    Google Sheets
    Grant Wiggins
    G Suite For Education
    Guest
    Helpful Hacks
    John Hattie
    Podcast
    Podcast PD
    Remote Learning
    Student Choice
    Top 20

    Archives

    November 2020
    October 2020
    September 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019

    RSS Feed

Somethin' to Tech About - a weekly podcast featuring ideas, resources, templates, and more for ​building digital evidence of active learning.
​ 

Subscribe to Newsletter
Somethin' To Tech About,LLC  - © 2019
  • Home
  • Blog
  • About
  • Remote Learning
  • PD and More
    • PD Menu
    • Summer PD
  • Wakelet
    • Newsletter
  • Store
    • Free