Advanced Forms and Sheets Lesson Ideas

Share:

Google Forms and Sheets are fantastic, because there is just so much you can do with them.  Not only can they be well utilized by the tech novice, but they also have a whole array of features to take advantage of when you are ready to do something a little more advanced.

First off, here are a few resources to help you be the expert your advanced students need:

Sheets Lesson Topics

Pixel art with Google Sheets is definitely a fan favorite.  The first time trying this type of project you might give students an already formatted spreadsheet so they can just get started. Walk them through making something simple like “Creeper” from Minecraft, and then let them choose between 5-10 patterns.  It’s great to have some simple patterns and some complex ones, so they can pick depending on their comfort level. Practice conditional formatting, changing colors, resizing cells, inserting sheets, removing grid lines, moving sections of cells, etc. Then you can let them loose to search for patterns so they can do whatever they want. If they search for “Perler bead patterns” they are guaranteed to find something that inspires them!

Do a project that involves making and sticking to a budget.  This will help your students learn more about formulas such as auto sum and multiplying quantity x item price and for a grand total.  This can be done around so many different themes! Consider budget projects for:

  • Clothing
  • Toys
  • Birthday parties
  • Camping trips
  • Christmas shopping

Try the m&m project. Supply each student with a small bag of m&ms, and have them start by recording the quantity by colors. Then they make a copy of the sheet and create formulas to total colors, average colors, and create charts. After their work is done they get to eat the m&ms!

In another version of this idea, you let students survey their classmates (favorite ice cream, color, video game, etc.) and tally the responses on a paper data sheet. Then they enter the data into Google Sheets and create a chart using their results.

Forms Lesson Topics

Try having your students make Choose Your Own Adventure type stories.  

Making their own quiz games is always fun too! Kids can do academic subjects, trivia or whatever else they want.  Go through How to Create a Self-Grading Quiz in Google Forms as well to make sure this lesson is a challenge!

Cross-Suite Lesson Topics

Fantasy Football projects can use Google Forms, Sheets and Slides.

In this twist on the budget project, kids play “Survivor”. Give them a virtual backpack and a $100 bill to shop at Walmart. The backpack is all they can have once dropped off on survivor island.  Then culminate the project with a Form to have the kids vote on which backpack would make the best survival bag!

Google has Applied Digital Skills lessons that are a great place to look for inspiration.  Most lessons are for middle school and higher, but you can always adjust them for younger grades by cutting out elements that may be too hard and allowing longer time. 

There’s also several resources for Forms and Sheets lessons in my own shop:

Brittany Washburn

Brittany Washburn

Hi, I'm Brittany. I'm an educator obsessed with technology and passionate about teaching students 21st century skills. I'm so glad you came to visit my website.

Leave a Reply

Hi, I’m Brittany! I’m an educator obsessed with teaching with technology. Check out my free PD for technology teachers!

Click the image to learn more and sign up!

Disclaimer: this content is reader-supported, which means if you click on some of the links that I may earn a commission.

I'd love to connect with you! Find me on Social Media

Most Popular

On Key

Related Posts

How to Integrate Math into your Tech Class

What you need to know is how to integrate math into your lessons in tech class in a way that is accessible to your elementary, middle and high school students! Here are a few recommendations that will let you blend math practice into your tech lessons an authentic way.

Tips for Teaching Tech when it is not your Specialty

So, they asked you to cover the technology classes even though that is definitely not your specialty.  You may be thinking a lot of things in regards to this development, but most likely hovering above all of them is that pesky cloud of feeling unprepared.  So, how are you going to pull this off?

Wait! Your order is almost complete...

Add this offer to your order.

Add Student Created Bulletin Boards

Save 50% by adding this to your order today!

Original Price: $14.00 Discounted Price: $7.00

No thanks, I will pass!

Prep for Digital Citizenship Week with 20% off everything in the Internet Safety Category until 9/30/22. Use the code DigCitWeek20

Love tech lesson ideas?

Weekly Lesson Plans

Every week of the school year I send an email with visual lesson plans. Let me know where to send it by filling out the form here:

Weekly Newsletter

* indicates required