I want to create a gradesheet using google sheets, each assignment grades are entered as letters (A thru F). Each grade is given a numerical value - decided dynamically at the end of course.

I want to create a gradesheet in which I can enter each students grades as letters and in the end while calculating the final grade each letter is converted to a number and totalled.

Is there anyway to do this in google sheets.