After students complete a district test, many teachers receive access to data-rich spreadsheets detailing student performance across standards. The problem is, it takes a bit of work to group students based on these standards. Since in a former life I was a computer programmer, I created a utility to automatically group students from these spreadsheets: The Student Grouper.

For this to work:

• You should have a .xls Excel Spreadsheet (not the newer .xslx version)
• Student names should be down the first column
• Standards should be across the top row

I’ve included the ability to ignore certain row and column names (for example, “averages” and “totals”) as well as set your own threshold (below 75%, below 60%, etc).

Finally, here’s a video showing it in action:

Receive Weekly Updates