Saturday, April 15, 2017

Live Exit Tickets With Google Forms

Most Google Apps educators know that Forms works great for collecting almost any kind of information from students, including administering quizzes and collecting open responses. Managing the information, however, is a problem that needs attention.

Google Forms Sheets

We can automate the grading for multiple choice quizzes, yet constructed responses, like exit tickets, require feedback from the teacher. The problem is getting that feedback to the students. Sure, it can be returned to the students numerous ways, but what if it was always live and the need to return work was eliminated?

Back to Forms and Sheets

Since Google Classroom added the question tool a couple years ago, I started using it for exit tickets. It works great, but it's also limited in terms of what you can do with the response as a whole. It's hard to identify patterns of strength and weakness over time, which is why I've switched back to using Forms and Sheets.

Sheets is still the best solution for so many classroom routines. The following explains how I have made exit tickets with Sheets so that the information is live.

Live Docs

What do I mean by live? The responses go to a sheet in which feedback is provided. The feedback can be added to the response destination sheet and exported to a student-specific sheet (tab across bottom). The student-specific sheet is synced with a separate document owned by the student.

The video below shows how this process works. Following the video, I will explain the tools I use to complete the live exit tickets.



Making Live Exit Tickets

1. Open Roster Tab Template

Roster Tab was created by Alice Keeler. She is my first search for anything Google Sheets or Classroom. Open this template (below), make a copy, and title your new document. This sheet will be your response destination (explained in next step).

Notice the Roster Tab menu across the top. You'll need it for Step 4 (below).

Template Copy

2. Set Sheet as Form Response Destination

Open the form you use to collect exit ticket responses. Select the responses and click on the Sheets icon. This opens the options shown in the image below. Since the response destination sheet is already created, select an existing sheet. This opens Drive so you can choose the sheet you've created.


3. Import Roster From Classroom

Open the response destination sheet. In the Add-ons menu across the top, choose get add-ons. This brings you to a screen that will allow you search for rosterSync, which will allow you to import a roster from Google Classroom.

This post explains how to use rosterSync.

4. Run Roster Tab

Roster Tab makes a new sheet for each student on the roster. The tabs at the bottom will be used to send the query of response data for each student.


5. Make a Query 

I like to use EZ Query because it writes the function for you. You'll have to search for the EZ Query add-on and install it. When it's in your add-ons, run EZ Query to open the side bar shown in the image below.

EZ Query is going to make a query function based on the options you select. I like to include the time stamp, response, and feedback columns. The feedback column is something I add to the response destination sheet.

Also, make sure you check the range of rows from which the query pulls data. I  increase the row number to 10,000 or more rows to accommodate a full course.


6. Students Make a Sheet

I provide a set of directions for students because they will only understand how live docs work once they've completed the steps.


7. Share Function With Students

Step three on the student directions for making a sheet includes the function. Students paste the function into cell A1 and change two parts to specify the key and their tab from the mother sheet. The key is provided on Google Classroom to keep it secure.

=IMPORTRANGE("key=insertkeyfromzahner","firstname!A1:C20000")

8. Provide Test Feedback

The feedback is automatically synced to the student sheet, so there is no need to pass back work. Let's say I find myself waiting for an appointment, I can pull out my phone and provide feedback on today's exit ticket. There's no extra steps or complex apps to load. Sheets is simple and reliable.

I'm convinced that Google Sheets is the most powerful tool for running a classroom. It's also the safest tool to use and teach because it has a seemingly endless shelf life.