Maths worksheets for your kids – teach addition, subtraction & multiplication with these
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.
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.
Leave a Reply
|« How many Excel themed cryptic crossword clues can you solve? [Easter Eggs 2018]||Rescue oddly shaped data – Battle between Formulas, VBA and Power Query »|
10 Responses to “Maths worksheets for your kids – teach addition, subtraction & multiplication with these”
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.
I would love to see the alphabet one. We have a toddler that would love to learn on the computer!
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.
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.
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:
Format the cell as you wish
That's my very basic example along the lines that Chandoo discussed.
I must be missing a step. I have built as discussed but just getting #N/A in cell B1 and C1. I did the number one and it works great.
Appreciate the assistance.
Sorry, I forgot to tell you to put this in cell A1 ...
That should fix it!
Thank you Duncan Williamson! My kiddo will love this 🙂
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.