Student Scores Optimization

Rebalance 100 students on 7 teams into 5 new teams of different sizes, using Linear Programming to minimize the difference between the avg team score.

Making the teams as balanced as possible.


More detail can be found here

Current Team State

Team Average
43.250000
45.421875
47.634615
47.750000
50.852941
48.916667
44.458333


Boxplot of Team Skills


current_boxplot

Future Team State

Groundrules:


  • New Teams were created by minimizing the difference between team averages
  • Finds optimal/feasible solution where at least 1 person with a score of 70 or more in each Skill Category
  • Each team must be matched preset team size [15, 25, 20, 20, 20].


    • Boxplot of Team Skills

    All 5 future teams have identical team averages.

    Future Team means = 47.05 ✅


    future_boxplot


    v0.5