7-11 July 2014
Africa/Johannesburg timezone
Home > Timetable > Session details > Contribution details
PDF | XML | iCal

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
Session: Education
Track: Track E - Physics Education

Abstract

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.

Award

no

Level

N/A

Supervisor

N/A

Paper

Yes

Place

Room: D Les 310


Primary authors

More

Co-authors

More