Please use this identifier to cite or link to this item:

Using Excel to Analyze Multiple-Choice Items – Simple Ways to Improve a Test

File Description Size Format  
Hill 2013 IUPUI Item Analysis.pdf Hill_2013_IUPUI_Item_Analysis.pdf 643.27 kB Adobe PDF View/Open

Item Summary

Title:Using Excel to Analyze Multiple-Choice Items – Simple Ways to Improve a Test
Authors:Hill, Yao Zhang
Keywords:item analysis
learning assessment
Date Issued:29 Oct 2013
Citation:Hill, Y. Z. (2013, October). Using Excel to analyze multiple-choice items: Simple ways to improve a test. Interactive session presented at the IUPUI Assessment Institute Annual Conference, Indianapolis, IN.
Abstract:No test is perfect. Some test items may not be clear or fair to the students. This session provides introductory statistical methods to examine an item’s difficulty level, sensitivity to instructions, and power to differentiate master and non-master students, as well as the quality of the answer choices. The presenter demonstrates the analysis using Excel 2007 and the participants are expected to leave the session knowing the basic item analysis concepts, how to carry out the analysis, and how to interpret the results. The presenter will also showcase an example using item analysis to improve program learning assessment.
Appears in Collections: Workshops and Presentations

Please email if you need this content in ADA-compliant format.

Items in ScholarSpace are protected by copyright, with all rights reserved, unless otherwise indicated.