Tag Archives: K-12 schools

National Children & Education Statistics Program Updates

.. NCES Program updates .. tools, data & methodology to examine national scope children & education .. school, school district & extended geographic-statistical data with drill-down to school and intersection level. See more about the NCES Program below.

New this Week
ACS 2015 school district demographic-economic interactive tables
– view, compare, analyze selected/all U.S. school districts
– more focused blog updates coming soon.

School Districts with Highest Median Household Income
Use the interactive table to examine economic characteristics of school districts. Below is a list of the 10 school districts having the highest median household income developed using the Economic Characteristics interactive table. Develop similar views for metros and states of interest.

– ranked on item E062 — median household income.
– click graphic for larger view.

Use GIS tools to develop thematic pattern maps such as the one shown below with NCES GIS projects. Select from hundreds of statistical measures. Create your own regional;/district views. Integrate other data.

Patterns of Economic Prosperity by School District
– median household income (item E062 in table)

– view developed with CVGIS software & related GIS project and data.
– click graphic for larger view.

See the School Districts Economic Characteristics Interactive Table.

About the National Children & Education Statistics Program
The National Children & Education Statistics (NCES) Program provides access to tools, data & methodology to examine national scope children’s demographics & education-related characteristics. These resources enable stakeholders to view and analyze detailed geographic and statistical data at the school, neighborhood, community, attendance zone, school district and higher level geography. Integrate these data with drill-down demographic-economic data to the census block and intersection levels. Examine characteristics of schools, school districts and education data with related and higher level geography including urban/rural, cities, counties, metros, state and the U.S.

See NCES Main Section.

Contents: Summary of NCES Program Resources
Click a link to view more detail on a selected topic.
Updates: New Resources, Events & Related Topics
Analytics, Blogs, Studies
Using Software Tools & Datasets
01 Mapping & Visual Analysis Tools
02 School District Annual Demographic-Economic Data Resources
03 Children’s Demographics & Living Environment by School District
04 School District Enrollment & Operational Characteristics
05 School District Finances: Sources & Uses of Funds
06 School District Geographic Size & Characteristics
07 School District-ZIP Code Area Relationship Table
08 K-12 Public Schools
09 K-12 Private Schools
10 K-12 Public School Attendance Zones
11 K-12 Public Schools by Urban/Rural Status
12 Census Tract Demographic-Economic Characteristics
13 Metropolitan Area Situation & Outlook Reports

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Largest School Districts Enrollment Characteristics

..  while school district enrollment is reported by school districts, only public school enrollment is reported. Public and private school enrollment are available by district from the American Community Survey (ACS 2015).  With few exceptions, school districts do not report on demographic-economic characteristics of the school district.  These data are only available from ACS. See the related interactive table to access and compare enrollment characteristics of school districts of interest.

In 2015, there were 1,016 school districts with total population of 65,000 or more (of total 14,650) for which “1-year estimates” were tabulated.  These estimates are based on respondent data for calendar year 2015.  This section summarizes selected enrollment characteristics of the largest districts and provides access to much more detail for each of these districts.

Largest 10 School Districts
The following graphic shows the largest 10 school districts based on the size of the 2015 school age population ages 5-to-17. Click graphic for larger view.

Mapping the Largest School Districts
The following graphic shows locations of the largest school districts as red markers. Click graphic for larger view that opens in a new window. Expand browser window for bets quality view. The larger view shows school district locations on context of metropolitan statistical areas (MSAs).

  view created using CV XE GIS software and related GIS project.

School Districts Tabulated in ACS 2015
ACS 2015 data are tabulated for 14,650 school districts (among many other wide-ranging geography). The following table shows the number of districts for which 1-year estimates and 5-year estimates are tabulated. There are 1,016 districts for which 1-year estimates were tabulated.

These data show enrollment of residents of the district whether enrolled in that district or otherwise. Enrollment data are provided for preschool, K-12 and college and not enrolled.

Using the School District Enrollment Interactive Table
The following graphic illustrates use of the interactive table (click that link to use the table) showing enrollment in kindergarten by school district ranked in descending order.

– click graphic for larger view.

Using the table, you can select total, public or private enrollment for selected grade ranges.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Children’s Demographics by School District

.. data and tools to analyze children’s demographics by school district ..  the ACS 2014 median household income for the Houston ISD, TX (HISD) was $46,069 (all households) compared to $41,896 (grade relevant children’s households). How does economic prosperity (or choose from many other attributes) vary between the total population of an area and to those of total children or grade relevant children by type of enrollment in districts of interest? See related Web section with interactive table.

