Random Tool !!

[Cside]

Hi there,


Anyone know any reliable random tool?


Thanks.

 

[Matt77]

For what exactly? Random tool?

 

[Cside]

I'm a teacher assistant, and finding a tool to do random quiz questions, so that students in class does not get identical set of questions, so it must be the stratified random. You know, to first group the elements, then getting the random from every group. (the group would be like each topic for the quiz, must get the questions from every topic).

 

[Matt77]

1) In Excel insert your questions in column A (1 question per line)
2) In Column B, in each row tht contains a question, enter the following: =rand()*100. This simply generates a random number between 1 and 100.
3) Select both columns and then sort (i.e. from the menu bar, click "Data", "Sort"; when prompted, sort by the column that has your randomized numbers)
4) Once sorted, you can copy all of the questions in the Excel file and paste them into Word.