Tag Archives: school districts

Creating Custom School District Maps

…tools & data to map & geospatially analyze school districts. Ready-to-use state-by-state GIS projects may be downloaded enabling you to view and create custom maps almost instantly. Benefit from the power of using GIS software to perform tasks not available on Web-based mapping options. Use the latest school district and related shapefiles. See more information about using these resources in this related Web section.

Federal Revenue per Student by School District
Create views similar to the one shown below. Optionally combine layers as illstrated here by showing four Texas metros.

.. view developed with CV XE GIS and related GIS project.

Extending Reference and Analytical Possibilities

Texas by School District
Examine reference maps at the state, regional or local level. Optionally combine with roads/streets and other layers.

Patterns of Economic Prosperity by School District
Select from many ready-to-use demographic-economic subject matter items to create custom pattern views.

Drill-down — Houston Metro Area by School District
Zoom-in to a school district of interest. Set attributes of district as shown here.

County/School District
Visually examine the boundaries or school districts and counties. This view shows Harris County, TX area; select a county of interest.

Drill-down to Street Level
Add road/street and other layers. Drill-down within Fort Bend ISD, Houston metro, showing general earth surface features with streets layers. Mouse used to click on street (see pointer) and display mini-profile of street segment attributes.

Use for Analysis, Reference or in the Classroom
Schools and teachers: consider using these resources for classroom use. Familiarize students about how GIS resources can be used with a minimum of learning time and no cost. Enable students to use their own geography and adapt that learning to more general geography. See related Mapping Statistical Data ready-to-use GIS projects.

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.

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.

School District Demographic Trends: 2010-2015

.. data and tools to examine how school districts of interest are changing … based on total population, the largest 10 school districts in 2015, all experienced an increase in total population over the period 2010-2015. Five of these districts had a decrease in school age population (ages 5-17 years). Four of these districts had a decrease in the number of related children in families ages 5-17 years. See characteristics of districts in this interactive table. See the related Web section for more details.

School Districts with 2015 Population 100,000 or More
More than 600 of the total 13,245 school districts have a total 2015 population of 100,000 or more (red markers).

– view developed with CVGIS software and related GIS project.

Using New 2015 Estimates Released December 2016
– for use in 2017 ESEA Title I Allocations
Analyze annual demographic data for each U.S. school district for the period 2010 through 2015. These data include the Federal official 2015 estimates available for all districts. Developed for use as inputs for the ESEA Title I allocation formula, the data have broader uses of interest to school district demographics stakeholders. Use the interactive table in this section to view, rank, compare, query demographic characteristics of districts of interest.

The annual estimates for each school district include:
• total population
• number of children ages 5 to 17
• number of related children ages 5 to 17 in families in poverty

Using Interactive Data Tools
Use the interactive table to view, rank, compare, query ZIP codes based on a selection of demographic measures. The following graphics illustrate how the table can be used. Click graphic for larger view.

Total Population — 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

School Age Population — 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

Related Children Ages 5-17 in Poverty
– 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

Try it yourself. Use the table to examine a set of districts on your selected criteria in for a state/area of interest.

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.

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.

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.

Local Education Agencies by Type & State

