Not Just Another Pretty Course Web Site
        
        
        
        About three years ago, our department head challenged our faculty to develop 
  a Web site for each and every course they teach. The rationale was that students 
  need support for what happens in the classroom and the Web could be the most 
  flexible and efficient way to do that. The Web allows us to relay important 
  announcements to our students through, for example, e-mail, an electronic bulletin 
  board, and even something as simple as a pop-up message. It also serves as a 
  distribution point for materials, such as instructional supplements, assignment 
  handouts, or presentations. 
Now our department head wasn't irrational. He knew that the faculty couldn'tor 
  wouldn'tmeet this challenge without support. We began to tirelessly develop 
  static Web pages for each course. Subsequently we trained support stafftypically 
  secretaries and/or graduate/student assistantsin basic Web page editing so 
  that they could make the necessary updates. Realizing the tediousness and inefficiency 
  of this task and knowing that developing static Web content was fast becoming 
  an obsolete strategy, these practices didn't last long.
At the time, one of our alternatives was to use a well-known course management 
  system that was available throughout campus. However, a number of the faculty 
  had attempted to use it in the past and weren't pleased with its options, functionality, 
  or reliability. Furthermore, we had little control over the system at the departmental 
  level. This inspired the in-house development of our own system. The end product 
  of this development has been in operation for over a year now, and early feedback 
  has been very positive. Let me mention that the term “system” suggests the development 
  of an elaborate monstrosity. On the contrary, our “system” merely uses common, 
  run-of-the-mill Web technologies.
The system uses Active Server Pages to create dynamic Web sites. Data needed 
  to create a site for each course taught in a term is imported into a database 
  at the beginning of the semester. For simplicity in management and because it's 
  so small, each course has its own individual database. The database contains 
  pre-defined tables for the materials that will be uploaded, grades, information 
  about the students that will populate the course, and more.
Next, through a Web-based interface, faculty members and their support staff 
  simply have to manage files and/or fill in forms to further develop their course 
  site. For example, if the faculty member has a handout that they want to distribute, 
  they log in, go to the administration page for their course, and complete a 
  form. The form includes fields for a link title, a description of the file, 
  a classification (e.g. handouts, assignments, lectures, etc.), a field to specify 
  a time frame (data), if desired, that the file will be accessible, and a field 
  used to browse and select the file to be uploaded. So, with only a few clicks, 
  they have added content to their site.
The system allows them to upload almost any type of document (e.g. HTML, Word, 
  PDF, PowerPoint, etc.), then dynamically creates the link, with the text specified 
  in the link title field, to the file being uploaded. The page that the link 
  is included on is based on the classification, so you could have a separate 
  page for handouts, assignments, cases, and so on. Those classifications are 
  predefined but can easily be changed at the instructor's request.
The system also includes an online grade book for each course. Grade management 
  also works through an upload/download process. The instructor simply manages 
  grades in an Excel workbook and saves that workbook as a CSV file. Then, the 
  file can be uploaded directly into the system. When it's uploaded, that file 
  populates the grade book table in the database. If the instructor needs to update 
  grades, he/she can simply download a copy of that file, which the database generates 
  through an automated export process, make the necessary changes, and repeat 
  the upload process.
Other features include an e-mail distribution list, course announcements section, 
  and a links archive. The e-mail distribution list is automatically created, 
  for each class, from the student profiles. Through a Web-based e-mail option, 
  the instructor can send e-mail to the whole class without having to use normal 
  e-mail software to create a distribution list. This is ideal for simple message 
  distribution. The instructor also has the option to change the text (or “announcement”) 
  that is displayed on the course home page. This announcement section lets the 
  instructor give the students information, for example, about upcoming assignments, 
  class cancellations, and the like. Maintaining a links archive is another optionthe 
  instructor can provide the class with a list of links relevant to the course. 
  Finally, if they so desire, instructors can request access to a discussion forum 
  for their class that allows for online collaboration. I should mention that 
  the discussion forum tool used is an off-the-shelf system that we integrated 
  into ours.
From the standpoint of the student, they first must register for a departmental 
  portal account. Once logged into the portal, they see departmental announcements, 
  they can create a list of their own links, and they can browse a list of current 
  course Web sites. This list allows them to add links to the courses they are 
  currently enrolled in. The end result is one-stop shopping, sort to speak, to 
  each of their courses from anywhere they have Web access. It lets them easily 
  retrieve coursework supplements, review lecture material, review grades, and 
  communicate with the instructor. This, in fact, is beneficial to the instructor 
  as well because they can manage course content from anywhere too!
When students enter the course for the first time, the system asks for verification 
  that they are in the class. When they complete the verification, data relevant 
  to them (first and last name, e-mail address, etc.) is added to the course database 
  tables, thus creating a student profile for that student, in that course. This 
  is when the student is added to the grade book and the e-mail distribution list.
Finally, the elegant simplicity of the system has led us to migrate from the 
  above mentioned campuswide course management system to a complementary system 
  for delivery of our Web-based Executive MBA program. Thus, we were able to meet 
  different instructional needs with similar technology.