Please use this identifier to cite or link to this item:
Using Excel to Analyze Multiple-Choice Items – Simple Ways to Improve a Test
|Hill 2013 IUPUI Item Analysis.pdf||Hill_2013_IUPUI_Item_Analysis.pdf||643.27 kB||Adobe PDF||View/Open|
|Title:||Using Excel to Analyze Multiple-Choice Items – Simple Ways to Improve a Test|
|Authors:||Hill, Yao Zhang|
|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 email@example.com if you need this content in ADA-compliant format.
Items in ScholarSpace are protected by copyright, with all rights reserved, unless otherwise indicated.