In my department we have a laptop setup with Excel 2007 so that a student can walk in, scan his ID with a barcode scanner, and then be counted for attendance. This was very simple with the VLOOKUP formula. However, I have now been assigned the task of setting up a similar program only now I must make it so when the student scans his/her ID then it will give that student a random job.
I have three major problems when it comes to this:
1. I can't have jobs assigned to a student who is not there
2. I prefer the jobs be random, but cannot be given consecutively and must be evenly distributed
There are 25 students total that need to be involved, 13 juniors and 12 seniors with 8 jobs that need to be assigned. I will attach my template although I am able to be flexible on the setup.
Bookmarks