Googlefy Your Lessons

Google....not just for productivity, but for educational creativity!

Special Note: You will need a QR Code Reader for this session.

Famous Americans with QR Codes

Google Presentation

QR Codes (made from Google Sheets Add-on - QR Code Generator)
Google Slides (group presentations)
Google Research Tool

Activity Directions: 
1. Teacher explains the QR Code: 
     Each QR Code has 2 clues.
        Clue 1: Group Clue (Find your group)
        Clue 2: Famous American Clue

2. Pass out a QR code to each student. 
3. Students identify their group.
4. Students use the 4 clues to identify their Famous American/Canadian.
5. Assign each group a slide 3-13  (#15 is the Cesar Chavez example)

Click on this URL to get the RESEARCH SLIDES

6. Use the research tool in Slides to locate information on their Famous American/Canadian
        a. Group Name
        b. Locate a photo
        c. Research why each clue was given. 
        d. Site your source
Might require the information to be verified by different resources.

7. Share Famous American/Canadian Slides with parents, on your Google Site or at an Open House

1. QR Codes (see attachments below for pdf)
2. Make a copy of the Famous Americans or Famous Canadians Group Presentation
         Under Edit, select copy
         I leave it as Copy of (until I actually do something with, so it is searchable by Copy of)

Tips for the Classroom Management:
Give Post-it-Notes out for the slide number
Assign roles: Image-seeker, Timekeeper, Clue Researchers 1-4
Have students return their codes in an group envelope (slide number could be on the envelope. Great idea, because your codes are organized for the next time)

The Power of Words

The Power of Words

Google Forms
YouTube Video

Link to The Power of Words:

Activity Directions:
1. Create a new Google Form
    Embed the video
    Choose your saying 
3. Give access to your form
4. Students watch video
5. Write the Same but in Different Words

Try common phrases you might hear at home or school.
Have a great school year.
What did you learn in school today?
No, don't hit the cat.
Have a wonderful summer vacation?

Can you think of more?

Inferencing with Five Clues

Process of deriving logical conclusions from prior knowledge or information assumed to be true.

Go to StoryBuilder.

Click the Build link (on the grey bar)

Type in the names of two characters.

Click the Write Story button.

Start writing your script between the two characters.

When finished writing the conversation, click the Add Music button.

Select the soundtrack from the right-hand list of choices.

Click the Get Share Link.

Give your story a title and add your first name as the author.

When done, click the Finish Up button (or Edit Story if needed).


Create a dialog between two characters with Google Story Builder.
Create a dialog between two political candidates (current or past) that represents their views of a particular topic.

Samples: Jefferson and Hamilton   Rocky and LugNut

Story Starters with Google Drawing
Google Drawing
Any type of Story Starter System you are using in the classroom.

Activity Directions:
1. Teacher chooses a Story Starter
2. Each student will create a new Drawing
3. Students write a story or write "and then"
4. Use the Google Drawing, Clay or LEGOS to illustrate your story.
5. Or try adding a photo to your Drawing
        From the Menu
        >Take a snaphot
        >Might have to allow to access your camera and microphone

Additional Information:
Order And Then Cards from Amazon 
Story Starters for Middle and High School
Another great Google tool for writing is the Google Story Builder

Jeopardy Style Quiz in Google Sheets Using Flippity.Net

Directions to Make Your Own (Jeopardy Style) Quiz Show?

Step 1: Modify the Google Spreadsheet Template
Make a copy of this template. (Sign-in, click File, then Make a copy…)

Step 2: Edit all the categories, questions, and answers.

Step 3: Publish Your Spreadsheet
Go to File, Publish to the Web…, then click Publish.
Copy the link under the Link tab.

Step 4: Get Your Link
Click on the Get the Link Here tab of the template (at the bottom).
Paste the link in the light blue cell to get the link to your Flippity Quiz Show.

Step 5: Click, Bookmark, and Share
Click on the link to test out your game.
Make a shortcut or bookmark to get back to the game whenever you want to play.

Peggy's Example

M&M's with Google Sheets

Number off for a row in Sheets (2-17)

  • Pick a bag of M&M's

  • Predict the number of each color of M&M's in a bag of M&M's.

  • Then open your bag and count each color. How close were you?

  • Now, let's see what the class count looks like click here and go to the Google spreadsheet we will use to get the class count.

  • Type your name in the column titled "Student's Name" then insert the number of M&M's for each color on the row with your name on it.

  • In partners work toward finding the mean, medium and mode for each color.

  • After the teacher creates a chart from the data gathered, in the last column, review the class data and predict what would be in the teacher’s bag of M&M’s. (change color for each bar to match color by clicking on the color of the bar in graph and changing the color)

Eric Curts, a self-proclaimed Google Geek, decided to create a playable version of his beloved Battleship game inside of Google Sheets. And with that, Battlesheets was born!

Here's how it works:
Basically it is an online game where each player uses a different tab in a shared spreadsheet, types in letters in one grid to place their ships, and then takes turns typing in X's in another grid to drop their bombs.
Pre-made formulas and conditional formatting then show you if you have hit your opponent and if they have hit you.
The game continues until one player has sunk all of their opponent's ships.
Replay is as easy as deleting the contents of your grids and starting over.
Detailed directions are included on the first tab of the spreadsheet labeled "Instructions".

Maps... not just for directions anymore.

Taking screenshots from Google Maps in satellite view, has turned into a scavenger hunt to test your knowledge of landmarks. This Google presentation has 16 United States memorable landmarks and 15 world well-known places.
Peggy's creation

A Google Maps based geography and trivia game.

Game using StreetView images that drops the player in a random location and challenges them to work out where they are.

Collaborative Crossword Puzzles with Google Sheets
by Damien Kee

Google Research Tool
Google Sheets

Google Summit
Make a copy of the Collaborative Crossword Puzzles Template
1. Click on this URL
2. Under Edit, select copy
3. I leave it as Copy of (until I actually do something with, so it is searchable)

Lessons Learned
This googlefied crossword is a little complicated. My tips.
1. Assign a category
2. Brainstorm a list of 15 words (make sure you have short words also)
3. Next, work on the clues.
4. Place your longest word first and save your short words for last.

Additional Information:
Peggy's example:
Damien Kee's Original Article about Google Sheets and Crossword Puzzles

Student Instructions
Form your students into groups, 3-5 works well, and share this Sheet with them
Brainstorm all the words that relate to a topic and put them in the column marked 'All Words'. Once you have about a dozen words, you can start assembling your crossword.
Have someone choose a starting word. Write that word at the top of the 'Words in Use' column. (It'll have a dark brown background)
Go to the 'Crossword' Sheet and place the word, 1 letter per cell, starting somewhere in the middle. Place the word either horizontally or vertically
Highlight the cells of that word and use the 'fill colour' tool to make it the same colour as the 'Clues' Worksheet (The first word should have a dark brown background)
Other members then look at the existing crossword and find a spot to place a new word. Just like a real crossword, their word must somehow use a letter(s) from a word already placed
Once they place their word, ensure the word on the 'Crossword' worksheet and the Word/Clue cells in the 'Clues' Worksheet are highlighted the same colour
Keep going until you run out of room or run out of words. There are 10 distinct colours, so a maximum of 10 words works well. Any more than that and you have to get into different shades of colour
Go back to the 'Clues' worksheet and now write clues for each of the words that have been used. Discuss within the group (possibly using the comments functionality) how to make the clues 'better'
The Clues will be automatically copied onto the 'Crossword' worksheet with the correct colours
Delete the 'All Words' and 'Words in Use' columns (you can go back through the revisions to find the answers if necessary)
Go back to the 'Crossword' Worksheet and highlight the whole worksheet
Press the Delete button. All the letters will disappear but the colours will stay, showing you where the words need to go
Share the Sheet with another group for them to solve
Have fun! (If you use it in class, please drop me an email and let me know how the activity went -

If you have a lesson you have GOOGLEFIED, please send it to me. I would love to pass along your ideas to other superb educators.

SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser

Peggy's 5 Clue Inferencing Activity  Mar 2, 2015, 9:22 AM Peggy Reimers
  May 21, 2015, 11:05 AM Peggy Reimers
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
Make a copy for your classroom lesson.   Mar 2, 2015, 9:21 AM Peggy Reimers
View Download
Download the QR codes for your classroom    84k v. 2 Mar 2, 2015, 9:21 AM Peggy Reimers
View Download
Download the QR codes for your classroom    81k v. 2 Mar 2, 2015, 9:21 AM Peggy Reimers
Make a copy for your classroom lesson.  Mar 2, 2015, 9:21 AM Peggy Reimers