I have a junior and we are about to start the process of putting together a spreadsheet of schools, requirements, audition info, etc, but for awhile now I’ve been staring at a blank screen. I’m just not sure where to begin, what fields to include, etc.
Would anyone be willing to share their spreadsheets with us newbies? I would appreciate any help that you can give!
My spreadsheet is confusing for some but it works for me. Make sure to have a couple spreadsheets and don’t tackle them all at once. Have one spreadsheet with headings such as app, sat, transcript, recommendations, etc and you can put an X next to each school under the category when it is complete! Also have the audition spreadsheet with headings such as prescreen and requirements and you can mark which schools require what and when prescreens are complete. Add on to that later the dates of your scheduled auditions. I hope this helped!
When we did our spreadsheets, a couple years ago, when my son was a junior, we STARTED with one page per school…with bullets for location (urban/suburban/rural), size of school, public or private, average GPA and test scores for admittance, school reputation, and cost to attend. We then added scholarship info, pre screen and audition requirements, etc. When we were narrowing the search down we started to add info on the faculty and the curriculum at the individual programs.
Eventually we just put everything into binders with tabbed sections for each school my S was applying to. The binders came in handy as each section had pockets for school correspondence and scholarship info, etc.
But by midway through the audition process the binders turned into individual school files, lol, because SO MUCH stuff was coming in and we wanted to keep all the info organized with which letters go with which school…and lots of important forms such at letters of intent, dorm info, scholarship, etc…
But it all started as one page per school with information bullets. L-) Hope that helps!
PM me, @DrowsyChaperone … I’ll send you mine. 
No need to reinvent the wheel.
MTmom - thanks so very much! I’ve been tinkering with it all day! What a big help!