Page 1

Reporting Term and Cumulative GPA

Beginning the fall of 2009, URR will be reporting term GPA’s only for those students that have at least one course with a GPA grade (A, B, C, D, F, etc.) for the term in question and will be reporting cumulative GPA’s only for those students that have at least one course with a GPA grade at IU. For those students that do not have at least one course with a GPA grade, the GPA in URR files will be a blank and will be reported in a category of “<2.0 or No GPA”. There are instances where a student’s status changes from enrolled to another status where grades are not applied. An example of this is when a student changes from enrolled status to waitlist status for the term. There are instances where a student could be classified as dropped but still have courses with GPA grades. Typically these grades are F’s. In this situation we will report a term GPA of 0. Below is the logic that will be instituted starting with the fall of 2009.

Term GPA

Term GPA’s will be reported for the following groups of students

  • Enrolled
  • Dropped, but with at least one course with a GPA Grade (A, B, C, D, F)
  • Deceased, but with at least one course with a GPA grade

Cumulative GPA

The cumulative GPA will be reported for students that have at least one class with a GPA grade. Because of the way that Peoplesoft calculates the cumulative GPA the correct cumulative GPA will be on the alphabetically last campus for that term when there are multiple enrollments for a term. The following logic will be used:

  • Select students that have at least one course with a GPA grade
  • Select the max term that is <= to the term in question
  • If there are multiple enrollments across campuses for the same term select the CUM GPA from the alphabetically last campus.

SQL

Sample SQL for selecting term GPA

select a.prsn_univ_id,a.inst_cd,a.ACAD_CAREER_CD,b.STU_IUGPA_CUR_GPA_NBR,b.stu_drv_enrl_stat_ind

from dss_rds.IR_CEN_TRM_SNPSHT_GT a,

dss_rds.sr_stu_term_st b

where a.prsn_univ_id = b.prsn_Univ_id

and a.inst_cd = b.inst_cd

and a.ACAD_TERM_CD = b.acad_term_cd

and a.ACAD_CAREER_CD = b.ACAD_CAREER_CD

and a.acad_term_cd = '4098'

and a.acad_term_prd_desc like 'Off%'

and a.inst_cd = 'IUBLA'

and b.stu_drv_enrl_stat_ind in ('E','D','X')

and b.STU_IUGPA_UNT_TKN_GPA_NBR > 0 // at least one course has a GPA grade assigned to it

Sample SQL for selecting the cumulative GPA

select a.PRSN_UNIV_ID, a.inst_cd,b.STU_IUGPA_CUM_GPA_NBR

from dss_rds.ir_cen_trm_snpsht_gt a,

dss_rds.sr_stu_Term_st b

where a.PRSN_UNIV_ID = b.PRSN_UNIV_ID

and a.ACAD_CAREER_CD = b.ACAD_CAREER_CD

and a.acad_term_cd = '4098'

and a.acad_term_prd_desc like 'Off%'

and a.inst_cd in ('IUBLA')

and b.acad_term_cd = (select max(acad_term_cd)

from dss_rds.sr_stu_Term_st c

where a.PRSN_UNIV_ID = c.PRSN_UNIV_ID

and a.ACAD_CAREER_CD = c.ACAD_CAREER_CD

and c.acad_term_cd <= a.acad_term_cd

and stu_drv_enrl_stat_ind in ('E','D','X'))

and b.inst_cd = (select max(inst_cd)

from dss_rds.sr_stu_Term_st c

where a.PRSN_UNIV_ID = c.PRSN_UNIV_ID

and a.ACAD_CAREER_CD = c.ACAD_CAREER_CD

and b.acad_Term_cd = c.acad_term_cd)

and STU_IUGPA_TOT_UNT_TKN_GPA_NBR > 0 // at least one course has a GPA grade assigned to it

order by a.PRSN_UNIV_ID, a.inst_cd

..\Reports_Public\Enrollment\Documentation\Reporting Term and Cumulative GPA.docUpdated: 01/13/10 - TJS