{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,24]],"date-time":"2026-02-24T14:05:08Z","timestamp":1771941908627,"version":"3.50.1"},"reference-count":60,"publisher":"MDPI AG","issue":"1","license":[{"start":{"date-parts":[[2026,2,24]],"date-time":"2026-02-24T00:00:00Z","timestamp":1771891200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"name":"National Funds through FCT-Portuguese Foundation for Science and Technology","award":["UID\/04107\/2025"],"award-info":[{"award-number":["UID\/04107\/2025"]}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Analytics"],"abstract":"<jats:p>The evaluation of student performance often relies on basic spreadsheet outputs that provide limited insight into item functioning. This study presents a methodological demonstration showing how widely available spreadsheet software can be transformed into a practical environment for psychometric analysis. Using a simulated dataset of 40 students responding to 20 dichotomous items, spreadsheet formulas were developed to compute descriptive statistics and Classical Test Theory (CTT) indices, including item difficulty, discrimination, and corrected item\u2013total correlations. The demonstration was extended to Item Response Theory (IRT) through the implementation of 1PL, 2PL, and 3PL logistic models using forward-calculated item parameters. A smaller dataset of 10 students and 10 items was used to illustrate the interpretability of the indices and the generation of Item Characteristic Curves (ICCs). Results show that spreadsheets can support teachers in in-terpreting test data beyond total scores, enabling the identification of weak items, refinement of distractors, and construction of small-scale item banks aligned with competence-based curricula. The approach contributes to Sustainable Development Goal 4 (SDG 4) by promoting accessible, equitable, and high-quality assessment practices. Limitations include the instability of IRT parameter estimation in small samples and the need for teacher training. Future research should apply the approach to real classroom data, explore automation within spreadsheet environments, and examine the integration of artificial intelligence for adaptive assessment.<\/jats:p>","DOI":"10.3390\/analytics5010012","type":"journal-article","created":{"date-parts":[[2026,2,24]],"date-time":"2026-02-24T12:19:23Z","timestamp":1771935563000},"page":"12","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Operationalising CTT and IRT in Spreadsheets: A Methodological Demonstration for Classroom Assessment"],"prefix":"10.3390","volume":"5","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-3088-9464","authenticated-orcid":false,"given":"Ant\u00f3nio","family":"Faria","sequence":"first","affiliation":[{"name":"UIDEF, Instituto de Educa\u00e7\u00e3o, Universidade de Lisboa, 1649-013 Lisboa, Portugal"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4423-4522","authenticated-orcid":false,"given":"Guilhermina Lobato","family":"Miranda","sequence":"additional","affiliation":[{"name":"Instituto de Educa\u00e7\u00e3o, Universidade de Lisboa, 1649-013 Lisboa, Portugal"}]}],"member":"1968","published-online":{"date-parts":[[2026,2,24]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","unstructured":"Bruner, J. (1960). The Process of Education, Harvard University Press.","DOI":"10.4159\/9780674028999"},{"key":"ref_2","unstructured":"Bruner, J. (1966). Toward a Theory of Instruction, Harvard University Press."},{"key":"ref_3","doi-asserted-by":"crossref","first-page":"39","DOI":"10.1007\/BF02504993","article-title":"Blueprints for complex learning: The 4C\/ID-model","volume":"50","author":"Clark","year":"2002","journal-title":"ETR&D"},{"key":"ref_4","doi-asserted-by":"crossref","first-page":"114","DOI":"10.1037\/xap0000363","article-title":"True-false tests enhance retention relative to rereading","volume":"28","author":"Uner","year":"2022","journal-title":"J. Exp. Psychol. Appl."},{"key":"ref_5","first-page":"35","article-title":"The importance of testing as a learning strategy","volume":"76","author":"Roediger","year":"2019","journal-title":"Sch. Adm."},{"key":"ref_6","first-page":"23","article-title":"Factores relevantes na avalia\u00e7\u00e3o escolar por perguntas de escolha m\u00faltipla","volume":"5","author":"Pinto","year":"2001","journal-title":"Psicol. Educ. Cult."},{"key":"ref_7","first-page":"246","article-title":"Teachers\u2019 attitude towards the use of excel software, to teach and learn statistics on learner\u2019s performance in rwanda\u2019s kicukiro public upper secondary schools","volume":"8","author":"Gasigwa","year":"2024","journal-title":"J. Res. Innov. Implic. Educ."},{"key":"ref_8","first-page":"40","article-title":"Excel As an ICT Tool For Increasing Teacher Proficiency Towards Quality Education: A Panacea for Addressing Challenges Confronting Nigeria Education System","volume":"10","author":"Muhammad","year":"2024","journal-title":"Int. J. Educ. Eval."},{"key":"ref_9","unstructured":"Hambleton, R., Swaminathan, H., and Rogers, H. (1991). Fundamentals of Item Response Theory, SAGE."},{"key":"ref_10","first-page":"275","article-title":"Understanding the role of digital technologies in education: A review","volume":"3","author":"Haleem","year":"2022","journal-title":"Sustain. Oper. Comput."},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"50","DOI":"10.33542\/JTI2025-1-05","article-title":"The rasch analysis of item response theory: An untouched area in evaluating student academic translations","volume":"18","author":"Akbari","year":"2025","journal-title":"SKASE J. Transl. Interpret."},{"key":"ref_12","first-page":"1397","article-title":"The integration of classical testing theory and item response theory","volume":"12","author":"Hu","year":"2021","journal-title":"Psychology"},{"key":"ref_13","doi-asserted-by":"crossref","first-page":"384","DOI":"10.26803\/ijlter.21.8.22","article-title":"The classical test or item response measurement theory: The status of the framework at the examination council of Lasotho","volume":"21","author":"Ayanwale","year":"2022","journal-title":"Int. J. Learn. Teach. Educ. Res."},{"key":"ref_14","first-page":"57","article-title":"Comparative study of classical test theory and item response theory using diagnostic quantitative economics skill test item analysis results","volume":"3","author":"Eleje","year":"2018","journal-title":"Eur. J. Educ. Soc. Sci."},{"key":"ref_15","unstructured":"Allen, M., and Yen, W. (1979). Introduction to Measurement Theory, Brooks\/Cole Publishing Company."},{"key":"ref_16","doi-asserted-by":"crossref","unstructured":"Kurniawan, D.D., Syifa, A., Huda, N., and Kusuma, M. (2022). Item analysis of teacher made test in Biology subject. 5th International Conference on Current Issues in Education (ICCIE 2021), Atlantis Press.","DOI":"10.2991\/assehr.k.220129.057"},{"key":"ref_17","first-page":"139","article-title":"Using classical test and item response theories to evaluate psychometric quality of teacher-made test in Ghana","volume":"18","author":"Butakor","year":"2022","journal-title":"ESJ"},{"key":"ref_18","doi-asserted-by":"crossref","first-page":"939","DOI":"10.22219\/jpbi.v10i3.34345","article-title":"Analysis of biology midterm exam items using a comparison of the classical theory test and the Rasch model","volume":"10","author":"Priyani","year":"2024","journal-title":"JPBI"},{"key":"ref_19","unstructured":"Nasir, M. (2014). Application of Classical Test Theory and Item Response Theory to Analyze Multiple Choice Questions. [Doctoral Thesis, University of Calgary]. Available online: http:\/\/hdl.handle.net\/11023\/1917."},{"key":"ref_20","doi-asserted-by":"crossref","first-page":"241","DOI":"10.1590\/S0102-79722013000200004","article-title":"Avan\u00e7os na psicometria: Da teoria cl\u00e1ssica dos testes \u00e0 teoria de resposta ao item","volume":"26","author":"Sartes","year":"2013","journal-title":"Psicol. Reflex\u00e3o Cr\u00edtica"},{"key":"ref_21","doi-asserted-by":"crossref","unstructured":"Bhakta, B., Tennant, A., Horton, M., Lawton, G., and Andrich, D. (2005). Using item response theory to explore the psychometric properties of extended matching questions examination in undergraduate medical education. BMC Med. Educ., 5.","DOI":"10.1186\/1472-6920-5-9"},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"604","DOI":"10.11591\/ijere.v11i2.22233","article-title":"The quality of test on national examination of natural science in the level of elementary school","volume":"11","author":"Hamidah","year":"2022","journal-title":"Int. J. Eval. Res. Educ."},{"key":"ref_23","doi-asserted-by":"crossref","unstructured":"Brown, G., and Abdulnabi, H. (2017). Evaluating the quality of higher education instructor-constructed multiple-choice tests: Impact on student grades. Front. Educ., 2.","DOI":"10.3389\/feduc.2017.00024"},{"key":"ref_24","doi-asserted-by":"crossref","first-page":"167","DOI":"10.14483\/udistrital.jour.calj.2014.2.a03","article-title":"Classical test theory and item response theory: Two understandings of one high-stakes performance exam","volume":"16","author":"Janssen","year":"2014","journal-title":"Colomb. Appl. Linguist. J."},{"key":"ref_25","doi-asserted-by":"crossref","first-page":"335","DOI":"10.1111\/bjet.13270","article-title":"Beyond item analysis: Connecting student behaviour and performance using e-assessment logs","volume":"54","author":"Lahza","year":"2022","journal-title":"Br. J. Educ. Technol."},{"key":"ref_26","unstructured":"Furr, R., and Bacharach, V. (2018). Psychometrics: An Introduction, SAGE."},{"key":"ref_27","doi-asserted-by":"crossref","first-page":"1013","DOI":"10.21449\/ijate.1164590","article-title":"Investigation of the effect of parameter estimation and classification accuracy in mixture IRT models under different conditions","volume":"9","author":"Atar","year":"2022","journal-title":"Int. J. Assess. Tools Educ."},{"key":"ref_28","doi-asserted-by":"crossref","first-page":"385","DOI":"10.35445\/alishlah.v14i1.926","article-title":"Estimating item parameters and student abilities: An IRT 2PL analysis of mathematics examination","volume":"14","author":"Jumini","year":"2022","journal-title":"Al-Ishlah J. Pendidik."},{"key":"ref_29","doi-asserted-by":"crossref","first-page":"e1208","DOI":"10.1002\/lio2.1208","article-title":"A scoping review of Rasch analysis and item response theory in otolaryngology: Implications and future possibilities","volume":"9","author":"Liu","year":"2024","journal-title":"Laryngoscope Investig. Otolaryngol."},{"key":"ref_30","doi-asserted-by":"crossref","first-page":"280","DOI":"10.18222\/eae255720142832","article-title":"Aplica\u00e7\u00e3o da Teoria da Resposta ao Item uni e multidimensional","volume":"25","author":"Barbetta","year":"2014","journal-title":"Estud. Em Avalia\u00e7\u00e3o Educ."},{"key":"ref_31","unstructured":"Howells, K. (2018). The Future of Education and Skills: Education 2030: The Future We Want, OECD. Available online: https:\/\/repository.canterbury.ac.uk\/download\/96f6c3f39ae6dcffa26e72cefe47684172da0c93db0a63d78668406e4f478ae8\/3102592\/E2030%20Position%20Paper%20%2805.04.2018%29.pdf."},{"key":"ref_32","unstructured":"Dillon, S. (2019). OECD Future of Education and Skills 2030: OECD Learning Compass 2030, OECD. Available online: https:\/\/www.oecd.org\/content\/dam\/oecd\/en\/about\/projects\/edu\/education-2040\/1-1-learning-compass\/OECD_Learning_Compass_2030_Concept_Note_Series.pdf."},{"key":"ref_33","unstructured":"Le, C., Wolfe, R., and Steinberg, A. (2025, November 11). The Past and the Promise: Today\u2019s Competency Education Movement, Available online: https:\/\/files.eric.ed.gov\/fulltext\/ED561253.pdf."},{"key":"ref_34","unstructured":"(2025, November 15). Education Commission of the States. Available online: https:\/\/www.ecs.org\/wp-content\/uploads\/CBE-Toolkit-2017.pdf."},{"key":"ref_35","doi-asserted-by":"crossref","first-page":"e01228","DOI":"10.1002\/cbe2.1228","article-title":"Making sense of K-12 competency-based education: A systematic literature review of implementation and outcomes research from 2000 to 2019","volume":"5","author":"Evans","year":"2020","journal-title":"J. Competency-Based Educ."},{"key":"ref_36","unstructured":"Looney, J., and Kelly, G. (2023). Assessing Learners\u2019 Competences\u2014Policies and Practices to Support Successful and Inclusive Education\u2014Thematic Report, Publications Office of the European Union. Available online: https:\/\/curated-library.iiep.unesco.org\/library-record\/assessing-learners-competences-policies-and-practices-support-successful-and."},{"key":"ref_37","unstructured":"European Commission\/EACEA\/Eurydice (2012). Developing Key Competences at School in Europe: Challenges and Opportunities for Policy, Publications Office of the European Union. Available online: https:\/\/eurydice.eacea.ec.europa.eu\/publications\/developing-key-competences-school-europe-challenges-and-opportunities-policy."},{"key":"ref_38","first-page":"297","article-title":"Improvements in bASES21: 21st-Century Skills Assessment Model to K12","volume":"Volume 1","author":"Pacheco","year":"2020","journal-title":"Proceedings of the 12th International Conference on Computer Supported Education (CSEDU 2020)"},{"key":"ref_39","unstructured":"European Commission, Directorate-General for Education and Culture (2019). Key Competences for Lifelong Learning, Publications Office of the European Union. Available online: https:\/\/www.fi.uu.nl\/publicaties\/literatuur\/2018_eu_key_competences.pdf."},{"key":"ref_40","unstructured":"(2025, November 16). European Education Area. Available online: https:\/\/education.ec.europa.eu\/document\/action-plan-on-basic-skills-graphic-version."},{"key":"ref_41","doi-asserted-by":"crossref","first-page":"120022","DOI":"10.1016\/j.eswa.2023.120022","article-title":"A novel approach to generate distractors for multiple choice questions","volume":"225","author":"Kumar","year":"2023","journal-title":"Expert Syst. Appl."},{"key":"ref_42","doi-asserted-by":"crossref","first-page":"65","DOI":"10.4103\/2395-2113.251640","article-title":"Basic principles of constructing multiple choice questions","volume":"1","author":"Kar","year":"2015","journal-title":"Indian J. Community Fam. Med."},{"key":"ref_43","doi-asserted-by":"crossref","unstructured":"Shin, J., Guo, Q., and Gierl, M.J. (2019). Multiple-choice item distractor development using topic modeling approaches. Front. Psychol., 10.","DOI":"10.3389\/fpsyg.2019.00825"},{"key":"ref_44","doi-asserted-by":"crossref","first-page":"368","DOI":"10.1080\/01443410.2017.1349877","article-title":"The influence of distractor strength and response order on MCQ responding","volume":"38","author":"Kiat","year":"2018","journal-title":"Educ. Psychol."},{"key":"ref_45","doi-asserted-by":"crossref","first-page":"141","DOI":"10.7575\/aiac.alls.v.8n.6p.141","article-title":"Item Analysis of a Multiple-Choice Exam","volume":"8","author":"Ertunc","year":"2017","journal-title":"Adv. Lang. Lit. Stud."},{"key":"ref_46","doi-asserted-by":"crossref","first-page":"571","DOI":"10.4103\/0253-7613.190757","article-title":"Comparison between three option, four option and five option multiple choice question tests for quality parameters: A randomized study","volume":"48","author":"Vegada","year":"2016","journal-title":"Indian J. Pharmacol."},{"key":"ref_47","first-page":"189","article-title":"The number of options in a multiple-choice test item and the psychometric characteristics","volume":"4","author":"Nwadinigwe","year":"2013","journal-title":"J. Educ. Pract."},{"key":"ref_48","doi-asserted-by":"crossref","first-page":"398","DOI":"10.1016\/j.sbspro.2014.03.432","article-title":"comparison between three-and four-option multiple choice questions","volume":"98","author":"Dehnad","year":"2014","journal-title":"Procedia-Soc. Behav. Sci."},{"key":"ref_49","doi-asserted-by":"crossref","unstructured":"Tarrant, M., Ware, J., and Mohammed, A.M. (2009). An assessment of functioning and non-functioning distractors in multiple-choice questions: A descriptive analysis. BMC Med. Educ., 9.","DOI":"10.1186\/1472-6920-9-40"},{"key":"ref_50","first-page":"561","article-title":"Como elaborar quest\u00f5es de m\u00faltipla escolha de boa qualidade","volume":"47","year":"2019","journal-title":"Femina"},{"key":"ref_51","doi-asserted-by":"crossref","first-page":"166","DOI":"10.1080\/10401334.2016.1146608","article-title":"Using automatic item generation to improve the quality of MCQ distractors","volume":"28","author":"Lai","year":"2016","journal-title":"Teach. Learn. Med."},{"key":"ref_52","first-page":"730","article-title":"Assessment of distractor efficiency of MCQS in item analysis","volume":"29","author":"Ansari","year":"2022","journal-title":"Prof. Med. J."},{"key":"ref_53","first-page":"84","article-title":"The impact of 3-option responses to multiple-choice questions on guessing strategies and cut score determinations","volume":"5","author":"Royal","year":"2017","journal-title":"J. Adv. Med. Educ. Prof."},{"key":"ref_54","doi-asserted-by":"crossref","first-page":"565","DOI":"10.1152\/advan.00186.2016","article-title":"Item statistics derived from three-option versions of multiple-choice questions are usually as robust as four-or five-option versions: Implications for exam design","volume":"42","author":"Loudon","year":"2018","journal-title":"Adv. Physiol. Educ."},{"key":"ref_55","doi-asserted-by":"crossref","unstructured":"Rezigalla, A., Eleragi, A., Elhussein, A., Alfaifi, J., ALGhamdi, M., Al Ameer, A., Yahia, A., Mohammed, O., and Adam, M. (2024). Item analysis: The impact of distractor efficiency on the difficulty index and discrimination power of multiple-choice items. BMC Med. Educ., 24.","DOI":"10.1186\/s12909-024-05433-y"},{"key":"ref_56","first-page":"102381","article-title":"Analysis of 2022 and 2023 Osun State basic education certificate examination mathematics items using item response theory: Implications for large scale assessment","volume":"13","author":"Opesemowo","year":"2026","journal-title":"Soc. Sci. Humanit. Open"},{"key":"ref_57","first-page":"83","article-title":"Psychometric analysis of senior secondary school certificate examination (SSCE) 2017 NECO English language multiple choice test item in KWARA state using item response theory","volume":"3","author":"Kasali","year":"2022","journal-title":"J. Appl. Res. Multidiscip. Stud."},{"key":"ref_58","first-page":"25","article-title":"A study on importance of microsoft excel data analysis statistical tools in research works","volume":"1","author":"Kumar","year":"2023","journal-title":"J. Manag. Educ. Res. Innov."},{"key":"ref_59","unstructured":"Mar\u00f4co, J. (2021). Analise Estat\u00edstica Com o SPSS Statistics, ReportNumber. [8th ed.]."},{"key":"ref_60","unstructured":"(2025, November 24). Goals 4 Ensure Inclusive and Equitable Quality Education and Promote Lifelong Learning Opportunities for All. Available online: https:\/\/sdgs.un.org\/goals\/goal4."}],"container-title":["Analytics"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2813-2203\/5\/1\/12\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,2,24]],"date-time":"2026-02-24T13:18:08Z","timestamp":1771939088000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2813-2203\/5\/1\/12"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,2,24]]},"references-count":60,"journal-issue":{"issue":"1","published-online":{"date-parts":[[2026,3]]}},"alternative-id":["analytics5010012"],"URL":"https:\/\/doi.org\/10.3390\/analytics5010012","relation":{},"ISSN":["2813-2203"],"issn-type":[{"value":"2813-2203","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026,2,24]]}}}