1311

Introduction To Programming Logic
CSCI 1311 - Fall 2008 - Tentative Schedule - 2:10 TT

All Labs/Assignments Are Due The Next Class Period Unless Specified Otherwise!

Class

Topic(s)

Reading Assignments
& Handouts

Laboratory
Assignments

# 1

8/28

Introduction To Class
Fill Out Questionnaire (Lab I-6 points)
Discuss Course Outline

Scripting Languages

Reasons For Learning HTML
Text Edit With Notepad
HTML
WWW
URL
DNS
<HTML> </HTML>
<HEAD> </HEAD>
<BODY> </BODY>
<TITLE> </TITLE>
<B> </B>
<U> </U>
<I> </I>
<P> </P>
<CENTER> </CENTER>
<H1> </H1>
<H2> </H1>
<H3> </H3>
<H4> </H4>
<H5> </H5>
<H6> </H6>
<HR>
<BR>
<IMG SRC>

Campus Run //Ananke/1311
Campus Run //131.194.71.9/1311

Browser On Campus ==>http://ananke.cs.trinity.edu/1311

Read the Course Outline

Read Chapters 1 & 2

IntroHTML

Questionnaire HW

HTML-About-Me Lab

Class Schedule Page
http://carme.cs.trinity.edu/thicks/1311/Schedule.html

Class Outline Page
http://carme.cs.trinity.edu/thicks/1311/Outline.html

On Campus Class Web Projects
http://ananke.cs.trinity.edu/1311/

# 2

9/2

Review
HTML
WWW
URL
DNS
<HTML> </HTML>
<HEAD> </HEAD>
<BODY> </BODY>
<TITLE> </TITLE>
<B> </B>
<U> </U>
<I> </I>
<P> </P>
<CENTER> </CENTER>
<H1> </H1>
<H2> </H1>
<H3> </H3>
<H4> </H4>
<H5> </H5>
<H6> </H6>
<HR>
<BR>
<HR>
<IMG SRC>

Introduction To FrontPage

Load Front Page On Your System
Campus Run \\tucc-tiger\Software\Microsoft

Practice With Front Page For At
Least An Hour Or Two
Change Font - Style, Color, Size
Change Body - Background, Color, Title
Add Image, HyperLink
Do Bold, Underline, Italics

Study For Quiz 1

# 3

9/4

QUIZ 1

Relative Address
Absolute Address

Introduction to Web Site Design

Web Site Design

Read Chapters 4

Small Site Lab

# 4

9/9

Continue to Web Site Design

Introduction To Expression Web

Introduction To Tables

Using Tables To Organize Data

Creating A Web Site With Expression Web

Advantages Of Web Editor Over Text Editor

Web Site Design

Polish Small Site Lab
With Expression Web
(If Desired)

Study For Quiz

# 5

9/11

Introduction To ASP

Viewing Javascript Code With Browser
No Security

Viewing ASP Code WIth Browser
Security - Server Side

Active Server Pages
Render With Web Browser
Security Of Code (Server Side)
Tags <% %>
Write --> Response.Write "Text"
Declare Variables --> Dim Name, No
Assign Data To Variables --> Name = "Tom" or No = 5
Response.Write "Name = " & Name & "<P>"
If Then Statement
If (Name = "Tom") Then
Response.Write "Welcome Tom"
Response.Write "Name = " & Name & "<P>"
End If
If Then Else Statement
If (Name = "Tom") Then
Response.Write "Welcome Tom"
Response.Write "Name = " & Name & "<P>"
Else
Response.Write "You Are Not Tom"
End If

Read Chapters 3 & 5

Find and example of If Then and If Then Else In Your ASPTutorials

Find and example of Response.Write In Your ASP Tutorials

Find and example of DIM In Your ASP Tutorials

References Lab

Practice With The
ASP Commands

# 6

9/16

ASP Code For Each ASP Page

<%@ LANGUAGE = VBScript %>
<% Option Explicit %>
<% Response.Expires = 0 %>

HTML Form Tag Sets

HTML Form Tag Sets

Setting Focus To An Input Field
<body OnLoad="Document.LoginForm.UserName.focus()">

HTML Submit Button

ASP Redirect

Response.redirect "Error.asp"

ASP Functions
http://www.haneng.com/FunctionSearch.asp

HTML Request

UserName = Trim(Request("UserName"))

ASP Response.Write

Response.Write "User Name = " & UserName & "<P>"

Use Gimp To Create
Thumb-Nail Image & Link To Full Image

Work On
In-Class-Login
Together

# 7

9/18

Bits & Bytes
Char - 8 Bits = 1 Byte

Protocol - IP, TCP/IP, FTP, SMTP
Transmission Control Protocol/Internet Protocol
File Transfer Protocol
Simple Mail Transfer Protocol

Search Engine Uses Web Crawler
Keywords & Content From MetaTags In Header

