Assessment Resources

Assessment Spreadsheet Templates

Spreadsheets can help you organize student assessment information and do item analysis automatically.

These spreadsheet templates can be adapted for most assessments you might give

1. Right click on the template and choose "Save Target As..." to save spreadsheet to your computer.
2. Open the spreadsheet you just saved. (Opens with Microsoft Office, Open Office or Star Office.)
3. To keep the original file as is, choose "Save As.." from the file menu and save a new copy for each quarter.

Template for item analysis of assessment

Template for grading and item analysis of assessment
22 Items | 32 Items | 63 Items

These templates have Protection turned on (Tools Menu). You cannot edit the formulas unless you turn off Protection. No password is necessary

PDF file with instructions