Words+Their+Way+Online+Pre-Test+Directions

=Words Their Way= Directions for setting up a Words Their Way online pre-test through Google Docs and School Center.

Tips for Test Taking:
 * 1) Use Firefox since it will not correct spelling by default.
 * 2) Have students enter their names Last name first, First name last (This will make sorting easier).
 * 3) If you find that items from the last student to take it are appearing on the test as the new student types:
 * 4) Go to Preferences in Firefox (Under the Firefox Menu item).
 * 5) Select the Privacy Tab.
 * 6) Take the checkmark out of the box that reads "Remember what I enter in forms and the search bar."
 * 7) Quit Firefox and reopen.

Step 1 - Create a Custom Form (This only has to be done once!)

 * 1) Sign in to Google Docs
 * 2) Click on this link to access the Words Their Way Pretest Template.
 * 3) From the Google Docs File menu, choose "Make a Copy" to duplicate the spreadsheet and make your own form.
 * 4) Rename the document.
 * 5) From the Form menu, choose the "Go to live form" option.
 * 6) Copy the URL/address for the live form
 * 7) Log in to School Center and go to your teacher page.
 * 8) In Edit mode, click on the "Edit Navigation" option.
 * 9) On the bottom left under "Custom Items" you will find a "Custom Link" button. Drag that button up into the "Left" column and place it where you want it on your list of pages.

Step 2 - Export the Test Results

 * 1) Log into School Center
 * 2) Go to your custom form page (Spelling Pretest or whatever you named it)
 * 3) Click on Edit to go into edit mode and see your editing toolbar.
 * 4) Click the button on the far right that says, "Response Data" [[image:Screen_shot_2010-09-#4CDEB7.png]]
 * 5) The page that comes up will look blank under all 3 tabs...Just ignore that and click the export button on the right (it looks like a globe with an arrow).The file will download as a .csv file and it will open up in Excel. [[image:Screen_shot_2010-09-#4CDEB8.png]]
 * 6) The file will download as a .csv file and it will open up in Excel.

Step 3 - Copy Results to the Words Their Way Spreadsheet
Download the WTW Spreadsheet:


 * 1) Sort the names by clicking in the column and choosing the "Sort Ascending" button in the toolbar (it looks like an A to Z). Or doing a sort through the Data menu.
 * 2) Highlight the names of your students all the way through Word 25. DO NOT highlight anything past Word 25.
 * 3) Copy those cells.
 * 4) Open the Words Their Way Spreadsheet.
 * 5) Paste it into the cell that reads "Click here and paste" on the Tests sheet.
 * 6) Save your document.
 * 7) Click on the "Fall" tab at the bottom of the spreadsheet to switch to the results of your first test.
 * 8) "S1-S30" Tabs are for the individual student results.