Focal Interest
Focal Interest
AI Summary of Peer-Reviewed Research

This page presents an AI-generated summary of a published research paper. The original authors did not write or review this article. [See full disclosure ↓]

Publishing process signals: MODERATE — reflects the venue and review process. — venue and review process.

Spreadsheets can support classroom psychometric analysis

A woman in a white business shirt sits at a wooden desk with a laptop computer, reviewing papers with blue handwriting, while a notebook and pen lay nearby on the desk.
Research area:Decision SciencesStudent Assessment and FeedbackPsychometric Methodologies and Testing

What the study found

The study found that spreadsheet software can be used as a practical environment for classroom psychometric analysis, including Classical Test Theory (CTT) measures and Item Response Theory (IRT) models. It also found that this approach can help teachers interpret test data beyond total scores.

Why the authors say this matters

The authors conclude that this approach may help identify weak items, refine distractors, and build small item banks aligned with competence-based curricula. They also state that it contributes to Sustainable Development Goal 4 (SDG 4), which concerns accessible, equitable, and high-quality education.

What the researchers tested

The researchers presented a methodological demonstration using spreadsheet formulas. They used a simulated dataset of 40 students answering 20 dichotomous items, then computed descriptive statistics and CTT indices such as item difficulty, discrimination, and corrected item–total correlations. They extended the demonstration to IRT by implementing 1PL, 2PL, and 3PL logistic models with forward-calculated item parameters, and used a smaller dataset of 10 students and 10 items to show how the indices and item characteristic curves (ICCs) can be interpreted.

What worked and what didn't

The results show that spreadsheets can support the interpretation of test data beyond total scores. The paper says the approach can support identification of weak items, refinement of distractors, and construction of small-scale item banks. It also notes that IRT parameter estimation is unstable in small samples.

What to keep in mind

The abstract reports limitations: IRT parameter estimation may be unstable in small samples, and teacher training is needed. The summary also says future research should test the approach with real classroom data, explore automation in spreadsheets, and examine artificial intelligence for adaptive assessment.

Key points

  • Spreadsheet software was shown as a practical setting for classroom psychometric analysis.
  • The demonstration covered CTT measures and IRT models, including 1PL, 2PL, and 3PL logistic models.
  • The study used simulated datasets of 40 students with 20 items and 10 students with 10 items.
  • The authors say the approach may help identify weak items, refine distractors, and build small item banks.
  • The abstract notes that IRT estimation can be unstable in small samples and that teacher training is needed.

Disclosure

Research title:
Spreadsheets can support classroom psychometric analysis
Authors:
António Faria, Guilhermina Lobato Miranda
Institutions:
University of Lisbon
Publication date:
2026-02-24
DOI:
10.3390/analytics5010012
OpenAlex record:
View
AI provenance: This post was generated by OpenAI. The original authors did not write or review this post.

More posts