Google Spreadsheet Magic Part 1: Super Grouper


Google is amazing. I started using google drive this school year. I quickly fell in love with shared google docs, and knew students’ lives would be changed forever. It didn’t take long before I asked myself what else has google given us teachers? The answer is a personal secretary. Ok, I don’t really know what it would feel like to have one of those, as my district has not tried that approach to education. However, I can imagine that it would come with a tremendous increase in productivity. Google Dirve gave me that once I started to play around with spreadsheets and forms. This is the first in a series of video-casts for educators to show just what can be done with a google spreadsheet and a form.

The first spreadsheet magic covers the super grouper. This spreadsheet will help you create groups for your classes in no time. Watch the tutorial video to learn how to get the most out of this amazing, and best of all, pre-built spreadsheet.

Copy Super Grouper

Part II: Big Brother



  1. Top Ten Things to Do In Your First 2 Weeks of Teaching | magnetiCClassroom - […] If you do partner work (which you should), you need an easy way to assign students. I recommend Mr. Matera’s…
  2. Connecting Math Games and Computation | Matt Coaty - Educational Aspirations - […] were given a game board and recording sheet. I pair the students using Michael‘s grouping spreadsheet and the students grab…
  3. Helping Student’s Get Ready for an Essay | magnetiCClassroom - […] Put them in groups of 3 or 4. I suggest Mr. Mater’s amazing Super Grouper for […]
  4. #GAFE Magic Part 5: Postmaster Plus Mail Merge for All | - […] Super Grouper […]
  5. Google Spreadsheet Magic Part 3: Fast Formative | - […] Super Grouper […]
  6. Google Spreadsheet Magic Part 2: Big Brother | - […] Part I: Super Grouper […]
  7. Math Station Setup | - […] Teachers use many different methods to create student groups. I still use the generic popsicle stick method to choose…
  8. Visible Random Groupings | Five Twelve Thirteen - […] use a tool called Super Grouper by Michael Matera. It looks like […]

Discover More!
Join the Crew...

Join my mailing list to receive extra tips and tricks about exploring the seas of gamification. 

Consider yourself part of the crew!