Review ASP

Len(Name)
Trim(Name)

Read Chapter 6

First-Login Lab

# 8

9/23

Review for Exam

HTML FORMS
TEXT INPUTS
SUBMIT INPUTS
DIM - Create Variables
Response.Redirects
Response.Write
Response.Request("First")

New ASP Functions
Left, Right
UCase, LCase
Cint, Clng

Study For Test

# 9

9/25

Designing Professional User Forms

Exam I

Form Guidelines

Prototype Forms.pdf

User-Form Lab

# 10

9/30

Introduction To Database
What Is A Database
MySQL Open Source Database

DOS Command WIndow
DOS - Disk Operating System
IPCONFIG, IPCONFIG /ALL
IP - Internet Protocol
PING
SQL-Structured Query Language
mysql Lab Connections
Ananke Remote Connections

Create A Database
CREATE DATABASE Trinity

Delete A Databases
DROP DATABASE Trinity

Display Databases
SHOW DATABASES

Open A Databases
USE Trinity

Create A Table
CREATE TABLE Students(
FirstName VARCHAR (15),
LastName VARCHAR (30),
ID INTEGER);

Display Table Fields
DESCRIBE TRINITY

Query All From Table
SELECT *
FROM MyFriends;

MySQL1.pdf

MySQL-Database Table Management

Introducton To SQL

Practice

# 11

10/2

Introduction To DatabaseDatabase Search Efficiency
DNS - Domain Name System/Server
Windows Services
DOS Mode vs MySQL Mode

Review & Practice
CREATE DATABASE Trinity
DROP DATABASE Trinity
SHOW DATABASES
USE Trinity

Create A Table
CREATE TABLE Students (
FirstName VARCHAR (15),
LastName VARCHAR (30),
ID INTEGER);

Display Table Fieldsi
DESCRIBE Trinity
SHOW FIELDS FROM Students

Delete A Table
DROP TABLE Students

Add A Full Record To A Table
INSERT INTO Users (Name, HomePhone, CellPhone, ID, Age)
VALUES (’Eggen, Maurice’, ’(210) 999-7487’, ’(210) 999-7777’, 1, 50);

Add An Incomplete Record To A Table
INSERT INTO Users (Name, HomePhone)
VALUES (’Lewis, Mark’, ’(210) 999-7499’);

Query All From Table In Ascending Order
SELECT *
FROM MyFriends
ORDER BY Name;

Query Partial Table In Descending Order
SELECT Name, ID
FROM MyFriends
ORDER BY ID DESC;

Not Equal Conditional Query Partial Table In Order
SELECT ID, Name, CellPhone
FROM Friends
WHERE ID <> 5
ORDER BY Name;

Or Conditional Query Partial Table In Order
SELECT ID, Name, CellPhone
FROM Friends
WHERE (ID = 3) OR (ID = 5)
ORDER BY Name;

Between Conditional Query Partial Table In Order
SELECT ID, Name, CellPhone
FROM Friends
WHERE (ID BETWEEN 3 AND 9)
ORDER BY Name;

Partial String Match Conditional Query Partial Table In Order
SELECT ID, Name, CellPhone
FROM Friends
WHERE Name Like ’H%’
ORDER BY Name;

Read Chapter 6

SQL-Database-Practice-I-With-MySQL-HW

SQL-Database-Practice-II-With-MySQL-HW

# 12

10/7

'------------------------------------------------------------------------------------
' Declarations
'------------------------------------------------------------------------------------

Dim Conn, SQL, RecSet, Counter

'------------------------------------------------------------------------------------
' Declare ASP Database Constants
'------------------------------------------------------------------------------------
'---- CursorTypeEnum Values ----
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adopendynamic = 2
Const adOpenStatic = 3

'---- LockTypeEnum Values ----
Const adLockReadOnly = 1
Const adLockPessimistic = 2
Const adLockOptimistic = 3
Const adLockBatchOptimistic = 4

Const adModeReadWrite = 3

STATUS

Rename A Table
ALTER TABLE BestFriends
RENAME Friends;

Rename A Table Field
ALTER TABLE Friends
CHANGE CellPhone Cell VARCHAR (14);

Add A Table Field
ALTER TABLE Friends
ADD HomePhone VARCHAR (14);

Update A Table Record
UPDATE Friends
SET Name = ’Pitts, Gerald’
WHERE ID = 11;

Update All Table Records
UPDATE Friends
SET KissQuality = 7;

Upper Case The Display Of Query Fields 
SELECT Upper(Name)
FROM Friends;;

Lower Case The Display Of Query Fields 
SELECT Lower(Name)
FROM Friends;

Update All Table Fields With Upper Case Equivalent 
UPDATE Friends
SET Name = UPPER(Name);

SQL-Database-Practice-III-With-MySQL-HW

# 13

10/9

Review MySQL Database Commands
ODBC Database Connections
Show Connection On Ananke

'Declare Program Variables
Dim Conn, SQL, RecSet, Counter

'Create a Connection Object
Set Conn = Server.CreateObject ("ADODB.Connection")

'Open The LibraryApp MySQL Database
'And Associate It With The Connection Object
Conn.Open "LibraryApp"

'Associate A Simple Query With Variable SQL
SQL= " SELECT First " &_
" FROM Users "

'Create a Record Set Object
'To Hold A Set Of Records If The Query Produces Any
Set RecSet = Server.CreateObject( "ADODB.Recordset")

'Attempt To Place All Of The Records, Selected By The Query,
'Into The RecSet object.
RecSet.Open SQL, Conn, adOpenDynamic, adLockOptimistic

DisplayUsers.asp
Implement The Code By
Next Class

Do A Web Search For
ASP Database ODBC
RecordSets
Connection Objects
EOF
Do While Loops

# 14

10/14

'Do While Loop
Counter = 1
Do While (Counter <= 10)
Response.Write Counter
Counter = Counter + 1
Loop

Counter = 10
Do While (Counter >= 1)
Response.Write Counter & "<BR>"
Counter = Counter - 1
Loop

'Do While Loop
Do While NOT RecSet.EOF
.
.
.
RecSet.MoveNext
Loop

'Extract Fields From Record Set
First Name = <% = RecSet.Fields("First")
DIM First
First = RecSet.Fields("First")

Display-Library-Users Lab

# 15

10/16

Session Variables
Session("LoggedIn") = true
Session("First") = First
Session("Last") = Last
Session("Administrator") = False

Practice With

Quiz - 60 % ASP Database
May Bring 1" x 2" Cheat Sheet With Hand-Written
ASP Commands for Quiz (measure it)
Include Create Connection & Create RecordSet!

While-Loop-Team HW

Create-Database-Contact-List. Lab

# 16

10/21

Session Variables
Session("LoggedIn") = true
Session("First") = First
Session("Last") = Last
Session("Administrator") = False

Database Query Review

Create-Login Lab

# 17

10/23

Quiz
Session Variables
ASP Database
Forms
Request
Redirect
Login-Confirmation

You may use your 1" x 2" review sheet on the quiz

For-Loop Team HW

# 18

10/28

ASP User Defined Functions
ASP User Defined Subroutines

Design & Code More Than A
Dozen Functions/Subroutines

Find Internet Tutorials
On Functions &
Subroutines

Study For Exam II

# 19

10/30

Exam II

Read Chapters 8 & 9

Think About A Theme For Your
Final Project Site

Tutorial On HTML Frames

# 20

11/4

Review Exam Material

Introduction to Functions
& Subroutines

Review Chapters 8 & 9

Think About Final Project

# 21

11/6

Introduction To
HTML Forms & Table Design

Review Chapters 8 & 9

Sketch Final Project Frames

# 22

11/11

Advanced Forms Practice
Add Users To Database Using
An HTML Form

FP-Add-Entity Lab
Due Next Time

# 23

11/13

Return To Functions
& Subprograms

Review Chapters 10 & 11

FinalProject-Edit-Delete Lab
Due 11/20

Add Display To Project
Add Delete To Project

Your Project Must Have At Least
4 Buttons
Per Team Member
Which Work By Tuesday

Add, Delete, Display, ??

# 24

11/18

Edit An Exiting Database Record
GetIDNo Form
Edit Form
Open Database - Read Record
Include Data In Table
Confirmation Page Does
Update - Not Insert

FinalProject-Edit-Delete Lab
Due 11/20

# 25

11/20

Confirmation Logic For Check-Boxes,
Combo-Boxes, Radio Buttons, Etc.

Read Chapter 12
Apply To Project

Add Two More Functional Buttons
Per Person
At Lest One Per Person Must BeA Functional
Database Button
Final Project

Improve Existing Forms
Check Boxes, Combo Boxes, Etc

Due 12/2

30 Points

# 26

11/25

Work On Project

# 27

11/27

Thanksgiving

# 28

12/2

Finish Up Functions
& Subroutines

Review For Exam

Write Functions
Team (1-3 Persons)
15 Points

Cube(No) --> Cube(2) returns 8
Decrement(No) --> Decrement(5) returns 4
AreaTriangle(Base,Height) --> AreaTriangle(5,10) returns 25
EvenNo(No) --> EvenNo(6) returns true
OddNo(No) --> OddNo(6) returns false
ReverseString(String) --> ReverseString("abcd") returns "dcba"
Palendrome(string) --> Palendrome("12321") returns true

My Functions Team InClass Lab

# 29

12/4

Exam III

Final Project
Will Not Be Accepted After
Noon on 12/10

# 30

12/9

Work On Final Project

12/10
12/11

Reading Days

No assignments will be accepted after 12/10/2008 Noon