Newbies Kevin12 Posted January 10, 2005 Newbies Posted January 10, 2005 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 Posted January 10, 2005 Posted January 10, 2005 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.
Newbies Kevin12 Posted January 11, 2005 Author Newbies Posted January 11, 2005 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 Posted January 18, 2005 Posted January 18, 2005 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))
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now