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
- Right click on the template and
choose
"Save Target As..." to save spreadsheet to your
computer.
- Open the spreadsheet you just saved. (Opens with Microsoft Office, Open
Office or Star Office.)
- 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
|