I have a friend that wants me to design them a priority system for a class. I am struggling with how to do the math and then add it to the sql.
Here is what she is looking for. She wants to compare a students GPA and how far they travel in order to prioritize class sign ups. Here is the issue. The comparison needs to take into consideration GPA with more weight than distance. i.e. Someone with a 4.0 GPA that travels 5 miles should get more priority than someone with a 2.0 GPA that travels 200 miles.
Naturally the one above would be higher and get priority... that would be a simple approach; but again depends on the whole picture... let me know all the cases and I will what I can do to help
~P
Pablo Varando Senior Application Architect EasyCFM.COM, LLC.
Basically she is a nursing student. 75% of the students commute to the university from 1-2 hours away. The schedules are very sporadic and there is no preference for students who commute. She made a proposal to her professors on this little project so she asked me to write the program. So, it needs to make sure that people who have the highest GPA get 1st dibs on the "good" schedule but weigh in the distance of the commute.
check out this thread to see if helps you. It helped me when I was doing something like this... My had a random factor but it may be able to be taken out...
MIGhunter
04-15-2010 @ 11:56 PM
