Creating Custom Student Groups using Excel, Access, or some other Microsoft Software-Please help a teacher out.

Question

I want to create groups of students with varying numbers in each group--and factoring in gender, academic grades, etc...  Some students MUST be placed with certain other students.  Is there a way to use Excel to sort students with an IF/THEN relationship?  For example: Jimmy must be placed with Tommy, and Tommy must be placed with Jenny.  How do I sort a group of 127 students into semi-equal groups so the students just listed are defiantly together?  I may need 5 groups, I may need 20 groups for various school activities.

Answer 1

Post the SkyDrive link on the thread to help us check the uploaded file and assist you.

Oopps... here it is.

https://skydrive.live.com/?cid=120480b30c7bfeba#!/edit.aspx?cid=120480B30C7BFEBA&resid=120480B30C7BFEBA%21113

Answer 2

Post the SkyDrive link on the thread to help us check the uploaded file and assist you.

Answer 3

oad a sample file onto the SkyDrive to help us work on the issue and assist you further. Refer the link which explains how to upload the data onto SkyDrive:

http://social.technet.microsoft.com/Forums/en-US/w7itproui/thread/4fc10639-02db-4665-993a-08d865088d65

Note: Make sure that there is no confidential data in the document before uploading the document on the SkyDrive.

Have you had a chance to look at my question/data file?

Answer 4

I created a SkyDrive and uploaded a file so it is public.  It has the information I am trying to sort.

Answer 5

oad a sample file onto the SkyDrive to help us work on the issue and assist you further. Refer the link which explains how to upload the data onto SkyDrive:

http://social.technet.microsoft.com/Forums/en-US/w7itproui/thread/4fc10639-02db-4665-993a-08d865088d65

Note: Make sure that there is no confidential data in the document before uploading the document on the SkyDrive.