GPA Calculation with some courses PASS/FAIL

[Kevin12]

I am a "newbie" to the Filemaker System.

In the Filemaker Pro 7 System, I am using the Course Tracker inside of the Filemaker K-12 Starter Kit.

Can anyone explain how to have the system accomodate the PASS/FAIL designation in the calculation of the GPA.

Thank you for any help.

Kevin12

[RalphL]

Kevin,

That starter kit is something most of us don not have. If you can give us some details on the calculation as it appears in the define fields and if you tell us how you want to handle the Pass/Fail in the calculation of the the GPA, we may be able to help you.

[Kevin12]

RalphL

Tables

There are 9 tables.

We are interested in 3 Tables - Student Table, StudentCourse Table and Courses Table.

We are interested in 1 Occurrence of the Courses table

[RalphL]

If the course is Pass/Fail then the Gradepoints are Null, i.e., empty. Lets make a field PassFailCourseCredits = Case(IsEmpty (GradePoints); CourseCredits) then

GPA = Sum(Gradepoints) / ( CreditsEnrolled - Sum(PassFailCourseCredits))