Google Forms Tips (Part 2)

This week we will focus on part 2 of Google Forms. If you would like to look back at part 1 of Google Forms, click here. 

This week's tips include: Exporting answers to Google Sheets, sending to a new questions based on answer, importing questions from a previous form, deleting previous responses, and stop accepting responses. 

Did you know that you can differentiate within a form? One of my favorite features is sending students to a new section based on their answer. The new section can have them watch a video or go to a new website for remediation, or it can simply ask them to answer the question again with a hint as to what they need to do to fix their answer. This is a feature that is used when digital escape rooms are created. 

1) Export Answers to Google Sheets

You have the option of viewing your responses in a Google Sheets, which will display all responses in an easy to read format. From the responses tab, click on the Google Sheets icon in the right hand corner. You will be prompted to create a new spreadsheet or select an existing spreadsheet. 

You will want to create a new spreadsheet. After you have created the spreadsheet the first time, it will not ask you this step again. You can now view all of your responses as a spreadsheet. It will continue to add responses from the form as they are submitted, even after you create the spreadsheet. 

                                                                   

2) Import Questions from Previous Form

Let's say you created a review for a test using Google Forms. You want to reuse some of the questions from this review in a new Google Form created for your test. You can insert the questions from your previous form into your new one without having to retype them, which saves you time! 

In the sidebar on the right, click import questions. This will pull up all of the forms you have previously created. Click the form you want to pull the questions from and then click select. This will pull up all the questions from the form on the right-hand side. You can either select all the questions or select certain questions by clicking the checkbox beside them. Once you have selected the questions you want to use, click import questions. They will automatically go into your form, as well as the previous point values and correct answers. 

3) Deleting Previous Responses and Stop Accepting Responses

To reuse forms year after year, you will want to delete the old responses from your previous classes. To do this, click the responses tab. On the right hand side, you will find a 3 dot dropdown menu. When you click the 3 dots, there will be the option to delete all responses. Click this and all of your previous responses will be deleted so you can start fresh with your current class and reuse the form. 

If you want to put a due by date or time on your form, there isn't a option to click a certain date or time. However, you can choose to stop accepting responses on the form after a certain period of time. To do this, click on the responses tab. You will see a button on the right hand side that says accepting responses. Turn the switch to off and now anyone who has the link won't be able to respond. You can also change the message that appears when someone clicks the link. The default message is "this form is no longer accepting responses."

Step 1)

Step 2)

4) Sending to Section based on Answer/Branching Form

This last trick is a little bit complicated and takes some playing around with to use. My advice is to start small and work your way up. This is a great feature for differentiating within your classroom. I used it for my study guides in math in order to have my students rework their problems to get the correct answer before moving onto the next question. When you create the new section, you can have the students watch a video explaining the concept again before they answer the question. You may hear this referred to as a branching form. 

Want to see an example of how this works? Try it out here. Get an answer incorrect to take you to ideas of how you can use the branching method. 

The following video will walk you through the steps of how to create a form with branching questions.

Have you tried any of these tips on your Google Forms? Which one is your favorite to use?