Collect class data using Forms

Objectives

After completing this lesson, you will be able to:

  • Create a class survey
  • Add and edit survey questions
  • Add images to survey questions
  • Collaborate with others when creating the survey
  • Send the survey to students or parents
  • View survey responses (summary, spreadsheet)

Scenarios

The following scenarios show examples of how educators use Google Forms in their classrooms:

Survey your students/parents

At the beginning of the school year, a 1st-grade educator wants to collect feedback on how useful parents found her presentation at Back to School night. In the past, she sent paper surveys home with the students, waited for them to be returned to school, and processed them manually. This was a time-consuming process, and many of the surveys never came back.

This year, she has decided to implement the same survey via Google Forms. At the end of her presentation, she shows a link to the survey so that the parents can fill out the form on their mobile devices before they leave the classroom. She is even able to address immediate concerns with the whole group of parents before they leave the classroom.

Create an assignment or assessment

A 7th-grade English teacher requires her students to read for at least 30 minutes every day. She used to require her students to fill out paper weekly reading logs and turn it in each Friday, which she would then review manually and mark the scores in a grade book.

Now, she uses a Google Form to collect the students’ weekly reading logs. Every student is expected to spend a few minutes filling out the form, either on the classroom computer or from home on Friday mornings. These include questions about how much the students have read each week, what books they’re reading, and ratings of each of these books. Using the form has reduced visual processing time since the teacher can scan the results in a spreadsheet, rapidly identify students who are missing expectations, and collect a list of her students’ favorite books.

Collect and visualize data

A 4th grade math teacher is teaching his students how to create and interpret charts and graphs. He used to have the students collect data manually and create charts of basic information about themselves: birth month, favorite color, and height, for example. Collecting this data used to take an entire class period; creating the graphs used to take one or two additional class periods. He has now created a form to collect this information. All students spend no more than five minutes completing the form in the computer lab. They then work in groups to create charts representing this data. The entire lesson now takes only one class period and more class time can be spent analyzing the charts and data.

Send consent forms to parents

Mr. Justice, a 1st-grade teacher has trouble sending permission slips and consent forms home with students. Because they are still learning responsibility, his students often lose the forms before they arrive home. Often times, parents call the school angry that they did not know there was a field trip or a program involving their children.

Since the school started using Google Apps, Mr. Justice decides to send the forms directly to parents without going through the students. He collects the email addresses of the parents who have internet access at work or at home. He then sends consent forms directly to them using Google Forms. With the rest, he still sends the forms home through the students. He has been able to reach 92% of all of his students' parents whenever the parents must respond to a consent form.

How-to

Create and format a Google Form

To create a Google Form:

  1. Navigate to drive.google.com.
  2. Select New, then More.
  3. Select Google Form

Add and edit questions

By default, the form has at least one question. To add or edit form questions:


  1. Edit this question to be one of these question types:
    • Text: Respondents provide short answers.
    • Paragraph text: Respondents provide longer answers.
    • Multiple choice: Respondents select one option from among several.
    • Checkboxes: Respondents select as many options that apply.
    • Choose from a list: Respondents select one option from a drop-down menu.
    • Scale: Respondents rank something along a scale of numbers (e.g., from 1 to 5).
    • Grid: Respondents select a point from a two-dimensional grid.
    • Date: Respondents select a calendar date from a drop-down menu or mini-calendar tool.
    • Time: Respondents select either a time of day (Hrs, Mins, AM/PM) or a duration of time (Hrs, Mins, Secs) from a drop-down menu.
  2. Click Insert and then Question type.
  3. Type the question in the Question Title field.
  4. Add Help Text if necessary.
  5. Make the question required, if necessary.

If you need to rearrange questions, you can click on the question and drag it to the appropriate spot within the form.

To edit a question:

  1. Click on it once to bring up the fields for question editing.
  2. Click Done.

To add a question:

  1. Click Add item.
  2. Select the question type.

Add an image to your form

To add an image to your form:

  1. From the Insert menu, select Image.
  2. Once you've uploaded the image, you can give it a title and specify what text will appear when someone hovers over the image.

Images in Forms aren't attached to or associated with form questions. You can change the position of an image by dragging it up or down in your form.

Share the form with collaborators

To share a form, select Add Collaborators from the File menu.

Send the form to students

When you send a form to someone using email, recipients will be able to respond to the form from within their email program. To send the form via email:

  1. From the File menu, select Send form.
  2. Enter email addresses.
  3. Click Send.

To publish the web address of the form for anyone to fill out using the URL:

  1. From within the form editor, click View live form.
  2. Copy the URL and paste it in a presentation or an email message.

Embed on a website

To embed a form on a website:

  1. From the File menu in the Form editor, select Embed.
  2. Copy the code and paste into your site or blog. The height and width of the form can be specified to conform the site that it will be embedded on.

View form responses

To quickly view how many users filled out a form and their responses:

  1. From the Form Responses menu, select Summary of Responses.
  2. From within a spreadsheet, select View responses in the toolbar.
  3. Select whether you want to create a new spreadsheet for the results or a new sheet in an existing spreadsheet.The responses tab of the spreadsheet you selected will open automatically.

Learn more

Additional information about the topics in this lesson can be found here:

Google Educator Group Curriculum

Online help and tools

Google Forms Help Center
Google Forms Product Forum


Activity

Part A. Create a Google Form

Option 1. Create a new Google Form that you could use in your classroom. Add questions of at least three question types. When complete, send it to a colleague to help you work on the form as a collaborator. Add at least one image to the form. Finally, send the form to a friend.

Option 2. Practice creating a form with these questions:

  • What is your name? [text entry]
  • How many minutes did you spend reading this week? [time]
  • Rate the last book you read. [scale]


When complete, send it to a colleague to help you work on the form as a collaborator. Add at least one image to the form. Finally send the form to a friend.

Part B. View form results




You’re viewing the spreadsheet of raw form results (Figure 1 above). How do you go from this page to viewing an automatic summary of the results (Figure 2 above)?

Part C. How will you use Google Forms in your classroom?







Please answer all questions in order to receive credit for this project.








Please answer all questions in order to receive credit for this project.

Discussion