I have set up fields for every course taken (ID Course), for credit hours attempted (HA Course), credit hours earned (HE Course), and letter grade (GRD Course) for all required classes...I have created a fourth field in the row for "Quality Points" (QP Course).

Adobe Acrobat Pro allows you to create a "custom calculation script" for any field created. It needs to be in javascript.

I am trying to tell it take the credit hours earned, and multiply to the third field - but I need it to convert Grade to points first. It is a fairly simple/straightforward conversion:

if (grade=="A")point=4;

if (grade=="B")point=3;

if (grade=="C")point=2;

if (grade=="D")point=1;

if (grade=="F")point=0;

but I need to script that conversion into the calculation - multiply by hours earned (HE course)

**Can someone help with this custom calculation script?**It would make a whole lot of students a lot happier, not having to multiple in their heads (many are not so good with math...sigh, they are communication students). I fear the errors if I do not specify the value for Quality Points with an automatic calculation, that the Overall GPA will be incorrect accordingly (Which I have already figured out how to calculate). Thanks for your time. Jeff