tominjapan
New Member
- Joined
- Jul 21, 2018
- Messages
- 1
Hello everyone.
I could use some help with creating class memberships. I have about 600 students across 4 departments that need placing in about 16 classes based upon a placement test score, preference survey, and departmental membership. So far I have worked within the database using sort to create the larger groups, vlookup to match usernames with student numbers, and that is about it. This works, until we get the lists of class repeaters, those coming off of a leave of absence, and transfer students. Accommodations as such can change our static set up dramatically and the changes needed have to be done within hours of having to announce class memberships. How can this task be done in a more dynamic manner? I have been all over youtube and have become a little more fluent match, pivot tables, and the like, but have yet to make any real progress. Any ideas? Thank you. - Tom
I could use some help with creating class memberships. I have about 600 students across 4 departments that need placing in about 16 classes based upon a placement test score, preference survey, and departmental membership. So far I have worked within the database using sort to create the larger groups, vlookup to match usernames with student numbers, and that is about it. This works, until we get the lists of class repeaters, those coming off of a leave of absence, and transfer students. Accommodations as such can change our static set up dramatically and the changes needed have to be done within hours of having to announce class memberships. How can this task be done in a more dynamic manner? I have been all over youtube and have become a little more fluent match, pivot tables, and the like, but have yet to make any real progress. Any ideas? Thank you. - Tom
