Sunday, April 26, 2015

FileMaker Pro, A Love-Hate Story. Season 2, Episode 16

I got an interesting text message from my department chair at the last school at which I worked.  Apparently, there are some outstanding invoices from J.W. Pepper (a sheet music company) from when I was teaching there.  I know that I settled all my financials before I left.  Though, what that actually means is that I submitted payment requests to the school.  I cannot say for certain whether or not the school actually followed up on those payments.  And, since I was leaving the school, I did not take any of that financial paperwork with me.  I can't even say for certain what happened to it.  I hope they are able to sort through the paper trail and get everything settled.  I guess some things get a little messy in a band director transition, especially when the school waits too long to hire a new person.

I don't remember whether I told you yet or not about this, so I am going to start at the beginning of this particular story.  If this sounds familiar to you, feel free to scroll down till you find new and interesting information.  If you haven't heard this before, then you better read it.  All of it.  Every word.  There may be a test at the end.

You may recall that I have had Pet Shop (the instrument storage room) duties as part of my assistantship.  Well, the Pet Shop signs instruments out to students using the old method: triplicate forms filled out by hand, which take forever to fill out and which create piles of paper records to keep organized and need space to be stored.  I had been using a Filemaker Pro database to manage my inventory and loan instruments when I was working for the school system, and I figured the same kind of system could be implemented at Temple to streamline the instrument sign out procedure and to cut down on the paperwork storage space we use.  I have some experience using Filemaker Pro and figured it would be a cakewalk to design an instrument inventory database.  I was wrong.  It turns out that what I know about Filemaker Pro barely scratches the surface of its functionality.  

What I knew when starting the project:
  • You enter all your data in a spreadsheet, like the ones used in Excel.
  • You can design layouts that display the information in the spreadsheet.
  • Multiple layouts can be used to display data relevant to different situations.
  • Layouts can be printed, so I assumed they could be emailed as well.
