On November 3rd I had honor of being asked to present at the Mercy High School Tech Talk #MHTT17. While my presentation was great, I was more blown away by the other presentations. While it was a small conference it was effective and impressive. Just what I needed for those just before Thanksgiving Blues. You know those over worked blues, where you force yourself to think about a thing to be thankful for everyday of the month of November to just forget how overworked and out of control your school life is. Yeah, this was perfect. Their keynote speaker, Brent Coley, was brilliant. His stories propelled you into a space of laughter and sometimes tears (or that almost tears moment). To sit and remember in a funny yet thought provoking way that we have the influence to be eduawesome is just what I needed. I needed to be reminded I have the power to change a student's perspective but simultaneously I'm not the only teacher who is terrified about becoming THAT teacher. You know the one who is set in their ways. The one who will criticize every student and teacher, if their behavior doesn't fit the 1952 protocol for education.
Well, what does this have to do with teaching Google Forms? It was during this conference and in the session Taking Google Forms to the Next Level with Brent Coley that I learned how awesome it is to use Google Forms. I was so excited I had to share it with someone and since most of my building is headed out on the Washington DC trip, I returned to my blog. I highly suggest watching the tutorials on how to create these amazing Google Forms at BrentColey.com
The thing that I have loved about Google Forms, since the beginning of Google Forms; is it will take the data from a survey and populate it into a Google spreadsheet. Let me repeat, it will take the data from a survey and populate it into a Google spreadsheet - this spread sheet then can be sorted for deeper investigation and can also be shared with others. I used to sort everything using the pull down tabs in Google Forms but I found out that a better ways is to use the google chrome add on EZ Query, you can easily and quickly sort your spreadsheet from its original format into other pages based on specific criteria. Here you can see that I have created other pages at the bottom of my Spreadsheet labeled 8th grade, 7th grade and 6th grade. All I had to do was use the EZ Query add on, then select what I want to include in my query and how I wanted it sorted. POOF! After a minute or two, depending on my connection speed, it populated the new sheet and now I can easily find my students via grade and name. Again I suggest watching the tutorial. It is much easier to watch than to explain via text.