Spreadsheets (You are not logged in)

The following spreadsheets reflect some of the major data tabulations and analyses reported in past issues of OPPORTUNITY. To save newsletter space, they are made available here. If these spreadsheets are used, please cite this website as the source: www.postsecondary.org The [XLS] links are password protected for our current Subscribers. If you are not a Subscriber you can initiate a Subscription now

Remember me

Page: next 
1 2 3 4 
Sort by: Title , Date

State, Local and Federal Fiscal Support for Higher Education per $1000 of State Personal Income, FY1961 to FY2014
This large Excel spreadsheet combines the Grapevine data from Illinois State University on state tax fund appropriations for higher education, with state personal income data published by the Bureau of Economic Analysis.Data are reported for each state for each fiscal year from 1961 through 2014. These data illustrate the ebb and flow of state investment in higher education over the last three decades. 2/18/2014

Dependent Pell Grant Recipients by Institutional Control, Level and State, FY2003 to FY2013 12/18/2013

College Participation Rates for Students from Low Income Families by State, FY1993 to FY2012
This Excel workbook contains state and national data used to calculate college participation rates for students from low income families for the years FY1993 to FY2012. This rate is the ratio of dependent Pell Grant Recipients divided by 4th to 9th graders nine years earlier, approved for free or reduced-price school lunches.
The data for each state includes: dependent Pell Grant recipients by state of residence, 4th to 9th grade enrollments in public schools, the percent of children approved for subsidized school lunches, the number of 4th to 9th graders in these low income families, and their rate of enrollment in college nine years later. These data show the number of children in these low income families in the K-12 pipeline headed toward higher education in each state. 9/6/2013

"I worked my way through college. You should too."
This Excel workbook illustrates the data calculations used to show the number of hours a student would have to work to finance his or her college education through earnings from employment. The time period shown is 1964-65 through 2008-09. 
The institutional types for which these calculations are made are public universities, public 4-year colleges, community colleges, private universities, private 4-year colleges and private 2-year colleges. 8/30/2013

Labor Force Status of Persons 16-24 Years Old by School Enrollment, Education, Race & Hispanic Origin, 1970 to 2012
The data in this Excel workbook comes from the Bureau of Labor Statistics. These spreadsheets contain information on the labor force status of people age 16 to 24. The data is broken down by school enrollment, type and control of school, gender, and race/ethnicity.

State Need-Based Grant Coverage of Pell Grant Recipients, 1978-79 to 2011-12 7/26/2013

Pell Grant Recipient Data by State, 1976-77 to 2010-11
This large Excel workbook contains Pell Grant recipient data by state, by institutional control, and by year, 1976-77 to 2010-11.
The data are compiled from annual Pell Grant End of Year reports prepared by the U.S. Department of Education. The recipient data included both the numbers of Pell Grant recipients and the Pell Grant dollars they received for each academic year. The Pell Grant recipient data are classified in two ways: first by location of institution, then by state of residence of the recipients. The difference between these two is net migration of Pell Grant recipients and dollars into or out of each state. 5/25/2013

Current Fund Expenditures of Public & Private Higher Education as a Percentage of Gross State Product by State, FY1977 to FY2011
This Excel workbook summarizes by state available current fund expenditures data for public, private and proprietary higher education institutions from FY1977 through FY2011
These sector data are also expressed as a share of Gross State Product in each state, and these shares are ranked against all other states.  Current funds expenditure data for private institutions was redefined in FY1997 and thus is not strictly comparable to prior years' data.  5/25/2013

National School Lunch Program, State-Level Data, FFY1989 - FFY2012
These data provide annual, state-level data on participation by K-12 students in the the U.S. Department of Agriculture's National School Lunch Program.
School children approved for free lunches come from the lowest family income levels, and those approved for reduced price lunches come from somewhat high but sill low income families.These data are useful when measuring the number of children from low income families enrolled in K-12 education, and headed for higher education in each state. The data used in these tables were prepared by Jeffrey Derr and Anne Pauls, Child Nutrition Division, Food and Nutrition Service, U.S. Department of Agriculture. 5/25/2013

Dependent and Independent Pell Grant Recipients by Institutional Type/Control and State, 1993-94 to 2010-11 5/25/2013

Degrees Conferred by Level of Degree, Gender and State 1970 to 2011 5/25/2013

Interstate Net Migration of Bachelor's Degree Holders, 1989 to 2012
This is a stock & flow analysis of annual changes in the number of Bachelor Degree Holders in the state between 1989 and 2012 5/25/2013

Pell Grant Recipients as a Percentage of Pell-Eligible Undergraduate Enrollment
 by Institutional Type/Control and State, 1993-94 to 2010-11 4/1/2013

Educational Attainment by State, 1977 to 2012
This Excel workbook summarizes data collected and reported by the Census Bureau on the number and proportion of each state's population age 25 and over that is at least a high school graduate and that has at least a Bachelor's degree from college.
The data from 1977 through 1987 are for the 15 largest states only. Beginning in 1989 data was reported for all 50 states plus the District of Columbia. 3/31/2013

Poverty Rates by State, 1980-2011 3/31/2013

Gini Coefficients for Household and Family Income by State -
1969, 1979, 1989, 1999 and 2006-2011 3/30/2013

Median Family Income by State & Median Household Income by State, 1959 to 2011 3/30/2013

Public High School Graduation Rates by State, 1981 to 2010
This Excel workbook compiles historical data by state on the cohort survival rates of public school ninth graders through regular high school graduation.
These data are reported by states to the National Center for Education Statistics, and from these reports the cohort survival rates are calculated for each state and each state is ranked by the resulting high school graduation rate. 3/30/2013

Chance for College by Age 19 by State, 1986 to 2010
This Excel workbook contains the data used to calculate the proportion of each state's 19 years olds who will be enrolled in college somewhere in the United States in the fall following high school graduation.
Data are available for the years 1986, 1988, 1992, 1994, 1996, 1998, 2000, 2002, 2004, 2006, 2008 and 2010. The public high school graduation rate, the college continuation rate, and their combination - chance for college by age 19 - are shown for each state and year. 2/14/2013

Income by Educational Attainment for Families and People, 1956 to 2011
These are data on mean and median income by educational attainment of families and people collected and reported by the Census Bureau in the P60 reports of Current Population reports.
These data are shown in current and constant dollars. Note the inclusive definition of income used by the Census Bureau on the Notes worksheet.  12/31/2012