calculating cumulative GPA

M

MR at UB

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
 
M

Marshall Barton

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


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top