Menu

How to group my students using Excel

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Martin Brown Martin Brown is offline

Martin Brown is offline

external usenet poster

Posts: 230

Default

How to group my students using Excel

On 10/12/2010 13:33, wrote:
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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
students course	Jimmy	Excel Programming	1	October 27th 08 07:42 AM
Add New Students	[email protected]	Excel Discussion (Misc queries)	2	June 26th 07 01:37 PM
How can I use Excel to schedule students for classes?	Mort 62	Excel Discussion (Misc queries)	1	September 8th 05 03:45 PM
Why not introducing worksheet for business students in MS EXCEL?	Syed Ibne Ali	Excel Discussion (Misc queries)	1	April 10th 05 01:28 PM
Where can I get excel worksheets for students in college	Nelson	Excel Worksheet Functions	2	March 8th 05 04:32 PM

All times are GMT +1. The time now is 07:14 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement