Skip to main content
Skip to main content

Office of Teacher Services

Teacher Work Sample Data Collection Information

The file must be opened in Excel 2007 and must stay in the .xlsx format.  If the file is opened in any other version of Excel or saved in a previous version, the pivot tables and formulas will not work. 

1. Open the file in Excel 2007.
2. Read the directions included in the file.
3. Enter the student information as requested in the green area
3. Enter data into the yellow areas, following the format in the example.
4. Remember to scroll down and enter the proficiency Learning Goals. This is the score that indicates proficiency, not the total score for the assessment.
5. In the "Data" tab at the top, click the green "Refresh All" button.
6. You can now view the graphs on the other sheets included in the file.  (you may view the Calculations sheet but do not modify any data on this page)
7. Graphs and tables included in these pages can easily be copied and pasted into Word 2007 using the Copy/Paste function or CTRL-C/CTRL-V.

Things to be aware of:

  • if modifications are made to the data in the yellow area after the initial entry, the student will need to  go to the "Data" tab at the top, click the green "Refresh All" button to update all graphs
  • If you see an error about "invalid references", ignore it and press OK.

Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.

Note: documents in Excel format (XLS) require Microsoft Viewer,
download excel.

Note: documents in Word format (DOC) require Microsoft Viewer,
download word.

Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
download powerpoint.

Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,
download quicktime.

 Last Modified 7/24/17