Saturday, November 25, 2017

Using Random Formula in Google Sheets to Create Dice

I was recently looking for a way for dice functionality in Google Sheets or Slides. A lot of math games / activities use dice or playing cards so it seems like a natural extension to Google Apps. 

While simplistic, I found the random between formula to do a pretty good job with some tinkering. On the Google Sheet I have a tab for each type of dice. 

I have included dice for a variety of number ranges. This includes a dice for 0-1 to randomized three digit numbers. 

If I was going to use a specific dice for a particular activity I would copy it to a blank spreadsheet. I would then duplicate it for each group or student with that activity in mind.