What
is the GPA table?
This table captures GPA
and credit hour information
for each student for each
semester.
What
is the key (unique identifier
for a row) for GPA?
Affiliate ID and semester
.
What
is the timing of the table?
A record is placed in this
table when grades are posted
as long as a student has
not completely withdrawn
from classes. This table
is updated weekly until
2 years past the end of
semester?
Why
would you use it?
The primary use of this
table is to find ASU GPA's
for a particular semester.
It also contains credit
hours of various types -
earned hours, net earned
hours, transfer hours, semester
GPA's before and after grade
changes, correspondence
hours, advanced placement
hours, CLEP hours, international
student hours (GCE and International
Baccalaureate), and hours
earned prior to the SIS.
Why
would you NOT want to use
it?
Don't use this table if
you want the most recent
GPA for a currently enrolled
student. Use the Student
Currently Enrolled table.
Don't
use this table if you are
trying to compare GPA's
of groups of students across
time - year to year. GPA
in the census database would
be better for this.
What
should you watch out for?
Watch out for 0.0 GPA's.
They can mean that the student
received failing grades
OR it could mean the student
withdrew from classes after
grades were posted. (Happens
a lot!)
Also
keep in mind that a semester
GPA may be 0.0 if the student
is enrolled in thesis/dissertation
type classes (grades of
Y) or pass fail classes.
As
is generally true in the
Warehouse, a GPA record
is never removed even if
the SIS record that created
the Warehouse record is
removed. Therefore if a
student changes their Affiliate
ID (SSN) the old GPA records
remain and new records are
created with the new Affiliate
ID.
