Email news@statisticool.com to sign up to receive news and updates
Typos
3/27/20
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 working on identifying typos, or words that are spelled incorrectly.
First, you can copy/paste many words into a single column. I searched the web for things like words for 1st grade, words for 2nd grade, etc. Of course, feel free to enter in any words you want!
For purposes of this spreadsheet, I define a "typo" to be a correctly spelled word that has one letter inserted, substituted, or deleted. For example, if the correctly spelled word is "fungus", then an insertion could be "funguus", a substitution could be "fungis", and a deletion could be "fngus".
You set the frequency of words to have insertions, substitutions, and deletions. The spreadsheet randomly samples from your big list of words, and using your frequencies, creates versions with an insertion, substitution, or a deletion, or leaves the word as is. The insertions, substitutions, and deletions are done at random positions in the words. The letters that are being inserted or substituted in the words are randomly selected from the alphabet (this list can also be edited to exclude certain odd letters like x and z, for example, that may make a typo too obvious).
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, and you're good to go.
Click here to download the spreadsheet.
If you find this spreadsheet useful, please credit Statisticool.com. Thanks for reading.
Please anonymously VOTE on the content you have just read:
Like:Dislike:
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 news@statisticool.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!