This section summarizes data and tools to access to the children’s demographic-economic data, based on the 2014 American Community Survey (ACS 2014) school district special tabulation (SDST), for each/all school districts. These data provide insights into the population, social, economic and housing characteristics of total children and grade relevant children — in contrast to the total population and housing. Use the interactive table below to view, rank, compare, query children’s characteristics.

Patterns of Economic Prosperity by School District; Children’s Households
— Median Household Income for Grade Relevant Children Households
The following thematic map shows patterns of median household income for grade relevant children households by school district for Texas and adjacent states. Click graphic for larger view (shows metros). Expand browser to full extent for best quality view.

View developed using CV XE GIS software and associated GIS project.

Additional Views:
Dallas metro area
Houston metro area
Los Angeles metro area

Importance of these Data
The annually updated SDST data are a unique source of data to help stakeholders understand demographic-economic characteristics of total children as well as grade relevant children. The real power of these data is that they enable analysis of children’s living characteristics by type of enrollment (enrolled in public school, enrolled in private school, not enrolled) by school district. For example, in this Houston ISD, TX profile it can be determined that of those grade relevant children who ‘speak English less than “very well”.
– enrolled in public school
… 36,995 or 18.7% of total grade relevant children enrolled public
– enrolled in private school
… 810 or 3.9% of total grade relevant children enrolled private (very low)
– not enrolled
… 3,265 or 30.9% of total grade relevant children not enrolled (very high)

How does Houston ISD compare to Dallas ISD? … to Los Angeles Unified? … use these data to find out. Whether ability to speak English, or other living/demographic environmental characteristics, these are among the factors that can primarily influence educational outcomes.

Comparing the Number of Households
The total number of households compared to the number of households with grade relevant children is often in the range of 3-to-4 to 1. The following table shows illustrative examples for selected districts.

Scope of the School District Special Tabulation
The School District Special Tabulation is a tabulation of the characteristics of children who reside within the boundaries of a school district. Note that such residents/children might attend a school located outside of the school district of residence. Subject matter items are tabulated for these seven universes:
• all children — population ages 0-19, 18 & 19 not high school graduates
• all school age, grade relevant children
– children enrolled
– children enrolled in public school
– children enrolled in private school
– relevant children not enrolled
See about related data

Children’s Demographics by Type of Enrollment
  — Interactive Table
The following graphic illustrates use of the interactive table to rank districts by total relevant children and views percentage distributions by type of enrollment. Note that among the largest 10 districts, Las Vegas (Clark County, NV) has the largest percent not enrolled (12.x% — far right column). Use the full interactive table to compare contrast district based on your criteria.

– click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn

Mapping Statistical Data Updates

.. statistical mapping & visual data analysis … ready-to-use GIS projects/datasets … Geographic Information Systems (GIS) provide flexible and powerful capabilities to combine maps with data. In our increasingly data rich environment, we often experience “drowning in data.” GIS tools can help harness disparate and voluminous data and assist with data linkage. This section provides links to other sections that provide information on no cost GIS software and “production” GIS projects and datasets that you can use.

• Recent Additions
– Real Gross Domestic Product by State & Area – 06/23/16 – details
– Housing Price Index by Metro; 2015Q1-2016Q1 – 07/02/16 – details
– Housing Price Index by 5-Digit ZIP Code; 2010-2015; 07/02/16; details

Example: Mapping Median Housing Value by ZIP Code;  Los Angeles Area
Make this type of view/map for any area. Click graphic for larger view. Larger view illustrates use of identify/select tool to show mini profile for a selected ZIP code (see at pointer). Expand browser window for best quality view. Using GIS resources described here.


View developed with CV XE GIS software.

Related Topics in Mapping Statistical Data section …
• K-12 Curriculum Program
Data Analytics & Mapping Statistical Data in the Classroom

• GIS Projects/Datasets/Applications
World by Country
U.S. by State
U.S. by Congressional District
State Legislative Districts
U.S. by Metropolitan Area
U.S. by County
U.S. by City/Place
U.S. by ZIP Code Area
State by Census Tract (each/all states)
State by Block Group
State by Census Block
K-12 Schools & School Districts
K-12 Schools & School District Data Analytics

Join in … participate in the weekly Data Analytics Lab sessions to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

K-12 School System Revenue & Expenditure Patterns

.. while we might first associate K-12 school systems with children and education, they are also an important part of the economy .. jobs, businesses and more. Total expenditure by public school systems, mostly school districts, was $613.6 billion in fiscal year 2014, up 2.6 percent from 2013. These data are based on the latest survey of public school systems conducted by the Census Bureau and sponsored by the U.S. Department of Education. This section provides an overview of these data and tools to access and view/analyze the data. See related full Web section for data access and more details.

