Students with Test Scores of 15 or lower (ACT or equivalent)"); echo("

These are first-time entering degree/certificate seeking students only."); echo("
Academic Year = ".$acadyr."."); echo("

"); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); // list of schools $query1 = " SELECT DISTINCT f.inst_type, f.school_abbr, f.fice_code FROM fice_table f WHERE f.inst_type IN ('2') ORDER BY f.inst_type, f.school_abbr;"; $n = 1; $result1 = odbc_exec($conn_id, $query1); while (odbc_fetch_row($result1)) { $inst_type = odbc_result($result1, "inst_type"); $school_abbr = odbc_result($result1, "school_abbr"); $fice_code = odbc_result($result1, "fice_code"); echo(""); echo(""); echo(""); echo(""); //echo(""); // number of under-prepared students $cnt = 0; $query2 = "SELECT COUNT(DISTINCT(s.ssn_id)) AS cnt FROM student_table s WHERE s.fice_code = '".$fice_code."' AND s.academic_year = '".$acadyr."' AND s.enroll_status = '01' AND s.degree_intent IN ('2', '4', '6', '7', '8') AND ( (s.ent_exam_type = '0' AND s.ent_exam_score <= '15') OR (s.ent_exam_type = '1' AND s.ent_exam_score <= '740') OR (s.test_type_math = '0' AND s.test_math <= '15') OR (s.test_type_math = '2' AND s.test_math <= '25') OR (s.test_type_math = '3' AND s.test_math <= '18') OR (s.test_type_english = '0' AND s.test_english <= '15') OR (s.test_type_english = '1' AND s.test_english <= '380') OR (s.test_type_english = '2' AND s.test_english <= '39') OR (s.test_type_english = '3' AND s.test_english <= '49') OR (s.test_type_reading = '0' AND s.test_reading <= '15') OR (s.test_type_reading = '2' AND s.test_reading <= '38') OR (s.test_type_reading = '3' AND s.test_reading <= '70') ); "; //echo("

".$query2."

"); $result2 = odbc_exec($conn_id, $query2); while (odbc_fetch_row($result2)) { $cnt = odbc_result($result2, "cnt"); $cnt_total = $cnt_total + $cnt; } echo(""); // number of first-time degree/certficiate seeking students $undup = 0; $query3 = "SELECT COUNT(DISTINCT(s.ssn_id)) AS undup FROM student_table s WHERE s.fice_code = '".$fice_code."' AND s.academic_year = '".$acadyr."' AND s.enroll_status = '01' AND s.degree_intent IN ('2', '4', '6', '7', '8'); "; //echo("

".$query3."

"); $result3 = odbc_exec($conn_id, $query3); while (odbc_fetch_row($result3)) { $undup = odbc_result($result3, "undup"); $undup_total = $undup_total + $undup; } echo(""); $perc = ($cnt * 100) / $undup; echo(""); // number of all students - entire student body $body = 0; $query4 = "SELECT COUNT(DISTINCT(s.ssn_id)) AS body FROM student_table s WHERE s.fice_code = '".$fice_code."' AND s.academic_year = '".$acadyr."'; "; //echo("

".$query4."

"); $result4 = odbc_exec($conn_id, $query4); while (odbc_fetch_row($result4)) { $body = odbc_result($result4, "body"); $body_total = $body_total + $body; } echo(""); $perc2 = ($cnt * 100) / $body; echo(""); echo(""); } // this bracket ends list of schools // all totals echo(""); echo(""); echo(""); echo(""); $perc_total = ($cnt_total * 100) / $undup_total; echo(""); echo(""); $perc2_total = ($cnt_total * 100) / $body_total; echo(""); echo(""); echo("

#	Inst. Type	Institution	Underprepared	First-Timers Seeking Deg/Cert	Percent	Entire Student Body	Percent
".$n++."	".$inst_type."	".$school_abbr."	".$fice_code."	".number_format($cnt,0)."	".number_format($undup,0)."	".number_format($perc,1)."%	".number_format($body,0)."	".number_format($perc2,1)."%
Totals			".number_format($cnt_total,0)."	".number_format($undup_total,0)."	".number_format($perc_total,1)."%	".number_format($body_total,0)."	".number_format($perc2_total,1)."%

"); odbc_error(); odbc_close($conn_id); ?>

Scores Used:
Test	Composite	Math	English	Reading
ACT (0)	15	15	15	15
SAT (1)	740		380
Asset (2)		25	39	38
Compass (3)		18	49	70