7-11 July 2014
Africa/Johannesburg timezone
<a href="http://events.saip.org.za/internalPage.py?pageId=16&confId=34"><font color=#0000ff>SAIP2014 Proceedings published on 17 April 2015</font></a>

Excel IF functions as marking rubrics for assessing physics practicals

8 Jul 2014, 11:10
20m
D Les 310

D Les 310

Oral Presentation Track E - Physics Education Education

Speaker

Mr Jan Oelofse (University of Johannesburg)

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

Yes

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

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

N/A

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.

Primary author

Mr Jan Oelofse (University of Johannesburg)

Co-authors

Dr Leelakrishna Reddy (University of Johannesburg) Dr Padmanabhan Nair (University of Johannesburg)

Presentation Materials

There are no materials yet.