| 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 #14/#15/final Week of December 2nd/9th/16th |
Your last project/final is to develop a project that shows what you have learned. Both Perl and ASP can use XML so my suggestion is that you do something that combines one of
the languages with XML. You need to send me a proposal for approval. Please pass in your final project by Monday December 16th. If you run into problems, let me know. Evaluations have been put under the actual course you are taking (they are on elearning), so you can now do the evaluations. |
| Week #13 Week of November 25th |
We will look at some more XML this week. XMLschema zipped XML zipped I would like you to do some research on importing XML into a database or a spreadsheet and tell me what you find. Assignments: This week I want you to experiment with schema and XSLT and pass in some examples showing a basic understanding. It would be great if you took what you did in DTD last week and redid in with a schema. I would also like you to try some of the things with XSLT. Experiment! Extra credit if you do an example of bringing XML into a database or spreadsheet. |
| Week #12 Assignments Week of November 18th |
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 Assignments Week of November 11th |
I want you to do some research on XML this week. Find some tutorials and go through the basics. There are examples at my site as well. This is a catch up week. |
| Week #10 Assignments Week of November 4th |
Continue working with ASP inside Visual Studio and Web Developer and start researching basic information about XML.
Please check back! Assignments: Using Visual Studio or the Web Developer I would like you to incorporate accessing data from a database. |
| Week #9 Assignments Week of October 28th |
Now we are going to take a look at ASP through Visual Studio and the Web Developer. If you have worked with Visual Basic then you can continue
to work with that, otherwise you can choose which way to go. I have got pdfs that show the creation using both. Be sure to look at both pdfs.
The create ends up with many of the same screens and I went further in the Visual Studio example with adding textboxes, labels and buttons. Using Visual Studio (Visual Basic) to create ASP Using Web Developer to create ASP Needless to say I want you to try one of these approaches. I used localhost to test and you can too. Localhost is available through either of the packages described. Assignments: I want you to use the Developer or Visual Studio and develop a couple of ASP pages with a lot of different tags and a variety of objects such as textboxes and buttons. Be sure to link back and forth with your pages. Having them run on localhost is fine although you can choose to put them on a website. |
| Week #8 Assignments Week of October 21st |
ASP database connection on Brinkster We are connecting to a database. My examples mostly use .mdb, but one of them uses .accdb. Another helpful link Some things you might find helpful: Web development (4/25/13) in PDF format Accompanying audio Web development (4/25/13) Accompanying Smartboard Web development thru Brinkster (4/30/13) in PDF format Accompanying audio Web development thru Brinkster (4/30/13) Accompanying Smartboard Multi pages and connect DB (5/2/13) in PDF format Accompanying audio Multi pages & connecting to DB (5/2/13) Accompanying Smartboard Assignments: I want you to connect to a database using ASP and retrieve and maintain database data. Let me know if you have maintain problems. |
| Week #7 Assignments Week of October 14th |
W3schools information on ASP ASP Tutorial ASP.NET tutorial ASP tutorial at tizag.com Please start to look through some of the ASP examples at W3Schools and also look at the examples at my web site. Continue looking at the non database examples - we will get there! Assignments: Experiment with 10 things related to ASP that are discussed at W3 schools or another tutorial or site that you have not tried last week. Check back! |
| Week #6 Assignments Week of October 7th |
I have a lot of examples using aspx that are up on brinkster, the list of the beginning ones is located under examples at my web site. Here are some ASP examples I did in a Visual Basic class. List of examples This week I want you to either use Microsoft Visual Basic or some other language in Visual Studio or Visual Web Developer 2008 Express Edition (can be downloaded from Microsoft) and experiment with ASP. Some examples to experiment with. ASP intro A look at the beginning examples in ASP Running through localhost ASP and db Find a tutorial and do some reading: 3 schools tutorial Tizag tutorial We will continue with this next week. For now you are just getting introduced. Lets leave databases for next week. Assignments: Your assignment is to show me you are experimenting with ASP successfully. You can do something similiar to what I have at Brinkster (set up your own brinkster account) or you can setup with the Visual tools. Your choice, but you do need to show me something running so I strongly suggest Brinkster. I would like you to look at my examples and then create some programs that do similar things. Make them simple and experiment. Show me five different things you tried. |
| Week #5 Assignments Week of September 30th |
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: 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 September 23rd |
Sorry! I copied and pasted wrong! Week 3 did not happen again really! 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 September 16th |
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 once. |
| Week #2 Week of September 9th |
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 September 2nd |
Read chapter #1 and chapter #2 in the CGI/Perl text. 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. |