In this case, I needed to select between 1 and 99 coins. Excel has a random number generator that picks numbers between 0 and 1. If you multiply the random number by 99 and round up, you will get a random selection of numbers between 1 and 99. Once I get the formula right, I simply copy it down the column and it will generate different numbers in every cell! Here is the statement in Excel that worked:
Because I wanted to make sure she had multiple chances to work with 1 to 9 coins, I copied the following formula into several of the cells to force randomly generated, single- digit numbers:
In the next column, I needed to alternate between pennies and dimes from one problem to another. I set up a logical statement that puts in the word dimes when the random number is less than .5 and pennies for all other numbers. Here is what worked:
Here is what these three formulas produced in ten rows of problems:
I just LOVE technology!