This button imports an Excel, or .csv, file that contains the names and numbers of the courses.
72% of students were assigned to their first choice.
90% of students were assigned to their first or second choice.
100% of students were assigned to their first, second, or third choice.
(The initial value of all the percentages will be zero, until the assignment tool is run. If possible, it would be nice to save this information into the Assigned Students table.)
|Course number||Course name||First choice||Second choice||Third choice||Weight||Minimum class size||Maximum class size||Students assigned|
|2||Urban American Musical Literature||2||1||0||13||5||15||0|
|3||Sketchbook Journaling Feb 17||3||2||0||21||5||15||0|
|4||Sketchbook Journaling May 15||1||4||3||20||5||15||0|
|5||Visualizing the World||1||1||2||10||5||15||0|
|7||History of Baseball||1||3||3||17||8||20||0|
|9||Power of the Matrix||3||1||0||18||8||20||0|
- The weight field is determined programmatically (5 points per first choice, 3 points per second choice, 1 point per third choice).
- The Students Assigned fields initial value is 0, until the first run, where students have been asssigned a class.
- The minimum and maximum class size fields need to be editable, to allow for classes to be removed.
This button downloads an Excel, or .csv, file with the information in the table above.
This button runs the algorithm, and creates the 2 tables below.
|Student ID||First name||Last name|
|Student ID||First name||Last name||Course assignment|
This button downloads an Excel, or .csv, file with the information in BOTH the Unassigned Students and Assigned Students tables above.