DIY College Rankings College Search Spreadsheet

 


Now You Can Compare Colleges the Way You Want to Compare Them

Do you ever go to a college search website and get frustrated because it won’t let search on the variables you really want to search on?

Or maybe you want to search on average cost and then rank by admission rates but it doesn’t let you sort at all.

The problem is that the websites often have the data you’re interested in but it’s not searchable in the way you want or can’t be easily be exported into a useful format for you.

You could enter the data yourself into a spreadsheet for each school. Or if you’re lucky, the website will let you export comparison data for four schools but you don’t get to choose what data is used in the comparison.

The frustrating part is that you know the data has to be out there somewhere since so many of the websites seem to be using the same information. And you’re starting to feel there’s some sort of conspiracy to keep you from analyzing the information the way you want to.

Well, you’re right.

Not about the conspiracy part (as far as I know) but that the data exists part.

At least 80% of the data on all the different college search sites can be found in one source–The Integrated Post-Secondary Education Data System (IPEDS). IPEDS is what drives the College Navigator and CollegeResults.org websites.

Commonly used information

Use the Data to get Answers for the Questions You Want to Ask

Imagine what you could do if you had all the data for over 1500 colleges already entered into a spreadsheet ready for you to sort and search as you see fit?

Instead of being stuck with predefined size categories, you could decide that your ideal school size is between 4,500 and 6,000 undergraduates. Then you could eliminate all the colleges where the 75th percent SAT Math score was over 700.

Enter your own search requirements

And maybe you have a theory about the relationship between the arts and sciences on campus and only want colleges where at least 3.0% of the degrees awarded were in biology and the visual and performing arts.

Oh, you also only want schools where the average net price for families with incomes between 75,001 and $110,00 is less than $20,000. And that would get you a list of 29 colleges.

Want to see what schools have at least a 50% graduation rate, more than 5,000 students, 40% or better acceptance rate, and at least a 600 75th percentile for the SAT CR? You would get 93 colleges with the 5 year graduation rate and 45 colleges with the four-year graduation rate.

Yes, you would get to choose to use the financially significant four-year graduation rate as opposed to the commonly used six-year rate.

How many college search sites let you search by graduation rates?

Search by graduation rates

Interested in colleges with January terms in Indiana, Michigan, Illinois, or Wisconsin? There are 15.

Looking for potential merit aid at small, traditional student body colleges? There are 52 colleges with less than 3000 full-time undergraduates, less than 10% part-time students, less than a 610 for the 75th percentile SAT CR, and at least a 40% four-year graduation rate.

Wouldn’t you rather be analyzing information than doing data entry for every college that might be interesting?

Wouldn’t a spreadsheet that had information on over 200 variables for over 1500 colleges be a great place to start your search?

Such a spreadsheet exists. It has information on the 1567 four-year colleges in the United States that have at least 500 full-time undergraduates and are not for-profit institutions (public and not-for profit colleges only.)

Average Merit Aid for the College

“When I filtered our choices, we chose schools with retention rates over 75%, admission rate over 50%, and ACT 75th percentile that was at least 1 point less than her ACT score because we want to focus on schools where we have the greatest chance for scholarship. We also considered size and location. Once we had our 30 or more schools, we started eliminating the ones where full time faculty was less than 50% and where % of part time students was more than 20%. Then we noticed the % dorms for population and eliminated the ones that had less than 40% dorms available for its students because she’s looking for a tight knit student body and where living on campus is more the norm than the exception.

I think the spreadsheet is a real time saver for people like me who like spreadsheets and is trying to make a decision based more on facts than on emotion. Some schools on her list are from a pure emotion decision, but the spreadsheet helped point out some things that caused us to change our mind about like a school that had more than 40% part time students and the school she thought she liked until she saw that only 32% of the faculty were full time.”
~Anna in Illinois

Spreadsheet Demonstration

It contains 235 columns of data including:

  • 4, 5, 6 year graduation rates
  • Acceptance rates by gender
  • SAT and ACT 25th and 75th percentile scores
  • Endowment and expenditures by category per student
  • Average Cost of Attendance broken down by family income
  • Degrees awarded by major categories
  • Faculty ratios and percentage full-time faculty
  • Financial aid awarded including information on Pell Grants, Federal and Private Loans, and Institutional Grants
  • Accepts AP or Dual Credit

Just think how long it would take you to find and enter the data for 20 schools that you want to compare. Of course, you would have had to spent some time to get down to the 20 to begin with by searching on some of the same data you now want to compare.

You can now have your own set of data for your college search.

So what’s the catch?

No catch but there are two things that you need to know.

The data is from IPEDS not the Common Data Set (CDS) used by US News College Rankings and the College Board.

So it won’t include breakdowns of admissions by SAT scores or GPA. It won’t include information on average amount of financial need met, percentage of classes by class size, or the percentage of students participating in Greek organizations.

That data is unique to the CDS. Of course, recently some of it has crossed the realm of uniqueness to fiction but that’s another story.

That’s why I started off by saying that about 80% of the data is readily available which brings me to the second thing you should know about this data.

You don’t have to buy it from me.

