St. Patrick’s Day & Google Sheets

Inspiration

My instructional tech team and I always receive grateful comments from our elementary teachers we share seasonal activities.  Most of the activities we shared were using Google slides.  I wanted to challenge myself and create a seasonal activity on Google sheets.  Here are the fruits of my labor.  🙂

The Activities

I created 3 different versions of a St. Patrick’s Day Google Sheet activity.  Students have to answer age appropriate math questions. Two actions occur when a correct answer is inputted.  First, an image begins to emerge in the blank rectangle.  Second,  the answer cell fills in with a light purple color.  A wrong answer, as shown below, is left white.

Below is the picture for grade 1. The picture is different for each version.

Capture

 

Here are the links to force your own copy:

  • Kinder:  Click here
  • Grade 1 & 2:  Click here
  • Grades 3 – 5: Click here

Enjoy!!

About jgvadnais

Math Coach. Desmos Fellow. Google Level 1 Certified. SoCal transplant. New Englander at heart. Lover of yoga, dogs, green smoothies and coffee.
This entry was posted in multiplication, Number Sense, technology, Uncategorized and tagged , , , , , , , . Bookmark the permalink.

2 Responses to St. Patrick’s Day & Google Sheets

  1. Jennifer says:

    Could you share a template for how you made this? I really want to adapt it to my science content!

    Like

    • jgvadnais says:

      I don’t have a template. A new design and answers will alter the formatting. Here’s the general flow. 1) Create picture. 2) create problems. 3) Use the function: =value(), to map an answer to a specific color in the picture, 4) Use conditional formatting show a color when an answer is inputted.

      I’m here if you have more questions. I’d also love to see how you adapted this format for science.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s