averaging school grades

[joemuskrat]

I developed a program that tracks public school music students. Part of the program allows the teacher to grade a student on up to 15 musical selections. I know about "average" for numerical grades, but is there some way to average letter grades?

[danjacoby]

Create a calc field that converts the grades to numbers. Usually it's 4 for an "A", 3 for a "B", etc., but your school or class may have a different system.

[Lee Smith]

Hi Joe,

Try this case statement:

Case(

Grade= "A+", 4.5, Grade="A", 4.25, Grade = "A-",4.00,

Grade= "B+", 3.5, Grade="B", 3.25, Grade = "B-",3.00,

Grade= "C+", 2.5, Grade="C", 2.25, Grade = "C-",2.00,

Grade= "D+", 1.5, Grade="D", 1.25, Grade = "D-",1.00,

Grade= "F", 0

)

HTH

Lee

[joemuskrat]

Hi Lee,

Thanks for your reply.

Assuming Grade is a field name and I use the same field name for A+ to F each time for 15 fields in a field I create for the Case statement, how do I get an average of the 15 fields?

Wow, is that a confusing sentence or what?

Joe