So, armed with what I thought was a pretty substantial set of Filemaker Pro skills, I set to work designing the database.  I was actually doing OK.  I even figured out how to write scripts (Filemaker Pro's version of custom action sequences) on my own.  But, I hit a wall when I tried to build the script that would enable me to email a signed loan contract.  And then I remembered that I have access to Lynda.com through school.  For those of you unfamiliar with Lynda.com, it is an online software training website.  So, I started watching Filemaker Pro videos and I pretty quickly realized I had been doing everything all wrong.  The biggest thing I learned is that Excel is what is considered a "flat database."  Meaning, all the information is stored in one spreadsheet and so the things you can do with the data is quite limited.  Filemaker Pro is a dynamic, relationship-based database.  Meaning, the data is stored across multiple tables (spreadsheets), which can be related to each other, making data manipulation and storage much easier.  So, now I have the database set up so that when we sign out an instrument, it automatically populates a loan form with data from the instrument inventory and from the borrower catalogue.  It also automatically signs an instrument in with the click of a button and saves both the loan form and the return receipt as individual records in a separate, searchable table, with each loan form and return receipt tied to both an instrument in the inventory and a person in the borrower catalogue.  I also have it set up to generate repair tickets for instruments needing repair.  The repair tickets, stored in their own set of records, are also saved and tied to a specific instrument in the instrument inventory.

Advertisement:
Are you a band or orchestra director?  Do you wish you had a more streamlined way to manage your instrument, sheet music, and uniform inventories?  Well, come down to Mitch' Filemaker Pro Database Emporium and Brewery to design the database of your dreams!

 This week was a concert-riffic week.  Monday night was the Night Owls concert.  I thought it went really well, overall.  My first piece, Scherzo Without Instruments, was an exercise in conducting strength.  Almost immediately, as we started the piece, the tempo got out of hand.  It took all the energy I had to try and control the tempo.  Dr. B. told me after the concert that he could tell how hard I was working to hold everything together.  I really was.  I had nothing left to give to gestures of style and interpretation.  It was all tempo, all the time.  But, we made it to the end together and the audience clapped, so I am going to count that one as win!  My second piece, Earthdance, went off really well, with just a minor exception.  The piece begins with 4, out-of-time measures of rain storm sound effects, followed by two measures of a bass drone and ambient percussion noises, followed by a clarinet and saxophone melody.  The past couple weeks, a saxophonist kept coming in two bars too early with the melody.  I took a minute to go through that section during my warm up with the group before the concert and we worked it out.  Yay!  But, then in the concert a clarinet player did the same thing the sax player had been doing.  The funny part of it is that when she came in early, the whole clarinet section turned to her and yell-whispered at her that she was early.  I could have sworn the whole audience heard the whispers.  But, it turns out nobody did.  The rest of the piece went really well.

Thursday was the last Wind Symphony concert of the year.  I played on two pieces, Donald Grantham's J'ai Ete Au Bal and Symphonic Dances from West Side Story.  I got the sense that a lot of the ensemble members did not like the Grantham, but I actually found the piece to be really cool.  And West Side Story is just awesome.  You can see the concert here:

I managed to get the school to let me play just contrabassoon this year.  And I have been worried that, come next year, they would expect me to play bassoon as well.  In all honesty, I am not as skilled at bassoon as I am at contra.  I have just considerably more time playing contra over the past 10 years and, to be honest, I like it better.  Dr. T. approached be as we were preparing for the concert and asked me, in a way that I feel like was meant to sound nonchalant, if I would be playing again next year.  But, I could tell that behind the conversational facade of the question was the desire to have my playing contra next year.  I told her that she was going to be stuck with me for the next few years.  To which she replied that she was definitely ok with that.  Looks like I have claimed my seat as the contrabassoonist here.

Dr. C. has been critiquing me pretty consistently about my pacing when I present.  She says that I speak with a little too much energy and that I move too quickly.  This weekend, at Temple Prep, I finally heard it in my own speech: I do talk fast when I am teaching/ presenting!  Much faster than my conversational speech.  I made an effort to slow down and actually found that the students listened better when I spoke slower.  This is going to be a hard habit to break.  But, I am going to have to put in the effort to make it happen.
I realized that there are no pictures in this blog yet, so enjoy this one as we come to a close:
 Well, folks, that is all for this week.  

Future Dr. Mitch, out!

Sunday, April 19, 2015

Open Mouth, Insert Foot. Season 2, Episode 15

Alright, folks.  I know last week I kind of phoned it in and wrote a lack luster post.  So, I will make up for it this week.  Strap in, and get ready.

Time circuits, on!
 

Flux capacitor, fluxing!
 

Here we go!

As you may remember, I have been TAing (I know it isn't a real word, but I am using it anyway) for Teaching Instrumental Music.  The students in the class play secondary instruments and take turns teaching each other.  One of the students has been having trouble with clarinet tone production.  As of yet, none of the teachers have addressed it.  At the end of class, I just wanted to suggest to students that they can address specific issues of technique and to give them something to focus on, I suggested that they do some thinking and research about how to help this one student with his clarinet tone.  But, what came out of my mouth ended up sounding  more like, "this student is squeaking up a storm."  I totally called him out by mistake!


Dr. B. did say at the end that my point was a valid one.  I just wish I had been able to word it a little differently.  I did take some time at the end of class to help him with his embouchure and we made some pretty good progress in only just a couple minutes.  He didn't seem scarred by my comments, so I think all is good!

Also, on Monday, Wind Symphony has rehearsal in the performance space, which you might remember is not in the same building as the school of music.  Well, on this upcoming concert, I am playing both the contrabassoon and baby bassoon.  So, I had to lug both horns across campus for rehearsal... and then we only played the part of the show that I play contra on.  At least I got some physical exercise carrying all that weight back and forth.  That being said, it would have been so much easier if I had that contra-/ baby-bassoon double case with the backpack straps and wheels.  I am still looking for a benefactor who wants to buy that case for me.  It's only $3,500.00!  Any takers?

In Dr. C.'s class this week, we talked about the identity of college music schools.  She asked the class what our perception of the Temple University School of Music's identity is.  It's funny, I have only ever earned music education degrees (I am working on my third one) and yet my mind went straight to the music performance side when I considered the school of music's identity.  I wonder why I didn't think of music ed. first.  I don't have any answers here, I just found it curious.

Night Owls this week went poorly.  I tried some new things in my conducting because of Dr. C.'s comments last week.  For some reason, the band and I just didn't connect.  I don't know if it was because of the new things I did, or because we were in the performance space and not the rehearsal space, or some intangible factor.  All I know is that it was the dress rehearsal and we get next to no rehearsal time before the concert this coming week.  I hope it all lines up!

This week, we had a project due in Measurement and Evaluation in Music.  We were tasked with creating an ePortfolio of our respective careers.  I have managed to save so much stuff from my years of teaching that it became quite the herculean effort to compile it all into an easily digestible product.  But, I think I did a pretty bang up job of it.  And so did Dr. B.

The two points I lost on layout were, admittedly, deserved.  There was one page that was not as well thought out or organized as the rest.  So, I will take the two point hit.  But, the rest of it was pretty great!

On Wednesday, I was definitely riding the struggle bus for Wind Symphony rehearsal.


I was gathering up my stuff for rehearsal and couldn't find my music (the whole folder was missing).  So, I had to go ask for extra copies of the music before rehearsal.  The rehearsal started with a sectional, which was not in the normal rehearsal room.  So, by the time I got down there from gathering up my instruments and collecting extra copies of the music, the room was quite full and it was difficult to maneuver my gigantic case into the space.  Moreover, I still had to go back upstairs and get the bassoon stands.  By the time I made it back down to the room with the stands, sectionals were already starting and I made more noise than I was comfortable with as I was getting unpacked and set up.  Because I was the last one in, I got stuck with the broken music stand, which I did end up rigging so it didn't dump my music on the floor every time I put something on it.  And then, halfway through the sectional, my phone decided to turn itself on and start making noise.  Gaaaah!  It was actually a good reminder to be understanding of students when stuff goes wrong.  To be fair, some students are just irresponsible.  But, other students are just having a bad day.  And when one thing goes wrong, it has the tendency to snowball.  Thanks, universe, for the slice of humble pie.

Well, it is official.  My session has been scheduled for the NAfME conference.
http://inserviceconference.nafme.org/sessions/
Tuesday, October 27, 2015 from 1:00pm - 2:00pm.
Let the freak out commence!

Well, that is all for this week.  Hope you enjoyed yourself!

Until next week,

Future Dr. Mitch, out!

Monday, April 13, 2015

I'm an Idiot! Season 2, Episode 14

Confession time, everyone: I am an idiot.   I was sitting in my office on Monday, getting some work done.  After all, I had some time; I didn't have to be at rehearsal until 3:00.  And then I got a text message from Cory: "Are you playing on this Wind Symphony concert or not?"  So, I said, "Yes.  On the Grantham.  It rehearses in 30 minutes.  I will be there."  And then Cory said, "You are on the Bernstein as well."  Well, crap!  I could have sworn that I was only playing on the Grantham.  So, just to double check before I told Cory he was wrong, I checked the part assignments again.  Of course, right there next to my name, it said I was playing contrabassoon on the Bernstein.  Crap!  So, I missed rehearsal for no other reason than that I was an idiot.  I apologized profusely to Dr. T. and I hope she actually forgave me.  I have seen what happens when you piss her off.  I don't want to be on that boat.






















Dr. C. gave me some interesting feedback in Night Owls this week.  I have been working on my conducting and trying to look less like a "middle school band director" and more like a "real conductor."  But, she told me that I need less finesse in my conducting.  She said the group needs something a little more rigid.  I will give that a shot next week and see what happens.

So, I found out that part of my assistantship next year will be me being the dedicated instrument repair guy for music ed at Temple.  I am super excited!  Dr. C. asked me to put together a list of tools and supplies that I would like the school to get me.  Can you say, "shopping spree?"  Here is what I have on my list so far:
  • dent rollers
  • pop rivets
  • saxophone pad assortment
  • clarinet pad assortment
  • woodwind screw assortment
  • Dr. T's Slide Knockerouter (yes, that's what it is called)
  • sheet cork assortment
  • large and small bell rim block
  • flute body mandrel
  • flute head mandrel
  • rawhide mallets
  • V block vice jaws
  • trumpet bell stem mandrel
  • dent hammers
  • anvil
  • canvas mallet
  • leak light
  • testing plug assortment
  • emery cloth
  • water key cork assortment
  • rotary valve bumper cord
  • felt bumper assortment
  • key felt assortment
  • felt washer assortment
  • plastic tubs
  • soap
  • sonic cleaner
  • brushes and snakes
  • penetrating oil
  • needle spring assortment
  • flat spring assortment
and I am not done shopping yet!

Dr. T. said something really subtle, yet incredibly effective in Wind Symphony rehearsal this week.  She was trying to get us to play in balance and she told us to lose our own sound within the sound of those around us.  It was such a great way of saying that.  I am going to borrow that saying from her!

I know this was a short entry.  Next week's will be better.  See you then!

Future Dr. Mitch, out!

Tuesday, April 7, 2015

Better late than never... Season 2, Episode 13

Well, it seems I have disappointed you, my faithful audience, by being a couple days late with my post.  Rest assured, I have heard your outcry and here is this week's installment of your favorite blog ever!

I will start off this week right where I left off last week: on the bus.  You might recall that I posted last week from the bus, on our way back from Nashville.  I was pretty confident at that point that nothing else of note would happen that week.  Boy, was I wrong.  As the bus neared campus - and I must emphasize, "near campus" - the driver started muttering things like, "this is not good," and, "we're not going to make it."  Then he announced that we were losing coolant.  At this point, we were 3 blocks from Presser Hall (the music building).  Lo and behold, the bus gave a little shudder, and the engine cut out.  Interestingly enough, when the driver realized the bus was about to break down, he did not attempt to get over to the right lane.  He also did not apply the brakes after the engine shut off and allowed the bus to coast to a halt...  you got it, folks, right in the middle of an intersection on Broad Street in North Philly.  It's not a great picture, but this will give you an idea:



I met with Dr. C. this week to discuss my research proposal.  I still can't tell you what I am going to be doing, but - trust me - it is going to be super cool... well, maybe moderately cool... but, definitely very interesting!  Well, she asked me a lot of really great questions and was satisfied enough with my answers to give me the green light to move onto the next steps.  So, I now have to do my IRB (Institutional Review Board) training, get Lionel's permission to use P.G. County Schools data, and submit my proposal to the IRB for approval.  It looks like this is going to happen!  I am stoked!

On Wednesday, we talked stats in Measurement and Evaluation.  It was really great to get to talk about this stuff in a different setting.  It definitely helped me figure out which things I really understand and which I still have no grasp on, whatsoever.  Dr. B. actually explained some of the concepts in a much more accessible way than my stats professor had.  I definitely need to spend some more time banging my head against stats!

I had a really great week in Temple Prep.  For Wind Ensemble, I really needed a win after the literature choice debacle of two weeks ago.  I picked The Winds of Destiny by Eric Morales, whose music I tend to like a lot.  I was just hoping the students would like it too.  It wasn't an easy piece for them.  There were some significant technical demands, not to mention a quite brisk tempo.  But, the students actually tackled the technique quite well and didn't sound half bad doing it.  I can honestly say that their sight reading of the tune was the best they have sounded yet this year!  In Musicianship, we worked on tuning.  It was a very informal lesson, where students, in pairs, attempted to tune to one another.  At the end of the period, a handful of the students hung around in the room and kept trying to tune to one another.  It was a pretty good indication that they, not only understood the concepts and the related skills, but that the importance of being in tune was made relevant to their musical lives.  Score!

So, I have to admit something to you all.  I have not been to the gym since my little spurt of motivation weeks ago.  I keep making excuses, telling myself that I just can't find the time.  Well, enough of that crap.  You don't find time for things, you make time for things.  So, I am going to be making time to both go to the gym and practice.  This is happening.  It has to!

You know that research study I have been working on for Dr. C.?  Well, we hit a snag on Friday.  The computer crashed.  And not a little crash, either.  The computer decided to completely fry the hard drive to the point that Windows wouldn't boot up.  I spent over 3 hours on the phone with the lead researcher trying to resurrect the computer to no avail.  I am not sure what we are going to do!

The big news this week is that I have my next semester all planned out and ready to go.  I will be taking:
  • Graduate Seminar in Music Education
  • Learning Theory in Music
  • Research in Music Education
  • Instrumental Conducting Seminar
  • Wind Symphony (pending the audition)
  • Night Owls Community Band
  • Independent Study with Dr. B. - College Marching Band Operations
It is going to be a busy semester, but that seems to be par for the course.  What's more, is that I talked with Dr. C. about transferring in my credits from the University of the Arts Summer Graduate Music Education Program.  She seemed to think that I could transfer them in.  If those credits go through, I can finish my coursework in 2 years, total!  That means I could actually finish my degree in 3 years, total!  Keep your fingers crossed, people.

Well, that is all I have for the week.  Next week should be a little more comprehensive.

Happy Passover to all!

Future Dr. Mitch, out!