Google Sheets has many features that make it ideal for curation and organization of information. Here are some ideas for educators to think about as they begin to use Google Sheets in the classroom.

1. Gradebook

Easily organize and access your grades anywhere with Google Sheets!

  • Create graphs for individual students that you can share with students or parents.
  • Use functions to figure out your final grades
  • Using conditional formating to visually organize your data

2. Organize Resources

Since you can easily incorporate hyperlinks into a Google Sheet, you can gather resources for your students and keep it one central location. Using the formatting features and multiple sheets allow you to create a document that’s easy and clear for students to navigate.

3. Create Flashcards

Use Flippity.net to create flashcards or have students create their own to help them review. Take some time to explore Flippty, there are other programs there to try too!

4. Explore and Share Graphs

Students can collect data, determine how it should be organized in their sheet and then use the chart feature to create a graph that best fits their data. The graphs can then be easily shared on a class webpage, wiki or blog, where students can share their findings and conclusions with others.

5. Use Templates

There are a variety of templates already created for teachers to make your life a little easier! You’ll find gradebooks, attendance sheets, schedules and more in the template gallery.

To learn about all of the features that make these projects possible in Google Sheets, sign up for PLP’s self-paced eCourse today!

Google Sheets for the Connected Classroom

As classrooms are becoming more connected, and teachers are collaborating with each other all around the world, it’s become easier than ever to collect and compare data!

Google Sheets allows you to easily collect and compare your data. You can create one sheet, share it worldwide with your collaborators, and everyone can view and edit the document all at the same time.

Think about how interesting that would be for your students – to be viewing a document and at the same time, someone from the other side of the country — or the world — was interacting with the document and making edits. It’s a pretty powerful feeling for kids.

 

Google Sheets for the Connected Classroom

The collaboration features of Google Sheets really set this tool apart from other spreadsheet tools.

Not only can students collaborate from all over the world – they can collaborate right inside your own classroom. Let’s say you’re doing a science experiment – you could have four different groups at four different stations all conducting their experiment, yet sharing the same document at the same time, adding their data as it’s happening.

Hi, I’m Jennifer Bloomingdale, a Google For Education Certified Trainer and educational leader, and I want you to join me for a self-paced course, Google Sheets for the Connected Classroom.

During the Google Sheets for the Connected Classroom course, you’ll learn:

  • The basics of starting a sheet
  • Editing
  • Collaboration features
  • Ideas for classroom integration

 

You’ll also do assignments that allow to practice your skills with Google Sheets, while at the same time, thinking about how to use this tool in your classroom or with your students.

I can’t wait to show you all that Google Sheets can do to make your life and your teaching practice easier.

Specific topics to be covered include:

Introduction

What is Google Sheets and what is the value of creating and organizing your data in the cloud?

How-To

Learn how-to use specific features of Google Sheets such as creating and editing a spreadsheet, incorporating graphs and using add-ons.

Google Sheets in the Classroom

Discover resources and ideas for using Google Sheets in the classroom and as a professional.

Enroll now

Create and organize your data in the cloud using Google Sheets.

Get expert guidance from Google For Education Certified Trainer Jennifer Bloomingdale.

Instant access, $29.

About The Instructor

Jennifer Bloomingdale

Jennifer Bloomingdale

Google For Education Certified Trainer, Course Instructor

Jennifer Bloomingdale graduated from the College of St. Rose in 2006 with a Bachelors in Childhood Education. In 2011 she completed her Masters in Educational Technology and became a New York State certified Educational Technology Specialist.  Jennifer has four years of elementary teaching experience, which includes implementing a 1:1 netbook initiative. It was through her teaching experience and masters program that Jennifer developed a passion for integrating technology and assisting others in doing so. She has been an eCourse facilitator at Powerful Learning Practice for three years and is a Google For Education Certified Trainer. You can follow Jennifer’s blog here.

Frequently Asked Questions

How is the material presented?

This self-paced course is a mixture of videos, written content, worksheets, downloadable goodies, and more.

Is this a “live” course? Can I take it whenever I like?

This course is an asynchronous, self-paced learning opportunity. You can review the content whenever you like. Each lesson has video instruction, resources, a practical example, and a “take action” at the end.

When will I have access to the course content?

You’ll get instant access right after we securely process your payment. You then have access to the course material forever.

How do you handle payments?

Payments are securely handled through Stripe. We accept Visa, Mastercard, Discover, or American Express. If you need to pay with a purchase order, enroll in bulk, or want us to create a custom bundle for you, contact us.

Can I register multiple people in this course like a school or district?

Absolutely. We give significant discounts for bulk registrations. Please contact us to make an arrangement for your staff, school, or district.

Money Back Guarantee

You might be concerned that these courses won’t work for you. We get that. We offer a no risk, 60-day money back guarantee. If you don’t like the courses, if you feel like you already know the material, or if you just change your mind, we will refund 100% of your money for the first 60 days upon completion of an exit interview so we can learn how to make it better next time around. Do you have questions about this offering? Please contact us!

Money-Back Guarantee

Enroll now

Create and organize your data in the cloud. In this course you’ll see how easy it is integrate Google Sheets into the classroom and have your students become pros at collaborating.

Get instant access and expert help from a Google For Education Certified Trainer for just $29.

Need to pay with a purchase order? Or maybe you want to enroll more than one teacher, your staff, your whole school or district? Or maybe you want to create a custom course bundle? We can do that! Contact us and we’ll get you set up in a hurry.

The following two tabs change content below.
During a 25-year education career, Sheryl Nussbaum-Beach has been a classroom teacher, technology coach, charter school principal, district administrator, university instructor and digital learning consultant. Sheryl is the co-founder and Chief Executive Officer of Powerful Learning Practice, where she works with schools and districts from around the world to re-envision their learning cultures and communities through the Connected Learner Experience and other e-learning opportunities. She is the author (with Lani Ritter Hall) of The Connected Educator: Learning and Leading in a Digital Age (Solution Tree, 2012) and serves on the ISTE Board of Directors.
Share this: