DIY College Rankings College Search Spreadsheet

Jump-Start Your College Search SpreadsheetCollege Merit AidPlanning 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.

Add to Cart

How much more useful would your college search spreadsheet be if you already had the following information entered for every four-year institution with at least 500 full-time undergraduates?

The spreadsheet above shows all of the actual columns included in the spreadsheet for a selected number of schools. The “Definitions” tab lists all of the variables and their definitions.

This data is extracted from the Integrated Post-Secondary Education Data System which is basis for the College Navigator website.

“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

This data is extracted from the Integrated Post-Secondary Education Data System which is basis for the College Navigator website.

School Identification Student Background Majors
(OPE)ID % Native American Agriculture- Agriculture Operations- and elated Sciences
IPEDS ID % Asian/Pacific Islander % Agriculture- Agriculture Operations- and related Sciences
Name % African American Architecture and related Services
State % Hispanic % Architecture and related Services
State Abbr % White Area- Ethnic- Cultural- and Gender Studies
Type % 2 or more races % Area- Ethnic- Cultural- and Gender Studies
Address % Unknown Biological and Biomedical Sciences
City Finances % Biological and Biomedical Sciences
ZIP Code Total Endowment Business- Management- Marketing- and related Support Services
Website Endowment per Student % Business- Management- Marketing- and related Support Services
Longitude Instruction per Student Communication- Journalism- and related Programs
Latitude Academic Support per Student % Communication- Journalism- and related Programs
Alternate Names Research per Student Communications Technologies/Technicians and Support Services
Carnegie Classification Students Services per Student % Communications Technologies/Technicians and Support Services
General Characteristics Institutional Support per Student Computer and Information Sciences and Support Services
Size (all students) % Expenses Instruction % Computer and Information Sciences and Support Services
Full-time Undergraduates % Expenses Research Construction Trades
% Part-time % Expenses Academic Support % Construction Trades
% Undergraduates age 25 and above % Expenses Student Service Education
% Graduate Students % Expenses Institutional Support % Education
Transfer in Undergraduates % Other Expenses Engineering Technologies/ Technicians
% Transfer in Undergraduates Total FTE staff % Engineering Technologies/ Technicians
% Foreign % Instruction-research and public service FTE staff Engineering
% Undergraduate Women % Executive-administrative and managerial FTE staff % Engineering
% Students with Disabilities % Other professional FTE staff English Language and Literature/ Letters
Student to Faculty Ratio % Non-professional FTE staff % English Language and Literature/ Letters
% Full Time Faculty Cost of Attendance Family and Consumer Sciences/ Human Sciences
Graduation Rates Tuition and fees- 2007-08 % Family and Consumer Sciences/ Human Sciences
Retention Rate Tuition and fees- 2008-09 Foreign Languages- Literatures- and Linguistics
6 yr Graduation Rate-total Tuition and fees- 2009-10 % Foreign Languages- Literatures- and Linguistics
6 yr Graduation Rate-men Tuition and fees- 2010-11 Health Professions and Related Clinical Sciences
6 yr Graduation Rate-women Total Price In-State Students (10-11) % Health Professions and Related Clinical Sciences
6 yr Graduation Rate-White Total Price Out-of-State Students (10-11) History
6 yr Graduation Rate-Black % Undergraduates Receiving Any Financial Aid % History
6 yr Graduation Rate-Hispanic Avg Amount of aid (any source) for Undergraduates Homeland Security- Law Enforcement- Firefighting- and Related Pr
6 yr Graduation Rate-Asian or Pacific Islander % Undergraduates Receiving Pell Grants % Homeland Security- Law Enforcement- Firefighting- and Re
6 yr Graduation Rate-Native American Avg Pell Grants for Undergraduates Legal Professions and Studies
6 yr Graduation Rate-Race Unknown % Undergraduates Receiving Federal Student Loans % Legal Professions and Studies
6 yr Graduation Rate Foreign Students Avg Amount Federal Student Loan for Under-graduates Liberal Arts and Sciences- General Studies and Humanities
4 yr Graduation Rate % Freshman Receiving Federal Grants % Liberal Arts and Sciences- General Studies and Humanities
5 yr Graduation Rate Avg Amount of Federal Grant for Freshman Library Science
6 yr Graduation Rate Avg Amount of Aid (any) Received by Freshman % Library Science
Transfer Out Rate % Freshman Receiving Pell Grants Mathematics and statistics
Acceptance Rates Avg Amount Pell Grants for Freshman % Mathematics and statistics
Applicants-Total % Freshman Receiving Other Federal Grants Mechanic and Repair Technologies/ Technicians.
% Applicants Men Avg Amount of Other Federal Grants for Freshman % Mechanic and Repair Technologies/ Technicians.
% Applicants Women % Freshman Receiving State-Local Grants Military Technologies and Applied Sciences
% Admitted-Total Avg Amount State-Local Grants for Freshman % Military Technologies and Applied Sciences
% Admitted-Men % Freshman Receiving Institutional Grants Multi/ Interdisciplinary Studies
% Admitted-Women Avg Amount of Institutional Grants for Freshman % Multi/ Interdisciplinary Studies
% Enrolled-Total % Freshman Receiving Student Loans Natural Resources and Conservation
% Enrolled-Men Avg Amount Student Loans for Freshman % Natural Resources and Conservation
% Enrolled-Women % Freshman Receiving Federal Student Loans Parks- Recreation- Leisure- and Fitness Studies
Admission Testing Avg Amount of Federal Student Loans for Freshman % Parks- Recreation- Leisure- and Fitness Studies
SAT/ACT Required % Freshman Receiving Non-Federal Student Loans Personal and Culinary Services
% Freshman Submitting SAT Scores Avg Amount of Non-Federal Student Loans for Freshman % Personal and Culinary Services
% Freshman Submitting ACT Scores Avg Net Price After Grants (2008-2009) Philosophy and Religious Studies
SAT Critical Reading 25th Percentile Avg Net Price After Grants (2007-2008) % Philosophy and Religious Studies
SAT Critical Reading 75th Percentile Avg Net Price After Grants (2006-2007) Physical Sciences
Avg SAT Critical Reading Score Avg Net Price Family Income $0-$30,000 % Physical Sciences
SAT Math 25th Percentile Avg Net Price Family Income $30,001-$48,000 Precision Production
SAT Math 75 th Percentile Avg Net Price Family Income $48,001-$75,000 % Precision Production
Avg SAT Math Score Avg Net Price Family Income $75,001-$110,000 Psychology
Avg SAT (CR+M) Avg Net Price Family Income over $110,000 % Psychology
SAT CR+M 25th Percentile Athletics Public Administration and Social Service Professions
SAT CR+M 75th Percentile Member of an Athletic Division % Public Administration and Social Service Professions
SAT Writing 25th Percentile NCAA Member Science Technologies/ Technicians
SAT Writing 75th Percentile NAIA Member % Science Technologies/ Technicians
ACT Composite 25th Percentile NSCAA Member Social Sciences
ACT Composite 75th Percentile NCCAA Member % Social Sciences
Avg ACT Composite Score Football Conference Theology and Religious Vocations
ACT English 25th Percentile Basketball Conference % Theology and Religious Vocations
ACT English 75th Percentile Baseball Conference Transportation and Materials Moving
Avg ACT English Score Cross Country-Track Conference % Transportation and Materials Moving
ACT Math 25th Percentile Visual and Performing Arts
ACT Math 75th Percentile % Visual and Performing Arts
Avg ACT Math Score All Majors Grand Total
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
This data is extracted from the Integrated Post-Secondary Education Data System which is basis for the College Navigator website.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.Add to Cart

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
The following video is a short demonstration on how you could use the data instead of spending time entering it.
Average SAT Scores

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 an Excel spreadsheet (compatible with PC version 2007+ or Mac 2011) with over 1,500 public and non-profit colleges and 200 variables and a 60 day money back guarantee–no questions asked.

