Excel spreadsheets for item and test analysis
WebClass calculates a number of test and item statistics automatically. In addition, test scores can be downloaded to Excel and analyzed using, for example, the following spreadsheets (based on Brown, J. D., & Hudson, T. (2002). Criterionreferenced Language Testing. Cambridge: Cambridge University Press):
 Item analysis will calculate:
 Item Facility (IF)
 Cutscore indices
 Bindex
 Item phi (φ)
 Agreement statistic (A)
 Reliability/Dependability will calculate (among others):
 Dependability of domain score estimates
 the phi coefficient (Φ), using a shortcut formula for 01 tests
 Squarederror loss agreement indices
 phi lambda (Φ_{λ}), using a shortcut formula for 01 tests
 kappa squared (κ^{2})
Generalizability Calculations
Gcoefficients can be calculated here:
