Email firstname.lastname@example.org to sign up to receive news and updates
With the recent Coronavirus Disease 2019 (COVID-19), many children are at home because schools are closed. Education and fun, however, should not stop. Here is a spreadsheet I created that gets kids practicing subtraction and addition with subtraction stories.
In the spreadsheet, there is a column that randomly selects from several hundred male and female names.
There are columns for the numbers 0 through 20 with their English equivalents. This is because I have the spreadsheet randomly choose if it will display the actual number or the English equivalent in the subtraction stories. If you want to use numbers larger than 20, you will need to add on to these columns. Numbers are randomly selected from the range 2 to 20. I didn't allow 0 or 1 to be selected because it made the problems too easy, as well as increased the minor programming logic I'd need to add to account for singular words and other math and grammar special cases.
There are columns that are used to randomly select a subject, as well as the present and past tense verbs relating to this subject. Note that I tried to include some funny, gross, or entertaining examples that kids might like.
The spreadsheet actually creates three subtraction stories. In each subtraction story the student needs to solve for the unknown x. The first subtraction story is of the "10-x=3" type. The second subtraction story is of the "10-3=x" type. The third subtraction story is of the "x-4=3" type. There are probability parameters that you can set for stories 1 and 2 that will make the spreadsheet randomly select from the three subtraction stories with your specified probabilities. Note, the probability of selecting the third subtraction story is just calculated as 1-(probability story 1 + probability story 2).
I set the Print Area, that is, the area that will be printed out when you click Print, to be the area with the words in the outlined box. This way, you can just open up the spreadsheet and print. You can also press F9 to refresh the random numbers and generate a new subtraction story.
Click here to download the spreadsheet.
You are free to edit the number range, the names, subjects, verbs, and so on, as you need. If you find this spreadsheet useful, please credit Statisticool.com.
Thanks for reading.
Please anonymously VOTE on the content you have just read:Like:
If you enjoyed any of my content, please consider supporting it in a variety of ways:
- PLEASE take a moment to check out two GoFundMe fundraisers I set up. The idea is to make it possible for me to pursue my passions. My goal is to be able to create free randomized educational worksheets and create poetry on a full-time basis. THANK YOU for your support!
- Email email@example.com to sign up to receive news and updates
- Donate any amount via PayPal
- Take my Five Poem Challenge
- Subscribe to my YouTube channel
- Visit my Amazon author page
- Buy what you need on Amazon using my affiliate link
- Follow me on Twitter here
- Buy ad space on Statisticool.com
AFFILIATE LINK DISCLOSURE: Some links included on this page may be affiliate links. If you purchase a product or service with the affiliate link provided I may receive a small commission (at no additional charge to you). Thank you for the support!