One of my colleagues in a school thinks I'm a wizard. Thus she thinks I can make this interface. I told her it sounds terrifyingly complicated and that no off-the-shelf product does what she wants. Am I wrong?
Here's what she wants: You're moving a pool of students into, say, four classrooms. Each student is represented by a pink or blue (girl or boy) rectangle with the students name. Each class is represented by a different area.
As you drag students into the different classes, it keeps track of boys/girls per class, total count per class, plus other lovely school data like how many students per class in special ed, free-or-reduced lunch, ESL, and so on.
Since we'd be doing this for a lot of students and a lot of classrooms, we'd have to be able to start with a spreadsheet and have a spreadsheet as a result. So no, we can't hard-code the students into the interface. We start with a spreadsheet (or database) and say: Show us the interface for 4th graders. And at the end of the manipulations, the data on how we grouped them is recorded in the database.
The closest I can imagine is the electoral map
Chuck Todd played with all election season. He moves states, the numbers change. No idea if back-end data changes, though, or if he could save scenarios.
I don't know if any such tool is widely available, or if there's a scriptable graphic interface that can sync with Excel or some other data store. I know Flash may be a candidate, but I don't know about the data in/out. I'm an amateur tinkerer with programming, no better. So scripting languages probably yes, Python or Objective C from scratch probably no.
All guidance welcome.