Easy STEM Olympics Activity: How to Create a Graph with Google Sheets

Hey, just so you know … This post includes affiliate links. That means if you use them to make a purchase, I may earn a commission. You can read my full affiliate disclosure HERE.

Let's be real, my friend. We homeschool moms like to turn whatever we can into an educational experience, right? With the Olympics fast approaching, we've got the perfect chance! And, this Olympics activity for kids will teach your kids some math and technology skills.

Tackling Phys Ed is a given because you're learning about different sports. And you can totally cover geography by learning about the different countries competing. History? No problem…just learn about the ancient Olympics. And there are plenty of notebooking and lapbooking options to practice writing.

But, how about techin' your Olympics study? Have you considered ways to reach STEM standards by learning about the upcoming Olympics?

Try out this STEM activity from the Olympics Online Unit Study. By tracking medal standings during the Olympic Games, your family will learn about spreadsheets and graphs. Check it out!

Olympics Activity: Create a Medal Results Graph

To create your graph, you'll need a Google Drive account and a basic understanding of Google Sheets. You can learn more about using Google Sheets HERE.

To complete this project:

• Sign up below to get your copy of the “Olympics Medal Results” spreadsheet template and add it to your Google Drive.
• Choose at least 5 countries that you'll track medals for during the Olympics. Type them into the Column 1.
• Daily check the Olympic medal count HERE.
• Update your spreadsheet for the medals won by your chosen countries. Input the results in the appropriate column (gold, silver or bronze). Add onto the number each day so it shows the total medals won.
• Notice how the graph on the right changes as you input data.

 

To get your Olympics Activity spreadsheet template, enter your contact info below and I'll send it to you.

I'll also send you periodic emails with digital learning tips and inspiration.

Know that your info is safe with me. I won't share it with anyone or spam you ('cause that would be downright rude). You can check out my privacy policy HERE.

Get your template

 

 

Loading…

 

Thank you!

Check your email for your template.

You can create other graphs about the medal standings. Watch the video below explaining how to create graphs with Google Sheets. Then experiment with your spreadsheet to add some new graphs.

Looking for more activities to learn about the Olympics? Check out the Olympics Online Unit Study.

With this online course,  your family will discover the history of the Olympics, study Olympic traditions, and “meet” inspirational Olympics. You'll learn what it takes to be an Olympian, watch your favorite events in current Olympics and keep track of winners. Then create a collection of online puzzles/games as a final project.

BOOKS FOR KIDS ABOUT THE OLYMPICS

100 Greatest Moments in Olympic HistoryThe Olympics: Ancient to ModernAncient Greece and the Olympics: A Nonfiction Companion to Magic Tree HousePhysical: Feats and Failures (TIME FOR KIDS® Nonfiction Readers)

MORE TUTORIALS FOR DIGITAL STUDENT PROJECTS

• Techie Homeschool Project: Virtual Art Gallery
• Techie Homeschool Project: Illustrated Quote Graphic
• Techie Homeschool Project: Animated Photo Showcase

Want some techie homeschooling tips and inspiration delivered to your inbox? Sign up here for weekly-ish emails from me.

Techie Homeschool Mom is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. You can read my full affiliate disclosure HERE.