Classroom Creator is a quick and efficient way to sort students into balanced classrooms.
Classroom Creator is an Excel spreadsheet and associated macro (program) that my engineer husband developed. By entering student data into a table and running the program, you are able to instantly create class rosters that are balanced in regard to gender, academic levels, behavior, and ethnicity. You can also designate students who should be kept separated.
The resulting class rosters appear in an Excel spreadsheet sorted into classrooms and alphabetized within each classroom. If desired, you can make manual adjustments to the rosters. If you aren’t pleased with the rosters that are generated, you can discard them and rerun the program for a new result.
Classroom Creator includes instructions, a sample input sheet, and a sample roster output sheet.
Requirements: You will need Microsoft Excel running on a Windows computer. Some familiarity with Excel is helpful, but not necessary.
Specific Details: The program will make the boy/girl ratio in each classroom as close as possible to the boy/girl ratio in the overall student population. The program gives equal weight to academic ratings and behavior ratings, which are entered by the students’ current or previous teachers on a scale from 1 to 5. You can make all classes as close as possible to the same size, or you can customize class sizes. The program will ensure reasonable ethnic diversity across all classrooms, but you can make this more or less flexible by changing a program parameter, which is explained in the instructions. Up to 3 students can be flagged as a group that needs to be separated (assigned to different classrooms), and up to 5 such groups can be entered.
Note: The program currently has a maximum of 200 students. We are considering increasing the max number of students if we get feedback requesting it.
Hint: We were able to export student names and genders from my school corporation’s online gradebook into Excel, so it was not necessary to type them into the spreadsheet. If you use an online gradebook, check to see if it has an option to export names and genders.
There is a commercially available program that performs a similar function, and it sells for $495 with a $100 annual maintenance fee.
If you have questions or problems using this program, please contact me, and my husband will be glad to help.