Stainless02
New Member
- Joined
- Sep 21, 2015
- Messages
- 21
Good morning all, please stay with me on this. I am after formulas or macros that have some flexibility for timetabling and lesson allocation...
The situation is I have up to 32 students (learning to be instructors) and have a bank of lessons. The first step I would like to achieve is automatically (randomly) pairing students and then automatically allocating a lesson to that pair. I would like it to keep cycling through the lesson list until all pairs are allocated.
I would like the lesson and student list to be dynamic so that it future proofs the workbook as lessons and student numbers change and an awesome addition would be, to have a couple of lesson banks so that we can progressively allocate harder lessons as they progress through course.
Not sure if this is a fantasy or not but thought I would ask some experts.
Cheers
The situation is I have up to 32 students (learning to be instructors) and have a bank of lessons. The first step I would like to achieve is automatically (randomly) pairing students and then automatically allocating a lesson to that pair. I would like it to keep cycling through the lesson list until all pairs are allocated.
I would like the lesson and student list to be dynamic so that it future proofs the workbook as lessons and student numbers change and an awesome addition would be, to have a couple of lesson banks so that we can progressively allocate harder lessons as they progress through course.
Not sure if this is a fantasy or not but thought I would ask some experts.
Cheers