NOTE: This includes only remedial courses. Success includes grades of A, B, C, S, CR (Credit), and R (Registered).
Academic Year selected = ".$acadyr." (from AY".$acadyr1." to AY".$acadyr5.")."); $queryX = "SELECT DISTINCT f.inst_type, f.fice_code, f.school_abbr FROM fice_table f WHERE f.inst_type IN ('1', '2') ORDER BY f.inst_type, f.school_abbr"; $resultX = odbc_exec($conn_id, $queryX); echo("| # | "); echo("Inst. Type | ");
echo("Institution | "); echo("AY".$acadyr1." | "); echo("AY".$acadyr2." | "); echo("AY".$acadyr3." | "); echo("AY".$acadyr4." | "); echo("AY".$acadyr5." | "); echo("3-Year Avg. | "); echo("2-Year Avg. | "); echo("Change | "); echo("||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SSCH | "); echo("Success | "); echo("Percent | "); echo("SSCH | "); echo("Success | "); echo("Percent | "); echo("SSCH | "); echo("Success | "); echo("Percent | "); echo("SSCH | "); echo("Success | "); echo("Percent | "); echo("SSCH | "); echo("Success | "); echo("Percent | "); echo("SSCH | "); echo("Success | "); echo("Percent | "); echo("SSCH | "); echo("Success | "); echo("Percent | "); echo("||||
| ".$n++." | "); echo("".$inst_type." | "); echo("".odbc_result($resultX, "school_abbr")." | "); // ssch enrolled - year 1 $query1a = "SELECT SUM(c.enrollment * c.credit_hours) AS ssch FROM course_table c WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr1."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND c.course_number NOT LIKE 'DSG%';"; $result1a = odbc_exec($conn_id, $query1a); while (odbc_fetch_row($result1a)) { $sschyr1 = odbc_result($result1a, "ssch"); $sschyr1_total = $sschyr1_total + $sschyr1; if ($inst_type == '1') { $sschyr1_1 = $sschyr1_1 + $sschyr1; } if ($inst_type == '2') { $sschyr1_2 = $sschyr1_2 + $sschyr1; } } echo("".number_format($sschyr1,0)." | "); // successful ssch - year 1 $query1b = "SELECT SUM(c.credit_hours) AS success FROM course_table c JOIN registration_table r ON c.fice_code = r.fice_code AND c.academic_year = r.academic_year AND c.term = r.term AND c.sequence = r.sequence AND c.level_sequence = r.level_sequence WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr1."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND r.end_of_term IN ('A', 'B', 'C', 'S', 'K', 'R') AND c.course_number NOT LIKE 'DSG%';"; $result1b = odbc_exec($conn_id, $query1b); while (odbc_fetch_row($result1b)) { $successyr1 = odbc_result($result1b, "success"); $successyr1_total = $successyr1_total + $successyr1; if ($inst_type == '1') { $successyr1_1 = $successyr1_1 + $successyr1; } if ($inst_type == '2') { $successyr1_2 = $successyr1_2 + $successyr1; } } echo("".number_format($successyr1,0)." | "); $percyr1 = ($successyr1 * 100) / $sschyr1; echo("".number_format($percyr1,1)."% | "); // ssch enrolled - year 2 $query2a = "SELECT SUM(c.enrollment * c.credit_hours) AS ssch FROM course_table c WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr2."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND c.course_number NOT LIKE 'DSG%';"; $result2a = odbc_exec($conn_id, $query2a); while (odbc_fetch_row($result2a)) { $sschyr2 = odbc_result($result2a, "ssch"); $sschyr2_total = $sschyr2_total + $sschyr2; if ($inst_type == '1') { $sschyr2_1 = $sschyr2_1 + $sschyr2; } if ($inst_type == '2') { $sschyr2_2 = $sschyr2_2 + $sschyr2; } } echo("".number_format($sschyr2,0)." | "); // successful ssch - year 2 $query2b = "SELECT SUM(c.credit_hours) AS success FROM course_table c JOIN registration_table r ON c.fice_code = r.fice_code AND c.academic_year = r.academic_year AND c.term = r.term AND c.sequence = r.sequence AND c.level_sequence = r.level_sequence WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr2."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND r.end_of_term IN ('A', 'B', 'C', 'S', 'K', 'R') AND c.course_number NOT LIKE 'DSG%';"; $result2b = odbc_exec($conn_id, $query2b); while (odbc_fetch_row($result2b)) { $successyr2 = odbc_result($result2b, "success"); $successyr2_total = $successyr2_total + $successyr2; if ($inst_type == '1') { $successyr2_1 = $successyr2_1 + $successyr2; } if ($inst_type == '2') { $successyr2_2 = $successyr2_2 + $successyr2; } } echo("".number_format($successyr2,0)." | "); $percyr2 = ($successyr2 * 100) / $sschyr2; echo("".number_format($percyr2,1)."% | "); // ssch enrolled - year 3 $query3a = "SELECT SUM(c.enrollment * c.credit_hours) AS ssch FROM course_table c WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr3."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND c.course_number NOT LIKE 'DSG%';"; $result3a = odbc_exec($conn_id, $query3a); while (odbc_fetch_row($result3a)) { $sschyr3 = odbc_result($result3a, "ssch"); $sschyr3_total = $sschyr3_total + $sschyr3; if ($inst_type == '1') { $sschyr3_1 = $sschyr3_1 + $sschyr3; } if ($inst_type == '2') { $sschyr3_2 = $sschyr3_2 + $sschyr3; } } echo("".number_format($sschyr3,0)." | "); // successful ssch - year 3 $query3b = "SELECT SUM(c.credit_hours) AS success FROM course_table c JOIN registration_table r ON c.fice_code = r.fice_code AND c.academic_year = r.academic_year AND c.term = r.term AND c.sequence = r.sequence AND c.level_sequence = r.level_sequence WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr3."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND r.end_of_term IN ('A', 'B', 'C', 'S', 'K', 'R') AND c.course_number NOT LIKE 'DSG%';"; $result3b = odbc_exec($conn_id, $query3b); while (odbc_fetch_row($result3b)) { $successyr3 = odbc_result($result3b, "success"); $successyr3_total = $successyr3_total + $successyr3; if ($inst_type == '1') { $successyr3_1 = $successyr3_1 + $successyr3; } if ($inst_type == '2') { $successyr3_2 = $successyr3_2 + $successyr3; } } echo("".number_format($successyr3,0)." | "); $percyr3 = ($successyr3 * 100) / $sschyr3; echo("".number_format($percyr3,1)."% | "); // ssch enrolled - year 4 $query4a = "SELECT SUM(c.enrollment * c.credit_hours) AS ssch FROM course_table c WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr4."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND c.course_number NOT LIKE 'DSG%';"; $result4a = odbc_exec($conn_id, $query4a); while (odbc_fetch_row($result4a)) { $sschyr4 = odbc_result($result4a, "ssch"); $sschyr4_total = $sschyr4_total + $sschyr4; if ($inst_type == '1') { $sschyr4_1 = $sschyr4_1 + $sschyr4; } if ($inst_type == '2') { $sschyr4_2 = $sschyr4_2 + $sschyr4; } } echo("".number_format($sschyr4,0)." | "); // successful ssch - year 4 $query4b = "SELECT SUM(c.credit_hours) AS success FROM course_table c JOIN registration_table r ON c.fice_code = r.fice_code AND c.academic_year = r.academic_year AND c.term = r.term AND c.sequence = r.sequence AND c.level_sequence = r.level_sequence WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr4."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND r.end_of_term IN ('A', 'B', 'C', 'S', 'K', 'R') AND c.course_number NOT LIKE 'DSG%';"; $result4b = odbc_exec($conn_id, $query4b); while (odbc_fetch_row($result4b)) { $successyr4 = odbc_result($result4b, "success"); $successyr4_total = $successyr4_total + $successyr4; if ($inst_type == '1') { $successyr4_1 = $successyr4_1 + $successyr4; } if ($inst_type == '2') { $successyr4_2 = $successyr4_2 + $successyr4; } } echo("".number_format($successyr4,0)." | "); $percyr4 = ($successyr4 * 100) / $sschyr4; echo("".number_format($percyr4,1)."% | "); // ssch enrolled - year 5 $query5a = "SELECT SUM(c.enrollment * c.credit_hours) AS ssch FROM course_table c WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr5."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND c.course_number NOT LIKE 'DSG%';"; $result5a = odbc_exec($conn_id, $query5a); while (odbc_fetch_row($result5a)) { $sschyr5 = odbc_result($result5a, "ssch"); $sschyr5_total = $sschyr5_total + $sschyr5; if ($inst_type == '1') { $sschyr5_1 = $sschyr5_1 + $sschyr5; } if ($inst_type == '2') { $sschyr5_2 = $sschyr5_2 + $sschyr5; } } echo("".number_format($sschyr5,0)." | "); // successful ssch - year 5 $query5b = "SELECT SUM(c.credit_hours) AS success FROM course_table c JOIN registration_table r ON c.fice_code = r.fice_code AND c.academic_year = r.academic_year AND c.term = r.term AND c.sequence = r.sequence AND c.level_sequence = r.level_sequence WHERE c.fice_code = '".$fice_code."' AND c.academic_year = '".$acadyr5."' AND c.course_level IN ('0') AND UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') AND r.end_of_term IN ('A', 'B', 'C', 'S', 'K', 'R') AND c.course_number NOT LIKE 'DSG%';"; $result5b = odbc_exec($conn_id, $query5b); while (odbc_fetch_row($result5b)) { $successyr5 = odbc_result($result5b, "success"); $successyr5_total = $successyr5_total + $successyr5; if ($inst_type == '1') { $successyr5_1 = $successyr5_1 + $successyr5; } if ($inst_type == '2') { $successyr5_2 = $successyr5_2 + $successyr5; } } echo("".number_format($successyr5,0)." | "); $percyr5 = ($successyr5 * 100) / $sschyr5; echo("".number_format($percyr5,1)."% | "); $ssch_sum_3yr = $sschyr1 + $sschyr2 + $sschyr3; $ssch_sum_2yr = $sschyr4 + $sschyr5; $success_sum_3yr = $successyr1 + $successyr2 + $successyr3; $success_sum_2yr = $successyr4 + $successyr5; echo("".number_format($ssch_sum_3yr,0)." | "); echo("".number_format($success_sum_3yr,0)." | "); $threeyear_perc = ($success_sum_3yr * 100) / $ssch_sum_3yr; echo("".number_format($threeyear_perc,1)."% | "); echo("".number_format($ssch_sum_2yr,0)." | "); echo("".number_format($success_sum_2yr,0)." | "); $twoyear_perc = ($success_sum_2yr * 100) / $ssch_sum_2yr; echo("".number_format($twoyear_perc,1)."% | "); $change = $twoyear_perc - $threeyear_perc; echo("".number_format($change,1)."% | "); echo("
| 4-Year Universities | "); echo("".number_format($sschyr1_1,0)." | "); echo("".number_format($successyr1_1,0)." | "); $percyr1_1 = ($successyr1_1 * 100) / $sschyr1_1; echo("".number_format($percyr1_1,1)."% | "); echo("".number_format($sschyr2_1,0)." | "); echo("".number_format($successyr2_1,0)." | "); $percyr2_1 = ($successyr2_1 * 100) / $sschyr2_1; echo("".number_format($percyr2_1,1)."% | "); echo("".number_format($sschyr3_1,0)." | "); echo("".number_format($successyr3_1,0)." | "); $percyr3_1 = ($successyr3_1 * 100) / $sschyr3_1; echo("".number_format($percyr3_1,1)."% | "); echo("".number_format($sschyr4_1,0)." | "); echo("".number_format($successyr4_1,0)." | "); $percyr4_1 = ($successyr4_1 * 100) / $sschyr4_1; echo("".number_format($percyr4_1,1)."% | "); echo("".number_format($sschyr5_1,0)." | "); echo("".number_format($successyr5_1,0)." | "); $percyr5_1 = ($successyr5_1 * 100) / $sschyr5_1; echo("".number_format($percyr5_1,1)."% | "); echo("|||||||||
| 2-Year Colleges | "); echo("".number_format($sschyr1_2,0)." | "); echo("".number_format($successyr1_2,0)." | "); $percyr1_2 = ($successyr1_2 * 100) / $sschyr1_2; echo("".number_format($percyr1_2,1)."% | "); echo("".number_format($sschyr2_2,0)." | "); echo("".number_format($successyr2_2,0)." | "); $percyr2_2 = ($successyr2_2 * 100) / $sschyr2_2; echo("".number_format($percyr2_2,1)."% | "); echo("".number_format($sschyr3_2,0)." | "); echo("".number_format($successyr3_2,0)." | "); $percyr3_2 = ($successyr3_2 * 100) / $sschyr3_2; echo("".number_format($percyr3_2,1)."% | "); echo("".number_format($sschyr4_2,0)." | "); echo("".number_format($successyr4_2,0)." | "); $percyr4_2 = ($successyr4_2 * 100) / $sschyr4_2; echo("".number_format($percyr4_2,1)."% | "); echo("".number_format($sschyr5_2,0)." | "); echo("".number_format($successyr5_2,0)." | "); $percyr5_2 = ($successyr5_2 * 100) / $sschyr5_2; echo("".number_format($percyr5_2,1)."% | "); echo("|||||||||
| Grand Total | "); echo("".number_format($sschyr1_total,0)." | "); echo("".number_format($successyr1_total,0)." | "); $percyr1_total = ($successyr1_total * 100) / $sschyr1_total; echo("".number_format($percyr1_total,1)."% | "); echo("".number_format($sschyr2_total,0)." | "); echo("".number_format($successyr2_total,0)." | "); $percyr2_total = ($successyr2_total * 100) / $sschyr2_total; echo("".number_format($percyr2_total,1)."% | "); echo("".number_format($sschyr3_total,0)." | "); echo("".number_format($successyr3_total,0)." | "); $percyr3_total = ($successyr3_total * 100) / $sschyr3_total; echo("".number_format($percyr3_total,1)."% | "); echo("".number_format($sschyr4_total,0)." | "); echo("".number_format($successyr4_total,0)." | "); $percyr4_total = ($successyr4_total * 100) / $sschyr4_total; echo("".number_format($percyr4_total,1)."% | "); echo("".number_format($sschyr5_total,0)." | "); echo("".number_format($successyr5_total,0)." | "); $percyr5_total = ($successyr5_total * 100) / $sschyr5_total; echo("".number_format($percyr5_total,1)."% | "); echo("|||||||||