.. the number and structure of school districts by state varies widely. Does this have an impact on educational outcomes and opportunities from state to state? In 1952, Texas had approximately 2,500 school districts (see in related section; today there are 1,027 school districts in Texas (see full table). School districts are now part of a more broadly structured set of Local Education Agencies (LEAs) which include state, regional and independent charter agencies offering elementary/secondary education. This section provides data on the count and type of LEAs by state for the 2014-15 school year.

Use the interactive table to view, rank, compare school districts/LEAs by state by type for the 2014-15 school year. These summary data are based on our processing of individual LEA data provided by individual state education agencies. Additional detail by LEA will be available later in 2016.

2014-15 LEAs by State
States labeled with total LEAs as of the 2014-15 school year. Click graphic for larger, more detailed view. Expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

2014-15 Independent Charter Agencies by State
States labeled with Independent Charter Agency (ICA) LEAs as of the 2014-15 school year (3,056). States with no ICAs not labeled. Red markers show locations of all ICAs. Click graphic for larger, more detailed view. Expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

Additional views – click to view graphic; expand browser window for best quality view:
Houston area zoom-in showing ICAs with name as label
Houston area zoom-in showing charter schools (green markers)
– black boundary shows Houston ISD school district
– yellow label: total enrollment; white label: total free & reduced lunch fee

Kansas City area zoom-in showing ICAs with name as label
– black boundary shows Kansas City, MO school district
Kansas City area zoom-in showing charter schools (green markers)
– black boundary shows Kansas City, MO school district
– yellow label: total enrollment; white label: total free & reduced lunch fee

Related School District Data
See about related demographic-economic datasets, interactive tables & GIS resources: General Demographics .. Social Characteristics .. Economic Characteristics .. Housing Characteristics

States Ranked by Total LEAs
The following graphic shows states ranked by total LEAs using the interactive table — the 10 states having the largest number of LEAs. Click graphic for larger view.

Join me in a Data Analytics Lab session to discuss more details about analyzing LEA characteristics and pattern and use of data analytics to develop further detail related to your interests.

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.

K-12 Schools Data Analytics

.. resources to analyze patterns and trends .. how to improve K-12 education opportunities and outcomes? How might the K-12 improvements impact your community? Higher education? What resources and methods can be used to better understand where we are … and where we are going? How can we use data to better understand patterns, where and how change will occur … and how change will impact us? Have we got the best/right data to answer the right questions? Data Analytics can help K-12 schools, school districts, leadership and stakeholders answer these questions and better achieve visions and goals.

This section provides illustrative data analytics views and application examples using a K-12 school district Geographic Information System (GIS) project and related datasets. The McKinney ISD, TX school district, located in the Dallas metro area, is used. A similar data analytics project/fileset can be developed for any school district. The applications use the ProximityOne CV XE GIS software. Most of the files and layers used in the GIS project are described here. Statewide GIS base K-12/community projects/datasets are available for many states; seeMissouri

The ProximityOne Data Analytics team develops the GIS project and related datasets. The software and data are electronically installed on the school/school district/community computers. Knowledge of how to develop the datasets and GIS project are not required by school/school district staff. Specialized staff are not required to operate the software, use the GIS tools and data or perform data analytics applications. Having staff available with these skill sets can extend productivity and results from use of the resources.

McKinney ISD in Context of Counties/Region
McKinney ISD shown with bold black boundary. McKinney city shown as hatched area. Urban census blocks: orange fill pattern; understanding urban/rural status of geography important for many reasons. See more about K-12 schools and urban/rural geography.

  — view created using CV XE GIS and associated LAES GIS Project
— click graphic for larger showing details.

Zoom-in View of McKinney ISD & K-12 Schools
See school by type/level in legend at left of map. View, compare, query, rank K-12 schools of interest using this interactive table. Extensive school level data are integrated and accessible but not shown in these views.

  — click graphic for larger showing details.

Students Shown by Red Markers
Student markers/locations are added to the GIS project by first geocoding the student address data. A shapefile is created and added to the GIS project. Extensive student level data (demographic, performance, other) are integrated and accessible but not shown in these views. Optionally place a query on the students layer to view/analyze those meeting a certain condition such as attending a specific school, enrolled in a certain grade/grade range, having specified test results, etc.

  — click graphic for larger showing details.

Elementary School Zones
See ES Zone layer (blue boundary) at left in legend panel; choose any/all zones. School zone boundaries can facilitate analysis of students attending associated school. The GIS project can facilitate analysis of alternative redistricting plans and enrollment distributions change.

  — click graphic for larger showing details.

Further Zoom-in View
ES Zones labeled with ES Zone name; census block layer turned off (unchecked). The ability to easily navigate across geography or add detail can create visual pattern analysis not possible using tabular data.

  — click graphic for larger showing details.

Using Site Analysis; Focus on Walker ES Zone
Using the Site Analysis operation, a query placed on student layer so only students attending this school are shown (red markers). The CV XE Site Analysis tool used to select a small group of students (cross-hatched in circle). See summary in grid at right; total students 51; 5 students are Hispanic. In the grid, the total number of students is shown with the name “Weight” — the field name of the database item used to dynamically total/sum/count the number of students. In this example, the value of the weight field is always 1 (thus when summed it shows the total number of students). The field could be set to values varying by individual student for a measure such as performance or participation.

  — click graphic for larger showing details.

Using Site Analysis; Focus on Walker ES Zone
Counting all students enrolled in Walker ES; 532 students; 69 Hispanic.

  — click graphic for larger showing details.

Using Site Analysis; Focus on Walker ES Zone; Further Zoom-in 
This view shows all students; note some are not selected as they are residents of Walker ES zone but do not attend that school. Census block layer has been checked on; census blocks are labeled with Census 2010 population.

  — click graphic for larger showing details.

Thematic Pattern Map; Gini Coefficient by Block Group; McKinney ISD Region
Patterns of income inequality as shown by Gini Coefficient by census block group. Block groups are the smallest geography for which richer demographic-economic data are available (from ACS). See more about Gini Coefficient and Income Inequality.

  — click graphic for larger showing legend details.

Patterns of Economic Prosperity by Census Tract
View shows Median Household Income by census tract. Approximately 74,000 census tracts, averaging 4,000 population, cover the U.S. wall-to-wall. The graphic shown below illustrates integrating census tract/neighborhood level demographic-economic data from American Community Survey with attributes of students, schools and other geography.

  — click graphic for larger showing legend details.

Examining Demographic-Economic Characteristics for a Study Area — Study Area Part 1
The view below shows use of the Site Analysis tool to select a set of 5 census tracts in the vicinity of McKinney Boyd HS (blue triangle marker). Any number of tracts can be selected, contiguous or otherwise. The subject matter items to be summarized are D001_13 (total population), D002_13 (male) and D002_13 (female) — ACS 2013 5-year estimates. More or different items could have been selected. The grid at lower right shows aggregated (across 5 tract) values for these three items.

  — click graphic for larger showing legend details.

Database Operations — Export/View Tract Dataset for Study Area — Study Area Part 2
The view below shows the tracts dataset records in a CV XE grid/spreadsheet based on the above Site Analysis operation. This dataset extract is generated, and grid populated, when the View File button is clicked in the Site Analysis operation (see in Part 1 graphic at right). This grid displays the records selected in the above operation. These selected data records can optionally be exported for use with other software.

  — click graphic for larger showing legend details.

Demographic-Economic Profiles for Study Area — Study Area Part 3
Summary demographic-economic profiles are generated for the above 5 census tract study area by clicking the Report button in the Site Analysis operation (see Part 1 graphic at right).
View the McKinney Boyd HS Area 1 Analysis Reports/HTML profiles generated:
General Demographics (DEP1)more about these data; interactive table
Social Characteristics (DEP2)more about these data; interactive table
Economic Characteristics (DEP3)more about these data; interactive table
Housing Characteristics (DEP4)more about these data; interactive table

Patterns of Percent Children in Poverty by School District
The graphic shown below illustrates using visual analysis tools to compare/contrast school district characteristics in region/state. View, compare, query, rank school districts of interest using this interactive table. Data used in the graphic shown below are derived from the from ACS 2013 5-year estimates.

  — click graphic for larger showing legend details.

Children’s Demographics & Living Environment
Most demographic-economic data are developed for the whole population in an area. Data from the annually updatedACS School District Tabulation can help analysts and leadership better understand demographic-economic characteristics of children, and gain insights into needs, in a school district. See the McKinney ISD Children’s Demographic-Economic Profile by Universe of Enrollment.

Predictive Analytics; Demographic-Economic Projections
ProximityOne develops demographic-economic estimates and projections for individual school districts and component area geography such as census tracts. These data help schools and school districts examine how enrollment and the population in the district might change over the next several years. Projections are developed in several ways: by single year of age by gender by race/origin, by type of enrollment (public school, private school, not enrolled), and by demographic-economic characteristics.

Roads & the Digital Map Database
The street/road network used in the GIS project is from an augmented version of the TIGER digital map database. Each street/road segment runs from intersection to intersection creating opportunities for routing and transportation management. The CV XE GIS identify tool is used to click-on a street segment (see pointer). A mini-profile for this segment is displayed as shown in the graphic. The mini-profile shows that this is the 5500 block of Petunia Dr.

  — click graphic for larger showing legend details.

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.