fbpx
Search
Close this search box.

Maths worksheets for your kids – teach addition, subtraction & multiplication with these

Templates - 10 comments

Nishanth & Nakshatra, my kids are now 8 years old and learning mathematics at school. Very soon (from this Saturday), they will have 2 weeks of school term break. As a stay at home dad, I shudder at the thought of school holidays. So this time, I have an evil plan. I made maths worksheets for them. Everyday, I will print one and ask them to complete.

If you are a stay at home parent and want to keep your kids busy for a few minutes every day, grab a copy of this and give it a go. Keep in mind that the workbook uses RANDBETWEEN(), so the numbers change every time. If you have multiple kids, print multiple copies. There are no answer sheets, so when you need to check the answers, you too must calculate them by hand.

So what is in these worksheets?

  • 2 number additions (you can adjust digits)
  • 2 number subtractions (adjust digits)
  • Multiple additions (you can adjust digits and numbers)
  • 2 number multiplication
  • 2 number multiplication vertical orientation

All the best and happy parenting.

For the curious parent or Excel user:

The formulas for most part are relatively simple. That said, the multiple addition worksheet uses interesting uses of INDEX() formula along with conditional formatting to show problems. Examine the worksheet to learn how this works.

Use Excel to teach kids? Share your stories

I use Excel now and then to teach things to kids. A while ago, I built a snowman hot chocolate game to teach them simple programming concepts.

What about you? Do you use Excel to teach your kids? What fun things have you built? Please share your stories in the comments section.

Chandoo

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Written by Chandoo
Tags: , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

10 Responses to “Maths worksheets for your kids – teach addition, subtraction & multiplication with these”

  1. Duncan Williamson says:

    I have done this at college and business school level as well as for accountants and others.

    RANDBETWEEN is ideal for this.

    For every question or question set, I created a solution and used a cross referring code to tie the question and answers together.

    I have had classes of 15 to 30 people and was able to set each student/delegate their own questions/case.

    Using CONCATENATION, too, you can create relatively different questions/cases so that your victims can't just copy and paste or find a very easy way to solve everything even though you think you have created something fabulous.

    I have created a flash card file in Excel for the entire International Financial Reporting Standards Glossary ... hundreds or terms a definitions and i created a separate file to teach a toddler the alphabet.

    • CC says:

      I would love to see the alphabet one. We have a toddler that would love to learn on the computer!

      • NARAYAN says:

        Hi ,

        I wouldn't be in too much of a hurry to introduce computers.

        The real world is vast and beautiful enough to satisfy a child's curiosity ; it is only jaded adults who need a virtual world.

        Let young children involve themselves in physical activity , running around , touching and feeling things , listening to sounds , music. Talk to them , read to them.

        Computers can be introduced when they are 5 or more.

        • Duncan Williamson says:

          I agree with you except for this: by using Excel, I can create flash cards that are easy to randomise, the child can press the F9 button so becomes involved. we can make the cards colourful and stimulating and you can even build in additional feedback if you wish.

      • Duncan Williamson says:

        I am travelling at the moment but will post my coding here shortly ... unless someone beats me to it.

        No VBA needed either!

      • Try this ... very basic so that you should find it very easy to do.

        A go button would be handy, of course, rather than relying on the F9 key.

        In the range D3:F28 I have stored

        Column 1 Numbers 1 to 26 Column 2 Capital letters Column 3 Lower case letters

        In cell B1 =VLOOKUP(A1,$D$3:$F$28,2,0)
        In cell C1 =VLOOKUP(A1,$D$3:$F$28,3,0)

        Format cells B1:C1 with font size 144 or whatever it takes to make both cells to be seen at the same time ... if you like it that way

        Have upper case blue and lower case the same or a different colour as you want

        Press the F9 key and the letters change

        I have done the same for numbers, on a different sheet. In that case, enter =RANDBETWEEN(1,10) in B1, format as above ... this is just number recognition from 1 to 10 ... or any numbers you want!

        On sheet three I have entered =VLOOKUP(A1,F15:G29,2,0) in cell B1 and stored a range of words in a lookup table to go with this:

        1 Abi
        2 Mama
        3 Papa
        4 Elsa
        5 Anna
        6 Olaf
        7 Sven
        8 Moon
        9 Sun
        10 Star
        11 School
        12 Car
        13 Garden
        14 Bed
        15 Sleep
        ...
        Format the cell as you wish

        That's my very basic example along the lines that Chandoo discussed.

  2. John says:

    I have a daughter who graduated with 4.0 in Chemistry from college. She once told me the best thing I ever taught her in home schooling was how to use Excel. So she did not have to learn it in college.

Leave a Reply


« »