Excel IF functions as marking rubrics for assessing physics practicals
Presented by Mr. Jan OELOFSE on 8 Jul 2014 from 11:10 to 11:30
Type: Oral Presentation
Track: Track E - Physics Education
Close to 1500 undergraduate students are doing various physics practicals per semester in our laboratories at the Doornfontein Campus of the University of Johannesburg. To assess the students’ analysis of experimental data (calculations, graphs, etc.) on a weekly basis for such a large group is extremely time consuming. Therefore it became necessary to design an Excel Rubric Marking Scheme (ERMS). This rubric is programmed to award marks based on the student’s knowledge of the particular practical topic and calculation skills. Excel IF functions are used very effectively in the rubric spreadsheet programme to provide a very reliable and consistent assessment tool to evaluate student’s answers and results.