Tag Archives: random number generator

IditaRead: Using the RANDBETWEEN function in MS Excel to practice plotting team positions

Check out the functionality of the MS Excel IditaRead workbooks by using the RANDBETWEEN function on the Data sheet.

RANDBETWEEN allows you to set minimum and maximum integers, so you can see how team positions might play out by generating random numbers.

For example, if your target reading time per day is 45 minutes, consider students reading between 0 and 60 minutes per day.  Your formula would then be =RANDBETWEEN(0,60)

Screen shot 2016-02-25 at 9.24.40 AM

Put this formula in the Day 1 cell on the Data sheet and Fill Down for all your readers.  Check the Trail Position sheet for exact locations of each team and pin them on your Google map.

Screen shot 2016-02-26 at 6.34.51 PM
Exact positioning of team positions on the trail.

Screen shot 2016-02-25 at 9.21.24 AM