Sync scripts and clerkship reports updated for 09-10

As with the database table changes, there was a need to modify the sync scripts and clerkship reports files for the new school year.  Previous years have had little modification in the sync scripts and clerkship reports.  However, this year, I needed to make adjustments for the different tables that now store data for clerkship encounters and BCS encounters separately.  These modifications had to incorporate features that would know which database table to retrieve BCS encounters, depending on the year’s reports being viewed.  For instance, up until the 08-09 school year all clerkship encounter data, including BCS data was stored in the same db table.  The 09-10 school year’s BCS data along with future year’s BCS data, will be stored in separate db tables.  When a student, clerkship director, or CERTTS admin chooses a report year, the clerkship reports and admin tools need to know which table/tables to query the data.  Sync scripts also had to be modified to write Pendragon data to the correct db tables.  CERTTS admins have some additional tools they can use to create encounters, copy table data to other years, create BCS encounters from clerkship encounters, etc.  All of the student, clerkship director, and admin reports have been modified and are reflecting data correctly.  All sync scripts and admin tools are creating and modifying encounters and encounter data correctly.

Updated Pendragon Forms created for 09-10

With the new school year, there was a need to update the Pendragon clerkship forms that the students use to log encounters with any modifications desired by the Clerkship directors.  Each form has been modified based on the new requirements and will be distributed to the students during their next hotsync.

BCS report for previous year’s encounters

Dr. Humbert requested an Excel spreadsheet of BCS data for the 08-09 school year.  He wanted to review all encounters logged as BCS so that he may be able to detect trends in logging encounters.  That data has been exported into an Excel spreadsheet and sent to Dr. Humbert for review.  There may be some adjustments in the types of column data he would like to see in addition to the already created report.  If so, an updated report will be exported.

CERTTS Database updates for 09-10

The new database creation process for the end of the 08-09 school year and beginning of the 09-10 school year is complete.  This year the update/creation process was quite a bit more involved than previous years.  Dr. Humbert (BCS Clerkship Director) wanted the BCS reports to reflect data for students throughout their 4 years of logging BCS encounters rather than just the current year as previously developed.  Therefore, I created a separate database table to hold BCS encounters separate from all other encounters.  This also caused the creation of a separate procedure, diagnosis, history and miscellaneous tables for BCS encounters.  BCS data from the 08-09 school year had to be moved from the original tables to the newly created tables so that the student reports would reflect correct cumulative BCS data for the new year.  Along with the creation of these new tables, the sync scripts need to be modified for all forms that need to write a BCS encounter to the database.

Palm Treo Pro, Treo 800 and Samsung Saga CERTTS compatibility

Each of these devices will work with CERTTS for the most part, but there is an issue with the signature box used to get experience signed off. You actually have to sign the box above where the box appears to get the signature to work.

The best thing to do if you want to use one of these devices is to test this for yourself so you will see how it works. Sign a couple of encounters for yourself, and look at the results in Angel. You can delete them once you are done testing from the “view all of my encounters” link in the clerkship reports. It’s not hard to work around, but unfortunately you will have to let the person who is signing know about the quirk each time you get an encounter signed.

Palm Pre and CERTTS compatibility

I am working with Joseph Salfity, an MS 3, to keep informed about the prospect of using the Palm Pre with CERTTS. We were able to test this today for the first time. The short answer is no, it doesn’t work with CERTTS - at least for now. The problem seems to be that the emulator (Classic from MotionApps) does not recognize the network that the Pre is connected to. This means that the clerkship forms cannot be downloaded, and if they were downloaded there would be no way to sync them with Angel. The “Forms” program used for recording skills actually runs, but it is useless with no way to connect to the server to get the actual clerkship forms.

Since the Palm Pre is a new device, and the “Classic” program is in version 1.0, it’s very likely that this problem will be solved in the future. Thanks to Mr. Salfity, I’ll be testing this with each new release or update of the Classic emulator.

For those that want to purchase a Palm Pre, I am suggesting that they get a cheap or used PDA that will support the clerkship forms to get them through the time period where CERTTS does not work with the Pre. Please note, the possibility exists that the Pre might never work correctly with CERTTS but I remain optimistic and will keep checking.

