A few days ago I came across two excellent blog posts from Ruth Morgan at Chapel Hill Snippets explaining how she uses Google forms to track student therapy contacts. As a literacy coach, I used Google forms to create my own digital conferring notebook and was itching to use the same approach with my speech therapy students. Ruth created an individual Google doc for each of her students which allowed her to display all therapy notes on a comprehensive spreadsheet. I liked this idea and may end up following Ruth's model but I also wanted to experiment with a single form that could capture all of my therapy notes for all of my students. Below is a screenshot of the live form I'm playing with as well as what the spreadsheet looks like. I will probably enter some dummy data to get a feel for how it will work or not work.
This is what the form will look like on my iPad.
This shot shows the headings for the data I want to collect.
Whenever I create a form in Google docs, I start with what information I will need and how I want it to look in the spreadsheet. In other words, I don't start by creating a form. I begin with sketching out a spreadsheet on paper, then go from there. I want my form to be simple, quick, and flexible. And I want the columns to fit across one sheet of paper in a landscape view. I usually do a test print of what the spreadsheet will look like before I finalize the questions on the form. In the future, when I need to print the information I have collected, I want it to be in a useful format. Please follow the links for the live form and the spreadsheet to take a look, ask any questions, and provide any suggestions or comments.