A Random Student Name Picker

[Transitory]

Hi,

I have an idea I think for teaching that I think could be done in excel, but I'm not sure. I imagine it will require some programming. Basically:

I want to have excel display 3 names at random from a list of students. It would look something like this:

Up Now: Bob
On Deck: Jamie
In the hole: Jorge

Then, when Bob talks, there are two options. Either Bob answers satisfactorily or not. If he does, he is removed from the list and Jamie moves to 1st, Jorge moves to second, and a new student moves into the third position. If he does not, Bob moves to the third position (to get some wait time), Jorge goes to 2nd, and Jamie goes to 1st.

The concept seems simple, but I'm unsure of the execution. Any help would be appreciated

[Sindhus]

You can try this structure. You should have the list of students in column a and active/inactive in column b. Whoever removed from the list would be inactive.

When you are running this for the first time, you can use the randbetween function to find three students randomly. i.e index(list_of_Students,randbetween(1,total_Students),1). This will be entered in c1, c2, c3

After the first person talks, enter 1/0 (say in range(D1) for satisfactory/non-satisfactory and run a vba code.

Please Login or Register  to view this content.