You can download it yourself for free at the IPEDS website. I even show you how to do it on my website.

However, I promise that even with step by step instructions, it will take six to ten hours to get all the variables I have into a nicely formatted spreadsheet. And that’s assuming that you do it right the first time.

So how much is your time worth?

Because you can download a copy of the spreadsheet for an introductory price of only $42.00.

Buy Now!

That’s less than the average application fee for two colleges. And if you’re only applying to three colleges, don’t you want to make sure they’re three where you’ll get in, be happy, and maybe even get some merit money?

Think about how much time and money you are going to spend in applying to colleges.

You have to prep and take college entrance exams, write essays, possibly travel for interviews, request letters of recommendation, and pay application fees. Wouldn’t it make sense to also invest in finding the best colleges for you to apply to?

For $2, start searching and ranking colleges by the factors most important to you.

Best of all, if you are not happy with the spreadsheet for any reason, let me know within 60 days and I’ll refund your money, no questions asked.

Buy Now!

For less than the cost of an AP Exam, you could spend your time comparing colleges instead of entering college data.

The spreadsheet is in Microsoft Excel 2007 format which requires Mac Excel 2011 to run on an apple. It includes the following variables:

School Identification

  • (OPE)ID
  • IPEDS ID
  • Name
  • State
  • State Abbr
  • Type
  • Address
  • City
  • ZIP Code
  • Website
  • Longitude
  • Latitude
  • Alternate Names
  • Carnegie Classification

General Characteristics

  • Size (all students)
  • Full-time Undergraduates
  • % Part-time
  • % Undergraduates age 25 and above
  • % Graduate Students
  • Transfer in Undergraduates
  • %
    Transfer in Undergraduates
  • % Foreign
  • % Undergraduate Women
  • % Students with Disabilities
  • Student to Faculty Ratio
  • % Full Time Faculty

Graduation Rates

  • Retention Rate
  • 6 yr Graduation Rate-total
  • 6 yr Graduation Rate-men
  • 6 yr Graduation Rate-women
  • 6 yr Graduation Rate-White
  • 6 yr Graduation Rate-Black
  • 6 yr Graduation Rate-Hispanic
  • 6 yr Graduation Rate-Asian or Pacific Islander
  • 6 yr Graduation Rate-Native American
  • 6 yr Graduation Rate-Race Unknown
  • 6 yr Graduation Rate Foreign Students
  • 4 yr Graduation Rate
  • 5 yr Graduation Rate
  • 6 yr Graduation Rate
  • Transfer Out Rate

Acceptance Rates

  • Applicants-Total
  • % Applicants Men
  • % Applicants Women
  • % Admitted-Total
  • % Admitted-Men
  • % Admitted-Women
  • % Enrolled-Total
  • % Enrolled-Men
  • % Enrolled-Women

Admission Testing

  • SAT/ACT Required
  • % Freshman Submitting SAT Scores
  • % Freshman Submitting ACT Scores
  • SAT Critical Reading 25th Percentile
  • SAT Critical Reading 75th Percentile
  • Avg SAT Critical Reading Score
  • SAT Math 25th Percentile
  • SAT Math 75 th Percentile
  • Avg SAT Math Score
  • Avg SAT (CR+M)
  • SAT CR+M 25th Percentile
  • SAT CR+M 75th Percentile
  • SAT Writing 25th Percentile
  • SAT Writing 75th Percentile
  • ACT Composite 25th Percentile
  • ACT Composite 75th Percentile
  • Avg ACT Composite Score
  • ACT English 25th Percentile
  • ACT English 75th Percentile
  • Avg ACT English Score
  • ACT Math 25th Percentile
  • ACT Math 75th Percentile
  • Avg ACT Math Score

Other Characteristics

  • Undergraduate Application Fee
  • Religious Affiliation
  • Calendar
  • Tuition Guarantee Plan
  • Dual Credit
  • AP Credits
  • ROTC
  • ROTC-Army
  • ROTC-Navy
  • ROTC-Air Force
  • Study Abroad
  • Freshmen Required to Live on Campus
  • On-Campus Housing Available
  • Dorm Capacity
  • Dorm Capacity as % of Full-time Undergraduates

 

Student Background

  • % Native American
  • % Asian/Pacific Islander
  • % African American
  • % Hispanic
  • % White
  • % 2 or more races
  • % Unknown

Finances

  • Total Endowment
  • Endowment per Student
  • Instruction per Student
  • Academic Support per Student
  • Research per Student
  • Students Services per Student
  • Institutional Support per Student
  • % Expenses Instruction
  • % Expenses Research
  • % Expenses Academic Support
  • % Expenses Student Service
  • % Expenses Institutional Support
  • % Other Expenses
  • Total FTE staff
  • % Instruction-research and public service FTE staff
  • % Executive-administrative and managerial FTE staff
  • % Other professional FTE staff
  • % Non-professional FTE staff

