<p>Good stuff. Since this is something that you’re looking at for your students, from an instructor’s perspective, I, too, am a spreadsheet fan, but I suppose there are a few things I do differently.</p>
<p>First, with the spreadsheet, I also organised by school, then listed things like prescreen, prescreen due date, prescreen material, all artistic requirements (song cuts, monologue length(s), dance reqs), Unified options, audition dates. Once things were selected (like an audition date), I would bold it. Also for artistic reqs, since I also use Numbers, I used the option to create predefined cell pull down menus with a student’s song and monologue options (e.g. “Pulled” 16 bars, mm. 4-20; Much Ado, Hero, Act III, lines 100-200, 90 seconds, etc), so that I could see a school, see what they wanted, and then instead of going from memory what that student had for options, I could just go to a pull down menu to see their choices and pick the best 32 bar cut, or whatever that school needed. (Did that make sense? If you’re not familiar with that function on Numbers, it’s really great!). I also kept what schools provide an accompanist and if not, what their backtrack requirements were. The spreadsheet was more of a way for me as a teacher to be artistically OCD haha.</p>
<p>I also kept a separate folder on my computer for each student. The folders were organised with:
- a copy of their sheet music (if I had it digitally, which I mostly do) separated by full song and cuts (since you’re a Mac user, you can cut down songs into cuts using “Print PDF” in Preview- another good function if you’re not familiar), which was helpful in case I got a call that something had happened to the music, and I could just quickly email a new copy or print one without much work
- monologue copies with any notes from after working them
- their edited and unedited audition or prescreen videos
- a copy of their resume, rep list and headshot: this is partly to have for reference, partly to be able to help them edit them if necessary, and partly to make sure they get done in time
- the student’s recommendation letter(s) from me
- recorded background tracks (I also keep an iTunes playlist for each kid with these) separated by full song, 16 bar, 32 bar, etc
- the spreadsheet, of course :)</p>
<p>THEN… completely separately for myself, I keep a running list of programs - as many as possible, anyway - with updated information about the schools (campus info, academic requirements, etc), the program itself (curriculum, info on professors, class size, cut/cut-like systems, etc, etc, etc) and the general audition requirements, along with whatever notes I have that make sense probably only to me haha. I also keep a copy of info from past or current students when possible. This just keeps my brain slightly more organised so that I know how to more intelligibly talk about the programs, or give better informed advice based on what each student is looking for. </p>
<p>I feel like I’m forgetting something, but that’s the general idea of what I personally do. I’m kind of a control freak, so I’m also an organisation freak. If I think of anything else, I will surely post it here. MTCoachNYC- you already know you’re welcome to get in touch any time :)</p>
<p>Also on a separate note to parents, I notice that some of you have had your kids fill out an “audition reflection” or something similar (and/or a “visit reflection”), and I think that’s a REALLY good idea. Make an immediate pros/cons list, or similar, so it’s fresh in your mind, then make another one later based on research, etc, and I think once the time comes around to make a decision, it will likely help. Similarly, making a preliminary pros/cons list before the audition (and/or visit) might help inform the student of questions to ask or discussion points about that specific program (for the interview, or otherwise).</p>
<p>Hope that helps some.</p>