calculating cumulative GPA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
MR at UB said:
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
Click to expand...


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
 
Back
Top