05-14-13, 21:03 #1Registered User
- Join Date
- Sep 2011
Unanswered: Need Help, Building a Scheduling Program...
I'm not satisfied with our SIS's scheduling program for elementary. But no fear it's open source and can easily be modified. I'm planing on doing this in stages because it's a very complex set of criteria.
But what I'm trying to figure out right now, is how to basically separate students into groups (assigned to teachers) with the only criteria being balancing gender ration ie not too many males or females in a class. I have a students, teacher table and a table for the data to go into.
So basically third table should just get a teacher id next to each student id with gender being balanced. It sounds basic, but I just can't figure out how to achieve it. Then the idea is once I have that done I'll run some queries to move them around based on test scores, discipline incidents and so forth.
Thanks in advance for the help!
05-15-13, 08:31 #2Annie's Dog Walker
Provided Answers: 6If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.
- Join Date
- Nov 2004
- on the wrong server