Please use this identifier to cite or link to this item: http://hdl.handle.net/10125/48538

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

File Description SizeFormat 
Hill_2013_IUPUI_Item_Analysis.pdfHill_2013_IUPUI_Item_Analysis.pdf643.27 kBAdobe PDFView/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
Issue Date: 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.
Pages/Duration: 17
URI/DOI: http://hdl.handle.net/10125/48538
Appears in Collections:Workshops and Presentations



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