Multiple-choice test item analysis by spreadsheet macros

Research output: Chapter in Book/Report/Conference proceedingChapter

Abstract

To produce good quality MC tests, the commonly used tools are item analysis and test reliability. Although most teachers have learnt how to use these techniques, it is uncommon for a class teacher to use them in schools as it is quite difficult to do the analysis manually. This article attempts to investigate the possibility of using an electronic spreadsheet to solve the problems and gives discussions on the worksheet functions approach and the Visual Basic for Applications (VBA) approach. Copyright © 1996 University of Hong Kong.
Original languageEnglish
Title of host publicationScience technology education: Bridging science and technology education: Innovations and experiences: Science & Technology Education Conference '96 proceedings
EditorsKenneth S. VOLK
Place of PublicationHong Kong
PublisherThe University of Hong Kong, The Hong Kong Institute of Education, Education Dept., Hong Kong and Hong Kong Association for Science and Mathematics Education
Pages67-72
ISBN (Print)9628093940
Publication statusPublished - 1996

    Fingerprint

Citation

Lai, Y.-C. (1996). Multiple-choice test item analysis by spreadsheet macros. In K. S. Volk (Ed.), Science technology education: Bridging science and technology education: Innovations and experiences: Science & Technology Education Conference '96 proceedings (pp. 67-72). Hong Kong: The University of Hong Kong, The Hong Kong Institute of Education, Education Dept., Hong Kong, and Hong Kong Association for Science and Mathematics Education.