I am responsible for assigning lunch tables at the school which I work. There are 415 students, 48 teachers/staff that are assigned to two lunches. First lunch has 4 grade levels and second lunch has 5 grade levels. The table assignments are broken into:
1. 8 students and 1 adult per table
2. Of the 8 students they are divided into 2 per grade level and the gender is divided 50/50. The adult's grade and gender are not taken into consideration for this divide.
3. Each table is reassigned quarterly and cannot have:
a. Student repeat a table. i.e. if Sally is at Table #1 for the 1st quarter, she cannot return to table 1 for quarters 2, 3 or 4.
b. Students cannot repeat a pairing at a table. i.e. if Sally and Johnny are at Table #1 for the 1st quarter, then Sally is assigned to Table #2, Johnny cannot be at either Table #1 or Table #2
c. Siblings cannot be at the same table (filter for last name)
d. Students with the same teacher cannot share a table
e. Limit number of students with allergies to 1 or 2 per table
f. there are not an even number of students and genders per grade, at the end tables, extra students must be distributed among the tables. i.e. there are more 6th grade girls than any other grade/gender combination. At some tables, need assign 4 6th grade girls instead of two but maintaining the 50/50 gender balance.
4. I currently use an excel spreadsheet but mainly as a table. The headers are: Q1 Table, Q2 Table, Q3 Table Q4 Table, First Name, Last Name, Grade, Teacher, Allergies, Spanish, Gender and RAND. (The Spanish column is only for informational purposes and not used in the sort)
There is not a hard deadline for this project. Q4 starts March 28th, but if necessary we can skip this school year. Then the deadline would be closer to July 1.
17 freelanceria on tarjonnut keskimäärin 118 $ tähän työhön
Hi, I have understood your project requirements. I shall provide impeccable quality work for your project. Please contact me Best regards.............