ࡱ> |{ \p Joe F. Smith Ba= =- +8X@"1VArial1VArial1VArial1VArial18VVerdana18VVerdana1 VArial1VArial1VArial1VArial1VArial1VArial1VArial1VArial1VArial1VArial1VVerdana18VArial18VArial1QVTahoma1QVTahoma1VArial1VArial1VArial1VArial1$VArial1VArial1VArial1VArial1VArial1VArial1VArial1VArial1VArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.0%0.0 "$"#,##0 "$"#,##0.0 "$"#,##0.00 "$"#,##0.000 #,##0.0 0.000%"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"                + ) , *          H 8  (@ @  ,@ @  h@@+  h@+  h@+  h+  h @ +  h +  H X x@ @ (x  (@ a ,@ @ a l@ @ + a l@ @ , a l@ @   h,  ( )8 x )x *x +x  8@ @  8 +< +8  8 +< +8  x+ +|+  x  x, +|,  ,  x +| +|  x/  x?+ +<? +|?+ +8?  x@ @ + +<@ @ +|@ @ + +8@ @  x+ +|+  h x  h  8?  h@ @ )8   x@ @ !a ,@ @ ! (@ @ !   x@ @ , !"8@ @  x@ @ +  8@ @  x@ @  !a (x *x@ @ (x@ @ ! H a l@ @ , a l@ @ + a l@ @   l@+  l+  l + +|  L,  l,  l  @+  l +  l +  x@ @  < 8@ 8 a<@ @ x "x  @  H  H )X  `@@  `  @  `@  h   h  )x   `  )x   `  ` @   `   `   H  P *x "x )X (x )x )X "p@ !x )x "p |@ @ x@ @ (8@@ (8@ (8 @ *8 *x@ @ )8@@ )8@ )8 @  ` 5NOTESCNCES data by state#qgraph - Expend. per student comments re graph \graph - NCES percentages!  ; @  ;  ; rt1_1<rt2_1< rt3_1< rt5_1: rt5_2:=rt7_1< !rt7_2<;!" sort_all; @"x8 TL  3  @@  }AlabamaAlaskaArkansasArizona CaliforniaDelawareFloridaGeorgiaIdahoIllinois}Table 7. Expenditures for public elementary and secondary education and other related programs, by state: School year 2001 02IndianaKentuckyKansas LouisianaMaineMontana Minnesota ConnecticutMichigan New Mexico New Jersey North DakotaNorth Carolina New HampshireNebraskaMissouriOhioOregon Rhode IslandSouth Carolina South Dakota Tennessee MississippiUtahNevadaVirginia West VirginiaMaryland Washington WisconsinWyomingHawaiiNew YorkVermont PennsylvaniaOklahoma Massachusetts=http://nces.ed.gov/programs/quarterly/vol_6/6_3/3_3.asp#tab_5Table 5. Student membership and current expenditures per pupil in membership for public elementary and secondary schools, by function and state: School year 2001 02StateFall 2001 student membership,Current expenditures per pupil in membershipTotal InstructionSupport services UnitedStatesDistrictofColumbiaInstruction PercentSupport services PercentNon- Instruction PercentTable 4. Percentage distribution of current expenditures for public elementary and secondary schools, by function and state: School year 2001 02gTable 1. Revenues for public elementary and secondary schools, by source and state: School year 2001 02Table 2. Percentage distribution of revenue for public elementary and secondary schools, by source and state: School year 2001 02 1 - New York 2 - Maine3 - Utah 4 - Tennessee5 - New Hampshire6 - Rhode Island 7 - Vermont8 - Connecticut 9 - Georgia10 - MassachusettsData for graph: 33 - TexasColoradoIowaTexas(Restated as percentages) Table 7. Expenditures for public elementary and secondary education and other related programs, by state: School year 2001 02Table of Contents for next tab:& Non- instruction3The Tables on this xls are from this NCES document:highest Table 4. Percentage distribution of current expenditures for public elementary and secondary schools, by function and state: School year 2001 02 8 Table 5. Student membership and current expenditures per pupil in membership for public elementary and secondary schools, by function and state: School year 2001 02  >0http://nces.ed.gov/programs/quarterly/vol_6/6_3/(National Center for Education StatisticsVolume 6; issue 6-3\Revenues and Expenditures for Public Elementary and Secondary Education: School Year 2001 02Presents national and state data on public education finances, including revenues by source, expenditures per student, and expenditures for instruction.Source:>The Education Statistics Quarterly, release date July 16, 2005"$uTable 3. Current expenditures for public elementary and secondary schools, by function and state: School year 2001 02zTable 6. Current expenditures for instruction for public elementary and secondary education, by state: School year 2001 02Rank Comments:`The graph shows Texas, with 60.4% of expenditures for classroom instruction, along with the tenAstates that the NCES data show as having the highest percentages.eTwo of the states, Utah and Tennessee, have lower expenditures and classroom instruction expenditurestGovernor Perry's 65% Executive Order sets the bar at a level so high that only 4 states are currently above the bar.)than Texas spends for total expenditures!#http://www.firstclasseducation.org/This NCES data is used by First Class Education's website as the basis for their rankings of states on the map which appears at this link:\How realistic is the proposal to increase the percentage of expenditures to a 65% threshold?_In year 1, at a 50% level, only the District of Columbia, at 49.6%, would be out of compliance.eIn year 2, at a 55% level, the District of Columbia is still the only state/entity out of compliance.xIn year 3, at a 60% level, 15 states and D.C. are below the threshold; Texas (at 60.4%) is just above the 60% threshold.hIn year 4, at a 65% level, only 4 states, New York, Maine, Utah and Tennessee, exceed the 65% threshold.gQuestion: How can a threshold of 65% be set without first considering the level of total expenditures? than Texas.than Texas on a per student basis. However, the graph shows that 7 of the 10 top-ranked states have substantially higher total expenditures}New York and Connecticut, ranked 1st and 8th based solely on this percentage, spend more on per-student classroom instruction-LAThis NCES data is readily available at the link included at left.Lone can analyze how Texas or any state of interest compares with the other columns M through BFPurpose:\What is different about this spreadsheet is that with the data tables in an Excel worksheet,DThe spreadsheet is used as a basis for two graphs on the tabs below.`I believe that they illustrate that you can't just mandate the 65% part of the equation without Xstates using xls functions such as Data>Sort and Data>Filter across all the NCES Tables.addressing the variances between the levels of expenditures on a per student basis from one state to the next (highest DC., at 12,102 to Utah, at 4,900 per student).Texas ranks 36 on per-student total expenditures. Therefore, 35 states have more dollars/student to cover the 35% non-instructional expenses than Texas. 3If spending percentages remained at these levels & . ` pB+5"" $ W' '+-&02%cc   9zB  dMbP?_*+%M6HP DeskJet 1220CXC od,,LetterDINU"4$_'$$$$"d,,??U} } } $ } $} m  @ @ @   @@@V@f@@@@@@g@ x z\xxxxxx  zu xxxxxxxxx xWxxxxxx xxxxxxxxxx zXzzzxxx  xr xxxxxxxxx ]xxxxxx  xv xxxxxxxxx xYxxxxxx  xs xxxxxxxxxxxxxxxx  xy xxxxxxxxxxxxxxxx xxxxxxxxxx Zx xxxxxxxxx xx xw xxxxxxxx x{{{{{{x xx xxxxxxxx x [ x z   |}~ P~wwwwww~ V~ U~wwwwww~ ^~wwwwww~ >~~ ?~~  ~wwwwww~ O~~ _T ~BrXVJVVVB6JBBV..8.....0>@      7  OG^}}f  dMbP?_*+%M6HP DeskJet 1220CXC od,,LetterDINU"4$_'$$$$"d,,??U} $ } m} $} m } $ U} } m U} $ U} $ } } } } } } $} $ QColumn C,O Z@ @@O P P @  Jv Sgm  t  0!h!n"#i#o W 1  = / $$ 2 3 4$$$$$$ %% 5 ` 6 7 &%%%%%% %% &R % &: &` &; &< %$ 12j3jj3'0'' ` 'Q 12j3jj3QaabbQ p8 S3\ 6@  @¤@ t@! ) $?  D D  (! )+?  D D ! )OkQ? D D  4L&A@+(G@ D%@@@Bج@@z@ ))o^?(  @ 3 LL+ (:@ D %@ @ @B )2Ka?(  @ 3 LL )״?(  @ 3 LL 56fA6@( @(@2L-@@@B6@6V@7s@ )À?(   (E@(   L-@@@B ) F?(   )[C?(  89$,A9L@(H@(9v@92@:pw@ ) ;L,?(   (H@(   )yy?(   )`n?(  8F4tAF@(E@(F6@FP@Ht@ )͔p?(   (6@(   )tJ?(   )+/?(  R6{ @(9@(@@pq@ )P?(   (3@(   )\?(   )"*7?(  8L6L-6@(A@(6T@6@7n@ )Ne|?(   (G@(   )o!?(   )DJH8?(  T ;9f!A<@(@(<t@9ª@:w@ *Z|?(   ( @(   )xf?(   )Zve?(  896@9"@("@(9W@9x@:{@ )i"HR?(   (7@(   );7?(   )?(  qq 9rh@r@s?(rw@r^@tw@ q u0Qn?(  + sI@  D %@ @ @B u"i9H?(   uZ8?(  q 899E@(F@(9@9@:Ps@ )-?(   (D@(  @ *L-@@@B )0q?(   )myv?(  T ;9Y<Լ@(:@(<j@9ޡ@:w@ *Yp?(   ("@(   )C?(   )$\?(  =*9A9@(=@(9A@9b@:y@ )5X?(   (@@(   ) ?(   )/딗?(  89A9{@(G@(9@9>@:0p@ )MST?(   (<@(   )ҏǪ"?(   )ۅ[a?(  8 9~m~9@(1@(9}@9(@:0p@ )Ke Ke ?(   (C@(   )?(   )쪐쪠?(  8 9<96@(6@(9c@9,@:s@ )suy?(   (?@(   )l?(   )V"[?(  8M9A9@(<@(9@9@:@ )bz?(   (B@(   )H66?(   )^S??(  8 9A9@(;@(9°@9&@:`u@ )\ڤ?(   (F@(   )8B?(   )m(kܧ?(  8 9n'9{@(C@( 9F@9@:v@ )'bA9?(   (8@(   )T1?(   )]jA?(  BX. DVbt(<F!  !"#$%&'()*+,-./0123456789:;<=>?@ 8 9Q&A9@ (C@(! 9\@9@:z@ )9xC?(!   (;@(!   ) ?(!   ) 1}A?(!  !T !>!9 A?9@!($@("!?@9@:pr@! +8S?("  ! (@("  ! )]mP4?("  ! )+ ?("  "8&"9C*A9@"(&@(#"9 @9p@:y@" )ޡ?(#  " (0@(#  " )Ӂ˔%?(#  " )ۙ^S?(#  #T #;/#F-AG@#(@($#Gs@F@Hs@# *4 7`?($  # ($@($  # )!/B?($  # );*ӟ?($  $R$lh:A@$((@(%$h@@p@$ )*R_?(%  $ (H@(%  $ ):OI?(%  $ )z?(%  %8%6p)A68@%(5@(&%6<@6d@7t@% )Nh?^?(&  % (&@(&  % )2"?(&  % )Xy,?(&  &8!&9 A9@&(I@('&90@9ԛ@:u@& )D?('  & (A@('  & )3MJ?('  & )NJ?('  '8'9+AU߻@'(>@(('9@9P@:s@' )~L}?((  ' (=@((  ' )k55k,?((  ' )ga?((  (8(9XA9@((?@()(9@9@:pr@( )?()  ( (2@()  ( )fpЯ?()  ( )y\@c?()  )8)9fA9=@)(4@(*)9@9@:(@) ))0A+?(*  ) (*@(*  ) ).?(*  ) )'?(*  *8#*98A9@*(F@(+*9@9L@:h@* )yP?(+  * (,@(+  * )hO%?(+  * )p%9  ?(+  +T +;+9? A<@+(2@(,+<@9̣@:o@+ * ?(,  + (@(,  + )RW$p?(,  + )tS?(,  ,8,9x4A9@,(@(-,9?@9f@:v@, )w-?(-  , (D@(-  , )7+?(-  , )F?(-  -8-9A9@-(A@(.-9@98@:s@- )Gy?(.  - (I@(.  - )rrxA?(.  - )%W?(.  .T .>+.9M?@.(@(/.?@9p@:r@. +ݽ?(/  . (?(/  . )@_k?(/  . )I/?(/  /8/9HP9e@/(D@(0/9@9h@:w@/ )O^A?(0  / ((@(0  / )W?(0  / )u\D؜?(0  0809@95@0(B@(109@92@:8@0 )? ?(1  0 (9@(1  0 )Ku?(1  0 )Սͳ?(1  1819&o9@1(0@(219K@9J@:Pq@1 )FBb?(2  1 (F@(2  1 ).-Ȩ?(2  1 )*Z.?(2  28.29%9U@2(E@(329 @9^@:py@2 )=L~?(3  2 (G@(3  2 )~?(3  2 )?(3  3839p A9ڽ@3(7@(439@9@:p@3 )%?(4  3 (E@(4  3 )㘮@?(4  3 )h&?(4  48-49.o9@4(.@(549ƴ@9@:Pt@4 )~$W?(5  4 (.@(5  4 )?(5  4 )A}?(5  5T 5;59JA<@5(@(65<t@9@:p@5 *RJ)?(6  5 (@(6  5 )pW?(6  5 )`T. 8@s8kG@8(H@(98kL@@0r@8 +kF1?(9  8 (@(9  8 )(76?(9  8 )m{?(9  9T 9AN9BCs@9(B@(:9C@6N@70u@9 ,R#S?(:  9 (@@(:  9 )@"n%?(:  9 )ПO?(:  :T :>":9A?$@:(I@(;:?@9l@:p@: +?(;  : (@(;  : )++?(;  : )?(;  ;T ;;,;9@<'@;(@(<;<@9"@:0q@; *&Vš?(<  ; (@(<  ; )$=K ?(<  ; )Qot?(<  <8$<9NF9H@<(8@(=<9 @9.@:Pr@< )M?(=  < (5@(=  < )]S ?(=  < )?XNG?(=  =8'=9`.AU@=(@@(>=U]@9@:`u@= )L* ?(>  = (B@(>  = ),?(>  = )_BR?(>  >8%>9DA9@>(3@(?>9@9@:|@> )qq?(?  > (4@(?  > )Gb,?(?  > )wZeԭ?(?  ?8(?959@?(,@(@?9@9z@:Pq@? )?(@  ? (1@(@  ? )ATF?(@  ? )m?(@  D^l@@BDEFGHIJKLMN @8)@9@9@@(*@(@9@90@:q@@ )7{7{?(  @ (>@(  @ )n!?(  @ )?(  BDJ~ D? D>@D9M?@D?D?@9p@:r@D +ݽ?~ D d?D )@_k?D )I/?~ E@ E>AE9 A?9@E?E?@9@:pr@E +8S?~ E d@E )]mP4?E )+ ?~ F@ F>BF9A?$@F?F?@9l@:p@F +?~ F d@F )++?F )?~ G@ G>CG@s8lG@G-GlL@@@.0r@G +kF1?~ G d@G )(76?G )m{?~ H@ H;DH9? A<@H<H<@9̣@:o@H * ?~ H e@H )RW$p?H )tS?~ I@ I;EI9JA<@I<I<t@9@:p@I *RJ)?~ I e@I )pW?I )`T. M613L<2 <Table 4 Instruction % < rjB  0D@ i9i]`>$jCathy Wightman>@A QE=?  GGG666R        7  M[Xerox WC M15 Series PCL 6}_ d,LetterPRIV''''  x6Untitleddd"d,,??3` 4#` 4# ` 4# ` 4# ` 4# ` 4# ` 4#` 4# $(  $l $ s *`  @[ ]`-$ O0<PTotal Expenditures % for Instruction > 65% 63.7% to 64.9% 60.4%<0 $ (COf^ $ c $@ 2 ]`81$f^ $ c $@2 [ ]`1$f^ $ c $+@2 1[ u]`1$f^ $ c $@2 [ ]`|2$f^ $ c $ @ & ]`\$0 0 3C2dc  3Q (Total expendituresQ ;DNQ ;DNQ3_ O   MM< 4E4  3Q (Direct InstructionQ ;DNQ ;DNQ3_4 3_ O   MM< 4 3_ O +  MM< 43_ O +  MM< 43_ O +  MM< 43_ O +  MM< 43_ O +  MM< 43_ O +  MM< 43_ O   MM< 43_ O   MM< 43_ O   MM< 43_ O   MM< 4E4D$% MP(3O& Q4$% MP(3O& Q4FARS 3O & 3 b#M&43*#M&! M4% M3O1& Q ITop Ranked States by Percentage Spent on Instruction - as defined by NCES'4% ?ZMZ3O& Q *Dollars per Student'4523   fw % i@zar%KP)sp:"M( UUUU50%"B  `43" 3_ M NM  MM< 444% NkMP3O^'& Q BNCES - Expenditures Per Student'4% M3O&Q'4% M3O&Q'44 e! 1 - New York! 1 - New York 2 - Maine 2 - Maine3 - Utah3 - Utah# 4 - Tennessee# 4 - Tennessee+5 - New Hampshire+5 - New Hampshire)6 - Rhode Island)6 - Rhode Island 7 - Vermont 7 - Vermont'8 - Connecticut'8 - Connecticut 9 - Georgia 9 - Georgia- 10 - Massachusetts- 10 - Massachusetts 33 - Texas  33 - Texase@@9@@$@@G@L@@@@t@'@@@t@Լ@j@ @ s@ s@ @e> C2    dMbP?_*+%M6HP DeskJet 1220CXC od,,LetterDINU"4$_'$$$$"],,??U}      &xxxxxxxxxxxxxxxx&xxxxxxxxxxxxxxxxx ya"xxxxxxxxxxxxxx&xxxxxxxxxxxxxxxx x xb" xxxxxxxxxxxxxx x xc" xxxxxxxxxxxxxx& xxxxxxxxxxxxxxxx x xq" xxxxxxxxxxxxxx x xf" xxxxxxxxxxxxxx&xxxxxxxxxxxxxxxxx xd"xxxxxxxxxxxxxxx xp"xxxxxxxxxxxxxxx xo"xxxxxxxxxxxxxx&xxxxxxxxxxxxxxxxx xe"xxxxxxxxxxxxxx&xxxxxxxxxxxxxxxxx x{"xxxxxxxxxxxxxx&xxxxxxxxxxxxxxxxx xh"xxxxxxxxxxxxxx xx xg xxxxxxxxxxxxx&xzzzzxxxxxxxxxxx&xzzzzxxxxxxxxxxx&xxxxxxxxxxxxxxxx&xxxxxxxxxxxxxxxx4**>*>>*>>*>>>*>*>*>@***>@)))7  :  dMbP?_*+%"??xU} Y} Y} _} IY}  $ Y} Y} $ YColumn C:      !"#$ V8W $?X Z+Wݽ?~ [? ZW8S?~ [@ Z"W?~ [@ Z  WkF1?~ [@ \ W ?~ [@ \ WRJ)?~ [@ \, W&Vš?~ [@ \ WZ|?~ [ @ \WYp?~ ["@ \/W4 7`?~ [$@ ]WNh?^?~ [&@ ]WO^A?~ [(@ ]W)0A+?~ [*@ ]#WyP?~ [,@ ]-W~$W?~ [.@ ]&Wޡ?~ [0@ ](W?~ [1@ ]W?~ [2@ ]WP?~ [3@ ]%Wqq?~ [4@ ]$WM?~ [5@ ]W͔p?~ [6@ ]Wi"HR?~ [7@ ] W'bA9?~ [8@ ]W? ?~ [9@ ]W)o^?~ [:@ ] W9xC?~ [;@ !]!WMST?~ ![<@ "]"W~L}?~ "[=@ #])#W7{7{?~ #[>@ $] $Wsuy?~ $[?@D<l*..............................%&'()*+,-./0123456789 %V*%W5X?~ %[@@ &^N&WR#S?~ &[@@ ']!'WD?~ '[A@ (](WݵozD?~ ([A@ )]M)Wbz?~ )[B@ *]'*WL* ?~ *[B@ +] +WKe Ke ?~ +[C@ ,],WR_?~ ,[C@ -]-Ww-?~ -[D@ .].W-?~ .[D@ /]/W%?~ /[E@ 0]0WÀ?~ 0[E@0ccccccccc 1] 1W\ڤ?~ 1[F@ 1ci1cccccccc 2]2WFBb?~ 2[F@ 2c|2cccccccc 3].3W=L~?~ 3[G@ 3cj3cccccccc 4]L4WNe|?~ 4[G@ 4ck4cccccccc 5]5W*R_?~ 5[H@ 5cl5cccccccc 6]6W ;L,?~ 6[H@ 6cm6cccccccc 7]7WGy?~ 7[I@7ccccccccc 8]98W0Qn?~ 8[I@ 8cn8cccccccc 9ccccccccc ............JVVVVVVJV00(  0p 0 6NMM?.]`tB$  "tB??3` 4(` #` # ` 4E$"PH@40(  4迂3d23 M NM4 333Q .Expenditures by StateQ ;8Q ;8Q3_ O    d4 3_ O    d4E4D$% MP(3O&Q4$% MP(3O& Q4FA< 3O/B 3 b MZ&"43*?ffffff??{Gz??#M&! M4523   fw % i@zar%KP)sp:"M( UUUU50%"B  `43" 44% ZMZ3O }&Q f1Percentage Classroom Expenditures by State - NCES'443eNew YorkMaineUtah Tennessee# New Hampshire! Rhode IslandVermont ConnecticutGeorgia# Massachusetts Minnesota% North Carolina Nebraska Nevada! PennsylvaniaMaryland WisconsinMontana California# West VirginiaVirginiaArkansasDelawareKentucky! North DakotaAlabama LouisianaIdahoMissouriWyomingIndianaHawaii Texas! Mississippi%"South Carolina#Iowa$ Washington%Illinois!& South Dakota' New Jersey(Florida)Oregon*Alaska+Kansas,Ohio-Oklahoma.Colorado/Michigan0Arizona1 New Mexico12DistrictofColumbiaeݽ?8S??kF1? ?RJ)?&Vš?Z|?Yp? 4 7`? Nh?^? O^A? )0A+? yP?~$W?ޡ???P?qq?M?͔p?i"HR?'bA9?? ?)o^?9xC?MST?~L}?7{7{?suy?5X? R#S?!D?"ݵozD?#bz?$L* ?%Ke Ke ?&R_?'w-?(-?)%?*À?+\ڤ?,FBb?-=L~?.Ne|?/*R_?0 ;L,?1Gy?20Qn?e >@2227 Oh+'0HPh Cathy WightmanJoe F. SmithMicrosoft Excel@<@Ռ@!Ϣ՜.+,0 PXd lt|   NOTESNCES data by statecomments re graphgraph - NCES percentagesgraph - Expend. per student'comments re graph'!Print_AreaNOTES!Print_Area'NCES data by state'!rt5_1'NCES data by state'!rt5_2 sort_all  WorksheetsCharts Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijlmnopqrtuvwxyzRoot Entry FWorkbook@SummaryInformation(kDocumentSummaryInformation8s