<?xml version="1.0" encoding="UTF-8" standalone="yes"?><oembed><version><![CDATA[1.0]]></version><provider_name><![CDATA[Random Critical Analysis]]></provider_name><provider_url><![CDATA[https://randomcriticalanalysis.wordpress.com]]></provider_url><author_name><![CDATA[rcafdm]]></author_name><author_url><![CDATA[https://randomcriticalanalysis.wordpress.com/author/rcafdm/]]></author_url><title><![CDATA[Standardized tests correlations within and between California public&nbsp;schools]]></title><type><![CDATA[link]]></type><html><![CDATA[<p>To exploit <a title="concentrated poverty analysis" href="https://randomcriticalanalysis.wordpress.com/2015/05/16/on-concentrated-poverty-and-its-effects-on-academic-outcomes/" target="_blank">some of my prior work with California&#8217;s test score data</a>, I decided to extend this analysis to SAT, ACT, and AP scores in the state of California, i.e., to compare the relationships of these different tests within and between schools.</p>
<p>Notes/Caveats:</p>
<ul>
<li>To achieve more stable results with schools with small numbers of test takers I averaged 2-4 years worth of test score data together.</li>
<li>Unfortunately, AP results are not broken out by subject (some are much harder than others and there are apt to be different test taking patterns at different sorts of schools)</li>
<li>SAT/AP/ACT data is <span style="text-decoration:underline;">not</span> available by race/ethnicity</li>
</ul>
<p style="text-align:center;"><span style="text-decoration:underline;">ACT vs SAT (r=0.97)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_vs_act.png" target="_blank"><img class="aligncenter wp-image-1842 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_vs_act.png?w=660&#038;h=475" alt="sat_vs_act" width="660" height="475" /></a></p>
<p style="text-align:center;"><em>[It&#8217;s almost like they&#8217;re testing the same construct&#8230;. :-)]</em></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT by English grade 11 (r=0.84)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_composite_by_ela_g11.png" target="_blank"><img class="aligncenter wp-image-1843 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_composite_by_ela_g11.png?w=660&#038;h=475" alt="sat_composite_by_ela_g11" width="660" height="475" /></a></p>
<p><!--more--></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT by Science Grade 10 (r=0.81)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_scig10.png" target="_blank"><img class="aligncenter wp-image-1844 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_scig10.png?w=660&#038;h=475" alt="sat_by_scig10" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT by World History (r=0.79)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_world_hist.png" target="_blank"><img class="aligncenter wp-image-1845 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_world_hist.png?w=660&#038;h=475" alt="sat_by_world_hist" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT by Physics (r=0.73)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_physics.png" target="_blank"><img class="aligncenter wp-image-1846 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_physics.png?w=660&#038;h=475" alt="sat_by_physics" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT by Algebra I (r=0.56)</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_algebrai.png" target="_blank"><img class="aligncenter wp-image-1847 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_algebrai.png?w=660&#038;h=475" alt="SAT_by_AlgebraI" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT math by Algebra I (r=0.57)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/satm_by_algebrai.png" target="_blank"><img class="aligncenter wp-image-1848 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/satm_by_algebrai.png?w=660&#038;h=475" alt="satm_by_algebraI" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT by Algebra II (r=0.75)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_algebraii.png" target="_blank"><img class="aligncenter wp-image-1851 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_by_algebraii.png?w=660&#038;h=475" alt="sat_by_algebraII" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT math by Algebra II (r=0.79)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/satm_by_algebraii.png" target="_blank"><img class="aligncenter wp-image-1850 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/satm_by_algebraii.png?w=660&#038;h=475" alt="satm_by_algebraII" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP Average score by Algebra II (r=0.70)</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_algebraii.png" target="_blank"><img class="aligncenter wp-image-1852 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_algebraii.png?w=660&#038;h=475" alt="ap_by_algebraII" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP average score by English Grade 11 (r=0.72)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_ela_g11.png" target="_blank"><img class="aligncenter wp-image-1853 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_ela_g11.png?w=660&#038;h=475" alt="ap_by_ela_g11" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP average score by Science Grade 10 (r=0.70)</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_scig10.png" target="_blank"><img class="aligncenter wp-image-1854 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_scig10.png?w=660&#038;h=475" alt="ap_by_scig10" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP by SAT composite (r=0.82)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_sat.png" target="_blank"><img class="aligncenter wp-image-1855 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_sat.png?w=660&#038;h=475" alt="ap_by_sat" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP by ACT average score (r=0.81)</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_act.png" target="_blank"><img class="aligncenter wp-image-1856 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_by_act.png?w=660&#038;h=475" alt="ap_by_act" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP percent scoring 5 by ACT</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct5_by_act.png" target="_blank"><img class="aligncenter wp-image-1858 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct5_by_act.png?w=660&#038;h=475" alt="ap_pct5_by_act" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP percent scoring 4 or higher by ACT</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_4plus_by_act.png" target="_blank"><img class="aligncenter wp-image-1859 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_4plus_by_act.png?w=660&#038;h=475" alt="ap_pct_4plus_by_act" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP percent scoring 3 or higher by ACT</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_3plus_by_act.png" target="_blank"><img class="aligncenter wp-image-1860 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_3plus_by_act.png?w=660&#038;h=475" alt="ap_pct_3plus_by_act" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP percent scoring 1 by ACT</span></p>
<p><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_1_by_act.png" target="_blank"><img class="aligncenter wp-image-1861 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_1_by_act.png?w=660&#038;h=475" alt="ap_pct_1_by_act" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP Percent scoring 2 or lower</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_2_or_lower_by_act.png" target="_blank"><img class="aligncenter wp-image-1862 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_2_or_lower_by_act.png?w=660&#038;h=475" alt="ap_pct_2_or_lower_by_act" width="660" height="475" /></a></p>
<hr />
<p style="text-align:center;">Other correlates</p>
<p style="text-align:center;"><span style="text-decoration:underline;">Average number of AP tests per test taker by (school) ACT score</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_number_of_tests_per_tester_by_act_score.png" target="_blank"><img class="aligncenter wp-image-1864 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_number_of_tests_per_tester_by_act_score.png?w=660&#038;h=475" alt="ap_number_of_tests_per_tester_by_act_score" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">Average number of tests per senior by ACT score</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_avg_tests_per_senior_by_act.png" target="_blank"><img class="aligncenter wp-image-1863 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_avg_tests_per_senior_by_act.png?w=660&#038;h=475" alt="ap_avg_tests_per_senior_by_act" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">Average percent of senior tests by ACT score</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/avg_pct_seniors_tested_by_act.png" target="_blank"><img class="aligncenter wp-image-1865 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/avg_pct_seniors_tested_by_act.png?w=660&#038;h=475" alt="avg_pct_seniors_tested_by_act" width="660" height="475" /></a></p>
<p style="text-align:center;">Note: I am simply dividing by the number of students enrolled in grade 12.  Since juniors can and do take these tests the totals can exceed 100%.</p>
<p style="text-align:center;"><span style="text-decoration:underline;">Percent of seniors taking SAT (test takers / # seniors) by English Grade 11 scores</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_pct_tested_by_ela_g11.png" target="_blank"><img class="aligncenter wp-image-1866 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_pct_tested_by_ela_g11.png?w=660&#038;h=475" alt="sat_pct_tested_by_ela_g11" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">Percent of seniors taking ACT tests (test takers / # seniors) by English Grade 11 scores</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/act_pct_tested_by_ela_g11.png" target="_blank"><img class="aligncenter wp-image-1867 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/act_pct_tested_by_ela_g11.png?w=660&#038;h=475" alt="act_pct_tested_by_ela_g11" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">Percent of seniors taking SAT by ACT</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_vs_act_percent_tested.png" target="_blank"><img class="aligncenter wp-image-1868 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_vs_act_percent_tested.png?w=660&#038;h=475" alt="SAT_vs_ACT_percent_tested" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">AP percent tested by SAT percent tested (test takers / reported senior enrollment)</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_tested_by_sat_pct_tested.png" target="_blank"><img class="aligncenter wp-image-1869 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/ap_pct_tested_by_sat_pct_tested.png?w=660&#038;h=475" alt="AP_pct_tested_by_SAT_pct_tested" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">SAT composite by percent of &#8220;seniors&#8221; taking SAT</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat-by-percent-tested.png" target="_blank"><img class="aligncenter wp-image-1871 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat-by-percent-tested.png?w=660&#038;h=475" alt="SAT by Percent Tested" width="660" height="475" /></a></p>
<hr />
<p style="text-align:center;"><span style="text-decoration:underline;"><strong>Some quick and dirty modeling exercises</strong></span></p>
<p style="text-align:center;"><span style="text-decoration:underline;">Model 1 (ELA grade 12 + percent seniors tested): r=0.88</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_pred1_any_n.png" target="_blank"><img class="aligncenter wp-image-1872 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_pred1_any_n.png?w=660&#038;h=475" alt="sat_pred1_any_n" width="660" height="475" /></a></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_pred1_n200plus.png" target="_blank"><img class="aligncenter wp-image-1873 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_pred1_n200plus.png?w=660&#038;h=475" alt="sat_pred1_n200plus" width="660" height="475" /></a></p>
<p style="text-align:center;"><span style="text-decoration:underline;">Model 2 (Grade 10 Science + Algebra II + percent SAT test takers), r=0.85</span></p>
<p style="text-align:center;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_pred2_any_n.png" target="_blank"><img class="aligncenter wp-image-1874 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/sat_pred2_any_n.png?w=660&#038;h=475" alt="sat_pred2_any_n" width="660" height="475" /></a></p>
<p style="text-align:left;">I&#8217;m sure I could do better than this (especially if I deal with some of those outliers).  My point here is simply this: these tests are highly correlated and that accounting for differences in test taking rates or aggregating a few of them together improves the relationships further.</p>
<hr />
<p style="text-align:center;"><span style="text-decoration:underline;"><strong>Scatterplot matrices</strong></span></p>
<p style="text-align:left;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/matrix_including_outliers.png" target="_blank"><img class="aligncenter wp-image-1878 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/matrix_including_outliers.png?w=660&#038;h=475" alt="matrix_including_outliers" width="660" height="475" /></a></p>
<p style="text-align:left;"><a href="https://randomcriticalanalysis.files.wordpress.com/2015/05/matrix_excluding_outliers.png" target="_blank"><img class="aligncenter wp-image-1879 size-full" src="https://randomcriticalanalysis.files.wordpress.com/2015/05/matrix_excluding_outliers.png?w=660&#038;h=558" alt="matrix_excluding_outliers" width="660" height="558" /></a></p>
]]></html><thumbnail_url><![CDATA[https://i0.wp.com/randomcriticalanalysis.files.wordpress.com/2015/05/matrix_excluding_outliers.png?fit=440%2C330]]></thumbnail_url><thumbnail_height><![CDATA[330]]></thumbnail_height><thumbnail_width><![CDATA[390]]></thumbnail_width></oembed>