Cost of Attendance

  • Tuition and fees- 2007-08
  • Tuition and fees- 2008-09
  • Tuition and fees- 2009-10
  • Tuition and fees- 2010-11
  • Total Price In-State Students (10-11)
  • Total Price Out-of-State Students (10-11)
  • % Undergraduates Receiving Any Financial Aid
  • Avg Amount of aid (any source) for Undergraduates
  • % Undergraduates Receiving Pell Grants
  • Avg Pell Grants for Undergraduates
  • % Undergraduates Receiving Federal Student Loans
  • Avg Amount Federal Student Loan for Under-graduates
  • % Freshman Receiving Federal Grants
  • Avg Amount of Federal Grant for Freshman
  • Avg Amount of Aid (any) Received by Freshman
  • % Freshman Receiving Pell Grants
  • Avg Amount Pell Grants for Freshman
  • % Freshman Receiving Other Federal Grants
  • Avg Amount of Other Federal Grants for Freshman
  • % Freshman Receiving State-Local Grants
  • Avg Amount State-Local Grants for Freshman
  • % Freshman Receiving Institutional Grants
  • Avg Amount of Institutional Grants for Freshman
  • % Freshman Receiving Student Loans
  • Avg Amount Student Loans for Freshman
  • % Freshman Receiving Federal Student Loans
  • Avg Amount of Federal Student Loans for Freshman
  • % Freshman Receiving Non-Federal Student Loans
  • Avg Amount of Non-Federal Student Loans for Freshman
  • Avg Net Price After Grants (2008-2009)
  • Avg Net Price After Grants (2007-2008)
  • Avg Net Price After Grants (2006-2007)
  • Avg Net Price Family Income $0-$30,000
  • Avg Net Price Family Income $30,001-$48,000
  • Avg Net Price Family Income $48,001-$75,000
  • Avg Net Price Family Income $75,001-$110,000
  • Avg Net Price Family Income over $110,000

Athletics

  • Member of an Athletic Division
  • NCAA Member
  • NAIA Member
  • NSCAA Member
  • NCCAA Member
  • Football Conference
  • Basketball Conference
  • Baseball Conference
  • Cross Country-Track Conference

 

Majors

  • Agriculture- Agriculture Operations- and elated Sciences
  • % Agriculture- Agriculture Operations- and related Sciences
  • Architecture and related Services
  • % Architecture and related Services
  • Area- Ethnic- Cultural- and Gender Studies
  • % Area- Ethnic- Cultural- and Gender Studies
  • Biological and Biomedical Sciences
  • % Biological and Biomedical Sciences
  • Business- Management- Marketing- and related Support Services
  • % Business- Management- Marketing- and related Support Services
  • Communication- Journalism- and related Programs
  • % Communication- Journalism- and related Programs
  • Communications Technologies/Technicians and Support Services
  • % Communications Technologies/Technicians and Support Services
  • Computer and Information Sciences and Support Services
  • % Computer and Information Sciences and Support Services
  • Construction Trades
  • % Construction Trades
  • Education
  • % Education
  • Engineering Technologies/ Technicians
  • % Engineering Technologies/ Technicians
  • Engineering
  • % Engineering
  • English Language and Literature/ Letters
  • % English Language and Literature/ Letters
  • Family and Consumer Sciences/ Human Sciences
  • % Family and Consumer Sciences/ Human Sciences
  • Foreign Languages- Literatures- and Linguistics
  • % Foreign Languages- Literatures- and Linguistics
  • Health Professions and Related Clinical Sciences
  • % Health Professions and Related Clinical Sciences
  • History
  • % History
  • Homeland Security- Law Enforcement- Firefighting- and Related Pr
  • % Homeland Security- Law Enforcement- Firefighting- and Re
  • Legal Professions and Studies
  • % Legal Professions and Studies
  • Liberal Arts and Sciences- General Studies and Humanities
  • % Liberal Arts and Sciences- General Studies and Humanities
  • Library Science
  • % Library Science
  • Mathematics and statistics
  • % Mathematics and statistics
  • Mechanic and Repair Technologies/ Technicians.
  • % Mechanic and Repair Technologies/ Technicians.
  • Military Technologies and Applied Sciences
  • % Military Technologies and Applied Sciences
  • Multi/ Interdisciplinary Studies
  • % Multi/ Interdisciplinary Studies
  • Natural Resources and Conservation
  • % Natural Resources and Conservation
  • Parks- Recreation- Leisure- and Fitness Studies
  • % Parks- Recreation- Leisure- and Fitness Studies
  • Personal and Culinary Services
  • % Personal and Culinary Services
  • Philosophy and Religious Studies
  • % Philosophy and Religious Studies
  • Physical Sciences
  • % Physical Sciences
  • Precision Production
  • % Precision Production
  • Psychology
  • % Psychology
  • Public Administration and Social Service Professions
  • % Public Administration and Social Service Professions
  • Science Technologies/ Technicians
  • % Science Technologies/ Technicians
  • Social Sciences
  • % Social Sciences
  • Theology and Religious Vocations
  • % Theology and Religious Vocations
  • Transportation and Materials Moving
  • % Transportation and Materials Moving
  • Visual and Performing Arts
  • % Visual and Performing Arts
  • All Majors Grand Total

 

 

One single comment

  1. [...] is selling her college rankings spreadsheet for just $40, but you can get a free trial use of this [...]

Add Comment Register



Leave a Reply