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.

$20

Introduction to the NEW Google Classroom Online Workshop

Google Classroom has rolled out a new interface. Be ready for Fall, let’s look at the new Google Classroom and how to use Google Classroom.
Starts Monday, August 27th

Image result for google classroom
Register at alicekeeler.com/goslow