Question about adjusting exam scores on a kind of proportional scale
Let's imagine we have ten student's scores as %
The minimum passing score is set at 70%.
The school decides to throw out the 47% grade as a hard fail.
The next lowest grade, 59 is to be adjusted to 70. An increase of 11
The school then wants to adjust the other students' scores
For example the 91% grade.
I would subtract 91 from 100 giving 9, and that gives me my adjustable range, then inside that range I want to apply the same proportional increase that the failing student got when we increased his score from 59 to 70
My math is letting me down here. I solved this problem many years ago but have since lost the excel sheet i put it in, and for the life of me I can't seem to rediscover the solution. Can anyone help with the math?