Difference between revisions of "Calculating Marks"

From Chemical Engineering @ UP wiki
Jump to: navigation, search
(Supplimentary exams)
Line 5: Line 5:
 
Make sure that you round the semester mark, the exam mark and the final mark and rework with integer percentages (avoid the use of the Excel Percentage type, as this hides some common errors).  Use <pre>round(mark/total*100, 0)</pre>
 
Make sure that you round the semester mark, the exam mark and the final mark and rework with integer percentages (avoid the use of the Excel Percentage type, as this hides some common errors).  Use <pre>round(mark/total*100, 0)</pre>
  
=== Supplimentary exams ===
+
=== Supplementary exams ===
 
Always check the relevant yearbook.  The following description is from the [http://web.up.ac.za/sitefiles/file/2009_yearbooks/Engineering%202009%2021%20Nov.pdf 2009 Yearbook].   
 
Always check the relevant yearbook.  The following description is from the [http://web.up.ac.za/sitefiles/file/2009_yearbooks/Engineering%202009%2021%20Nov.pdf 2009 Yearbook].   
  

Revision as of 08:59, 11 May 2010

Calculating marks

Rounding

Make sure that you round the semester mark, the exam mark and the final mark and rework with integer percentages (avoid the use of the Excel Percentage type, as this hides some common errors). Use
round(mark/total*100, 0)

Supplementary exams

Always check the relevant yearbook. The following description is from the 2009 Yearbook.

In the School of Engineering a supplementary examination is only granted in instances where:

  1. A final mark of between 45% and 49% was achieved;
  2. A final mark of between 40% and 44% was achieved and where the candidate also achieved either a semester mark or an examination mark of 50% or higher;
  3. A pass mark has been obtained, but the required subminimum in the examination section of the module or divisions thereof has not been obtained.
  4. First-year modules on 100 level where a final mark of between 40% and 49% has been obtained, must be granted a supplementary examination.

This is summarised in the picture:

Suparea.png

The following VBA function can be used to do the calculation in Excel:

function engineeringstatus(semester as integer, exam as integer, final as integer) as string
' Criteria for assessing supplementary exams, according to engineering yearbook 2010
' Author: Carl Sandrock
	if final < 40 then
		engineeringstatus = "Fail"
	elseif final < 45 then
		if semester >= 50 or exam >= 50 then
			engineeringstatus = "Supp"
		else
			engineeringstatus = "Fail"
		end if
	elseif final < 50 then
		engineeringstatus = "Supp"
	else
		engineeringstatus = "Pass"
	end if
end function

This is equivalent to a formula (assuming semester, exam and final marks are in A1, B1 and C1)

=if(C1<40, "Fail", if(C1<45, if(or(A1>=50, B1>=50), "Supp", "Fail"), "Pass"))

Calculation of the final supplementary examination mark

  1. The semester mark is retained and the final mark is calculated as the weighted average of the supplementary examination mark and the semester mark, in accordance with the formula as published in the study manual of the specific module, with the proviso that the maximum final mark awarded may be no more than 50%. The only exception to this rule is in the case of first-year modules on first-semester level, where the semester mark is not considered, and where the supplementary examination mark is taken as the final mark, with the proviso that the maximum final mark awarded may be no more than 50%.
  2. All other pass requirements, as published in the study manual of each specific module, remain so and are applicable during the determination of the final result of a supplementary examination in the module.

Codes

Several codes are used to communicate special status in the CSV file that Admin expects to get from you after you have calculated the marks.

Semester Examination Final Remark
Examination refusal Mark 988 988
Unknown 987 987 987
Absent from exam Mark 987 987
Mark not avalable - Finance Mark xxx xxx
Mark not avalable - Library Mark yyy yyy
Mark not avalable - Both Mark zzz zzz
Aegrotat exam Mark 987 987 994
Supplementary Mark Mark Mark 999
Subminimum Mark Mark 992(only if above 50%) 999
Promote(only School of IT) Mark 973 973
Only postgraduate:
Mark not yet available 989 989 989
Did not complete 995 995 995