Academic Standing Update Process

The Academic Standing Update process revises the Academic Honors columns based on the Honors table. It then looks at the Probation table and updates the Academic Probation column for those students who are on probation, suspension, or in good standing.

Uses/Examples of Academic Honors

For example, your catalog has a statement that reads: "Full-time students who have attained a GPA of 3.50 during the term are on the Dean's list; full-time students who have attained a GPA of 3.75 during the term are on the President's list."

For example, using the statement above, the term GPA will determine the term honors and, since only full-time students are eligible for these honors, the part-time/full-time status must be determined.

For example, since both of these pieces of information are term-related, they will be located on the Term Summary tables. Part-time/full-time status will be on the Student Term Summary, is alphanumeric, and will be a match column. GPA information will be on the Student Term Summary by Division, is numeric, and will be a range column.

Table Code	Column Code	Match (M) or Range (R)
Student Term Summary	PT/FT status	M
Student Division Master	Term GPA	R

Create a table that includes every combination of part-time/full-time status and the term GPA. This table might indicate that part-time students receive no term honors (academic standing = N) regardless of their term GPA as well as any full-time student with a term GPA of less than 3.500. You may enter up to 10 characters in the Value columns.

PT/FT (Value 1)	Term GPA (Value 2)	Resulting Academic Honor
P	4.0000	N (No Honors)
F	3.4999	N (No Honors)
F	3.7499	D (Dean's List)
F	4.0000	R (President's List)

Uses/Examples of Academic Probation

For example, your organization's probation policy reads: "A student whose grade point average is below 2.0 is placed on academic probation or is subject to dismissal. Freshmen whose GPA for the year is below 1.6 are not eligible to continue the college program. Freshmen with a GPA between 1.6 and 2.0 will be admitted as sophomores on academic probation. Sophomores below GPA 1.75 and juniors below 1.85 may not return the next year."

On the basis of the catalog statement, the career GPA will determine the probation status. Also know the career earned hours (which determines the student's classification) impacts the GPA level that causes probation and suspension.

Since you need GPA information, select the Student Term Summary by Division table. Career Hours Earned and Career GPA are numeric columns, so mark them as range columns.

Table Code	Column Code	Match (M) or Range (R)
Student Division Master	Career Hours Earned	R
Student Division Master	Career GPA	R

You must create a table that includes every combination of career hours earned and career GPA.

Career Hours Earned (Value 1)	Career GPA (Value 2)	Resulting Academic Honor
29.99	1.5999	S (Suspension)
29.99	1.9999	P (Probation)
29.99	4.0000	G (Good Standing)
59.99	1.7499	S (Suspension)
59.99	1.9999	P (Probation)
59.99	4.0000	G (Good Standing)
89.99	1.8499	S (Suspension)
89.99	1.9999	P (Probation)
89.99	4.0000	G (Good Standing)
999.99	1.9999	S (Suspension)
999.99	4.000	G (Good Standing)