How to group my students using Excel

[dstdst123]

Hi

I have 16 female, 4 male students.
All these 20 students comes from different majors.
12 Physic, 4 Chemistry and 4 Biology.


I want to group them into 4 teams (each team 5 students).

Priority #1:
To ensure at least 1 male student assigned to each team
Priority #2:
Distribute them equally between Physic, chem, and biology
(i.e. each team should have a mix of majors)

Questions:
1) Do I need to write programmes in Excel 2003?

2) Can pivot table help? How to do it in my case?

Thanks a lot.

dstdst123

 

[Martin Brown]

Hi

I have 16 female, 4 male students.
All these 20 students comes from different majors.
12 Physic, 4 Chemistry and 4 Biology.

I want to group them into 4 teams (each team 5 students).

Priority #1:
To ensure at least 1 male student assigned to each team
Priority #2:
Distribute them equally between Physic, chem, and biology
(i.e. each team should have a mix of majors)

Questions:
1) Do I need to write programmes in Excel 2003?

No. This example is trivial.

2) Can pivot table help? How to do it in my case?

Thanks a lot.

If this isn't a computing homework question then I have to wonder if you
should be teaching students. This only requires a pencil and the back of
an envelope.

Start by allocating the 4 male students each to a team.
(constraint #1 matched)

12P, 4C, 4B is exactly soluble for 4 teams signature BCPPP

Male is B add females CPPP
Male is C add females BPPP
Male is P add females BCPP

It would more interesting if some were double majors or with maths.

Regards,
Martin Brown