Data Handling on the Web
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).
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
Examples used in class.
Additional manuals and tutorials can be found in the
Tools & Manuals online library.
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
- 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
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
Assignment: Will be given in class.
Week 3 Databases and the Web II
Reading: Text Rest of Part 2
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
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
Reading: Text Chapter 8 and 9
Project: Progress Review
Week 6 Data Integration with XML
Topics: Concept of Markup Languages, SGML, XML, XSL
Reading: Text Part 5
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