It has been ages since I've taken any statistics courses, and I have found myself in the following situation:
I am in charge of a university course with about 400 students and 10 assessors.
There is a presentation-style activity coming up, during which any given student will be graded by one of the assessors. Each assessor will have about 30, 40 students.
We have a rubric for grading, but historically there is a lot of variation in each assessor's average, standard deviation, range, etc. Teaching beliefs and expectations of students are very hard to change!
I would like to "normalize" student scores, so that any given student's assessor's mean would be compared to the population mean, and then that student's score would be scaled up or down accordingly.
Ideally, perfect scores (say, 20/20) would not change. I imagine as scores get closer to full points, the shift up or down would be less significant. Lower scores will be scaled a lot more.
To me, this sounds logarithmic, but I don't have the slightest idea how to go about it.
I am making a spreadsheet to handle this, so I was hoping for some mathematical formula to use. I am quite adept with Excel, and I have a strong mathematical background (at least I thought I did!), so complexity of the formula is not really a problem.
I don't remember a whole lot of terminology, however, so please be patient with me! And please let me know if more details are needed.
Cheers!