GPA Calculation with some courses PASS/FAIL

Followers

January 10, 200521 yr

Newbies

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

January 10, 200521 yr

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.

January 11, 200521 yr

Author
Newbies

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

January 18, 200521 yr

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))