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

 
Username:
Password:
Remember me

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

Chance for College by Age 19 by State, 1986 to 2008
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 and 2008. 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. 9/2/2010

State Need-Based Grant Coverage of Pell Grant Recipients
1978-79 to 2008-09 8/4/2010

Degrees Conferred by Level of Degree, Gender and State 1970 to 2008 5/13/2010

Per Capita Personal Income for U.S., States and Regions, 1929 to 2009
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. 5/11/2010

Residence and Migration of College Freshmen Graduating from High School in the Past 12 Months
These data are for the fall terms of 1996, 1998, 2000, 2002, 2004, 2006 and 2008. 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. 5/11/2010

Agricultural Employment, 1990-2009 5/11/2010

Public High School Graduation Rates by State, 1981 to 2008
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. 5/11/2010

College Entrance & Participation Rates by Race/Ethnicity & Gender for Recent High School Graduates & Leavers, 1959 to 2009
This Excel workbook summarizes data published by the Bureau of Labor Statistics from the Current Population Survey 
on the transition from high school directly into college the following fall for men, women, whites, blacks, hispanics and other race population categories.These data are the first published each year on numbers of high school graduates and college freshmen. 5/11/2010

Higher Education's Share of Gross State Product by State, FY1977 to FY2007
This Excel workbook summarizes by state available current fund expenditures data for public, private and proprietary higher education institutions from FY1977 through FY2007.
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/11/2010

Tuition & Fees in Public Institutions by State & Year 1972-73 to 2009-10
This workbook contains data on tuition and fees in public institutions by state and year for flagship universities, state universities and community colleges.
The data contained in this report were compiled using Washington Higher Education Coordinating Board surveys of state agencies or individual institutions. 5/11/2010

Unemployment Rates by State, 1976-2009 5/11/2010

Pell Grant Recipients at America's "Best" Universities and Colleges
FY1993, FY1994, FY2000 to FY2009  -- Amended with revised data for 2008 and 2009.  3/30/2010

National School Lunch Program, State-Level Data, FY1993 - FY2009
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. 3/11/2010

Poverty Rates by State, 1980-2008 3/11/2010

Median Family Income by State & Median Household Income by State, 1959 to 2008 3/11/2010

Educational Attainment by State, 1977 to 2009
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/11/2010

State, Local and Federal Fiscal Support for Higher Education
per $1000 of State Personal Income, FY1961 to FY2010 
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 2010. These data illustrate the ebb and flow of state investment in higher education over the last three decades.  2/25/2010

NPSAS Summary by Parental Income Quartiles
UPDATED: Financial Aid Packaging for Full-Time, Full-Year, One Institution Dependent Undergraduate Students In Quartiles 1990, 1993, 1996, 2000, 2004 and 2008
This Excel workbook summarizes data tabulated from the 1990, 1993, 1996, 2000, 2004 and 2008 National Postsecondary Student Aid Study. Data are reported on averages for family income, expected family contribution, costs of attendance, financial need, grant aid, loan aid, work-study aid, other financial aid, total aid, unmet financial need, student work/study burden, net price to family and net price to family as a percent of family income. Data are tabulated in quartiles of parental income for full-time, full-year, one institution undergraduate students. Data are also tabulated by institutional type and control: public 4-year, public 2-year, private 4-year, private less than 4-year and proprietary. 1/26/2010

Bachelor's Degree Attainment by Age 24 by Family Income Quartiles, 1970 to 2008
This Excel workbook summarizes data on high school graduation rates, college continuation rates, college participation rates, estimated bachelor's degree completion rates and estimated bachelor's degree attainment by age 24 by family income quartiles for each year from 1970 through 2008.
Original data were collected by Census Bureau and National Center for Education Statistics. 12/17/2009

ACT National Graduation Rates, 1983 to 2009
This Excel spreadsheet compiles all of ACT's published annual reports on institutional graduation rates.
ACT collects these data on its annual Institutional Data Questionnaire and publishes them in a variety of publications including its annual ACT National Dropout and Graduation Rate Report. Rates are reported as means with standard deviations by institutional control, highest degree offered and admissions selectivity. With ACT's permission, we have compiled these annual reports into this spreadsheet for 5-year and 3-year graduation rates. 10/14/2009