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
  

TRIO Programs Summary Statistics
This spreadsheet was used in the December 2012 Issue #234 of OPPORTUNITY. 2/2/2012

Pell Grant Recipients as a Percentage of Pell-Eligible Undergraduate Enrollment
 by Institutional Type/Control and State, 1993-94 to 2009-10 10/14/2011

Pell Grant Recipient Data by State, 1976-77 to 2009-10
This large Excel workbook contains Pell Grant recipient data by state, by institutional control, and by year, 1976 to 2010.
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. 9/14/2011

College Participation Rates for Students from Low Income Families by State FY1993 to FY2010
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 FY2010. 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/14/2011

Unemployment Rates by State, 1976-2010 9/14/2011

State Need-Based Grant Coverage of Pell Grant Recipients, 1978-79 to 2009-10
Updated 7/29/2011

ACT National Persistence Rates, 1983 to 2011
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. 7/29/2011

ACT National Graduation Rates, 1983 to 2011
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. 7/29/2011

Pell Grant Maximum Award Purchasing Power 7/18/2011

Pell Grant Share of Undergraduate Enrollment 7/18/2011

Gender Data for Children
This spreadsheet summarizes data on the conditions of children in the areas of Population, Education, Education Related, Computer Use, International, Work, Health and Behavior/other. 6/15/2011

Labor Force Status of Persons 16-24 Years Old by School Enrollment, Education, Race & Hispanic Origin, 1970 to 2010
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. 6/10/2011

College Entrance & Participation Rates by Race/Ethnicity & Gender for Recent High School Graduates & Leavers, 1959 to 2010
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. 6/10/2011

Degrees Conferred by Level of Degree, Gender and State 1970 to 2009 5/9/2011

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

Gini Coefficients for Household and Family Income by State -
1969, 1979, 1989, 1999 and 2006-2009 5/9/2011

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, 2007-08, 2008-09 and 2009-10.  4/18/2011

Gender Data
This spreadsheet summarizes data on the conditions of adult males and females in employment, the family, and civic life.  4/5/2011

Poverty Rates by State, 1980-2009 4/4/2011

Median Family Income by State & Median Household Income by State, 1959 to 2009 4/4/2011