Open Menu Close Menu

Web-Enabled Databases to Support Teaching

At the 1999 inception of course management at MU, a mere spreadsheet was adequate to keep track of the few dozen instructors who were early adopters of WebCT. As the popularity and sophistication of CMS usage increased and as Blackboard was added to the mix, the campus needed an adaptable system to (1) streamline the process for faculty signing-up to use BlackBoard or WebCT, (2) keep track of which faculty members were teaching which courses in the two systems, (3) manage courses over time so that an accurate historical record could be kept, and (4) facilitate the course creation, backup and copying processes from semester to semester. Although both BlackBoard and WebCT have a variety of internal tools designed to aid teaching and learning in online environments, neither system has what MU's ET@MO staff needed to manage and integrate the information that the two course management systems contained separately. As the number of support staff grew and the computing environment became more heterogeneous, an easy-to-use, cross-platform solution was needed so that multiple staff members could access and compare information.

Using FileMaker Pro, ET@MO staff created online course site request Web forms that feed directly into a database that contains information about the WebCT and BlackBoard courses offered in the current semester. Staff verify the information that faculty provide, making corrections as needed. Staff also import data from the university's distance learning administrative unit thereby eliminating the need for those faculty members to request a course site. Once data are verified, the five-member course management team can access the data simultaneously and "divide up" the creation of new courses based on platform, originating department, and several other criteria. This shared process helps balance the workload among staff at crunch times, especially at the beginning of the semester. To ensure that there is a historical record containing both faculty- and course-specific information, staff members use embedded macros to "push" final data from the short-term database to a permanent database. Having accurate historical records has enabled better planning for course management system growth, and also has helped various departments, schools, and colleges identify new possible degree programs from coherent groups of courses already using online technologies in significant ways. In Fall 2004, more than 60,000 students enrolled in approximately 1,200 WebCT and BlackBoard courses across the entire university curriculum--including face-to-face courses as well as courses offered completely online.

Facilitating Mid-Semester Course Evaluations

The University of Missouri has offered pencil-and-paper mid-semester evaluations for many years, but it has been a time-intensive task. First, faculty members needed to carve out at least 15 minutes of class time to conduct the evaluation. Next, university staff had to collect, tabulate, summarize (often re-typing hand-written comments to protect student anonymity), and then return paper summaries to faculty members. This process could literally take weeks, wasting valuable time when teaching improvements could have been implemented. Further, students felt that their comments were too late to bring about beneficial changes while they were taking the class.

To address the challenge of providing timely feedback, ET@MO collaborated with MU's Program for Excellence in Teaching (PET) to create an online "Early Feedback" teaching evaluation system. First, staff from these two units adapted the paper-and-pencil course assessment to an online format for faculty members who voluntarily requested the service. Next, Filemaker Pro automatically sends students in each course an e-mail message linking to the online course evaluation form which, when submitted, feeds into a database. With FileMaker Pro driving the system, staff are able to quickly generate feedback reports for each faculty member's course, save these summaries in PDF format, and e-mail them to faculty as soon as their students are done providing feedback. This tabulation process--which literally takes only a few seconds of staff time per course--gives faculty members access to timely information with which to improve teaching before the semester is finished. The time savings also frees staff for increased consultation with faculty who want to discuss new teaching strategies. In the past two years, this service has grown tremendously, and is now used by more than 500 courses each semester.On Likert scale questions, results from the 33 percent online response rate were found to be statistically similar to the 81 percent paper-and-pencil response rate. On open-ended questions, students were found to comment on twice as many different components of the course, and to provide twice as much description about each component when compared to the face-to-face version. Because of FileMaker Pro's easy-to-use interface and cross-platform compatibility, office staff and graduate student assistants from both support units can easily serve faculty from any FileMaker-equipped computer on the Internet. Version 2 of this system, which will allow faculty to use default questions or create their own, is under development and will be deployed in Spring 2005.

Like many other universities, the University of Missouri-Columbia has experienced rapid growth in the number of information technologies and systems serving its educational mission. FileMaker Pro has been an indispensable tool for allowing the staff that serves the campus to coordinate and innovate their services in this complex learning environment.

comments powered by Disqus