Results 1 to 9 of 9
  1. #1
    Star Lounger
    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!

  2. #2
    3 Star Lounger
    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,10-B2)

    Press F9 to recalculate and get a new set of numbers. You need to have the analysis toolpack installed.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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.

  4. #4
    Star Lounger
    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,10-B2) to meet my situation.

  5. #5
    Star Lounger
    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!

  6. #6
    3 Star Lounger
    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 two-digit 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 worked-out solutions, and I can post them as well.

  7. #7
    Star Lounger
    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.

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    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.

  9. #9
    3 Star Lounger
    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.

  10. The Following User Says Thank You to dcardno For This Useful Post:

    jcpos (2013-02-20)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •