Create FUN Adventures Using IF FUNctions

My obsession with Alice Keeler is still going strong. I took several of her Go Slow Workshops over the summer and I’m finally ready to share my favorite thing I learned with you. My first introduction to IF functions came in the form of poo. Yes, poo. Alice created an assignment that blew my mind. In this activity, your task is to discover how equations make operations of a farm in Tanzania more efficient. As you progress, personalized directions facilitate the various tasks embedded within the lesson. It makes you feel like the teacher is sitting right next to you, guiding and cheering you on as you learn. Click here to make a copy.

A Google Sheets IF function allows you to use decision making in a worksheet. The IF function tests to see if a certain condition in a cell is true or false. You then use cell referencing to pull data from one sheet to the next. The result is pretty amazing. After we learned the basics, we were tasked with creating an IF function adventure of our own. I chose place value for 2nd grade to be my learning objective. I recorded a video that walks you through the student experience. (Sorry about the dog in the background attacking the UPS guy. She does it out of love.) Click here to make a copy of the lesson.

I highly recommend Alice Keeler’s Go Slow Workshops to learn more about using G Suite with students. Find Teacher Tech blog posts and tips at Follow @alicekeeler on Twitter.

Leave a Reply

Your email address will not be published. Required fields are marked *