Interactive Web Sites - CIS47

Weekly Schedule

Week Information
Assignments due in one week and programs in two weeks unless otherwise stated
Week #1 Assignments
Week of January 20th
Read chapter #1, #2, and #3 in the text Database Driven Web Sites. See me about a copy of the text if you have not gotten one yet.
Let me know how well you know Access. If you don't you should play with it.
Week #2 Assignments
Week of January 27th
Please skim through chapter #4 (you know most of it) and read chapter #5 in the text Database Driven Web Sites.
I find that I learned this material best by trying to do much of what they did with modifications that meant I was not just copying.
If you are interested in using VB, this book covers it well - let me know if you want to play with it and you can dvelop a project in that area.
For that matter, there are only two of you doing this so we can follow your interests to some extent.
I am going to move on to Perl/CGI. Hopefully you have acquired the CGI/Perl text by Diane Zak (ISBN 0-619-03440-8). If not, let me know. I have an extra you can borrow!
Read the section intitled Read This Before You Begin and chapters #1 and #2 in the CGI/Perl book by Zak.
Experiment with writing script.
Look at the PowerPoint presentations on introduction to CGI/Perl and sending data. Also look at the samples (they are zipped).
Send me an email, and I will give you access to one of my sites that lets you test Perl - use it to try some simple code from the text.
Looking at this, we should probably count on it running over into next week!
Assignment to pass in:
Do one of the projects from Chapter #1 in CGI/Perl.
Week #3 Assignments
Week of February 3rd
Let's work on getting Perl going. If you are having problems still, let me know. We can use the BCC server if you continue to have problems using pgrocer.us.
Assignment to pass in:
It would be great if you could do one of the projects from Chapter #2 in CGI/Perl.
Week #4 Assignments
Week of February 10th
Read chapter #3 in the Zak book. If you need a copy, let me know.
Please let me know if you are willing for me to give your email to other people taking this course - I think it would be real helpful for you to communicate.
Assignment to pass in:
Do one of the projects from Chapter #3.
Week #5 Assignments
Week of February 17th
Please read chapter #4 in the Zak book. If you do not have the book, let me know and send me your address.
Assignment to pass in:
Do one of the projects from Chapter #4.
Week #6 Assignments
Week of February 24th
Move on to chapter #5. We need to use the BCC server for an assignment in this chapter.
Go to the site for MySQL: MySQL home page
Download MySQL and play with it. Create a database and some tables. Query the database using SQL. Report on your success.
The reference manual which includes tutorial information is at: MySQL Reference Manual
Also see the presentation on MySQL.
I would like you to think about an area of interest and what you want to accomplish in this course - we have a few different directions you can take for projects. Think about it!
Week #7 Assignments
Week of March 3rd
Read chapter #6 in the Perl/CGI text.
Continue working the information from last week and start to look at PHP.
Check back after I have heard from people about where they are and how they are doing setting up a database and working with cisweb.
My email is down - hopefully it will be fixed soon.
Week #8 Assignments
Week of March 10th
Read chapter #7 in the Perl/CGI text and continue looking at MySQL and PHP.
Assignment to pass in:
Do a project from chapter #5, #6 and #7. Can take some time.
Vacation Week
Week of March 17th
I am trying to get caught up - hope you are too and hope you are more successful than I am. Hope you enjoyed vacation too!
Week #9 Assignments
Week of March 24th
Read chapter #8 in the Perl/CGI text and continue looking at MySQL and PHP.
Assignment to pass in:
Do a project from chapter #8. You should also create a relational database using at least three tables using MySQL. You can put this on the cisweb site or a website of your choice.
Week #10 Assignments
Week of March 31st
Read chapter #9 in the Perl/CGI test.
Look at PHP tutorials - I have listed a few, you will probably find more.
PHP tutorial
PHP tutorial
PHP tutorial
PHP tutorial
Assignment to pass in:
Do a project from chapter #9.
Play with PHP and send me the results of something you played with.
Week #11 Assignments
Week of April 7th
Read chapter #10 in the Perl/CGI text.
Continue playing with mysql and PHP
Week #12 Assignments
Week of April 14th
Finish reading the Perl/CGI text.
Do some reading about ASP - it would be great if you tried something!
Assignment to pass in:
Create a mysql database and do three different things with it using PHP.
Decide on a interactive web project you want to do and sent me a proposal.
Week #13 Assignments
Week of April 21st
Continue doing some research in ASP and experiment with something. Remember to let me know about your interactive web project. That will be your final project for the course.
Week #14 Assignments
Week of April 28th
Continue building a fantastic site with all the neat stuff you have taught yourself!
Week #15 Assignments
Week of May 5th
The majority of you final exam will be tied to your interactive web project.
In addition, I would like you to do research on XML and write a short paper on its use and how to write a simple web page using XML.
For your status sheet: Send me a list of the projects you have done.

Send e-mail to Mrs. Grocer:
pgrocer@bristol.mass.edu

Back to the Top
Return to home page
Return to previous page