Monday, October 28, 2013

10 Trip Tips: "So what did you learn?"



Two weeks ago, I took my high school students on a long-weekend trip to Chicago. On the two buses were 66 students, 17 chaperones, 2 directors and a "partridge in a pear tree" (a.k.a.  my student teacher). I have asked said student teacher, Kayne Edwards, to share the most important things he learned about planning a trip.

1. Small Details 
It is the small detailed planning that makes the biggest difference and takes the most time. Making sure every thing is set beforehand sets the tone for the whole trip and makes it a smooth process. Also, making sure students (and chaperones) have a pocket itinerary saved the hassle of continuously being harassed about what was happening next. Rehearse the trip in your mind. Where will there be potential logistically snafus?

2. Parent Participation
Taking a trip and involving the parent-chaperones gets them involved in the program. This is the perfect time to mingle and get them interested in participating in the future. Additionally, it can help to boost the strength of your program and possibly even gain some music booster parents/officers. The same goes for administrators. Make sure to keep them involved and included in the participation and planning processes.

3. Generating Interest 
By routinely taking a trip, you can gain student interest in the program. Letting future students know of this possibility can influence their interest in learning a stringed instrument. In addition, you can have students begin fundraising for future trips in your lower aged string classes and get them devoted to the program and looking beyond middle school. Make them think ahead about their future in the orchestra and you could increase retention.

4. Leave (Some) Room For Down Time 
This could go either way, however, when a trip is crammed with activities from 7am-11pm the students, chaperones, and directors never truly get to rest, recover, and reflect on what they have done throughout the day. I think it would be nice to have some relaxation time for every one so that there is not a feeling of exhaustion. Cramming the itinerary can prevent potential behavior problems; however, travel days can be physically and psychologically draining. Plan accordingly. 

5. Don't Overload The Chaperones
Bringing enough chaperones to equally distribute a small number of students is recommended. If the chaperones become overloaded and do not get to enjoy the trip, which they are paying for, it isn't likely that they will feel appreciated or want to participate in future trips/events/activities in your program. This was something interesting to see/hear from our chaperones on the trip.

(The following are additional points I would like to tag on.) 

6. FIND SOMEWHERE CLOSE AND MANAGEABLE, if this is your first trip. 
My cooperating teacher (during student teaching) was planning a trip to Italy with his high school orchestra. This is definitely not a good idea for a young teacher. In fact, I am not sure if this is a good idea for a veteran teacher. Find a location that you feel comfortable traveling. The students will have fun regardless. 

7. CONSULT COLLEAGUES FOR TRAVEL SUGGESTIONS
Ask around. There are many educators around the state that have used various travel companies - some choose to plan the trip themselves ... this is a huge undertaking. You should begin hearing some reoccurring names/companies. Do some research of your own and get some pricing and itinerary options. Find what is best for your students and meet the needs of your trip's goals.

8. SEEK APPROVAL BEFORE ANNOUNCING TRIP, and follow all district protocols. 
As it turns out, my timeline for Board of Education approval was far more generous than others'. To announce the details of a trip to students or parents without proper approval did not sit well with me. I got my ducks in a row, consulted our travel company for pricing and itinerary options, and presented the itinerary for board approval a full eight months before the trip. To show my appreciation to the BOE for considering the trip during their agenda, I attended the open meeting. When I looked at the dates of other trips, I noticed they were in a few weeks. "Hmmmm...," I thought. "Talk about counting your chickens before they hatch." What would have happened if the other organizations did all their planning but the BOE did not approve the trip?! This advanced planning earned me a shout-out from our superintendent at the meeting. 

9. STUDENT SAFETY IS PARAMOUNT
Emergency Medial Forms (EMFs) are a requirement for any school; however, our band and orchestra departments - through the encouragement of our school nurses - have our students complete a second EMF for our program. Think about it: pulling and photocopying each student's EMF and filing it back in alphabetical order is a nightmare. For individual students this is no problem, but when its the week before a trip and you are asking your school nurse to pull 60-120+, think again. Save your nurses' sanity - be proactive.

