I am trying to take the avg gpa of a group of students by organization.(GREEKS, sports etc) I want to still see the student information(name, major etc) not just seeing GPA's

We are on version 7.1.1

Thanks for the help

quote:

I am trying to take the avg gpa of a group of students by organization.(GREEKS, sports etc) I want to still see

Do you plan to calculate the gpa of the body for the average, or average the individual gpa's of the body. Makes a difference on the approach.

what is GPA?

TABLE FILE STUDENTS
SUM AVG.GPA
BY STUDENTNAME
BY MAJOR
END

...

If you use average by name you will get incorrect results if they have same names, so always use by unique ID to get correct results. Sample code below:

TABLE FILE STUDENTS
SUM
AVG.GPA AS ‘Average GPA’
BY STUDENTID NOPRINT
BY STUDENTNAME
BY MAJOR
BY ORGANIZATION
END

I used to work at a major university for 20 years, and for 12 of those years I was responsible for producing these reports. A lot of groups need a an average GPA.

The problem is that one cannot just take a GPA and average it. what you would be doing is taking an average of an average... First year stat class would tell you that is wrong.

What you need to do is get the fields that go into calculating a GPA. This normally would be grade points, number of credits etc. This normally is explained in your college catalog.

Figure out how the GPA was calculated for one person. Is it all the classes, just one class, just one sememester, a cumulative gpa???
This is important since a person taking getting an A in a one hour course has a GPA of 4.0 and the information is totally different that someone taking 15 credits and getting all A's

Once you know how to calculate the GPA, then do it for the one person. Once you have that, then you can calculate the GPA for the subgroup you need.

So you would get the fields you need
with Student ID = xxx
Once you have the GPA, then you just expand the where clause to be

Where student Group=

If you want a real example, I can write one up for you using a real life program.

However, Stay away from averaging the GPA... you will get a number that is way off.

I went looking through my files to come up with a real life example.

Since I do not know your database, you will need to contact someone who knows what the fields are
Beware that in most universities, there is semester and cumulative data

The report would be something like the following
GRADEPTS IS GRADEPOINTS
HRS_FAVG IS HOURS FOR AVERAGING

TABLE FILE SPRINGDATA
IF STUDENTCLASSIFICATION EQ UPPERDIVISION
SUM GRADEPTS
HRS_FAVG
COMPUTE GPA/P7.3 = (GRADEPTS / HRS_FAVG)
BY COLLEGE
HEADING
"GPA FOR UPPER DIVISON BY COLLEGE"
END

You could do a BY STUDENTID
or substitute the BY with another field (group they belong to)

If you need to you could just use a Match to get just the IDS you need



Other fields you may want to consider
Hours attempted, hours earned,
Also determine are you only use Grades from the institution, or what if they transfer
Hope that helps