SAIP2014

Excel IF functions as marking rubrics for assessing physics practicals

8 Jul 2014, 11:10

20m

D Les 310

Oral Presentation Track E - Physics Education Education

Speaker

Mr Jan Oelofse (University of Johannesburg)

Level for award<br>&nbsp;(Hons, MSc, <br> &nbsp; PhD)?

N/A

Apply to be<br> considered for a student <br> &nbsp; award (Yes / No)?

no

Main supervisor (name and email)<br>and his / her institution

N/A

Would you like to <br> submit a short paper <br> for the Conference <br> Proceedings (Yes / No)?

Yes

Abstract content <br> &nbsp; (Max 300 words)<br><a href="http://events.saip.org.za/getFile.py/access?resId=0&materialId=0&confId=34" target="_blank">Formatting &<br>Special chars</a>

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.