Coronavirus lockdown week 11? – Let’s continue with what has now become a series of posts on educational kids activities spreadsheets. As a reminder, Part 1 was a Math Dice spreadsheet game and Part 2 was a Custom Math Worksheet Generator. Today’s spreadsheet will hop over to the English language part of elementary education and help you quiz your kids on their sight words.
Our goal is to take a list of sight words and randomly pull one word every time the sheet is refreshed so you can quiz your child. Sight words are frequently occurring words that kids should memorize rather than sound out.
Spreadsheet Inputs
- The list of Dolch sight words. Edward William Dolch compiled this list of words, which were published in a journal in 1936.
- The grade level. We’ll do a little trick here where we add a drop down menu by using the Data Validation function to select from the list of possible grade levels in the above screen, cells F4:F48.
Spreadsheet Output
Once you pick a grade level, the spreadsheet will use the Randbetween() function to generate a random number between 1 and the maximum number of words in that grade level. Then it uses a vlook function to return the word with which you can torture test your child.
Try it out yourself by downloading the spreadsheet here: Dolch Sight Words quiz spreadsheet. Remember to hit the F9 key to recalculate the worksheet and generate a new random sight word.