mardi 29 octobre 2019

How to find Curved Grade in Google Sheets?

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