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: previous next 
1 2 3 4 
Sort by: Title , Date
  

ACT National Persistence Rates, 1983 to 2009
This Excel spreadsheet complies all of ACT's published annual reports on institutional freshman-to-sophomore persistence 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 freshman-to-sophomore persistence rates. 10/14/2009

Income by Educational Attainment for Families and People, 1956 to 2008
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.  10/14/2009

Dependent and Independent Pell Grant Recipients by Institutional Type/Control and State, 1993-94 to 2007-08 8/20/2009

Pell Grant Recipient Data by State, 1976-77 to 2007-08
This large Excel workbook contains Pell Grant recipient data by state, by institutional control, and by year, 1976 to 2008.
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. 8/20/2009

National Income and Product Accounts, 1952 to 2008
These two Excel worksheets tabulate the most recently reported data on expenditures for higher education by the federal government, state and local governments, and students and their parents for higher education.
These data are compiled by the Bureau of Economic Analysis as a part of the National Income and Product Accounts of the United States. Compiled and reported in this way, they provide insights into higher education finance for the United States that are not available from other sources. 8/4/2009

Higher Education Equity Indices for Students from Bottom Family Income Quartile, 1970 to 2007
This Excel workbook contains the data used to calculate Low Income Equity Indices for 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 rates for the years 1970 - 2007. 7/28/2009

Educational Attainment & Economic Welfare Measures in:
Metropolitan Statistical Areas: 1989, 1991, 1993, 1994, 1995, 1999, 2000, 2001, 2002 7/28/2009

Pell Grant Shares of Undergraduate Enrollments in 4-Year Colleges By NCAA Divisions and Conferences 1992, 1993, 2001, 2002, 2003 and 2004 7/28/2009

College Continuation Rates by Family Income for Dependent Family Members
15 to 24 Years Old in Same Year Graduated from High School, 1987 to 2004 7/28/2009

"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 2007-08. 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. 7/28/2009

Private Correlates of Educational Attainment
This is an extensive compliation of data that describes how people differ according th their educational attainment.

Data that describe the population according to usually four levels of educational attainment have been collected from many (documented) sources. These data are categorized according to:
Population
Employment and Unemployment
Income, Benefits, Wealth and Expenditures
Health and Nutrition
Sex
Personal Life
Family Life
School Performance
Reading
Civic life
Volunteering
Crime and punishment
 

7/20/2009

Financial Aid Packaging for Full-Time, Full-Year, One Institution Dependent Undergraduate Students, 2008
The data in this spreadsheet was used in the analysis in Issue #204 June 2009. 6/30/2009

College Participation Rates for Students from Low Income Families by State FY1993 to FY2008
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 FY2008. 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. 6/30/2009

Gender Data
This spreadsheet summarizes data on the conditions of adult males and females in employment, the family, and civic life. On 6/4/09 Unemployment data has been updated with 2008 numbers.  6/4/2009

Labor Force Status of Persons 16-24 Years Old by School Enrollment, Education, Race & Hispanic Origin, 1970 to 2008
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. 5/20/2009

Gini Coefficients for Household and Family Income by State -
1969, 1979, 1989 and 1999 1/7/2009

Raw Pell Grant Recipient Data by State and Institution
from the Office of Postsecondary Education, US Department of Education. For years 1992-93, 1993-94, 2001-02, 2002-03, 2003-04, 2004-05, 2005-06, 2006-07 and 2007-08.  12/22/2008

Federal Income Taxes Paid by Educational Attainment of Householder, 1970 to 2007
This Excel workbook contains OPPORTUNITY's analysis of the contribution of college educated tax payers to federal individual income tax revenues. The period covered is 1970 through 2007.
Data on households, household income and educational attainment of householder from the Census Bureau are combined with data on adjusted gross income, federal individual income taxes paid and effective federal income tax rates to derive these estimates. The data illustrates the very large and growing dependence of the federal government on the tax revenues generated on the higher income of college-educated taxpayers. 11/6/2008

Stock and Flow of Bachelor's Degree Holders by State, 1989 to 2007
This is an Excel spreadsheet that uses data from the Census Bureau's Current Population Survey and National Center for Education Statistics' IPEDS survey to calculate the stock and flow of bachelor's degree holders by state between 1989 and 2007.
This approach enables the determination of net migration of bachelor's degree holders into and out of a state. This analysis helps illustrate the importance of migration of college graduates to state human capital development, which in turn largely determines state per capita personal income. 9/30/2008

State Appropriations, Public University Tuition Rates and Need-Based Grant Funding
This large Excel spreadsheet compiles data on year-to-year changes in state tax fund appropriations for higher education, public institution and fee rates, and state funding for need-based grant programs.
Data are compiled for years between FY1975 and FY2007 for all 50 states. These analysis consists of trends and patterns in bivariate correlations over time and within states. 3/31/2008