calculating cumulative GPA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MR at UB - 14 Dec 2005 22:42 GMT

I want to be able to calculate a student's cumulative GPA given each
semesters credit hours attempted and quality points. The calculation is to
sum the quality points and divide by credit hours attempted so that for each
semester I will have a cumulative GPA (grade point average) as well as each
individual semester GPA. I have a table with each student's identifier, the
semester indicator, their credit hours attempted and their quality points for
that semester. I would like it to be as simple as possible. Thanks - Mike

Reply to this Message

Marshall Barton - 15 Dec 2005 00:04 GMT

>I want to be able to calculate a student's cumulative GPA given each
>semesters credit hours attempted and quality points. The calculation is to
[quoted text clipped - 3 lines]
>semester indicator, their credit hours attempted and their quality points for
>that semester. I would like it to be as simple as possible. Thanks - Mike

Assuming you have one record for each semester for each
student. Add a text box named txtRunCredits to the details
section and set it's RunningSum property to Over Group. Add
another text box named txtRunPts with the same property
settings.

In the Student group footer section, use a text box with the
expression: =txtRunPts / txtRunCredits

Signature

Marsh
MVP [MS Access]

Reply to this Message