Syllabus

Course Objectives

This course is an intensive review of information technology. It covers topics in software development methods, data modeling and databases, application development, Web access and development, system integration, security, and data communications. Most of the homework sets lead the class through a project in which a database, application and Web site are designed and constructed, using good software process and addressing security, network and other issues. The project, which is done in two-person teams, provides hands-on experience to complement the lectures and readings. A few of the homework sets are individual efforts to reinforce class materials. Recitations discuss reading and provide more detailed information on the software tools used. There is a final exam. Homeworks are 50% of the grade, a midterm exam is 20% and the final exam is 30%. Homework will be accepted up to 2 days late, with a 20% deduction from the grade. Each team member receives the same grade on the shared homeworks; the midterm and final exam have individual grades, as do the individual homeworks. Homework is due at 12 noon, before class, on the due date. The course goal is to cover the key concepts in the major areas of information technology, to enable students to successfully understand, work with and manage IT efforts as part of supply chain, transportation or civil engineering projects. No programming experience is required.

Homework Outline

Homeworks with * are individual, not group homework.

• Software process. *
• Requirements, initial design and project size estimates.
• UML. Data modeling and database design.
• Database implementation. Implementation of tables and relationships in SQL Server.
• Design of Web site. Implementation of static pages with MS Front Page® 2003.
• Web middleware. *
• Completion of Web site. Implementation of database access.
• Security. *
• Hardware and network design to support Web services.
• Software process assessment.

Gradings