350 likes | 461 Views
EFFECTIVE DATA ANALYSIS AND PRESENTATION. Al Hermsen, Director Office of Student Financial Aid WAYNE STATE UNIVERSITY. WAYNE STATE UNIVERSITY. Large urban public school – Detroit, Michigan 32,000 students 20,000 undergrads and 12,000 grad/professional students
E N D
EFFECTIVE DATA ANALYSIS AND PRESENTATION Al Hermsen, Director Office of Student Financial Aid WAYNE STATE UNIVERSITY
WAYNE STATE UNIVERSITY Large urban public school – Detroit, Michigan 32,000 students 20,000 undergrads and 12,000 grad/professional students Medical, Law and Pharmacy schools Founded in 1867 82% of the students receive some form of financial aid
Data Analysis Needs Funding needs Monitor spending Final reports with details Comparisons to other schools National trends Longitudinal reports Operating funds
Funding needs Analyze your school needs Compare to other schools Set goals Explain goals to budget team Get commitment
p The equity packaging model for need based aid provides sufficient funding for tuition and fees without loans. Graph before new model:
Equity Packaging Model After New Model was Implemented
Loans to Meet Cost of Attendance Several types of loans are needed to meet the cost of attendance for students
Monthly Spending and Projection ProgramBudgetBufferSummerFallEst. F/WSpringTotal Est.Balance Campus-based Health Prof. Other Federal Direct Loans Total Federal State Programs Inst. Need-based Inst. Merit based Graduate awards
Comparison to other schools College Navigator Check other school websites Survey of competitor schools
Packaging Survey Add a sample of my pkg survey
Average Estimated Undergraduate Budgets, 2010-11 (Enrollment-Weighted) SOURCE: The College Board, Trends in College Pricing 2010, Figure 1.
Average Annual Percentage Increases in Inflation-Adjusted Published Prices by Decade, 1980-81 to 2010-11 SOURCE: The College Board, Trends in College Pricing, Figure 4
Public Four-Year Colleges and UniversitiesAverage Tuition and Fee and Room and Board (TFRB) Charges by College Board Region,in Constant 2010 Dollars, 2000-01 and 2010-11 (Enrollment-Weighted) SOURCE: The College Board, Trends in College Pricing 2010, Figure 6.
Net Price: Public Two-Year CollegesFull-Time Students by Dependency Status and Family Income, 2007-08 SOURCE: The College Board, Trends in College Pricing 2010, Figure 8B.
State Appropriations for Higher Education per $1,000 in Personal Income by State, 2009-10 (including Federal Stimulus Funds) SOURCE: The College Board, Trends in College Pricing 2010, Figure 11B.
Percentage Growth in Mean Family Income by Quintile in Constant 2009 Dollars, 1979–1989, 1989–1999, and 1999–2009 SOURCE: The College Board, Trends in College Pricing 2010, Figure 16A.
Median Family Income by Selected Characteristics, 2009 SOURCE: The College Board, Trends in College Pricing 2010, Figure 16B.
Ten-Year Trend in Student Aid and Nonfederal Loans per FTE Used to Finance Postsecondary Education Expenses in Constant 2009 Dollars, 1999-2000 to 2009-10 SOURCE: The College Board, Trends in Student Aid 2010, Figure 1.
Undergraduate Student Aid by Source (in Billions), 2009-10 SOURCE: The College Board, Trends in Student Aid 2010, Figure 2A.
Average Student Debt per Borrower andAverage Student Debt per GraduatePublic Four-Year Bachelor’s Degree Recipients1999-2000 to 2008-09 (in Constant 2009 dollars) SOURCE: The College Board, Trends in Student Aid 2010, Figure 10A.
Average Aid per Undergraduate FTE, 1994-95 to 2009-10 in Constant 2009 Dollars SOURCE: The College Board, Trends in Student Aid 2010, Figure 11A.
Percentage Distribution of Pell Grant Recipients by Family Income and Dependency Status, 2008-09 SOURCE: The College Board, Trends in Student Aid 2010, Figure 14A.
Percentage Distribution of Pell Grant Recipients by Age, 2008-09 SOURCE: The College Board, Trends in Student Aid 2010, Figure 14B.
“Trends” web-site For more information, visit:trends.collegeboard.org
Longitudinal Reports Develop your own trends reports Follow examples from College Board or others
Increased Need for Financial Aid The effect of the economy has lead to a 44% increase in financial aid applications
Increase in Undergraduate Aid Financial aid to undergraduates increased 62.5% over the last five years. 84% of undergraduates receive some type of aid.
Increases in Gift Aid Large increases in Pell Grants and BOG awards have increased need-based funding 142% Increased institutional merit awards have been offset by State and Federal merit aid decreases
Al Hermsen Senior Director Office of Financial Aid Wayne State University ahermsen@wayne.edu 313 577-3533