Associate
Hi
My girlfriend needs help with a grading system that scales base marks, depending on difficulty. I have provided a link for the grading system in place:
Page 22:
https://qualifications.pearson.com/...ication/Specification_GCSE_L1-L2_in_Music.pdf
So you can see that a raw mark of 10 becomes 13 on standard difficulty but 15 when the piece is more difficult.
Is there a formula (I was thinking an IF statement?) where changing the raw mark would automatically calculate the scaled mark?
Thanks if anyone can help.
My girlfriend needs help with a grading system that scales base marks, depending on difficulty. I have provided a link for the grading system in place:
Page 22:
https://qualifications.pearson.com/...ication/Specification_GCSE_L1-L2_in_Music.pdf
So you can see that a raw mark of 10 becomes 13 on standard difficulty but 15 when the piece is more difficult.
Is there a formula (I was thinking an IF statement?) where changing the raw mark would automatically calculate the scaled mark?
Thanks if anyone can help.