10. TECHNOLOGY CAN BE YOUR FRIEND
On the trip we utilized Remind101, Facebook, Twitter, Google Forms (Drive) and an iPad. Many of my students were already enrolled in our orchestras' Remind101 groups. It was through these that I invited travelers to sign up for an additional "class" for anyone wanting updates and reminders leading up to and during the trip. Through this new group various Google Form links were sent to gather important information before leaving: dietary restrictions, meal choices, emergency contact numbers, etc. and logistical information while on the buses or at the hotel. Prior to the trip I converted all EMFs to PDFs as well as the itinerary and form responses. These were downloaded to a school iPad for immediate access during the trip. Social media was used throughout the trip to keep our community, parents and administrators connected.

... also, think about how you are transporting your instruments. We used a 14' U-Haul truck driven by two awesome husband/wife parent chaperone teams. They rocked!





Saturday, October 26, 2013

PLN Resources: Ice Breaker Tags and Kaizena



Turn this ... into THAT in seconds! 





Do you fear retyping students' names, due to potential errors? Does entering student names for various documents and events become time-consuming? Want to learn how to complete these tasks in seconds instead of hours? 




Follow these 5 Steps and NEVER retype a student's name again! 
(Cue excited yelling by audience members attending taping of Oprah's 'Favorite Things' show) 

Microsoft Excel is an educator's friend. Why? Because the program's capabilities provide time-saving functions. The function presented below is my personal favorite and saves me from hours of headaches and frustrations. Similarly, if your school's music educators, coaches, secretaries, office workers, etc. do not know about this trick, be sure to share it with them! Can be used for concerts, banquets, athletic programs, graduation ceremonies, etc. The true value of this function occurs when there are many names being dealt with. 

When I receive an Excel spreadsheet containing my students' contact information, it typically appears in alphabetical order in this format below (with additional student address data, etc.) ...



Names in this form (contained in a single cell within Column A) are absolutely useless. Sure - I can sort by last name, grade and whatever other data are present in the columns, but it mets very few actual needs.


STEP 1: INSERT EXTRA COLUMNS
The first step is insert two additional columns (three or four to be extra safe, in the event a student has multiple middle names) to the right of Column A. Highlight Column B, right-click and select "Insert". Each word currently in Column A will be shifted into its own column in the next step.

STEP 2: TEXT TO COLUMNS 
Highlight Column A and select Text to Columns (under the Data tab). When doing this, the following window will appear.




Be sure "Delimited" is chosen and click "Next" 

"Tab" should automatically be selected, but ensure it is - as well as "Space".  
"Semicolon", "Comma" or "Other" provides other delimiting features.

Click "Finish" to proceed, I never worry about the Excel Wizard's "Step 3" 




STEP 3: REMOVE COMMAS
Following STEP 2, your document will appear like this. 

Results of Delimiting
We need to remove all commas present in Column A. Go to "Edit" and select "Replace". 


Enter the character you want to remove. In this example, we want Excel to Find "," and replace it with nothing. Select "Replace All" 


Excel will locate EVERY comma and remove it. By choosing various "Within" and "Search" parameters, Excel will be more selective. 


STEP 4: SAVE AS - for future use of middle names.
This is how the spread sheet now looks. For my purposes, I rarely use middle names so I often remove them after I "SAVE AS" the document, so I can salvage all the work I have already accomplished. Right click and clear contents.




Here is where the good stuff is about to happen. 

STEP 5: =B1$" "&A1
First, delete the contents of Column C and type (or click the respective cells) into C1: 
=B1&" "&A1 (includes a space) This will format all the names to appear as FirstName LastName 


Hit the Return/Enter key, and the cell will appear as below. Excel combined cell B1 (John) and cell A1 (Adams) and included a space (" ") between.



Click the small blue square at the lower right of cell C1. This will cause Excel to continue this formula throughout the document, automatically! 



See! I told you!



Add some space to Column C, to see the entirety of the names. 



By having additional data in the subsequent rows (instrument section, team, position, GPA, etc.) you will be able to sort the names in ways that suit your purposes. For example, I can sort Column D by grade (freshman-senior) and then copy and paste each grouping of names into a new document. 

IMPORTANT: You must paste by selecting "Paste Special". Depending on your software, there will be various options to choose. For example "Values" or "Unformatted Text". If not, the result of =B1&" "&A1 will show an error and/or be placed in a Word document within a table.





Results pasted into a word document.
Thanks for reading! 

Was this post helpful to you, or did you send it to someone else? 
Please let me know in the comments!