COAP 2120: Data Handling on the Web

Michael Hahsler <hahsler@ai.wu-wien.ac.at>
Vienna, Spring II 2002

News

May 10 is the final deadline to submit the documentation and the prototype. The documentation and the project-folder have to be sent by email to me (use winzip or other tools to create an archive of all your files and email the archive).

Course Description

Students will learn how to prepare information for an Intranet using a variety of business software tools. This will include converting documents from Word, Excel and Access databases into a format that is compatible with the Web, using HTML, XML and Adobe Portable Document Format. Dynamic Web publishing technologies will be introduced, using Microsoft Frontpage, SQL, ODBC and ASP.

Download the Syllabus of COAP 2120

Required Text Book

Jim Buyens: Step by Step Web Database Development, Microsoft Press, Redmond, WA, 2000
ISBN: 0735609667

Additional Resources

Examples used in class.

Additional manuals and tutorials can be found in the Tools & Manuals online library.

Term Project

Each Student is required to analyze and implement a Web application of his choice. This application must consists of Web pages with a connection to a database.
The topic as well as the scope of the application will be discussed in week 3. Progress will be reported weekly.
In week 8 each student has to submit and present the project. It consists of the working Web-based application together with the documentation (use this documentation template).

Course Schedule

Week 1 Review of Web Development Techniques
Topics: Internet Architecture, Review of HTML, Cascading Style Sheets, Conversion of Office Documents to PDF
Reading: Text Chapter 1 and 2
Material: Slides, HTML Primer, Learning CSS, Adobe Home Page (PDF)
Assignment: Built a personal Web-site about the classes you took at Webster. Write plain HTML code with a text editor. The site has to use CSS, tables, images and some of the papers you wrote for classes. The assignment is due week 2 on Fri.
Week 2 Databases and the Web I
Topics: Relational Databases, SQL
Reading: Text Chapter 2 and 3
Material: Slides
Assignment: Will be given in class.
Week 3 Databases and the Web II
Topics: ADO,ODBC
Reading: Text Rest of Part 2
Material: Slides, MS Universal Data Access
Exam: Friday, Mid-Term Exam on Week 1, 2 and 1. Class of Week 3
Project: Introduction to the Project
Week 4 Developing Web Applications I
Topics: Server-side Scripting, ASP
Reading: Text Chapter 7
Material: Slides, Building ASP (MS) VB Scripting (MS)
Project: Start of Project. You have to have a topic for your project.
Week 5 Developing Web Applications II
Topics: Scripting
Reading: Text Chapter 8 and 9
Material: Slides
Project: Progress Review
Week 6 Data Integration with XML
Topics: Concept of Markup Languages, SGML, XML, XSL
Reading: Text Part 5
Material: Slides XML at W3C, XSL at W3C
Project: Progress Review
Week 7 Working on the Project
Project: Final Review and Submission of the Documentation Draft
Week 8 Project Presentation
Project: Submission of Student Projects