Google Forms: Let Me Count the Ways…

When I mention Google Forms most people respond with, “Oh! Yeah that is great for taking surveys.” This is when I respond with, “Oh! But it can do so much more!!!”

Let Me Count the Ways…

  1. Parent Information Sheet
  2. Science Fair Judging Form
  3. Parent Volunteer Form
  4. Classroom Party Donations
  5. Group Projects Signup
  6. Student Interest Survey
    • Used for community building
      •  Apply to Foreign Language
        • Student answer questions in Spanish
  7. Progress Forms
    • Self monitoring
    • visual support due to graphs
    • Adult Feedback
  8. Directions Checklist
    • Each Step on its own page
    • Student focuses on one step at a time
  9. Self Monitoring Check list
    • Use Charts for self monitoring
    • Let’s Students see growths
  10. Classroom sign out Sheet
  11. Choose your own adventure stories
    • Use for comprehension checks
  12. Assessments for Mastery
    • Go to next question based on answer
      • Allows for review
      • Opportunity to answer question again
  13. Self correcting assessment
    • provides immediate feedback

…and so much more



Google Forms Supports Spelling Mastery

Recently I discovered the “Hoover Text” and Data Validation Features in a Google Forms. Right away I thought, “How can these features be used to support content mastery?” I came up with this Google Form idea to promote students independents as they learn to spell.

The Hoover Text feature allows one to add a clue if the students are having a hard time spelling the suggested word. In addition the “Data Validation” can help by limiting the letters for the spelling words to the exact amount of characters needed. In the below sample the spelling of cat provided an opportunity to use the text validation tool. Instead of limiting the characters I set the form for preventing a common spelling mistake from occuring. When Google Forms is used in a manner like this it provides opportunities for 100% Mastery.

I believe when a child works independently discovering their errors, and fixing them it supports the student with internalizing what they are learning. This is one reason why 100% Mastery is beneficial for the learning process. It also supports the benefits a student gains from the “Power of Positive Reinforcement.”

Google Forms Spelling Mastery Sample

Please click here if you would like a copy of the template

Using Hoover Text

  1. Insert an image
  2. Click the More Actions Icon (3 vertical dots)
  3. Check Hoover Text
  4. Type Text

Google Forms Hoover Text.gif

Google Forms Data Validation

Data Validation provides a wide variety of uses and instructions. Due to this I’m going to refer you to the Doc’s Editor Help Center Article for instruction on how to use. Please go to the Validate Answers in your Form for further instruction.

Google Sheets to Docs: What “No” Cell Lines?

Have you ever wanted to transfer Google Sheets information to a Google Doc and maintain formatting without the cell lines appearing? It can easily be done by copying the cell information from a Sheet and pasting into a Google Doc. This will paste the information as a table.  Once the  table is pasted into a Google Docs the border can be edited to zero to eliminate all borders. This is the easiest way to transfer Google Sheets text maintaining the formatting without any lines.

Google Doc Remove Cell  Border.gif

The following Keyboard Shortcut will Transfer the Text without formatting.

NOTE: I discovered this Keyboard Shortcut works best when using the Chrome Browser on a Mac or Windows laptop.

Google Drive: jpeg, gif or png “Oh My!”

Recently I was asked, “How can you tell the difference between image files in Google Drive if it isn’t stated in the title?”

The answer is simple this:

  1. Right click on the file
  2. Scroll down to “Manage Versions” & click
  3. A Window Open providing the Version Info

Google Drive .jpg or .gif

Using Google Hangouts On Air in Classroom

EngagementAre you looking for an easy way to engage students?

Search no longer and try a Google Hangouts On Air! A Google Hangout can play many different roles in a K-12 and Higher Ed Classroom. The hangout is recorded and can be reused as a classroom support or study tool shared privately by the teacher. Generally it takes minimal time to setup and run. 

During the hangout the teacher or person in control has access to a dashboard providing the ability to mute a user’s sound, audio and etc… In rare cases an educator may eject an Attendees  from a “Live Hangout” it they’re  not exemplifying “Good Digital Citizenship”. This can be avoided by reviewing the “Netiquette” Skills before using a Live Hangout with your students.

Live Google Hangout Ideas

  • Teachers can host a “Mystery Hangout”
  • Middle School & High School Students interact w/Elementary Students
    • Read to the class
    • Create a project with screen share
  • Provides the ability for an absent student to participate with their class
  • Classrooms can connect with global classrooms to collaborate on a project
  • Establish Student reading/discussion groups connecting two different districts
  • Eliminate travel for Professional Development
  • Student Study Groups
  • Invite a guest speaker

Please Click HERE to Share Your Google Live Hangout Idea