Tag Archives: Children

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.

Children in Households by Neighborhood

Between 1970 and 2012, the share of households that were married couples with children under 18 decreased from 40 percent to 20 percent. During this period, the average number of people per household declined from 3.1 to 2.6
(details). These trends vary by state and region. Patterns vary widely at the neighborhood level. What are the characteristics and patterns of households with children under 18 at the neighborhood level?

This section illustrates use of CV XE GIS with associated GIS project to examine patterns of children in households by age by block group. Data are based on Census 2010 Summary File 1 Table 32 as shown in the table presented below in this section. See more about the GIS project. See related Web section for more details.

San Francisco Area
  — Patterns of Children in Households by Block Group
Block groups with 400 or more children in households (item P0320001) appear blue. Block groups with 100-300 children in households appear with green fill pattern.

Click graphic for larger view

San Francisco Zoom-In
  — Patterns of Children in Households by Block Group
Block groups with 400 or more children in households (item P0320001) appear blue. Block groups with 100-300 children in households appear with green fill pattern.

Click graphic for larger view

San Francisco Zoom-In
  — Patterns of Children in Households, ages 6-17, by Block Group
Illustrating different colors, different ranges, population by age; other ages could be used. Block groups with 300 or more children in households (items p0320009 – p0320012 summed) appear red. Block groups with 100-300 children in households appear with orange fill pattern.

Click graphic for larger view

Cupertino Area Zoom-In
  — Patterns of Children in Households, ages 6-17, by Block Group
Illustrating further zoom-in, street detail, labels showing total population under 18 years; could be other item as label.
Block groups with 300 or more children in households (items P0320009 – P0320012 summed) appear red. Block groups with 100-300 children in households appear with orange fill pattern.

Click graphic for larger view — larger view use of identify tool to profile a selected block group.

Examining Study Areas Using Site Analysis Tool
Above view in site analysis mode; selecting three block groups as a study area using SiteAnalysis API tool. See summary profile in lower right section/table; export to HTML or XLS file. Use mouse to cherry pick areas to add and/or use circular area selection.

Click graphic for larger view.

Viewing Selected Records in Tabular Form
After selecting areas (block groups in this example) that comprise a study area, click the View File in the lower right panel above the grid. The dBrowse feature is started; the selected records dataset can be opened and used. The $$siterecs.dbf is overwritten with each new site selection. It can be optionally be saved to a CSV, TXT or dBase file for later use; possibly merger/comparison with other study area selections.

Click graphic for larger view.

GIS Project
The GIS project used to develop views shown in this section is focused on the state of California by block group. It can be used to examine patterns similar to those shown here for any area in California. A similar project could be developed for a specific county, another state or the U.S.

Data from Census 2010 SF1 Table P32 (see item list below) were merged into the California block group shapefile. Many of the items available in Table P32 were not used in the map views shown here but could be used to develop alternative views; e.g., specific age patterns or percentages.

A GIS project is itself a file that knits together a set of layers that have certain settings. In the GIS project used here, the layers mainly reflect attributes of a corresponding shapefile (U.S. by state, U.S. by county and California by block group).

Children in Households; Census 2010 Summary File 1; Table P32
Universe: Population under 18 years
P0320001   Total
P0320002     In households
P0320003       Householder or spouse
P0320004       Related child:
P0320005         Own child:
P0320006           Under 3 years
P0320007           3 and 4 years
P0320008           5 years
P0320009           6 to 11 years
P0320010           12 and 13 years
P0320011           14 years
P0320012           15 to 17 years
See full table item list in related Web section.

About Households
A household contains one or more people. Everyone living in a housing unit makes up a household. One of the people who owns or rents the residence is designated as the householder. For the purposes of examining family and household composition, two types of households are defined: family and nonfamily.

A family household has at least two members related by birth, marriage, or adoption, one of whom is the householder. A nonfamily household can be either a person living alone or a householder who shares the housing unit only with nonrelatives; for example, boarders or roommates. The nonrelatives of the householder may be related to each other.

Family households are maintained by married couples or by a man or woman living with other relatives. Children may or may not be present. Nonfamily households are maintained only by men or women with no relatives at home.

Own children are a subset of all children; they are the biological, step, or adopted child of the householder or family reference person (in the case of subfamilies) for the universe being considered, whether household, family, or family group. Own children are also limited to children who have never been married, are under the age of 18 (unless otherwise specified), and are not themselves a family reference person. Foster children are not included as own children since they are not related to the householder.

Support & DMI Web Sessions
Learn more about using resources described in this section. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants. We can address your specific questions about tools to analyze patterns of children’s demographics.