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. |