Update 6/17/2009 - I contacted Pendragon Forms today and received note that they have updated their S-Link program to work under Classic on the Palm Pre. S-link is the portion of the Forms 5.1 program that connects to the server. A small but significant problem in Classic is keeping Pendragon Software from releasing the update. Apparently, the Classic application does not save state when it is closed (when the Classic card is whisked away) and also does not allow Pendragon Forms to close. Because of this, the Forms database loses any updates. In a nutshell, when you close Classic you lose the data that has been entered on the Forms.

Pendragon Forms is in contact with MotionApps on this issue. I am fairly optimistic now that this will be fixed with an update to the Classic app and that CERTTS will work soon on the Pre.

The last ANGEL user conference

ANGEL community at the House of Blues in Chicago

ANGEL community at the House of Blues in Chicago

I was in Chicago on Thursday and Friday for the 6th and final AUC. It was interesting timing since the acquisition of ANGEL Learning by Blackboard had been finalized earlier that week. I have attended all of the ANGEL conferences, presented at one, maintained the web and registration pages for two of the conferences, and served on the planning committee for the second conference in Indianapolis.

I have a pretty good perspective on the establishment and growth of ANGEL, albeit somewhat of an outsiders view. IUSM was an early adopter of ANGEL, back in the days when Dave Mills, one of the founders, would visit our site in person to troubleshoot and market new features of ANGEL. These were also the days when a support call might end up being answered with a code snippet that could be used to modify an ASP file that had a bug or needed more functionality.

From that point, in the space of around 8 years, the company grew and was purchased for $95 million. ANGEL Learning had just been voted earlier in the month as one of the best companies to work for in Indiana, and it always showed in the attitude and motivation of ANGEL Learning employees. I don’t believe there was any shortage of people who wanted to join the organization. At the customer appreciation event at the House of Blues, I had a chance to talk to a few employees, as many of us did. Most of them were just coming to terms with the shock of learning their company had been purchased, and wondering if they would ever find such a wonderful environment in which to work in their continuing careers.

Beyond the personal stories, I went to the conference to learn about the future of the product and what would change in the coming year. IUSM’s contract with ANGEL lasts one more year, so in 6-9 months I will need to be very informed about alternatives in case a choice needs to be made. ANGEL 7.4 is out now, and I will be upgrading our system this summer. This version seems like it would provide for our needs for at least two years, and the CEO of Blackboard tried to assure the ANGEL community that pricing would remain consistent for the forseeable future.

Michael Chasen, CEO of Blackboard, made himself very available during the conference. He even posted his email and office phone and invited people to contact him. It felt to me that he was on a marketing mission the entire time. I don’t mean this in a negative way, he really had to try and assure the ANGEL community that important lessons had been learned from mistakes made in the past, especially in the area of user support. The feeling I went away with was that the community is optimistic and would like the ANGEL product to continue the established tradition of innovation and customer oriented development, but we don’t completely believe the hype coming from executives.

One of the toughest questions I saw the CEO face was on the subject of corporate culture. Someone expressed concern that the LMS they used was now owned by a company whose strategy of growth seems to be acquisition and litigation. The question was answered in a politely defensive manner, explaining why previous acquisitions had been made and admitting historical mistakes. Along with this explanation, I sensed that the CEO defended his actions by proclaiming that everything the company has done was with the best interests of the educational community in mind. Believing this was a stretch for me, knowing the corporate culture that seems to pervade today.

In all, my knowledge of the event is increased but my strategy has not changed. I am researching LMS offerings so that I can be an informed consultant for the choice that IUSM makes for the future, whatever that choice may be.

ANGEL Learning acquired by Blackboard

In the late afternoon of May 6th, I learned along with everyone else that Blackboard was planning to acquire ANGEL Learning. I immediately began to think about the future of the ANGEL LMS at IUSM. Others around the country were having the same thoughts, and the ANGEL-L listserv lit up with questions and concerns for the future. Most were not optimistic, especially in areas of pricing and support. Here at IUSM, we have 2 years left on our ANGEL license, so I don’t expect that changes in our system will be significant for some time. Still, any migration to a new system would be a big change for our faculty, so I need to be completely informed about competing products.

