Monday, March 22, 2010

Music Teacher's Office Web is here!

I have just finished and launched the all new web version of Music Teacher's Office.

It has most of the functionality of the LAN desktop version but eliminates all that as it works though a web browser now. No server to purchase or setup. No network to install. All that is needed is a computer hooked up to the web.

I have used Visual WebGui to create this application. It allows developers to create web applications that mirror the functionality and ease of use that desktop applications enjoy.

It has been over a year in the making so please give it a look at Music Teacher's Office

Thursday, March 27, 2008

Just never enough time to do it all!

My! It's really been a long time since I posted here but it seems there is never enough time to do all I want to do. I really will add the next part to Music Teacher's office but I became distracted.

I sell guitar parts among other things on eBay. So when their new policies rolled out in January I made the the decision to create our own Weed Music Ltd. Web Site to sell those items as well as I feel that eBay cannot be trusted or counted upon as viable venue to sell in the future. So I created our own Weed Music Ltd. It has a shopping cart and a shipping calculator that calculates the correct shipping using Canada Post.

...Anyway that is what I have been busy with.

I need to drive traffic to it so I am posting in blogs and plan to do a lens etc. I also plan to do some videos not only for installing guitar nuts and saddles, Changing strings and tuning but I would like to make some how to videos for Music Teacher's Office. They are coming it's just a matter of time.

Monday, November 5, 2007

Music Teacher's Office End to End Coninuted Part II

As promised I will continue the discussion about Music Teacher's Office. Today I will elaborate on the problems that we wanted to solve as well as the problems encountered devising the solution.

As it became clear that what we needed was real time information about the students status and progress to be made available to all the relevant players, administrators, teachers, parents and students. Administrators, parents and teachers needed to know if the student they were teaching had actually paid for the lesson. Administrators needed to know what lessons had been taught to quickly and accurately calculate payroll. Students needed to know what their lesson assignment was, when their next lesson is and dates of recitals. Administrators also needed a way of monitoring what was actually being taught so as to be able to help with improving the quality of the lessons being taught. All this needed to be done in a fashion that was easy to use and actually improved efficiency in the business flow.

The only way to achieve this was to set up a computer network where the teachers and the administrations were all working off the same page at the same time. We needed a database placed on a server with all the information and a Windows application on each computer on the network that would access and update the data in real time for all to share.

Another major problem was getting the information to the parents. If you have ever taught in the schools or elsewhere for any length of time you quickly become aware of the fact that getting information home to the parents is a monumental task. Kids just don't communicate with their parents. You can't rely on kids taking information home especially the important stuff. When teaching in the schools as a band director for years the only thing I could really count on when I needed to contact a parent was to pick up the phone. But now with email it is very easy to fire off an email and you can almost be sure that it gets to the right party. So we knew that email had to be a part of the communication equation.

Scheduling teachers, rooms, and lesson times that is in constant flux was another major challenge that music schools encounter. When we were scheduling with pencil and paper there was always room for error and there always were errors. But with the computer we could set things up to eliminate most of these errors. Now it goes without saying that no systems is completely bullet proof but what we ended up with at least gave us a warning that our human errors might result in problems.

Creating flexibility in scheduling for different music studios and schools also presents many problems since no school or teacher works in the same way. Each school or studio teaches on different days of the week, different times, different instruments, lesson lengths, charge different tuition amounts, maybe different amounts for each teacher. They pay the teachers in different ways. Music Teacher's Office addresses all these factors and more and allows each school to customize how they do business.

Since many talented students take lessons from more than one teacher during the same session the system needed to be able to provide for multiple registrations for each student.

Scheduling group lessons could be problematic as the studio needed to take into account the number of students that would be allowed in a particular studio at one time not to mention registering, scheduling and invoicing.

Another problem that needed be addressed was that from year to year schedules changed, tuition amounts changed and if you needed to take registrations for the next term while still working in the current year the system needed to be able to work in one or more schedules or years at the same time.

The quality of education in the school being provided was also a concern and by having access to all the lesson assignments given by the teachers to the students could also be a great problem solver. Being able to track the students assignments could be a great tool in helping teachers that were having problems with students and addressing possible problems before they happened.

Having this digital log of assignments and student progress also provides a selling point when selling lessons or when having disagreements with parents or students if they challenge whether a lesson was actually taught or not.

Securing parent and student information was a prime concern as well. In todays world of the internet keeping customer personal information secure is a legal obligation and if not handled properly could be a disaster for any business including small music studios and private teachers. Originally I had entertained the idea of making this a web based application but finally leaned toward a more cautious approach by keeping the data on the schools local area network or computer rather than on a web server. Now in this day and age nothing is really secure but keeping personal data of parents and students off the web greatly reduces the chance of security breaches and puts the responsibility of security on to each individual school and teacher. This spreads any potential risk out to smaller entities rather than having the data of thousands of schools, teachers, parents and students in one place. Even though a web application would have been more flexible in some ways a local database is far more secure and I feel a better solution than keeping data on a web server. Especially when dealing with kids.

Thursday, November 1, 2007

Music Teacher's Office - End to End

Over the next few weeks or so I am going to cover Music Teacher's Office from the beginning to end. From is birth out of necessity to the features, benefits and best practices on its use. So to keep this organized I will start with an outline of topics.

  1. How and why it all started
  2. The Problem(s)
  3. The Solutions(s)
  4. Setting Defaults Nity Grity
  5. Best Practices - Administrators
  6. Best Practices - Teacher
  7. Recap

How and why this all started

Since 1992 my wife and myself have been running Weed Music ltd which is a music retail store and large music school. Around 1998 - 1999 it became apparent that there had to be a better way to run a large music school. We needed a tool that not only kept all of our ducks in a row business wise but actually and a positive impact on the quality of teaching in our school.

Up until 1998 we had created a great school manual that laid out procedures for registrations, invoicing and lesson forms and life was good.

We did very well with pencil and paper for registrations and had an easy to use multiple copy registration form that gathered all the parent and student information and an area where to record payments. We created multiple copy lesson assignment forms to record weekly assignments so that one copy stayed in the lesson log book to calculate pay and the other went with the student. The system worked great about 65% of the time but there were a lot of cracks in the system where a lot of tasks and information could fall through.

When we started to get a large number of students and teachers using the system these cracks became larger and larger.

How it worked was this way. When a payment for lessons was recorded to the registration form and then we added corresponding lesson assignment sheet to the teachers lesson assignment binders so the teacher knew that the lessons were paid for and they were not teaching for free.
The registrations form worked great until you had a payment or check go bad or had a student cancel lessons. If a check went bad and for some reason you forgot to pull the lesson sheets out of the teachers binder or could not because the teacher was using it at the time the student could walk in and take the lesson without it being paid for.

So that in a long story is the problem. What the administration and staff really needed was real time information about the status of the student. This was just not possible with pencil and paper.

So with that revelation I went looking for software. I looked at a couple of systems that were tied to music retail software and they did nothing for scheduling, or recording student assignments or achievements not to mention teacher payroll. I spent a lot of time surfing the net and trade shows and found nothing that would work the way I felt it needed to. This was about the time I was spending a lot more time on the computer and I found a book called VB6 Databases published by Wrox. Well, that was it. I had taken a basic computer programming course in my last year at the University of Montana and this book refreshed my zeal for coding. I knew then that I had to create my own Windows application to solve my problems. In about 1992 I made the step up to VB.NET in Visual Studio 2002 and never looked back.

So I guess thats how this journey began. We had a problem that needed a solution that did not exist until now.

Next time I will elaborate on the problems.

Tuesday, October 30, 2007

Laur's Blog - a composer and arranger.

Its time to add another entry to this work and was finding it hard to find something to write about and I was reviewing my wifes blog at Laura's Blog and thought I would give Laura and her new site a shameless plug.

Laura is a very talented composer, arranger and teacher. She has not been as productive as a composer and arranger until as of late. But ever since I have redone her website to include a blog, a shopping cart with the means via a desktop application to update her site on her own I see her less and less.

She spend most of her time composing now and preparing a book of Christmas songs and has set a deadline of Nov. 18th 2007. She also has had time to make a few blog entries about a local concert by Arne Sahlen and an article about a musical love triangle that those music history buffs will want to check out.

Over all I am please with the site, She loves it and I just need to do some more SEO on it to get it some traffic.

Since this blog is about Music, Teachers and being at the office I thought this would be a good way to start to expand the scope of topics on this blog and will start to add more articles about teaching and the business of teaching music.

More Later

Wednesday, October 24, 2007

The Original MTO has a new Name!

Over the past few weeks I have rebuilt the original Music Teacher's Office for private music teachers and have renamed it Private Music Teacher's Office or Private MTO.

I did this for a number of reasons. One, it was dated and needed an update. Two, it is really the same application as MTOPro but with out features so it will really be like maintaining one set of code rather than two. Three, I have added an advertising scheme to the teaching pages to generate some revenue to keep things going.

All in all I am very happy with the new product as the features now will make it easy for users to go from one MTO to the next.

You can get all the information and download at Music Teacher's Office

Thursday, September 27, 2007

Version 1.0.0.5 is now available

Wow!
It's been almost a month since I have posted on this blog, but it's been really busy out there. I created a new guitar parts website called Giitarparts.com. It is designed to help guitarists find the right guitar nut, saddle or other parts. It has a cool part finder database, but lo I digress.

Since we have been using Music Teacher's Office Pro at Weed Music full time this past fall I have found and fixed a few glitches and at the same time made the teachers GUI a bit more intuitive in this version. You can get by clicking Here.

But over all there have been very few glitches and I was really please when this morning I entered all of Octobers lesson payments and the new GUI interface saved me a ton of time. Anyway give it try!