<p>I have been hearing a lot about people who make spreadsheets to help with the college process. I like to see everything on paper, so I thought this might be a good idea for me.</p>
<p>I'd like to know, though, what did people include on their spreadsheets? Acceptance rate? Location?</p>
<p>In essence, how did you make a spreadsheet that worked for you, or how could you have made a better spreadsheet?</p>
<p>I did it for all 4 of my kids, some things that were included: </p>
<p>SAT/Scores-50th Percentile
Number of students
Male, Female Percentages
Housing for all 4 years?
Application Deadline
Notification Date
FAFSA Deadline Date
CSS PROFILE DEADLINE Date
Interview Required? Deadline?
Tax Returns Due by when?</p>
<p>SAT Scores Sent: List Dates</p>
<p>I made one, for each school:</p>
<p>its app deadline,
if it uses the common app,
school requirements (SAT only? SAT subject tests? recommendations? etc.),
app cost,
decisions mailed by,
likelihood (target, reach, match and % from **************.com haha),
total approx. cost to attend,
whether their Education program is good (since I’m a prospective teacher),
and additional comments</p>
<p>Hope this helped! :D</p>
<p>Yeah, I made that too.</p>
<p>App due date, scholarship app due date, essay question, what app you can use, location, size, type of school, tuition/room/board/fees, AP scores accepted, acceptance rate, admission requirements, quality of program, undergrad only vs uni with grad students, LAC or regular university, type of music program (school of music vs music department), students’ ACT/SAT/GPA averages, profs with terminal degree, grad rates (4& 6-year rates), distance from home, which music prof I’d have for lessons (I’m a piano major), decision by date, FA form deadlines, average class size, student-faculty ratio, special classes offered for music majors compared to the other, how many gen ed requirements I’d have to take after AP credits factored in, city size and info, retention rate, # and percentage of music majors, % of students involved in music as non-majors, in-state vs out-of-state enrollment, plus other things I can’t remember right now</p>
<p>I use a google Docs Spreadsheet that I’m VERY attached to - easy to update and such, but like you, I have a printed version as well. It basically looks like this:</p>
<p>Name | Average SAT score | Programs/Majors of Interest | Location |</p>
<p>Those are the only things on there for me because those are really important factors for me; cater your spreadsheet to fit your needs. I recommend one though, very useful from my experience! :)</p>
<p>BASICS - enrollment; acceptance % 2009; acceptance % 2010; yield % 2010; # of majors; student:faculty ratio; 2010-11 tuition; town population
RANKINGS - USNWR '11 Rank; USNWR A+ Schools for B Students; POPE CTCL; Kiplinger OOS value
NOTE - General take; Interesting fact; IRL alumnus;
ACADEMICS - Calendar; Strengths; Honors Programs
FINANCIAL - FA Summary; Offers Merit?; Average Merit; Need Methodology; Average Award; % Receiving Need-based aid; % Students with need fully met; average % discount from COA; Need-blind?; Full-need?; Loan-Free?; Average Total Indebtedness (10-11);
SPORTS - NCAA; club; area; school mascot
STUDENT LIFE - M:F ratio; % frat; % soro.; dorms
ADMISSIONS - application fee; EA deadline; RD deadline; common app?; CDS weighted components: Rigor, Rank, GPA, Scores, Essay, Recs; SAT Optional?; ACCEPTED STUDENTS STATS 25-75: SAT CR; SAT M; SAT W; ACT C; GPA</p>
<p>It’s pretty much way too big and unwieldy already, and my son’s only a rising sophomore. I think my next revision will be to split out undergrad enrollment and total enrollment.</p>
<p>It’s a Google Docs too.</p>