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

Students Create Animated Vocabulary Cards with Google Slides

Okay I admit to being a wee bit “Over the Hill” and growing up using those boring rote memorization flash cards. These days there are so many other avenues one can take to support the learning of vocabulary. I like having fun and know the kids do too! Google Slides presents an opportunity for the students to play and be creative while making a vocabulary study tool. Here is a simple animation idea which supports both the students critical thinking skills along with having “Good Old Fashion Fun Creating!”

CLICK HERE TO COPY TEMPLATE

RULES TO CREATE ANIMATED VOCABULARY STUDY CARD

  • The students are provided with a vocabulary word and definition
  • They need to find an image to represent the meaning of the vocabulary word
  • The student creates a slide presentation
    • Must include stop animation motion
    • No more than one slide animation action
  • Limit the amount of slides used
    • Not less than 5
    • No more than 7
  • Students can work on one big slide presentation with slides assigned to them
    • Work in smaller groups
    • Small group slides can be combined into one big presentation
    • This will provide a shared study resource for all the students

HERE IS THE LAYOUT OF MY SLIDE PRESENTATION

Screen Shot 2015-08-25 at 1.31.21 PM Screen Shot 2015-08-25 at 1.31.37 PM Screen Shot 2015-08-25 at 1.32.00 PM