I'm working on a file where final grades of all courses are added, every students has the right to get up to 5 grades as curve for all of his/her final grades with are lower than Passing Grade. My question is: is it possible to find new final grades with added grades by a Formula and/or Script in Google Sheets. Below is a sample of the data
studentName course final final (withCurve) A Math 59 60 A Physics 58 60 A English 54 54 B English 55 55 B Physics 58 60 B French 57 60
Note: Assume the passing Grade is 60 and give the 5 grades to more courses as possible, means better to give it to 57, 58 than one single 55 (if it is possible).
Aucun commentaire:
Enregistrer un commentaire