Tuesday, April 15, 2014

Small Group Google Form Request and Spreadsheet

I'm linking up this post up at Head Over Heels for Teaching and her Spark Student Motivation Saturdays, because I got very positive feedback from my students when I let students request small group intervention via a Google Form

I'm home today with a sick boy and am finally blogging about something I did in my class last week that far exceeded my expectations.  I didn't take any photos while doing this and I'm home today so perhaps I will update this post later with more photos, but everything is at school and I'm home today.  The main focus of this post is the Google Form and Spreadsheet I used.  I had a last minute idea, the stars aligned, and when I called my tech coach he had a few minutes available to help turn my idea become reality.

I spend lots of time pulling small groups for mini-lessons or conferring about formative feedback I get via entrance/exit slips.  Last week we had a MATHia day prior to our Chapter 10 Assessment on Triangles.  Students had the option to work on the computer or request extra practice/small group instruction on various concepts being assessed the next day.

With the assistance of the best teach coach ever @chadkafka I created the google form shown below where students could sign up for some extra practice/discussion any concepts they felt they still hadn't mastered.  I created a google shortcut for students to access the google form.  This form seriously took me about 10 minutes to create. If I can do it anyone can.  Really, the creation is a fairly intuitive process. Interested students completed the form and I had instant data on who I would be working with during math class/ Core Plus that day.

If you click to picture below you can see the results of my form.  It was so easy to see everything in one place in Google Drive.  I hid the student name column so I could post this for you to view.  That would be located directly left of the class hour.  I ended up using the purple shading because I had students in 6th hour that were separated and I was not able to sort them by class hour because the sorting feature was being problematic the day I was using this.

Google Form results allowed me to form small groups.
I do like the idea of shading the box (dark purple) once the student has completed a learning station/small group lesson on a concept so I can keep track of who has completed what. There was a lot of different things going on at once based on student request.  I also keep notes in the last column if students worked on this during Core Plus or Class.  I love having this data to refer back to and also to inform parents if students are taking advantage of these added opportunities or not.

This worked so well for me.  I did a post about the three Learning Stations I created last year.  I had students use these to practice independently after I modeled for them how the station worked.  I wrote the answers on a post-it on the back to the center and gave the student the sheet protector with the card in it.  Students really enjoyed using these to review for the assessment.  They checked in with me after completing the station and most were able to solve for a missing angle x using the concepts of either the triangle sum theorem or exterior angle theorem.  I'm posting the photos below because they are saved on my computer from when I created the stations last year.

Each color is a different station

Direction sheet.

Each station had six cards.  I also attached the answer key on the back of the white sheet. The cards were actually on the other side of the sheet protector when I handed them out. 

I also made worksheet that had two different triangle constructions for students to practice.  The constructions have been really challenging for many of my students.  While many have mastered how to construct a triangle using given sides or angles, many still struggle.  If students just wanted more practice they worked on this independently, but many preferred to have me model the construction for them in a small group.  During mini lesson time in workshop I use the SMARTboard compass to construct triangles.  Some students prefer watching me use a real compass to do the construction step by step while they complete their own construction.

The last three concepts, determining congruence in triangle, determining possible side lengths for the third side of a triangle when two are given, and whether three side lengths would form a triangle, were all done in small groups with me using whiteboard examples and lots of discourse.

What I loved about using the Google Form for students to request small group lessons was the ownership it put on the students.  This gave every student access to work on concepts they still felt they needed more work on.  I pull small groups all the time, but usually I use entrance/exit slip data to determine the groups.  This gave students choice and voice in what they still needed/wanted to practice prior to the assessment.

I will definitely be using Google Forms more frequently to get feedback from students.  I would also like to create some entrance/exit slips on a form.  I will be sure to share on the blog anything else I do.  Let me know if you have any questions and I definitely recommend you try making a Google Form yourself.  It's so easy having the data collected on a Google Spreadsheet could not be easier to view!


  1. I love this! I use google docs frequently but haven't thought about using them in this way. I will definitely start now. Thanks for sharing!

  2. This is another great way to use google docs! Thank you for sharing.

    Mrs. Laffin's Laughings

  3. Genius! What a great tool for you and your students! I love how it's already organized for you and it's done in a non-threatening way for the students. Thanks for sharing and linking up!
    Head Over Heels For Teaching


Thank you so much for visiting my blog and leaving a comment. Feel free to email me at luvbcd@yahoo.com with any questions you have.