Teacher2Teacher |
Q&A #5986 |
From: Loyd
To: Teacher2Teacher Public Discussion
Date: 2003110112:24:45
Subject: Addition Worksheets Using Excel
The following worksheet is easy to make and once made for 2's as shown, then it is easy to replace all the 2's with 3's etc. The top row of each problem has the formula "=10*RAND() typed in. You then print this sheet and reproduce as necessary. If you need one for threes, just go to the first 2 in the lower number and insert a 3. Then highlight the row and copy right. That will put threes in all the cells for that row. Then select the entire row, copy and then paste into each of the lower addends. May sound difficult, but it is really very simple. The next time you open up the worksheet, the upper addend will be randomly selected so you have all the variety you need. The sheet shown here can be wider, but I was afraid it would wrap around so I shortened each row. My worksheets I make for grandchildren have nine problems in each row. It really pays for teachers to learn to use spreadsheets. By the way, Excel will stay in alignment better than the following. Addition: NAME------------- 5 9 1 9 1 7 2 2 2 2 2 2 2 2 ------- ------- ------- ------- ------- ------- ------- 5 3 10 3 8 9 4 2 2 2 2 2 2 2 ------- ------- ------- ------- ------- ------- ------- 7 2 0 1 1 8 4 2 2 2 2 2 2 2 ------- ------- ------- ------- ------- ------- -------
Post a reply to this message
Post a related public
discussion message
Ask Teacher2Teacher a new question
[Privacy Policy] [Terms of Use]
Math Forum Home ||
The Math Library ||
Quick Reference ||
Math Forum Search