Situation & Outlook

School District Applications

Hide Navigation Pane

School District Applications

Previous topic Next topic No directory for this topic No expanding text in this topic  

School District Applications

Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Comments (...)

This section illustrates use of S&O Server to access Table B14001 (School Enrollment by Level of School for the Population 3 Years and Over) from ACS 2011 5 year estimates for Kansas school districts.

 

Are you using S&O Server?  Perform the types of operations described here on your computer.  See additional  information. Follow us on Twitter to get updates -- https://twitter.com/proximityone

 

See related Children's Demographics and School Districts section -- http://proximityone.com/sddmi.htm.

 

Examples here use school districts.  The same operations and data can be applied/used with, for example, all states, all counties in a state or the U.S., all cities/places in a state or the U.S., etc.

 

Table B14001 structure is shown below.  The table consists of 10 items.

B14001. School Enrollment by Level of School for the Population 3 Years and Over

   Universe: Population 3 years and over

 B14001_001E     Total:

 B14001_002E     Enrolled in school:

 B14001_003E     Enrolled in nursery school, preschool

 B14001_004E     Enrolled in kindergarten

 B14001_005E     Enrolled in grade 1 to grade 4

 B14001_006E     Enrolled in grade 5 to grade 8

 B14001_007E     Enrolled in grade 9 to grade 12

 B14001_008E     Enrolled in college, undergraduate years

 B14001_009E     Graduate or professional school

 B14001_010E     Not enrolled in school

 

This application illustrates use of the selection/specification of subject matter (all items in this table) by using a selection file (as opposed to multi-selecting from listbox).  The name of the selection file is "sel_acs_b14001.txt" and is included in the setup.  The selection file is shown below.

 

To run this application, follow these steps:

Select Dataset as ACS 2011

Select Geography Type as School Districts

Check Select by File checkbox.

Enter selection file full path and name

Select State -- Kansas

Click Go button

 

Grid populates as shown below.

The GeoID column contains the state FIPS code plus Federal school district code.

The TableID column contains the school district name.

Table item columns appear continuing to the right.

Note the column header B14001_001E (highlighted in graphic).  The column/item description is shown in the information panel above the grid.  B14001_001E is the total population 3 years and over.

 

What do we do with these data?

Options include:

direct use in research, planning, collaboration and related.

sort the data, sum the data etc. use/analyze the data with grid operations.

export the data to CSV or spreadsheet; link with other data.

create pivot/transposed views for side-by-side comparative analysis.

export the data into shapefile structure and develop thematic pattern maps.

 

 

In this example all items in the table were selected.  The selection could have been one item, selected items or a mix of items from this table and any other ACS 2011 table/item (not possible with FactFinder).

 

This application illustrates use of a simple, basic set of data on this topic.  Many other related, more detailed, tables are available.  See, for example Table B14002 shown below.

 

Selection file (sel_acs_b14001.txt)

B14001_001E     Total:

B14001_002E     Enrolled in school:

B14001_003E     Enrolled in nursery school, preschool

B14001_004E     Enrolled in kindergarten

B14001_005E     Enrolled in grade 1 to grade 4

B14001_006E     Enrolled in grade 5 to grade 8

B14001_007E     Enrolled in grade 9 to grade 12

B14001_008E     Enrolled in college, undergraduate years

B14001_009E     Graduate or professional school

B14001_010E     Not enrolled in school

 

More Detailed Table B14002

B14002. Sex by School Enrollment by Level of School by Type of School for the Population 3 Years and Over

   Universe: Population 3 years and over

 B14002_001E     Total:

 B14002_002E       Male:

 B14002_003E         Enrolled in school:

 B14002_004E         Enrolled in nursery school, preschool:

 B14002_005E           Public school

 B14002_006E           Private school

 B14002_007E         Enrolled in kindergarten:

 B14002_008E           Public school

 B14002_009E           Private school

 B14002_010E         Enrolled in grade 1 to grade 4:

 B14002_011E           Public school

 B14002_012E           Private school

 B14002_013E         Enrolled in grade 5 to grade 8:

 B14002_014E           Public school

 B14002_015E           Private school

 B14002_016E         Enrolled in grade 9 to grade 12:

 B14002_017E           Public school

 B14002_018E           Private school

 B14002_019E         Enrolled in college undergraduate years:

 B14002_020E           Public school

 B14002_021E           Private school

 B14002_022E         Enrolled in graduate or professional school:

 B14002_023E           Public school

 B14002_024E           Private school

 B14002_025E         Not enrolled in school

 B14002_026E      Female:

 B14002_027E         Enrolled in school:

 B14002_028E         Enrolled in nursery school, preschool:

 B14002_029E           Public school

 B14002_030E           Private school

 B14002_031E         Enrolled in kindergarten:

 B14002_032E           Public school

 B14002_033E           Private school

 B14002_034E         Enrolled in grade 1 to grade 4:

 B14002_035E           Public school

 B14002_036E           Private school

 B14002_037E         Enrolled in grade 5 to grade 8:

 B14002_038E           Public school

 B14002_039E           Private school

 B14002_040E         Enrolled in grade 9 to grade 12:

 B14002_041E           Public school

 B14002_042E           Private school

 B14002_043E         Enrolled in college undergraduate years:

 B14002_044E           Public school

 B14002_045E           Private school

 B14002_046E         Enrolled in graduate or professional school:

 B14002_047E           Public school

 B14002_048E           Private school

 B14002_049E         Not enrolled in school

Comments (...)