Results 1 to 9 of 9

20040824, 15:30 #1
 Join Date
 Aug 2003
 Posts
 57
 Thanks
 0
 Thanked 0 Times in 0 Posts
create a math practice table (excel 2003)
I want to create a table to teach my son about addiction. How can I use function something like Rand to generate the first and second number between 1 to 9 and their sum not bigger than 10.
thanks!

20040824, 16:12 #2
 Join Date
 Jan 2001
 Location
 Ankeny, Iowa, USA
 Posts
 298
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: create a math practice table (excel 2003)
I take it you meant addition instead of addiction.
You can type this formula in cell B2
=RANDBETWEEN(0,10)
and this formula in cell B3
=RANDBETWEEN(0,10B2)
Press F9 to recalculate and get a new set of numbers. You need to have the analysis toolpack installed.

20040824, 16:17 #3
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 Posts
Re: create a math practice table (excel 2003)
What is the world coming to if parent teach their children addiction? <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
See if the attached workbook does what you want. There is a hidden cell that contains the correct answer. Conditional formatting is used to change the background color of the cell in which you enter your answer.

20040824, 16:37 #4
 Join Date
 Aug 2003
 Posts
 57
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: create a math practice table (excel 2003)
Thank you Ban!
That works great. But I have to change to =RANDBETWEEN(1,9)
=RANDBETWEEN(1,10B2) to meet my situation.

20040824, 16:46 #5
 Join Date
 Aug 2003
 Posts
 57
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: create a math practice table (excel 2003)
Sorry for the wrong spelling. Ha Ha!

20040824, 17:09 #6
 Join Date
 Dec 2000
 Location
 Vancouver, Br. Columbia, Canada
 Posts
 268
 Thanks
 0
 Thanked 1 Time in 1 Post
Re: create a math practice table (excel 2003)
Joe:
I am attaching a spreadsheet I wrote a few years ago for my kids. It is a little more advanced than what you are asking for  but it might come in handy next year!
The idea is to create a practice sheet with some random problems, with a mix of twodigit addition and subtraction problems, the sheet is set to print out two versions, one with no answers for the student to practice on, and one with answers because I didn't want to do the work myself (that's what I have Excel for!). Each problem is determined as either addition or subtraction randomly, by comparing a random value to the named value "Test." If Test = 0 then all the problems will be addition  if Test = 1 then all the problems will be subtraction. Test is set in Excel by going through Insert  Name  Define on the menu bar.
In order to minimize the exposure to negative numbers, the "top number" in the problem is a random integer from 0 to 15, while the "bottom number" is a random integer from 0 to 10 (note, this does not eliminate the need to deal with random numbers, but reduces it). I found that I could give these to the kids and let them work on it while I did something else  if I gave them the "answer key" they could mark their own work (although one of them was clever enough to realize that with the answer key and an eraser, a perfect mark was never far away).
If you (or anyone else) is interested, I also extended this to cover larger addition / subtraction problems, as well as multiplication and division, including properly workedout solutions, and I can post them as well.

20040824, 19:09 #7
 Join Date
 Aug 2003
 Posts
 57
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: create a math practice table (excel 2003)
Thanks, Dcardno. The worksheet is very useful. If you can post rest of the worksheets, Everybody and I will appreciate your work.

20040824, 20:53 #8
 Join Date
 Jan 2001
 Location
 La Jolla, CA
 Posts
 1,459
 Thanks
 30
 Thanked 61 Times in 57 Posts
Re: create a math practice table (excel 2003)
As your son progresses, create a few tables in Excel (e.g., a 10x10 addition table). Then, transpose it (you don't have to explain transpose to him at an early age; call it "flipping the table"). Then, compare the resulting cells which will tell him if addition is commutative. You can generalize the table so that you deal with subtraction, multiplication, division and even exponentiation. If Excel (and mathematics) had a symbol for MAX and MIN and others, you could show their relationship as well. But, that's another agrument.

20040824, 23:18 #9
 Join Date
 Dec 2000
 Location
 Vancouver, Br. Columbia, Canada
 Posts
 268
 Thanks
 0
 Thanked 1 Time in 1 Post
Re: create a math practice table (excel 2003)
I've attached them as a Zip file. I hope they are useful for someone.

The Following User Says Thank You to dcardno For This Useful Post:
jcpos (20130220)