Question Difficulty Index Analysis
=COUNTIF(B2:B101,">=&E2)/COUNTA(B2:B101)"ADVERTISEMENT - IN-ARTICLE
Implementation Guide
This task helps teachers analyze question difficulty by calculating the proportion of students who answered correctly. It supports assessment quality improvement and exam calibration. Questions with extremely high or low indices can be reviewed for clarity or alignment with learning objectives. The formula is simple, transparent, and suitable for accreditation documentation. Educators can track difficulty trends over time and across cohorts. This data-driven approach enhances fairness and instructional effectiveness.
💡 Expert Q&A Insights
Q: What is an ideal difficulty range?
Commonly 30–70%, depending on goals. |
Q: Can this work per class?
Yes, filter or segment the data.