How do you call on students in class? I use a spreadsheet and the =rand() formula.

  • Create  spreadsheet with student names
  • In the column next to their name write the formula =rand()
  • Sort the sheet by the random number and a random student will float to the top.

Since each time you sort the sheet it reassigns a NEW random number you can continue to sort by the random number column to continuously call on students randomly.

Bonus:

  • Create a 3rd column (C) “without replacement”
  • Create a 4th column (D) “Called on”
  • Each time you call on a student mark them off with an x in the “Called on” column.
  • In the “without replacement” column type this formula
    =if(D2=”x”,””,B2)
    Which states that if there is an x in the “called on” column put nothing in the “without replacement” column, otherwise insert the random number.
  • Sort the sheet by the “without replacement” column.
  • Any student who has been marked with an x in the “called on” column will sink to the bottom so they will not be called on again.

 

If you would like a template of this click here.