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

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

Degrees Conferred by Level of Degree, Gender and State, 1970 to 2012 5/20/2014

Current Fund Expenditures of Public and Private Higher Education as a Percentage of Gross State Product by State, FY1977 to FY2012
This Excel workbook summarizes by state available current fund expenditures data for public, private and proprietary higher education institutions from FY1977 through FY2012.
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/7/2014

Interstate Migration Patterns of College Freshman, 1996 to 2012
This new spreadsheet was prepared to clarify and simplify understanding of freshman interstate migration in each state. This is a true zero-sum game:some states attract more freshmen than they export.
Other states lose more freshmen to other states than they attract. These migration data imply important information about the attractiveness, or lack thereof, of state higher education opportunities. 5/1/2014

Pell Grant Recipients as a Percentage of Pell-Eligible Undergraduate Enrollment by Institutional Type/Control and State, 1993-94 to 2011-12 4/29/2014

Residence and Migration of College Freshmen Graduating from High School in the Past 12 Months, 1996 to 2012
These data are for the fall terms of 1996, 1998, 2000, 2002, 2004, 2006, 2008, 2010 and 2012. This data was collected in the fall IPEDS enrollment surveys by the National Center for Education Statistics. These data are used to study the interstate migration of college freshmen. 4/29/2014

Dependent and Independent Pell Grant Recipients by Institutional Type/Control and State, 1993-94 to 2011-12 4/25/2014

Pell Grant Recipient Data by State, 1976-77 to 2011-12
This large Excel workbook contains Pell Grant recipient data by state, by institutional control, and by year, 1976-77 to 2011-12.
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. 4/23/2014

Poverty Rates by State, 1980-2012 4/8/2014

Agricultural Employment, 1990-2012 4/1/2014

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

Unemployment Rates by State, 1976-2012 2/11/2014

Gini Coefficients for Household and Family Income by State, 1969, 1979, 1989, 1999 and 2006-2012 1/30/2014

Median Family Income by State and Median Household Income by State, 1959 to 2012 1/29/2014

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

Educational Attainment by State, 1977 to 2013
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. 10/3/2013

Per Capita Personal Income for U.S., States and Regions, 1929 to 2012
These data have been compiled and reported by the Bureau of Economic Analysis. 
We have organized these data to describe changes in state and regional per capita personal income compared to U.S. per capita personal income.The comparisons are time series and are of three types: states (or regions) as a percent of U.S., states (or regions) in CPI adjusted constant dollars, and state ranks year by year. 10/3/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

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.

"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