Content and Results

Chapter 6 - Teaching Technology for Community
Managing IT in Government, Business & Communities
by Gerry Gingrich (ed)
Idea Group Publishing 2003

	Brought to you by Team-Fly

In the course, students learn to use software tools for such computational tasks as composing and editing Web sites, maintaining and manipulating databases, and creating CD-ROMs. The students study the process of turning an idea into a useful software product and methods for evaluating that product in terms of usability.

In the first three weeks of the semester, students put their new computational skills to work by creating "guest books." A guest book is a dynamic Web site where users can enter or retrieve information. That information is stored in a database. Each guest book is developed independently by one student; it may have any purpose and design that the student chooses. This assignment gives all of the students a common experience, a common vocabulary, and a common set of computational tools. The guest book represents a substantial piece of individual work. For students who enter the course with little computational experience, designing a Web site, creating the database, and hooking the two parts together is a major accomplishment.

The remaining weeks then are devoted to completing a computational project in collaboration with a local community service agency. Representatives of the agencies meet with the students in order to refine the project ideas generated at the workshop, and they later work with the students to test and evaluate prototypes. To date, all of the projects have been Web-based although that characteristic is not a requirement of a course project.

While representatives of many agencies have played some role in the course, some of the most important projects to this point include:

• A self-paced introductory tutorial about computers and the Internet for Boulder Senior Services,

• A variety of educational products for Sojourner Charter Middle School,

• A game for fourth graders simulating the ecology of a local marsh for the Boulder Valley School District, and

• An on-line events scheduling calendar for use by local non-profit agencies, developed for the Boulder Community Foundation.

While most of the projects satisfy small-scale needs of the client agencies, a local bank executive who is very active in non-profit work expects the events calendar to save local non-profits $100,000 a year by reducing events-scheduling conflicts. The full set of projects is showcased at http://www.cs.colorado.edu/VDC.

	Brought to you by Team-Fly