fabi2004
asked on
Calculating GPA in Access 2010
Can you help me create a query that calculates current overall GPA?
The database is for only one student. It contains two tables (screenshot attached)
(GPA is calculated by dividing the total amount of grade points earned by the total amount of credit hours attempted. Grade point average may range from 0.0 to a 4.0. An A earns 4 points, a B earns 3, a C= 2, a D 1 and an F 0. A W earns no points but indicates that the semester hours for that course should not be counted in the hours attempted total.)
This is my scratch work so far...but I don't know what else to do with it or what else to try...
[[[ SUM DegreeRequirements.Semeste rHours where CompletedCourses.Grade <> W AND DegreeRequirements.CourseC ode = CompletedCourses.CourseCod e
SUM GradePoints,
GradePoints: [CreditHours] * Nz(Switch([LetterGrade] = "A", 4, [LetterGrade] = "B",
3, [LetterGrade] = "C", 2, [LetterGrade] = "D", 1, [LetterGrade] = "F", 0),
0)
GPA: SUM GradePoins / SUM DegreeRequirements.Semeste rHours ]]]
(I love Access, I don't know why I always get so tangled up with it :-( )
The database is for only one student. It contains two tables (screenshot attached)
(GPA is calculated by dividing the total amount of grade points earned by the total amount of credit hours attempted. Grade point average may range from 0.0 to a 4.0. An A earns 4 points, a B earns 3, a C= 2, a D 1 and an F 0. A W earns no points but indicates that the semester hours for that course should not be counted in the hours attempted total.)
This is my scratch work so far...but I don't know what else to do with it or what else to try...
[[[ SUM DegreeRequirements.Semeste
SUM GradePoints,
GradePoints: [CreditHours] * Nz(Switch([LetterGrade] = "A", 4, [LetterGrade] = "B",
3, [LetterGrade] = "C", 2, [LetterGrade] = "D", 1, [LetterGrade] = "F", 0),
0)
GPA: SUM GradePoins / SUM DegreeRequirements.Semeste
(I love Access, I don't know why I always get so tangled up with it :-( )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.