Creating Interactive Vocabulary Activity Using Google Sheets

Today I’m going to share how the word bank activity was created in the “Using Google Sheets to Create Vocabulary Activity Post” .  This activity can be taken one step further by adding  the badge component for “Gamification” into the classroom. Badges can be a motivator for middle school students who are into playing virtual on-line games where they earn visual trinkets to advance. However the concept for earning badges and gamification will have to wait for another blogging moment! In the meantime read this post by Alice Keeler about “Badges and Intrinsic Motivation” to learn more!
Vocabulary Google sheet activity

STEPS FOR CHANGING the THINKING SMILEY EMOTICON TO A HAPPY FACEScreen Shot 2015-10-25 at 11.09.58 AM

  • STEP ONE:
    • Create the question and answer layout with a word bank on a Google Sheet
  • Screen Shot 2015-10-25 at 11.09.35 AM
  • STEP TWO:
    • Insert code “If Logical Expression function”
    • This changes the Thinker emoticon to a Happy Face
      • when the correct answer is typed into yellow cell

Screen Shot 2015-10-25 at 11.11.04 AMScreen Shot 2015-10-25 at 11.10.37 AM

  • STEP THREE:
    • Protect the columns range which displays the function
      • This will allow only you and editor collaborators to make changes
      • Protecting a range prevents students from accidentally change the function
Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s