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.
|Title of host publication||Science technology education: Bridging science and technology education: Innovations and experiences: Science & Technology Education Conference '96 proceedings|
|Editors||Kenneth S. VOLK|
|Place of Publication||Hong Kong|
|Publisher||The University of Hong Kong, The Hong Kong Institute of Education, Education Dept., Hong Kong and Hong Kong Association for Science and Mathematics Education|
|Publication status||Published - 1996|