Student Success Initiative - Success Points

Revised June 25, 2015

Purpose

The process described in this document will annually select Community College, State Community College, and Technical College enrollments that qualify for Success Points in that year based on conditions related to credit hours earned and specific courses taken.

Scope

Success Points are awarded for the following academic performance:

1. Students earning their first 12 college level semester SCH at this institution by the current year.
2. Students earning their first 24 college level semester SCH at this institution by the current year.
3. Students earning their first 36 college level semester SCH at this institution by the current year.
4. Students completing any developmental English in the previous year and attempting any college level English either in the remainder of the previous year on any term this year.
5. Students completing any developmental Math in the previous year and attempting any college level Math either in the remainder of the previous year on any term this year.

 

Detailed Steps of Processing

Step 1:
Select all students enrolled in the selected fiscal year at an institution with campus type of CC, SC or TC in the inst_campus table. Select only one record per student per institution. On the web report both the number of Student Enrollment (SN) records and number of students. The SN records count should balance with the SN summary edits from when the files were loaded.

Step 2:
Summarize the SCH earned by the students in Step 1 at this institution in the current fiscal year and in any previous fiscal year starting with the beginning of HEI, Winter term 1997. Keep 4 separate totals of completed credits (crse_enroll_audit_sw="Y", even though this field is really the Award of Academic Credit switch) for each student:

1. College Credits Current Year: Credits earned in the current year for all courses taken at this institution with any Course Level other than V.
2. College Credits Previous Years: Credits earned in any prior year for all courses taken at this institution with any Course Level other than V.
3. Developmental Credits Current Year: Credits earned in the current year for all courses taken at this institution with any Course Level of V.
4. Developmental Credits Previous Years: Credits earned in any prior year for all courses taken at this institution with any Course Level of V.

 

Then students whose (College Credits Current Year + College Credits Previous Years) >= 12 Semester Credits and College Credits Previous Years < 12 Semester Credits earn the type 1 Success Point. For institutions on a quarter calendar (as reported in the acad_cal), convert the credits to Semester Credits by multiplying by 2/3. Also, students whose (College Credits Current Year + College Credits Previous Years) >= 24 Semester Credits and College Credits Previous Years < 24 Semester Credits earn the type 2 Success Point. Students with Developmental Credits Current Year > 0 and Developmental Credits Previous Years = 0 earn the type 4 Success Point. Also, students whose (College Credits Current Year + College Credits Previous Years) >= 36 Semester Credits and College Credits Previous Years < 24 Semester Credits earn the type 2 Success Point. Students with Developmental Credits Current Year > 0 and Developmental Credits Previous Years = 0 earn the type 4 Success Point.

Step 3:
Select all students who completed any developmental level courses in either the Math or English Subject Field in the fiscal year previous to the selected year. Select one record per student per institution. Developmental Level is Level V in the course inventory and Math and English are any Subject Code in the Course crse_inventory table that maps to the Math or English Subject Field in the Subject table. Completed Courses have crse_enroll_audit_sw="Y" in the crse_enroll table. Keep track of the last term in the previous year for Math and English separately. On the web report the number of students selected for Math and English separately. Then for each student selected select any college entry level courses taken by the student in the same Subject Field (Math or English), either in the same term or a later term of the previous year, or any term of the selected year and taken at any USO campus. College entry level is Level G or T in the crse_inventory table. On the web report the number of students selected for Math and English separately. These students earn type 5 Success Point for English and type 6 for Math.

For the web report, in a separate file linked from the output of Step 4, list the following for all rows selected for this institution – year, term, institution, student SSN (translated from OBRID), the subject, and whether the student earned a Success Point for the subject. Students earning multiple points should appear as multiple rows in the output, and students may appear as multiple rows earning a point for one subject but not the other.

Step 4:
Select all students enrolled on any campus with campus_type in (“UM”,”UB”) and with admis_area_code="UND" in any term of the selected fiscal year with the year and term of first enrollment at the UM or UB campus being any term of the selected fiscal year.

Step 5:
Summarize the SCH earned by the students in Step5 at this institution in terms prior to when they started at the UM or UB. Qualifying SCH at the community college must be:

1. Completed Courses: crse_enroll_audit_sw="Y".
2. College Level: crse_level_code other than V.

 

Then, for each CC where the student has earned at least 12 semester SCH, that CC earns a type 7 success point. Note if the student had 12 or more semester SCH from more than one CC, all such CCs earn the Success Point. On the web report the number of points earned, with a link to a detailed report, to be generated and saved at the same time, listing all students transferring from this institution by year, this institution, SSN (translated from OBRID), and the UM/UB campus. If the student has transferred to more than one, display all institutions transferred to.

Step 6:
Append the data for the selected year and CC institution to the Summary Success Points table. This table has one row per CC institution per fiscal year with a key of Fiscal Year and Inst Code. The attributes are simply the number of points for each of the 7 types. The process should be capable of being rerun for each CC institution each year. Therefore, before appending the new rows, be sure to delete the old one for the same institution and year. On the web report display a list of all the success points, broken down by a column for each point type, for this institution and year. Separately, display the total students that have earned each point type, and link the number of students to the student level detail query output detailed in the next step.

Step 7:
Append the data for the selected year to the Detail Success Point table. This table has one row per student, per year, per CC institution, per point earned. All attributes are part of the key. The process should be capable of rerun for each CC institution each year and separately for the four different cohorts of students. Therefore, before appending the new rows be sure to delete the old one for the same institution, year and cohort. For the web report, in a separate file linked from the output of Step 7, list the following for all rows for this year and institution – year, institution, student SSN (translated from OBRID) and the type number of the point earned. Students earning multiple points should appear as multiple rows in the output.