3 Tips for Using Google Forms

As a Google Top Contributor I’m exposed to an abundance of questions from teachers throughout the world. The following tips lists was created due to answering these questions in the Google Drive, Docs and G Suite for Education Help Forums.

1. Sharing a Google Forms…

It always amazes each year hearing the following question. “What am I doing wrong the students are requesting access to the form?”

This happens when the teacher copies and pastes the Google Forms URL instead of using the Send button to share the forms. Please follow the below steps to send a Google Forms.

FORMS DO NOT PASTE URL

Forms Send by Send button

Choose Forms Send Method.gif

2. Collecting Student Names…

What if a student forgets to enter their name? Is there a way to tell who the form belongs to?

If names aren’t collected from within the form there is no way to find out who completed the form. However teachers can prevent this from happening by using one of the two following steps.

  • Auto Collect Student Emails

    • Set the Form to Auto collect email by using the settings tool

Forms Click Settings

Forms Collect Email Addresses

  • Add a required Name Field

    • Add a Short Answer Question Field to the Google Form
    • Type First Name Last Initial in the question area
    • Set the Short Answer Field to Required

Forms Required Name.gif

3. Changing Submission Message…

Is it possible to edit the message a student receives once a Google Forms is submitted?

Yes, the message may be edited to add a mindful message. Please follow the illustrated steps to customize the Google Forms Confirmation message.

Forms Click Settings

Forms Click Presentation

Forms Type Confirmation Message

If you have further Google related questions you’d like answered please leave them in the comment area of this post. I’d be happy to answer them.

 

One Advantage to Using Google Sheets Conditional Formatting…

I’m a visual learner and like using conditional formatting to add color to Google Forms Spreadsheets. The Google Form Spreadsheet collects the data obtained from a Google Form. Thanks to the colorization capability of spreadsheets I can start accessing the data before creating charts and using equations.

SPREADSHEET EXAMPLE OF USING CONDITIONAL FORMATTING TO COLLECT DATA
Conditional Formating Data

  1. The color options for each column was created by using conditional formatting
    1. Allows one to set colors based upon the answers
    2. Spreadsheet automatically colors cell depending on response
  2. Data information can be seen before charting or using equations
    1. Example from the above graphic
      1. More females answered the question
        1. Female represented by pink
        2. Milk chocolate was the most popular answer ~ light brown cells
        3. White Chocolate was the least favorite ~ Black cells
        4. Grade column is difficult to assess visually ~ no color added

HOW TO SET COLOR USING CONDITIONAL FORMATTING 

  • Create a Google Form with multiple choice, checkboxes or list questions
    • This is the easiest questions to use for conditional formatting
  • Open the response spreadsheet associated with the form
  • WATCH this Video to setup a conditional format for each spreadsheet column

https://youtu.be/Zq7-X3WCd5M

Yes! You Can Have One Sheet per Student in a Google Form Spreadsheet

I’m discovering not many teachers know multiple student sheets can be added to one spreadsheet. Due to the time it takes for setting this up I don’t recommend doing this for all Google Forms. However due to the nature of a reading log it is well worth taking the time to set up a sheet per student. The trick is you will need to create one Google Form per student, and then add a sheet into an existing Spreadsheet.

This is how to add multiple sheets to one spreadsheet

Reading Log multiple students

STEPS for ADDING MULTIPLE SHEET to a SPREADSHEET

  • Open Google Form
  • Click Response

step 1

  • Click Change Response Destination

Step 2-2

  • Click New Sheet in Exisiting Spreadsheet

Step 4

  • Select the Spreadsheet

Step 5

IF ALL GOES WELL YOU SHOULD HAVE MULTIPLE SHEETS IN ONE SPREADSHEET

Screen Shot 2015-08-24 at 10.35.34 AM

Customize Google Forms Classroom Sign Out Sheet Header…

It seems like most people use a default or stock theme when creating a Google Form. Personally whenever possible I like to customize themes to make the form more personal or fitting to the content area. I get the impression the Google Forms customization tools is a hidden feature often over looked. This is how to change the header and Font for the Title in a Google Form. Elementary and Middle School Teachers who decorate their rooms seasonally and according to content would most appreciate this function.

Change the header

  1. Click on edit form
  2. Click change themes
  3. Go to header section
    1. Click Change header image
    2. Choose from a variety of themed images or upload your own
  4. Change font click on title section
    1. Pick out a font style
    2. Choose font size
    3. Select a color
    4. Choose left, center or right position

HERE IS A SAMPLE OF A CLASSROOM SIGNOUT SHEET

CLICK HERE TO DOWNLOAD A COPY  OF THE FORM

Click on FILE followed by Clicking Make a COPY

Why Use a Google Form for a Sign Out Sheet?

  1. Provides quick access to the information
  2. Prevents student from editing the sign out or sign in time (automatically timestamped)
    1. Thanks to the Automatic Time Stamp Teacher isn’t constantly interrupted with telling student the time
  3. Information can be automatically shared with the Office to help with locating a student
  4. Saves a Tree along with money
  5. Expediates the sign out process
  6. Creates a log of how much classroom a student is missing

Creating an Interactive Entry Ticket the Basics

Today I’m sharing how to create the Interactive Entry Ticket seen in a prior post. You will be amazed with how easy it is to create using Google Forms. Google Forms may be one of the most underused APPs sitting in your Google Drive. Most people relate the form with a method of providing surveys and polls. In actuality Google Forms is a very powerful tool for the educator. A Google form can assist you with collecting daily teaching evidence, RTI data, assessment data and it can save some time by automatically grading. All information collects into a spreadsheet. Imagine the time saved by scrolling down a spread sheet versus thumbing through piles of paper.

Google forms offer the user the ability to embed video, audio, clipart and link out to the web. This makes it easier to differentiate the work for all the different learning styles! I would say the power of a Google Form is a “Win Win” situation not only for the teacher but also the students!

This is how I created the Interactive Entry Ticket wait to you see what a breeze it is to create. Doesn’t take much time at all and offers a “Big Bang for the Bucks!”

  • Go to Google Drive click on New, Scroll Down to More, Click Forms

Open Google Forms

  • Click to give the Forms a Name

Forms ~give it a name

  • Give the Forms a Description

Forms Description

  • Type a question in the Untitled Question field
    • Provide text clues
    • Choose a question type
    • Click done when finished

Forms write question

forms question types

  • Add Items option allows you to add extra text, checkboxes, video, images, and etc…

Screen Shot 2015-07-16 at 4.46.37 PM

  • Choose a theme and then Click Send

Change Theme Click Send form

Screen Shot 2015-07-16 at 4.49.04 PM

  • Choose which method to use for sending the form then click done!

click done

SAMPLE INTERACTIVE ENTRY TICKET

MORE TO COME SOON ABOUT USING GOOGLE FORMS FOR CREATING EDUCATION INTER-ACTIVES