• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Allocation of students to preferred classes

K

ker28

New Member
I have a project of scheduling students to their preferred classes. Each student can have up to 3 choices of timeslots.

I have the following data:

1) Students’ particulars


2) Constraint #1: All classes must have a minimum number of 8 students and only a maximum of 15 students. If the min no. of students is not hit, the class at that particular timing will not be opened. If a class exceeds 15 students, the first 15 students who chose that particular timeslot will be given that class whereas the remaining students will be given classes in their 2nd or 3rd option or even none at all.

Aim:

The aim is to assign a particular student (identified here with a unique application id) a class in his/her first preferred timing.

This is my first time doing a project using excel and would appreciate all the help that I can get. Thank you all in advance!
 
Hi,
Pls upload a sample file with all the inputs, and expected output format as well.

It would help in providing quick solution.

Regards,
Prasad DN
 
prasaddn said:
Hi,
Pls upload a sample file with all the inputs, and expected output format as well.

It would help in providing quick solution.

Regards,
Prasad DN
Click to expand...
Hi Prasad,

Thank you for your response. I have attached a sample file. Please feel free to let me know if you need anything from me.

Jo
 

Attachments

  • Allocation of students to preferred classes.xlsx
    14.4 KB · Views: 7
Hi Jo ,

If you are going to allot everyone's first choices , then neither the BASIC nor the INTERMEDIATE classes would be held , since the number for every slot is far below 8. What is to be done ?

Narayan
 
NARAYANK991 said:
Hi Jo ,

If you are going to allot everyone's first choices , then neither the BASIC nor the INTERMEDIATE classes would be held , since the number for every slot is far below 8. What is to be done ?

Narayan
Click to expand...

Hi Narayan

It's my bad for not providing the whole picture. From the second tab, you can see that there are different levels (basic/inter/adv) of classes available to students.

however,
1) a student can only be allocated a timeslot of a same-level class. For e.g. a student who completed basic class is now signing up for intermediate classes.

2) a student can only make his 3 choices from the 6 classes available for each level. Assuming that he can always make it for at least 3 of the timeslots given (which he would have then indicated as his 3 choices), how do i allocate him a class? I will have to factor in the fact that a class will have to meet a min of 8 students and max of 15 students. Let's say his first choice only has 7 people, that class will not be opened and he will have to be allocated either his 2nd or 3rd choice or none at all.

My apologies for being vague. The output format is not fixed. You can give me any suggestions or tell me if i missed any important fields out. Thank you for your patience!
 
Hi Jo ,

I think there is some misunderstanding.

Just filter your data for , let us say , the BASIC class. There are 16 students who are taking this class , out of which the first choice for time slot A is 5. The first number of people who have opted for the other time slots is even less.

How do we go about allotting students for this class ?

Given your constraint that students should be allotted their first choice time slot , nothing is possible ; if we can allot someone their second or even third choice , then the BASIC class can be scheduled , with 8 students in time slot A , and 8 students in time slot B.

Narayan
 
You must log in or register to reply here.
Back
Top