Google Forms for Reading Conferencing

Something that we have been using at Webb City is Google Forms to record reading conferences with a student done by the teacher.  Gone are the clipboards of what the students are reading, where they are in their AR points, and furthermore trying to keep track of where each student is according to their goals.

We have had a few teachers create Google Forms to collect their students' data daily, weekly, biweekly, however often they choose to meet with their students.  Some teachers ask comprehension questions, and/or purpose for reading questions.  Teachers are tracking the number of pages read and tracking AR (Accelerated Reader) points.

Collecting the data is the easy part.  Simply create a Google Form with the questions you want to collect data on including name of students.  While doing this you get a google sheet of all the data that you collected.  All in one location, but organized by date collected, not ideal.  Teachers using iPads can make a shortcut on their homepage that goes directly to their Google form, teachers using a computer can simply bookmark the google form and you are ready to collect data.

Organization of the data takes a little more knowledge of formulas inside of google sheets.  Most teachers would like to have a sheet of data for a given student.  This is ideal for reviewing the progress of a student with the student and with parents.

Inside your response sheet you can work with the filter formula to bring data into another sheet with certain criteria.  You simply need to create multiple sheets inside of your response Google Sheet.  Name each sheet your students' names to help organize, then copy the header of your response sheet into the top row of your new sheet.

Student Sheet Names

Header Row 

In cell A2 or the first cell under your header row, you will create a formula similar to this:

=FILTER('Form Responses 1'!A$2:G,'Form Responses 1'!B$2:B="Students'Name").

Replace "Student's Name" with the name of your student leaving it in "".  This will bring in the data of that student.  Simply repeat copying the formula and header into each sheet and you are done.  It will automatically fill per student once you submit a form response.

Example with student name Ethen

Example Spreadsheet of data:  Reading Conference- Short (Responses)

Once you set up your formulas you are done.  Now you can start analyzing your data and have your students reflect on their reading progress.  You can look into sharing the sheets with students and parents, but be careful about sharing other students' data.

Good Luck, may you unlock the power of Google Forms and Google Sheets in your reading conferences.