Sakai is a logical first step in the discovery process. It already powers Oncourse, which is used by the IUPUI campus. It doesn’t have the flexibility of ANGEL but I need to find out exactly what that means for our environment. I requested an Oncourse test account this week, and am working through recreating an IUSM course on Oncourse for demonstration. I don’t expect that IUSM would choose to use Oncourse, we would probably maintain our own installation of Sakai. Granted, a lot may change in the next two years that I will need to be ready for.

Another interesting product is Epsilen, and I am somewhat familiar with this product since I maintain an electronic portfolio using this tool. Epsilen is hosted, so this would offload all of the system administration and we would concentrate on course curriculum, development and support of faculty. Similar to Oncourse, I have created a test course in Epsilen so that we will have something that can be demonstrated real time.

Later this week is the ANGEL user conference, and Blackboard representatives will be there. A future roadmap for the ANGEL LMS will almost certainly be discussed, although at this point I would tend to believe that it will be rooted in marketing. I’m very curious to see how this will play out - many institutions that use ANGEL came from Blackboard and have no interest in returning. The mailing list is teaming with stories of how support from Blackboard fell off the cliff when WebCT was acquired by Blackboard, so Blackboard’s poor track record is on full display in that forum at least. As of now, this list has 1,172 subscribers.

Dean’s office interested in promoting ANGEL

I met with Megan Palmer and Jon Eynon today from the Dean’s office. They were interested in getting an overview of how ANGEL is used at IUSM and what can be done to get teaching faculty to increase their knowledge and use of technology in their courses. Megan is organizing an instructional technology expo for faculty to come and get some ideas about how to use technology as a learning tool. I will be there to demonstrate ANGEL and to cooperate on informal training.

Today I jumped around inside Angel courses a bit, showed them what students see when they use Angel and talked about how Angel has become a portal to most resources available for students. Jon was interested to know that HTML content can be developed and zipped up for easy importing into Angel. I showed them the Anesthesia cases, which are admittedly a bit dated now, but a good example of how HTML content that spans multiple pages can be brought into Angel.

Megan would like to come to a consensus about what workstation tools faculty will need to develop effective online courses, and pass that to ISTM as a standard “Angel build”. That way, faculty could request this and their PCs would then have what is needed, and could be supported in a standard way. We also discussed how Angel courses need to have some minimum standards, such as a syllabus and best practices for uploading and displaying course content.

At the IUSM, we do not have any faculty teaching and development staff, although in the past year some library faculty have become more proficient in ANGEL and are doing some of this. Because of this, Angel usage is across the board. Some faculty use Angel to post a course schedule only, some as a document repository, and still others use many more functions such as discussion forums and interactive content. The push to use Angel has not come from the School since MECA lost Dianne Wyman a number of years back. For myself, as the Angel administator and go-to Angel person, I certainly have the skills to do this but not the time within my current role. I indicated in the meeting today that I was glad to see an effort towards instructional technology from the school level, and would be glad to work together with others to raise the awareness of what faculty can do with technology that is available right now.

Point of care PDA Pilot in Kenya

I’ve been fortunate to meet a couple of doctors from Kenya who are visiting through the Moi partnership with Indiana University. Dr. Okoth, whom I know as Biko, comes into our office quite frequently. He became friends with Wilfredo and is interested in PDAs because he believes that this technology would help improve patient care in Kenya. The Kenyan doctors want to test the effectiveness of UpToDate, a medical reference tool, at Moi hospital. This will cost around $300 per device to license. I met recently with Biko, Dr. Faiz Rehmani and Dr. Deb Litzelman to try and make this project work.

My role in the project is to identify affordable hardware and to preload the devices with a survey and data collection method that will help determine the usefulness of the PDAs for the registrars in Kenya. Registrars are somewhat like Residents here in the States if I understand correctly.

I contacted a vendor last week who sells refurbished Palm TX hardware, and I recommended we order 10 of these at a cost of $145 each. The budget for entire project is $5000, so it was good to get capable PDAs cheaply so that money will be available for software licensing. I hoped that the devices had new batteries installed, but the salesperson was not able to tell me this fact. She did assure me that the devices were in excellent condition, and came with a short warranty period. I told the group that if we needed to purchase new batteries it would only cost us around $20 each, and I can replace them. It’s worth the small risk in order to stay within the budget. In this particular case, UpToDate is the cost we’re working around.