A Case for Using Excel in Scoring Multiple Choice Test Items and Conducting Item and Test Analysis

DSpace Repository

Show simple item record

dc.contributor.author O. OGUNMAKIN, Abel
dc.contributor.author OSAKUADE, Joseph Oluwatayo
dc.date.accessioned 2021-06-01T11:19:12Z
dc.date.available 2021-06-01T11:19:12Z
dc.date.issued 2013-12
dc.identifier.issn 2310-5402 (Online)
dc.identifier.uri http://dspace.epoka.edu.al/handle/1/2041
dc.description.abstract Scoring of multiple choice objective test items and conducting item analysis has been a problem for teachers at all levels of Nigerian educational system. In view of the longer procedural steps it will take for item and test analysis coupled with complex mathematical / statistical computations involved, teachers nowadays jump the protocol of the normal procedure to be followed in constructing items for a credible, reliable and valid tests. The effect of this is that teacher-made tests are no longer yielding the true performance of examinees’ ability. This problem persists because of the inability of making teachers to fully integrate ICT into the school assessment practices. This paper makes a case for the use of spreadsheet package (Microsoft Excel) in scoring multiple choice objective test items and conducting item / test analysis. Excel was used in this article to score hypothetical 15 students’ responses to 20 items multiple choice questions. This same excel was later used to compute the dificulty index, discrimination index of the items and also validity and reliability of the test. The scoring and the analysis of both test and item statistics were performed at faster rate and with utmost great accuracy. It is hereby recommended that: 1. Government, University Management and Teaching Service Commission (TESCOM) should as a matter of urgency organize seminars and workshops for lecturers / teachers periodically so as to update their knowledge in ways of using spreadsheet package (Microsoft Excel) to score multiple choice objective test items and conducting item / test analysis. 2. Curriculum of Teachers Training programme needed to be re-designed to enable prospective teachers have irsthand experience during their training programme on how to use computers to score their students’ tests, analyze the psychometric properties of such tests and even familiar with the ways of using statistical packages like Excel, Lotus 1-2-2, SPSS and E-views in analyzing data emanated from their research project. en_US
dc.language.iso en en_US
dc.publisher Beder University en_US
dc.subject Excel, Scoring, Multiple Choice Objective Test Items, Item and Test Analysis en_US
dc.title A Case for Using Excel in Scoring Multiple Choice Test Items and Conducting Item and Test Analysis en_US
dc.type Article en_US


Files in this item

This item appears in the following Collection(s)

Show simple item record

Search DSpace


Browse

My Account