Current Spending per Student by School District, FY 2014
… Houston metro area .. click graphic for larger view.

  … view developed using the CV XE GIS software.


.. click graphic to view all states table

Using the Interactive Table
Use the interactive table in the related Web section to examine sources and uses of funds in school districts of interest. The following graphic illustrates use of the table to view selected characteristics (select from many other items) of districts in the Houston metro. Districts are ranked on percent total revenue received from Federal sources. Click graphics for larger view.

Create Analytical Profiles for Districts of Interest
Follow steps in this related section to create analytical profiles for selected districts.

Illustrative comparative analysis profile for two districts
.. graphic shows partial view .. open full xls profile

Join me in a Data Analytics Lab session to discuss more details about accessing these data and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

State and Regional Decision-Making Information

Organized on a state-by-state basis, use tools and geographic, demographic and economic data resources in these sections to facilitate planning and analysis. Updated frequently, these sections provide a unique means to access to multi-sourced data to develop insights into patterns, characteristics and trends on wide-ranging issues. Bookmark the related main Web page; keep up-to-date.

Using these Resources
Knowing “where we are” and “how things have changed” are key factors in knowing about the where, when and how of future change — and how that change might impact you. There are many sources of this knowledge. Often the required data do not knit together in an ideal manner. Key data are available for different types of geography, become available at different points in time and are often not the perfect subject matter. These sections provide access to relevant data and a means to consume the data more effectively than might otherwise be possible. Use these data, tools and resources in combination with other data to perform wide-ranging data analytics. See examples.

Select a State/Area

Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
D.C.
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming

Topics for each State — with drill-down to census block
Visual pattern analysis tools … using GIS resources
Digital Map Database
Situation & Outlook
Metropolitan Areas
Congressional Districts
Counties
Cities/Places
Census Tracts
ZIP Code Areas
K-12 Education, Schools & School Districts
Block Groups
Census Blocks

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Tip of the Day – Median Household Income by School District

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur. Options and tools for accessing and using median household income by school district are outlined below.

Richmond & Henrico County, VA School Districts
  – patterns of median household income by census tract; an illustration.
  – often drill-down geography, like census tracts, is needed.
  – click graphic for larger view.
.. view developed with ProximityOne CV XE GIS and related GIS project.

Accessing/Using Median Household Income by School District
.. the most recent estimate of median household income for school districts is as of 2014. These data are based on the American Community Survey (ACS2014) 5-year and 1-year estimates. See details about other years and longitudinal data below in this section. The subject matter “median household income” is used here but other wide-ranging subject matter can be accessed/analyzed using options described below.

Number and Type of Schools Districts — ACS 2014 tabulation areas
– 2013-2014 school year; as of January 1, 2014

Geographic Areas 1-year estimates 5-year estimates
population of 65,000+ all areas
School District (Elementary) 74 2,181
School District (Secondary) 88 538
School District (Unified) 842 10,923
Total 1,004 13,012

Option 1. Use the interactive table:
– go to http://proximityone.com/sd14dp3.htm (5-year estimates)
– median household income is item E086.
– scroll left on the table until E086 appears in the header column
– this column shows the data for E086 for all school districts
– see usage notes below table.

Option 2. Use the API operation:
– 5-year estimates for unified school districts in Arizona …
– median houshold income (MHI) is item B19013_001E.
click this link to get B19013_001E (MHI) using the API tool.
.. this API must be used on a state-by-state basis.
.. the state FIPS code must be the last two characters in the URL.
– a new page displays showing a line/row for each school district.
– MHI appears on the left, then school district name and then codes.
– optionally save this file and import the data into a preferred program.
– more about API tools.
– more about using 1-year and 5-year estimates.

Option 3. View the median household income in context of other attributes for a school district.
click this link to select a school district of interest.
– click link to view school district report (request a district).
– when report displays, scroll down in table to the household income section.

See the related section on school district community.

This section is focused on median household income and school districts. Many other subject matter items will be apparent when these methods are used. Optionally adjust above details to view different subject matter for school districts.

Data for Other Years & Longitudinal Data
Annual data for median household income by school district are available from the American Community Survey as summarized below.

ACS Year School Year Boundary as of:
2009 2008-2009 January 1, 2008
2010 2009-2010 January 1, 2010
2011 2009-2010 January 1, 2010
2012 2011-2012 January 1, 2012
2013 2011-2012 January 1, 2012
2014 2013-2014 January 1, 2014

Join me in a Data Analytics Lab session to discuss more details about accessing and using children’s demographics, schools and school districts data and data analytics . Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.