DIY College Rankings College Search Spreadsheet - Do It Yourself College Rankings

DIY College Rankings College Search Spreadsheet

Jump-Start Your College Search Spreadsheet

College Merit Aid
Average Merit Aid for the College

Planning on using a spreadsheet to track your college search? Why not save yourself time and have it loaded with the data you’re going to be copying from college search sites anyway?

For $42, instead of copying information on SAT scores, admission rates, size, graduation rates, and so on for each college as you decide to include it in your search, you could already have the information entered and be focusing on adding the unique characteristics as you find them.

Buy Now!See how easy it is to search over 1500 colleges if you already have the information entered. [jcolumns model=”4,1″ inbordercss=”1px solid #555555″]

Having the data already entered means that you can use it to actually search for colleges, not jut track colleges you have already found. Instead of entering graduation rates, admission rates, average cost of attendance, or 75th percentile test scores you could be searching on them.

Enter your own search requirements

[jcol/]

“I think it is fantastic. I am not an expert in excel by any means but I find the spreadsheet extremely easy to use. I was able to use the search tab to filter my choices which I then copied to a new sheet where I added in any schools my daughter is interested in that didn’t make the cut…Her list of 30 “awesome” schools is down to 10 truly outstanding choices that on paper are everything we are looking for. Schools we thought were great ended up getting crossed off because of factors we didn’t think of before. Thanks to the spreadsheet, those factors became evident especially as we compared them to other schools. We did all this in just under an hour.”

~Anna in Illinois
[/jcolumns]

You can have a spreadsheet with this data already entered, formatted as tables, and a tab for a pivot table for only $42. That’s what it costs to just take the SAT.

Buy Now!

For the cost of a single college application, you could be using your spreadsheet to narrow your college search rather than looking up the data from websites to enter.

For $42, you get a 2007 Excel spreadsheet with over 1,500 public and non-profit colleges and 200 variables and a 60 day money back guarantee–no questions asked.

Buy Now!So what are you waiting for? Wouldn’t you rather be using data than entering it?

This data is extracted from the Integrated Post-Secondary Education Data System which is basis for the College Navigator website and includes the following:

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

2 thoughts on “DIY College Rankings College Search Spreadsheet”

Leave a Comment