remove_red_eye 1.7K
page background

Google Sheets

Self-Paced Professional Development Course

Google SheetsSelf-Paced Professional Development Course
zoom_out_map

What is Google Sheets?

Google Sheets is an online spreadsheet program incorporating the basic features of Microsoft Excel or Apple Numbers, but adding real-time collaboration and sharing options that make it a great classroom and professional tool.

How can I use it to enhance & transform my classroom?

  • Take collaboration to a whole new level!

    • Create spreadsheets and share them with your students or colleagues, choosing whether they can edit, just comment on it, or only view it.

    • Students can create spreadsheets individually, collaborate with classmates in real-time, and/or share them with you for review.

    • Eliminate compatibility frustrations caused by differences in software programs and devices. Everyone can use Google Sheets.

    • Access from any internet-capable device any time.

    • Ensure all collaborators are doing their part by referencing the revision history of the spreadsheet.

Self-Paced Training Self-Paced Training

Things to Read and Watch

Sheets – Google Apps Learning Center

Create and simultaneously edit spreadsheets with your team, right in your browser.

launch apps.google.com

Google Spreadsheets Beginner - YouTube

Google Spreadsheets for Beginners

launch youtube.com
Google Share Settings
View and edit your files offline
4 Fabulous Google Sheets Add-Ons for Teachers
5 Tips for Using Google Apps on the iPad

5 Tips for Using Google Apps on the iPad

Google and Apple are two very different ecosystems. Both provide great technology and digital tools for use inside the classroom and beyond. When these two worlds collide, they offer a powerful toolbox for educators giving you the best of both worlds.

launch shakeuplearning.com

Learn by Doing

Google Sheets - Things To Try Checklist

Google Sheets - Things To Try Checklist

launch docs.google.com
Google Sheets Cheat Sheet.pdf

Google Sheets Cheat Sheet.pdf

launch drive.google.com
zoom_out_map

Implement

  • Use Google Sheets with your students and/or colleagues.
  • Be sure to use the features that are unique to Google Sheets: sharing or collaboration and using at least one Add-On.
zoom_out_map

Get your badge and PGP Certificate!

Complete the form below to show what you've learned and accomplished! Once reviewed, you'll receive your badge and PGP certificate.


2 PGPs


(Sorry.... these are only available to Southwest Parke staff.)

Google Sheets Course Completion Form
zoom_out_map

Additional Resources

Video Tutorials

  • Google Sheets Tutorial Series (Sethi De Clercq)

  • Google Spreadsheet Basics (neiltoupin)

  • Making Charts in Google Spreadsheets (Chad Kafka)

  • Add-Ons for Google Docs & Sheets (Google)

  • *How to Use Spreadsheets in Google - The Apps Show (Google)

  • *Add Custom Dropdown Menus to Google Sheets (The Gooru)

  • *Tips & Tricks for Making the Switch - Sheets (Google)

*These videos demonstrate more advanced features of Google Spreadsheets


Helpful Links & Info

  • Description of Share Settings

  • Lesson Plans Using Google Sheets (Teachers Pay Teachers)

  • Flippity.net - Turn Google Spreadsheets into Flashcards, A Random Name Picker Jeopardy-Type Quiz Game, or Certificates

  • 5 Tips for Using Google Apps on the iPad

  • Accessing Your Files Offline


Documents & Templates
  • Google Sheets Quick Start Guide

  • Google Sheets Cheat Sheet For Teachers & Students (Kasey Bell)

  • You can now access common templates from the sheets.google.com

  • Find more templates here


Experienced Users

  • SWP Hall of Fame


Sharing Ideas

  • Google Pinterest Board

  • Find or Create a Lesson Flow

zoom_out_map

Rachel Porter

I'd love to help you become more proficient with Google Sheets. Contact me with questions specific to your classroom!

Email: porterr@swparke.k12.in.us
Website: awakenlearning.net
Phone: (765) 569-2073
Twitter: @mrsporterDCIS

Loading indicator

close
Powered by