Interactive Web Sites - CIS250/47

Weekly Schedule

Week Information
Assignments due in one week unless otherwise stated. I may add some things during the week, so double check the schedule each week! Please keep copies of all work you submit until you receive your final grade at the end of the semester. You should buy the CGI/Perl Text (check used books).
Week #13
Week of April 20th
Lets see where you stand. Please check back and talk to me about a final project based on something you learned this semester.
Week #12
Week of April 13th
I want you to continue reading about XML and how to create basics XML.
Zipped XML examples
Focus on XML DTD this week, next week we will look at XML schema.
It is course evaluation time and the evaluation is now available at the elearning site for CIS283.
Assignments:
I want you to experiment with XML - I need you to make a fairly complex design using DTD - on the idea of the donor, donation, drive.
I would also like you to look into using XML to pass data - find some information and experiment with what you find (again Extra Credit).
We are almost at the end, so take your time and play with XML and try to get some results next week.
Week #11
Week of April 6th
Now we are going to create a database with SQL Server and use it on web pages with an vbhtml extension. There are examples and Smartboard explanations up on the web of the Payroll Site and the InvenDB that I did. Take a close look at them.
Assignments:
Database development in Web Matrix using SQL Server
Week #10 Assignments
Week of March 30th
This week I want you to start by reviewing SQL. Go back to the examples under PHP and make sure you remember how to work with SQL.
I also want you to experiment with VBHTML in Web Matrix.
I want you to read about SQL Server and its use in Web Matrix.
Assignments:
This week I want you to experiment with VBHTML the way you did with ASP and ASPX and try 10 examples.
Week #9 Assignments
Week of March 23rd
Continue with Web Matrix and ASP.
Catch up week
Vacation
Week of March 16th
This is catch up week - I am hoping that a lot of you will get caught up with assignments that you owe me.
If you are having problems Pat will be coming in on Tuesday and Thursday - I believe he said 10 to 3. I will confirm that with him. He is planning on K101 but if other people are using it you may have to look for him or ask at the help desk. You can also email me with questions and problems as well as homework for me to check.
Week #8 Assignments
Week of March 9th
Now I want you to look at the ASP.NET (extension ASPX examples). Remember that for each set of problems there is a Smartboard that goes over some key things.
W3Schools tutorial on ASP.NET
Another tutorial on ASP.NET
And another...
By now you should have downloaded the examples for all three types and looked at them in Web Matrix.
Assignments:
I want you to look at my examples and then try similiar things on your own: I am looking for taking in user input, writing conditions and writing loops. To force you to experiment, lets go with 10 for ASP.NET (ASPX) and a comment in each explaining what you are trying. What I am looking for here is the ability to get information using ASP and ASPX so please don't just do Hello World or take in something and display it. Try to really get involved!
Week #7 Assignments
Week of March 2nd
Now we are going to take a look at ASP (which actually uses VB Script) and then ASPX next. Looking at the next few weeks, after we have looked at the basics we will move on to Web Development with data etc.
Here are some sites with information on ASP:
W3Schools tutorial
Microsoft ASP tutorial
Under ASP and Smartboard (right below last weeks notes) you will see information on classic ASP. That is what I want you to look at this week.
Assignments:
Be sure you have looked at the ASP examples. To do this you need to have installed Web Matrix and gotten it to work. I want you to look at the basic ASP examples which include VB Script. I want you to do 10 examples using basic ASP.
Week #6 Assignments
Week of February 23rd
This week we are going to start working with ASP in Web Matrix. We are going to look at classic ASP and use a little VB Script and ASP.NET with an aspx extension and use Visual Basic. I would also like to look at the version with VBHTML. When you get to this point, Pat has played with Web Matric quite a bit so I suggest coming in and going over how to work with Web Matrix and ASP.
There are examples and Smartboard explanations that you can use as well.
Help with Web Matrix:
ASP.NET web pages
Intro ASP.NET using Razor Syntax(Visual Basic)
Web Matrix tutorials
Using Web Matrix
First Website
Assignments:
Your assignment this week is to experiment with Web Matrix. I want you to use VBHTML for this - when you click on New select the .vbhtml option. I want you to look at my examples and then try similiar things on your own: I am looking for taking in user input, writing conditions and writing loops. Try some very basic things using VBHTML - the VB part can be very basic at about the level we went to in CIS120. Lets go with 10 basic examples like mine.
Week #5 Assignments
Week of February 16th
We are going to continue with Perl including databases and maintenance of databases. Last week, I looked briefly at the comparison between using a file and a database. This is the example that I went over.
Files versus Databases
Good article on Perl and Databases
Examples:
Another look at arrays
Maintenance programs
Week examples
We are going to start working with ASP next week. If you do not have Visual Studio you will need it, so let me know and I will send you an invitation. We are going to look at ASP.NET so if you have a moment, find some tutorials and poke around.
Assignments:
I want you to experiment with these things and lets see how it goes.
We are going to go over updating a database using three separate programs (see above). I want you to write a program to do adds, changes and deletes in one program. Create your own database with a different structure from mine.
Week #4
Week of February 9th
We will start looking at MySQL because we need to be able to use Perl with a database.
This week we are going to focus on setting up MySQL on a server and querying and maintaining it. You will be accessing MySQL on the cisweb server. Information about MySQL is available at their web site. MySQL site
Information about using it at BCC is on this handout. Using MySQL on the cisweb server
If you want a copy to work with at home, a copy is available on the CDs accompanying the text book or at this site.
Please look at the presentations under MySQL on using MySQL. Note: You will need your cisweb username and password.
You should also get a copy of PuTTY to use with MySQL if you plan to work from home. PuTTY is available in the labs. Two sites that can be used to download PuTTY are:
PuTTY
PuTTY
Here is an example sheet for use when you are creating databases and tables in putty: Using putty to create a database and table
Here is another example sheet for use when you are maintaining and doing queries similiar to the ones I have assigned. Using SQL with MySQL
You should be looking up tutorials on SQL. Two that I think are good are:
SQL Tutorial (based on MySQL)
A Gentle Introduction to SQL This is especially helpful for someone who has had Oracle because it shows comparisons between the two versions.
Remember you have two in your PHP account.
Assignments:
Perl function assignment
Week #3
Week of February 2nd
Please look at arrays and hash variables this week (chapter #4).
Some examples for this week: Arrays and Hash
Be sure to read the chapter on files in your test. I would also like you to look functions in the next chapter.
Some examples for this week: Files and Functions
Assignments:
Array Hash Assignment
I would like you to write a quiz where you store the scores on a file. The students should be given questions, the grade should be calculated and stored.
Extra credit if you a can figure out a way to only allow a student to take the quiz only once.
Week #2
Week of January 26th
Read chapter #3 and chapter #4. You should be starting to work with loops and if statements this week..
Some examples for this week: Examples using post and get
Examples using for loop
If you are not comfortable with if statements, this presentation will be helpful.
Presentation on logical if structures
    Separate speaker notes to accompany presentation on logical if structures
Some examples for this week: Loops and decisions (if statements)
Assignments:
Experiment with the things you read about which included passing data with the get and with the post and the basics of a for loop. You should do a program that uses the get and then change it to use the post. The for can be included or a separate program.
Loops and decisions assignment
Week #1
Week of January 19th
Read chapter #1 and chapter #2 in the CGI/Perl text. Contact me about the book.
Student downloads
The information below is work I did a few years ago using another site:
Look at the first three PowerPoint presentations under the topic CGI/Perl. Presentations
Look at the code for the programs which can be opened under Printed code to accompany examples for week #1. You can also download many (not all) of the examples from the beginning cgi/perl and beginning HTML. Examples
The examples I want you to go over are zipped. firstzip.zip
Using the web site: Using WinSCP3
Assignments:
Do one of the hands on projects from chapter #1 and one of the case projects from chapter #2. If you do not have a site yet, write them and put them online when you get a site.
If you do not have a user id and password, contact me. Also, when you make cgi files, you need to go into rights and set the properties to 755.

Google
WWW www.pgrocer.net

Send e-mail to Priscilla Grocer: Priscilla.Grocer@bristolcc.edu

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