K-12 Data Analytics: Dallas ISD, Texas

.. using tools and data analytics methods for analysis of K-12 schools located in Dallas ISD school district, Texas .. use the interactive table in related section to examine demographic-economic characteristics of Dallas County by block group. Apply these tools and methods to your schools, school districts and related areas of interest. Contact me for details. Tools and methods described here can help leadership, staff and stakeholders answer key questions and facilitate strategic planning. See the related main Web section for more details and tools access.

Examining the Current Situation
While most schools and school districts know a lot about the students, often less is known about children’s living environment and the broader school district community. See the demographic-economic profile for Dallas ISD total population (compare to Dallas city). These profiles tell a story. It helps stakeholders know “where we are now.”

Use the annually updated School District Special Tabulation that provides similar data but for the grade relevant school age population by type of enrollment universe. See Dallas ISD Children’s Demographic-Economic Profile by Universe of Enrollment.

Dallas ISD School District in Context
Dallas ISD (bold brown boundary) shown in regional context.

  — view created using CV XE GIS and associated GIS Project

School Locations in Context
Zoom-in to Dallas ISD. Pointer at county boundary; Dallas ISD is located in Dallas County. Schools are shown by different types of markers. See markers/style in legend at left. Using the query feature, it is possible to identify charter schools as one type of marker, irrespective of grade range.

Use the national scope interactive tables to examine characteristics of individual public schools and individual private schools. Rank, query, compare and contrast schools within a state or on a national basis.


  — view created using CV XE GIS and associated GIS Project

Zoom-in View of Schools; School Characteristics
Further zoom-in shows schools labeled with name.  The identify tool is used to show a mini-profile of a school by clicking on the Edna Rowe school marker.
The partial view of the profile shows free and reduced lunch participation and enrollment by grade.

  — view created using CV XE GIS and associated GIS Project

School Attendance Zones
Elementary school attendance (black boundaries) are shown in the next graphic. Dallas ISD has three types of attendance zones (elementary, middle, high school). The query feature is used to show only elementary zones. Click graphic for larger view showing more detail.

  — view created using CV XE GIS and associated GIS Project

Cities/Places & School District
Cities/places are shown in the next graphic (cross-hatch pattern) in context with the school district. Places are non-incorporated areas of population concentration. Click graphic for larger view showing more detail; adjacent city/places shown with yellow diagonal cross-hatch pattern.


  — view created using CV XE GIS and associated GIS Project

Road Infrastructure
Roads/streets are added to the view as shown in the next graphic. Vital to student transportation planning and management, the street density view also helps view the scope of build-out. Click graphic for larger view showing more detail; mini-profile shows attributes of street segment by school/pointer.

  — view created using CV XE GIS and associated GIS Project

Schools in Context of Urban/Rural Geography
Census blocks are categorized as urban or rural based on Census 2010. The graphic below shows urban census blocks with an orange fill pattern. It is easy see that most of Dallas ISD is urban; but a large area in the southeast part of the district is rural. See related K-12 Schools by Urban/Rural Status
.

  — view created using CV XE GIS and associated GIS Project

Percent Population in Poverty by Census Tract
Census tracts are statistically defined geographic areas covering the U.S. wall-to-wall (73,057 areas). The view below shows patterns of percent population in poverty by census tract. Click on graphic to view larger view. Choose from hundreds of demographic-economic measures to assess patterns of well-being, age distribution, housing structure and age, educational attainment, housing value, race/origin, employment, language spoken at home among many others.

  — view created using CV XE GIS and associated GIS Project

See zoom-in view of Edna Rowe school vicinity with tract and %poverty labels

Patterns of Economic Prosperity by Block Group
Block groups are statistically defined geographic areas covering the U.S. wall-to-wall (217,740 areas) and nest within census tracts (see above). Block groups (BGs) provide a finer geographic granularity compared to census tracts. The view below shows patterns of economic prosperity as measured by the median household income (MHI). MHI interval/color patterns are shown in the highlighted layer at left of the map. Click on graphic to view larger version that uses the MHI as a label for each BG. Choose from hundreds of demographic-economic measures to assess patterns of well-being. This view illustrates use of transparency setting to “see through” the pattern layer to view the topology/road infrastructure.


  — view created using CV XE GIS and associated GIS Project

Dallas County Block Group Demographic-Economic Characteristics
Use the interactive table to view, rank compare Dallas County block group demographic-economic characteristics. See about Dallas County demographic trends. All block groups for the county are included in the table. Optionally key in an address using the location-based demographics tool to determine the block group code of interest. You can then use the Find button below the table to locate that block group. See about using block group codes — a 12 character code uniquely identifying that area.

Block Groups in Vicinity of School — Interactive Table
The graphic below illustrates use is the Dallas County block group interactive table. Block groups in census tract “48113012206” are shown in the table. This tract was selected as it contains the Edna Rowe school (location used above in maps). The school’s address was used in the location-based lookup tool. Do this for any school or address in Dallas County. It is easy to see that the Gini Index is low indicating high degree of income equality. It is easy to see and compare the number and type of housing units, median income, housing values, and rent. Try this process yourself:
1 – enter an address using this tool to obtain a census tract code see this example.
2 – below the interactive table click ShowAll button, enter your 11 character tract code, click Find.
All block groups in this tract will show as rows in the table.

Data Analytics Lab Session
Join me in a Data Analytics Lab session. There is no fee. Discuss how tools and methods reviewed in this section can be applied to your situation.

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s