Spreadsheets‎ > ‎

Word Study

There are three different types of word studies that you can set up (word jumble, multiple choice, and type-in).  Directions are listed below for creating each type.

Setting Up Your Information

  1. On the Google Docs menu bar, click on New and select Spreadsheet.
  2. This is where you will construct your information to be used for your word study.  In cell A1, add a column heading titled “Vocabulary Word.”  In cell B1, add a column heading titled “Definition.”
  3. In the cells below the column heading “Vocabulary Word,” add your list of vocabulary words, with each word in one cell.
  4. In the cells below the column heading “Definition,” add the vocabulary word definition that corresponds to the vocabulary word to the left.
  5. An example of how your spreadsheet may be set up:



Inserting the Word Study - Word Jumble

  1. Make sure your spreadsheet is open.  Select all the cells in your spreadsheet that contain information.  Using the example spreadsheet above, cells A1 to B7 will be selected.
  2. On the Google Docs toolbar, click on Insert and choose Gadget.
  3. Select the Word Study Gadget.  This may be listed under the Featured section, otherwise, click on All and find the Flash Cards Gadget in the list of all gadgets.
  4. Click on the Add to spreadsheet button underneath the gadget listing.  This will insert the gadget on your spreadsheet.
  5. The Word Study Gadget window will open.  Make sure the range of cells listed is correct, the number of heading rows selected is 1, and your flash cards have a title.  Select Word Jumble from the Guess Style drop down menu.  Select the desired Hint Source (no hint, second column, image search, or translation), translation boxes, and if you would like to randomize the words.  Press the Apply and close button.  An example is listed below.

  1. Your gadget will now appear on your spreadsheet.  If you chose an image search, images will automatically be placed on your word study.  You can click and drag to resize the gadget, just as you would with a clip art image.  You may also click and drag to move the gadget to a new location on the spreadsheet.
  2. You may want to play around with some of the settings to make sure the gadget fits your needs.  If you want to edit your gadget at any time, click on the Edit button in the upper left-hand corner of the gadget and change any of the settings.  Select Apply and close to apply the changes and close out of the editing menu.
  3. If you are sharing your spreadsheet with students, it may be beneficial to move your gadget to cover the vocabulary words and definitions you placed in your spreadsheet to avoid any cheating.  Or if you would like the gadget in a sheet all of its own, click on the arrow in the upper right-hand corner of the gadget, and choose Move to own sheet.
  4. An example of a word study using the settings from the menu given above is located below.


Inserting a Word Study - Multiple Choice

  1. Make sure your spreadsheet is open. Select all the cells in your spreadsheet that contain information. Using the example spreadsheet above, cells A1 to B7 will be selected.
  2. On the Google Docs toolbar, click on Insert and choose Gadget.
  3. Select the Word Study Gadget. This may be listed under the Featured section, otherwise, click on All and find the Flash Cards Gadget in the list of all gadgets.
  4. Click on the Add to spreadsheet button underneath the gadget listing. This will insert the gadget on your spreadsheet.
  5. The Word Study Gadget window will open. Make sure the range of cells listed is correct, the number of heading rows selected is 1, and your flash cards have a title. Select Multiple Choice from the Guess Style drop down menu. Select the desired Hint Source (no hint, second column, image search, or translation), translation boxes, and if you would like to randomize the words. Press the Apply and close button. An example is listed below.
  1. Your gadget will now appear on your spreadsheet.  If you chose an image search, images will automatically be placed on your word study.  You can click and drag to resize the gadget, just as you would with a clip art image.  You may also click and drag to move the gadget to a new location on the spreadsheet.
  2. You may want to play around with some of the settings to make sure the gadget fits your needs.  If you want to edit your gadget at any time, click on the Edit button in the upper left-hand corner of the gadget and change any of the settings.  Select Apply and close to apply the changes and close out of the editing menu.
  3. If you are sharing your spreadsheet with students, it may be beneficial to move your gadget to cover the vocabulary words and definitions you placed in your spreadsheet to avoid any cheating.  Or if you would like the gadget in a sheet all of its own, click on the arrow in the upper right-hand corner of the gadget, and choose Move to own sheet.
  4. An example of a word study using the settings from the menu given above is below:

Inserting a Word Study - Type-In

  1. Make sure your spreadsheet is open.  Select all the cells in your spreadsheet that contain information.  Using the example spreadsheet above, cells A1 to B7 will be selected.
  2. On the Google Docs toolbar, click on Insert and choose Gadget.
  3. Select the Word Study Gadget.  This may be listed under the Featured section, otherwise, click on All and find the Flash Cards Gadget in the list of all gadgets.
  4. Click on the Add to spreadsheet button underneath the gadget listing.  This will insert the gadget on your spreadsheet.
  5. The Word Study Gadget window will open.  Make sure the range of cells listed is correct, the number of heading rows selected is 1, and your flash cards have a title.  Select Type-In from the Guess Style drop down menu.  Select the desired Hint Source (no hint, second column, image search, or translation), translation boxes, and if you would like to randomize the words.  Press the Apply and close button.

  1. Your gadget will now appear on your spreadsheet.  If you chose an image search, images will automatically be placed on your word study.  You can click and drag to resize the gadget, just as you would with a clip art image.  You may also click and drag to move the gadget to a new location on the spreadsheet.
  2. You may want to play around with some of the settings to make sure the gadget fits your needs.  If you want to edit your gadget at any time, click on the Edit button in the upper left-hand corner of the gadget and change any of the settings.  Select Apply and close to apply the changes and close out of the editing menu.
  3. If you are sharing your spreadsheet with students, it may be beneficial to move your gadget to cover the vocabulary words and definitions you placed in your spreadsheet to avoid any cheating.  Or if you would like the gadget in a sheet all of its own, click on the arrow in the upper right-hand corner of the gadget, and choose Move to own sheet.
  4. An example of a word study using the settings from the menu given above is below: