Week 1 (1/10 - 1/14) - Due 10:00 a.m., Friday, 1/14

• Go to the Discussion Board section of Blackboard and complete the Icebreaker assignment
• Read the FTP Tutorial Provided on my website
• Read the FTP download on my site and download the FTP client if you do not already have it.
• This is a program that you will use throughout this class. When you go to login the host name is sccitn.com, your username is the first letter of your first name and your full last name (Mine would be: scline) and your password will be your social security number. I want you to login just to make sure that you can.
• Look over the layout of the class website (especially the syllabus) just to make sure you can properly navigate it. http://www.sccitn.com/scline/classes/spring/itn180w/

• Read the Word documents that I have linked on my website. You will find them on the left side in the navigation bar. The names are ASP Info, ASP Closer Look and ASP Variables.
• Click on the VBScript Examples link and look at the first two examples under section 1 (Hello World and Declaring Variables) - If you click on the exclamation mark (!) you will find a brief description of the example.
• Click on the Projects link. Here you will find your first mini-project. You will need to complete the project and transfer the file up to the server into an ITN180 folder that you create.
• Last, but not least, you will need to go to the Discussion Board on Blackboard and post messages to your classmates about the project. You can even ask questions to your classmates if you like. It is called Week 2.

Week 3 (1/24 - 1/28) - Due 10:00 a.m., Friday, 1/28

Week 4 (1/31 - 2/4) - Due 10:00 a.m., Friday, 2/4

Here are your assignments for this week:

• Click on the VBScript Examples link and look at the examples under Section 2 - In this section you will be checking to see if certain conditions are met.
• Also look at the examples under Section 3. This area will focus on loops.
• Click on the Projects link. Here you will find mini-project 3 and mini-project 4. You will need to complete the projects and transfer the file up to the server into an ITN180 folder that you created.
• Link to your mini-projects from the start page you created.
• Last, but not least, you will need to go to the Discussion Board on Blackboard and post messages to your classmates about the project. You can even ask questions to your classmates if you like. I do encourage interaction. It is called Week 4.

Week 5 (2/7 - 2/11) - Due 10:00 a.m., Friday, 2/11

Here are your assignments for this week:

• Click on the VBScript Examples link and look at the examples under Section 4 and Section 5 - In this section you will be working with Sub Procedures and HTML Form elements.
• Click on the Projects link. Here you will find mini-project 5. You will need to complete the project and transfer the file up to the server into an ITN180 folder that you created.
• Link to your mini-projects from the start page you created.
• Last, but not least, you will need to go to the Discussion Board on Blackboard and post messages to your classmates about the project. When you are discussing this with your classmates, answer the following questions: Why are Sub Procedures useful? Why are Form Elements useful? You can even ask questions to your classmates if you like. I do encourage interaction. It is called Week 5.
  

Week 6 (2/14 - 2/18) - Due 10:00 a.m., Friday, 2/25

This week I want you to work on Project 1 found in the projects section of my website. You also will need to go to the Discussion Board on Blackboard and post messages to your classmates about the project. It is called Week 6.

Week 7 (2/21 - 2/25) - Due 10:00 a.m., Friday, 2/25

Week 8 (2/28 - 3/4) - Due 10:00 a.m., Friday, 3/11

Work on the Mini-Example Project found in your projects section.

Week 9 (3/7 - 3/11) - Due 10:00 a.m., Friday, 3/11

Finish the Mini-Example Project found in your projects section. Remember that I will be out of town, so do not expect a response before the end of Spring Break. I cannot guarantee my Internet access while I am out of town.

Week 10 (3/14 - 3/18) - Due 10:00 a.m., Friday, 4/1

Now we get to start some of the fun stuff. Look over the examples in Section 6. This section goes into connecting to databases. I am going to cover some of the main points that you need to get out of these examples. We are connecting to a Microsoft Access database.The name of the database is Student.mdb. The name of the table inside the database is StudentInfo.

Server.MapPath --------This gets the current path to the root directory of the current account. We add a /db/ to this to tell it to go to the db folder. I have printed the path that Server.MapPath gets on the first example.

databaseName -------- This is just a variable that I am using to store the database name in. We could call this variable anything we want.

connectionString ------- This is telling the user what kind of database we are connecting to and then where to find the database and then the database name.

sql ------- This is a special language that is used in many programming languages to connect to a database and make changes to it. The statement Select * From StudentInfo is just saying, Select Everything from the StudentInfo table. We could replace the * with SSNum, FName and it would just select those two fields.

set rs = Server.CreateObject("ADODB.Recordset") ------ This is creating an area in memory called rs that is used to store database information. We could call this area anything we want.

rs.Open sql, connectionString ------ This works from right to left. We are going to open the recordset (area in memory) using the connectionString to find the database and the sql to find the particular information in the table and put it in the recordset.

rs.MoveFirst ---------Moves you to the first record in the recordset.

rs.MoveNext ------- Moves you to the next record in the recordset.

rs.EOF ------- End of all the records in the recordset

while not ------- Does something while something is not true

wend ------- End of the While Loop

rs.Close ----- Close the area in memory so we no longer need to work with it

Set rs = Nothing --------- Clears the area in memory that is used to hold the database information

Now I want you to work on Mini-Project 6. If you do not know how to create a database, please let me know.

Week 11 (3/28 - 4/1) - Due 10:00 a.m., Friday, 4/1

Finish the work for Week 10.

Week 12 (4/4 - 4/8) - Due 10:00 a.m., Friday, 4/8

• Look at the examples in Section 7 and 8.
• Work on Mini-Project 7. It will be due at the end of the week.
• Post and reply to at least one message in the Discussion Board for Week 12.
  

Week 13 (4/11 - 4/15) - Due 10:00 a.m., Friday, 4/22

Look over Section 9 - Section 11. Complete Mini-Project 8 and Project 2.

Week 14 (4/18 - 4/22) - Due 10:00 a.m., Friday, 4/22

Complete the Previous Week's Work.

Start working on the Final Project

Week 15 (4/25 - 4/29)

Work on the Final Project

Week 16 (5/2) - Due 10:00 a.m., Monday, 5/2

Turn in the Final Project.