Major GPA Utility

1
Major GPA Utility

• Elliott Cheu
• 21 March 2007

2
Motivation

• Write a simple tool that can be used to determine
  the major GPA for a group of students.
• Needs to be flexible.
• Easily portable.
• Try to do outside of Microsoft Access.
• Dont know how to use Access well.
• Limitations in Access.

3
UIS system

• First needed to learn UIS.
• Relatively straight-forward.
• Tools exist, but undocumented.
• Need an expert
• Wrote some of my own documentation.
• http//www.physics.arizona.edu/elliott/UIS

4
UIS Instructions
5
major_gpa program

• Inputs
• Single UIS query.
• Export to Excel file.
• Open Excel and export to .csv file.
• Unfortunately, need two separate steps.
• Needs list of courses in major.
• major_gpa_courses.inp
• Simple text file.
• Can specify courses that are catalog dependent.

6
Invoking major_gpa

• Put all files into the same directory.
• UIS query .csv file.
• major_gpa_courses.inp
• Open a DOS command window.
• Change directory to correct directory.
• major_gpa ltUIS query .csv filegt

7
Program output

• Output written to major_gpa.dat
• Can be opened with Notepad, etc.
• Ordered by major GPA.

• Undergraduate Major GPAs 145 Students
• 
  Atmp Earn
• Name SID mGPA
  cGPA Crdt Crdt Cat
• Doe, John 999888044 1.632
  2.367 19 19 54
• Doe, Jane 999888002 1.667
  2.432 12 12 54
• Smith, Dean 999888731 1.673
  2.112 52 30 4
• Smith, John 999888493 1.727
  2.390 11 11 54
• Smith, Peter 999888464 1.833
  2.435 24 21 44
• Smith, Paul 999888060 1.846
  2.635 39 34 14
• Jones, Adam 999888846 1.956
  2.431 45 42 34
• Parker, Mary 999888261 2.000
  2.786 4 4 54

8
Recent Modifications

• Need to show number of credit hours in major
  (including transfer credits)
• Requires two additional queries.
• ZSIS_TE2 (Transfer courses)
• ZSIS_DP4 (Course substitutions)

Undergraduate Major GPAs 145 Students
Atmp
Earn Trns Name SID
mGPA cGPA Crdt Crdt Crdt Cat Doe,
John S01699999 2.231 2.581
26 26 26 54 Doe, Jane
075699999 2.265 2.500 34 31 41
14 Smith, John S01399999 2.320
2.890 25 25 25 44 Smith, Jane
601799999 2.366 3.219 41 38 38
24 Taylor, John S01399999
2.424 3.028 33 33 33 44 Taylor, Jane
223599999 2.429 2.880 42
42 42 34 Gates, John
889999999 2.462 2.565 39 39 53
54 Gates, Jane 601099999 2.477
2.575 44 44 44 14
9
Summary

• GPAs correspond to SAPR values.
• Spot checked a number of SAPRs.
• Found some problems with SAPRs
• Double majors mostly correct now. (PHYS325)
• Double counting of transfer credits.
• Its relatively easy to set up.
• About an hour including UIS and queries.
• I wrote it for myself, but anyone else is welcome
  to it.
• C. Dentel has used it.