Systems in Music Therapy: Databases, Access Files, and all Things Google

I am someone who yearns to be organized but who saves my successful organization systems for things other than my house. My clinic area is organized, arranged, and completely functional for what I use it for. My house is not, and my house is always a place where I want to be better (but rarely am better).

My best organization system is my electronic systems. While I prefer paper and pen for my planning and brainstorming processes, I am all about digital organization structures. In my life, I use Google Forms, Access, and Excel the most. Of the three, the most enigmatic for me is Access, but it works for what I need it to do.

Access is what I use for my clinical documentation. Each client has a file and the system allows me to make forms that keep records of all points of contact with every client for the duration of their stay with us. I can also move these files around as classroom assignments change and as clients leave and then return to our program. I do not know much, but I know enough to set up the database and make it work for me. At the end of it all, I can print out a spreadsheet of all points of contact with my clients when it is needed. I have a series of checkboxes and dropdown menus to help make doing up to 50 client notes per day faster. It has been a system that I have been using since 2017, and I am comfortable with using Access for that purpose. One of these days (quest for 2023??), I will learn more about Access and how it can be used for various things.

Excel is the program that I know the best and is the one that I go for first when putting together lists of information. I have a large Excel file for my therapeutic music experience list. It includes so much information in that one file (multiple, cloud-based copies of this list as well...) that I would be lost if something ever happened to it. It holds the information and work of about 20 interns in addition to all of my own work over 30+ years.

My most recent addition to my digital organization milieu is Google Forms. I use it for just about everything that requires responses from someone other than me. If I ever get motivated to start, I may end up transferring information from my Excel file of TMEs into Google. I could add more keywords and some different features if I did this - I know how to set those things up, but I'm not sure I will ever get that motivated.

The thing that I like about Google Forms is that I can easily see aggregates of information, but I can also download everything into a spreadsheet similar to Excel's format. As a person who is most familiar with Excel, this makes me feel comfortable. It is nice to work within a system that is familiar to me.

I am going to be establishing a Google file for my inventory list, one for here at home and one for my materials at work. This will probably be my project while I have no interns at the facility - a stretch from February through June, probably. I have an inventory started for both places (in Excel), but I think that I can do more things if I put the information into a Google form. I can also make different forms for different types of materials - so a form for visual aids and another for instruments. Once the information is included, I can then combine the information into one ginormous master spreadsheet. That's a very satisfying result and one that I have experienced before with other elements of my life.

What systems do you use to arrange elements of your life? What do you arrange in this way? I think that I could use Google Forms to arrange intern assignments - thought for interns #36 and 37 - they could finish up the form, upload their file, and that would give me an emailed prompt that the assignment is finished. I could also set specific due dates via a calendar that could prompt me to ensure that interns finish tasks as assigned or talk to me about changing their due dates. That's something we've been struggling with lately...Lots of things to think about here. I will probably spend some time thinking about and trying to work within the platform to see if I can get what I want to get from this sort of system. Lots and lots to think about...

Happy Friday.  

Comments

Post a Comment

Popular posts from this blog

Dear AMTA

Dear American Music Therapy Association: I am debating long and hard about remaining in this relationship. I have been in this relationship since college, and this is not a decision that I am taking lightly or without great cost.  I am not happy with what you are bringing to this relationship. Now, I have been a selfish partner over the past several years - mainly because I am not feeling like we share a common mission anymore. It is easy for me to place the blame on you, but I know that this is not all on me. I have tried to be invested in communication and support and understanding, but everyone comes to a time where enough is enough. I am trying very hard to decide if the benefits that you provide to me are worth the feelings that I have about where I think you and I are going. I am not sure that our destination is the same anymore, and this makes me sad. To be completely honest, I am only in this relationship these days for the music therapy interns. I don't think that is a hea...
Read more

Songwriting Sunday: Repetition

Image
One of the things that I find to be helpful with my client population (children, adolescents, and young adults with dual diagnoses) is repetition of phrases, lyrics, and music. As a result of 30+ years of working with this population in various iterations, I have found that my clients respond the most to songs with three repeated phrases to prime their responses with a different phrase to communicate the important part of the experience. DISCLAIMER: This is not a definite way to write music for clinical interactions. This is what seems to work well with my particular group of human beings. Don't go to your supervisors and tell them that I told you that this is the ONLY way to write music - It is NOT! You have to find what works for your clients and for their clinical goals. Since my clients respond well to this type of song, I tend to write songs in this format more than any other. What I have found is that my clients remember these songs more than the ones that I do in different f...
Read more

Being An Internship Director: On Hiatus

Image
It has been long enough since I have had an intern that I am seriously feeling like I have little to say on the subject. At the same time, I am currently writing Chapter 5 of my general internship handbook, so I am able to write about being an intern and what types of things to think about during this important time in our professional development. It is a strange place to be in, and it is one that is a bit challenging for me. Right now, I have had three vacant internship positions since the beginning of the calendar year. I will have a vacant position next month and that will be an entire year of rejected offers. In the past nine months, I have offered positions to three applicants who have declined. It is interesting how people complain that there aren't enough internship programs, but programs like mine are empty. I guess there aren't enough internship programs that pay large stipends (which mine cannot) out there. I get it. It is interesting to me how we have moved from an ...
Read more