Add to Cart

So what are you waiting for? Wouldn’t you rather be using data than entering it?
  1. [...] The following lists US News Best 100 National Universities ranked by the percentage of freshman receiving Pell Grants. The financial information is for the 2008-2009 academic year as listed in the Integrated Post-secondary Education System. All of this information is also available in the DIY College Rankings College Search Spreadsheet. [...]

  2. [...] The following table is based on the Integrated Postsecondary Education Data System (IPEDS). This is part of the data that is included in the DIY College Rankings College Search Spreadsheet. [...]

  3. [...] All of these schools accept at least 50% of their applicants and have at least a 50% graduation rate. You can get a list of 50-50 college here. You can start your own college search with the DIY College Rankings College Search Spreadsheet. [...]

  4. [...] In the following table, the 4 year graduation rate is used for private colleges and the five-year rate for public colleges. The data are based on the 2009-10 IPEDS year which are available on the DIY College Search spreadsheet. [...]

  5. [...] She has a great website called DIY College Rankings.?  On her website, she offers a pre-populated spreadsheet of college data that can be used as the starting point in the college search.?  You start with [...]

  6. […] you’re interested to see a list with information from the common data set, I suggest downloading DIY College Rankings College Search Spreadsheet. It costs $42, which I think is a bargain to have all this information at your fingertips. The […]

Comments are closed.