SULLIVAN UNIVERSITY COMPUTER
SCIENCE DEPARTMENT
COURSE
SYLLABUS
CSC 238
INTERNET SERVER SIDE
PROGRAMMING
INSTRUCTOR: WJ Patterson OFFICE HOURS: 8:00a-12:00p, Fri
EMAIL: wjpatterson@sullivan.edu
or by appointment
PHONE: 456-6504 (University Office) http://www.iluv2teach.com
I. COURSE DESCRIPTION
This course emphasizes web application development
fundamentals and engages the learner with the intellectual and software tools
necessary for developing professional dynamic data driven web
applications. The student gains
experience with the professional process of planning and developing prototype
web applications. The tool to be used
for this class is COLD FUSION.
Prerequisites
– CSC 235
II. COURSE OUTCOMES
Upon successful completion of this
course, the student will be able, using Cold Fusion to:
·
Learn the Cold Fusion
·
Create web pages in HTML and Cold Fusion
·
Learn about data types and flow control
·
Become familiar with SQL
·
Understand an apply relational database systems concepts
·
Create dynamic Web pages that extract information from databases
·
Create Web pages that upload and update information in databases
·
Develop Web pages that interact with e-mail servers, files systems and
other web servers
·
Manage state by using Cookies
Note: Refer to the Course Skills
List for specific topics included in this course.
III. REQUIRED
TEXT
Cold Fusion, Kaparthi & Kaparthi, Course
Technology, ISBN-0-619-03442-4
IV. COURSE OUTLINE
Week 1: Intro to CFML, Strings and other Data Types
Ch 1-2
Week 2: Flow Control in Cold Fusion Ch 3
Week 3: Form Handling Ch 4
Week 4: Databases and SQL Ch 5
Week 5: Data Retrieval using Cold Fusion Ch 6
Mid Term Exam
Week 6: Data Maintenance with Cold Fusion Ch 7
Week 7: Data Validation Ch 8
Week 8: The Cold Fusion Application Framework Ch 9
Week 9: Interaction with Other Services Ch 10
Week 10: Reusing Code and
Building a Complete Web Application
Week 11 Final Exam
V. ATTENDANCE
POLICY
Day
Division
Class attendance and punctuality are essential to the learning process. Attendance will be recorded daily. Any student entering the classroom late - 5 minutes or more after class has begun - will be marked tardy. The accumulation of 2 tardies will be counted as one absence. Any student accumulating 8 absences during the quarter may be dropped from the class.
Evening
Division
Class attendance and punctuality are essential to the learning process. Attendance will be recorded at the beginning of each class. Any student entering the classroom late - 15 minutes or more after class has begun - or leaving before class has been dismissed, will be marked tardy. The accumulation of 4 tardies will be counted as one absence. Any student accumulating 4 absences during the quarter may be dropped from the class.
Note: Refer to the Student
Handbook for complete details of the Sullivan University Attendance Policy.
VI. STUDENT DRESS CODE / PROFESSIONAL DRESS
DAY
The Sullivan University
dress policy requires all students to follow a set of guidelines for personal
dress and grooming. Additionally, Wednesday is Professional Dress Day for all
day school students. Students are expected to dress as if going on a
professional job interview. Students’ not properly attired will be asked to
leave class.
Note: Refer to the Student
Handbook for complete details of the Sullivan University Dress Standards.
VII. ACADEMIC DISHONESTY
Sullivan
University's policy on cheating and plagiarism is consistent with the
definition of plagiarism provided by Webster's Ninth New Collegiate
Dictionary:
to plagiarize is to;
w steal and pass off (the ideas or words of another) as one's own;
w use (a created production) without crediting the source;
w to commit literary theft;
w present as new and original an idea or product derived from an existing source.
Sullivan University also considers a student to be guilty of plagiarism if the student allows their original work to be used by another student for academic credit.
Note: Refer to the Student
Handbook for complete details of the Sullivan University policy.
VIII. COMPUTER LAB POLICY / HOURS
Computer Science Tutors are available for all students
Monday - Thursday afternoon between 2:00
and 6:00 and at other times by appointment.
Consult the Student Scene or Night Scene Newsletter for daily schedules,
or ask your instructor for more information.
Computer labs will be available
daily to students during the following hours:
Monday
- Thursday............ 7:00 a.m.
to 10:00 p.m.
Friday
& Saturday.............. 8:00
a.m. to 5:00 p.m.
Sunday.............................. 12:00 p.m.
to 5:00 p.m.
Students are encouraged to use the computer labs
when classes are not in session during the day, and at the following times:
Monday
- Thursday..................... 2:45
p.m. - 6:00 p.m.
Friday, Saturday
& Sunday.......... some labs
available all day
When a class is in session,
students may use any computer not used by a student in the class, as long as
the scheduled class is not disrupted.
The following rules apply during these times:
Ø
Do not enter a computer lab while an
instructor is lecturing to the class.
Ø
Do not ask the instructor for
assistance with an assignment or project.
Ø
Sit in the back of the room, if possible.
Ø
Allow students in the scheduled class to use their
choice of computer.
Ø Notify
the instructor if you are having a computer hardware problem.
** Food and drinks are NOT
allowed in any carpeted area of the building**
*********************************
It is a Class C felony in the State of Kentucky to alter computer files without authorization. At Sullivan University, the following actions are considered a Class C felony and are subject to both criminal action and instant dismissal from school:
* Changing the
"Welcome to Sullivan University" banner on a computer
* Changing any
desktop setting or windows setting unless part of a class assignment
* Loading personal
programs or games on a computer
* Intentionally
modifying files not specifically assigned as part of a class assignment
* Using any computer
for personal reasons
*********************************
IX. EVALUATION
Quarter grades will be
based on the schedule shown below.
GRADING SCALE:
A
= 90 - 100
B
= 80 - 89
C
= 70 - 79
D = 60 - 69
F
= below 60
Note: This is a core course of the Computer Science Department. A grade
of “C” or better is required for successful completion for any Computer Science
student.
Weekly Projects
20%
Weekly Exams 60%
Final Exam 20%
Total 100%
Weekly Projects
Weekly Projects will be given to support the connection of the lecture material. It is assigned the week the chapter is
reviewed in class and a due date will be assigned for completion of the work.
Homework will not be accepted late If a class is missed, to gain
credit for the homework, the student should fax it, email it, mail it, or make
arrangements to have it to the instructor before the class period it is due.
Exams
There will be 5 exams given during the quarter,
beginning the Thursday of week 2. Students
are expected to take exams as they are scheduled - exam days are
Thursdays. There will be NO
MAKEUPS GIVEN. You will be allowed to
drop your lowest test score. A
comprehensive final exam will be given as well.
X. OTHER COURSE
INFORMATION
1)
This course consists of lectures and programming
labs and other assignments that are designed to reinforce the theory covered in
the lectures. Although hands-on tasks
will be used during some lectures, most lab assignments must be completed
outside normal class meetings.
2) Attendance is required for this course. Any absence excused or unexcused still counts
as one absence. After you have
accumulated 4 absences, you will be dropped from this course.
3) Students are expected to take exams as they are
scheduled. NO make up exams will be
given for any reason.
4) All lab assignments will be introduced during class and will
have a specific due date. They will be
due at the beginning of the class meeting on the due date. All assignments are to be submitted through e-mail
attachments unless otherwise stated. Late assignments will not be
accepted. Absence from class does not
excuse late assignments.
5) The student is responsible for keeping backup copies of all
lab assignments. This is to protect the
student from having to recreate a lab assignment due to the loss of the lab
assignment through e-mail or other problems that may arise.
6) I have no objection to students helping other students on
lab assignments. In fact it is
encouraged. However, work turned in by the
student should be his/her own work. If
you do assignments together, you must clearly indicate that you worked
together. Otherwise, this is cheating
and will be treated as such and the offending student will be subject to
University disciplinary action.
7)
Students must take responsibility for their own
actions. If you are having trouble
completing assignments, please tell me immediately. Please do not wait until the day work is due
to tell me you had problems understanding it or getting started. Getting behind is a sure way to be
unsuccessful in this course. The
material continually builds on itself.
Once you are behind, you will get further behind exponentially.
CSC238 INTERNET SERVER-SIDE PROGRAMMING --
STUDENT LEARNING OUTCOMES
After successful completion of this course, the
student will be able to demonstrate the following skills:
UNDERSTAND SCRIPTING
q
Describe the role of scripts
in web page
q
Describe the differences
between static & dynamic Web pages
q
Develop basic input &
output statements
q
Describe basic memory
concepts using CFSET
q
Apply basic mathematical
operators
q
Use algebraic precedence
q
Describe the difference
between assignment & conditional statements
q
Use of relational &
equality operators
UNDERSTAND FLOW
q
Develop single side decision
structures
q
Develop double sided decision
structures
q
Design a WHILE loop
q
Design a counter controlled
repetition
q
Develop increment &
decrement structures
q
Design a FOR loop
q
Design a SWITCH selection
structure
UNDERSTAND DATA RETRIEVAL
q
Develop an ODBC connection
using CF administrator
q
Create query objects and
record sets
q
Execute SQL SELECT
statements in CFML
q
Develop QUERY loops for data
retrieval
UNDERSTAND DATA MAINTENANCE
q
Maintain a database with
CFML
q
Apply CFINSERT, CFUPDATE,
CFTRANSACTION
q
Maintain data using SQL update
q
Design form handlers for
inserted, updating, & deleting data
q
Create tables using CFML
UNDERSTAND FORM HANDLING
q
Describe the interaction
between Web browser and Web server
q
Process HTML forms using
CFML
q
Use CFML form handlers for
handling forms and accessing data entered in different types of controls
UNDERSTAND
URL PARAMETERS & STRINGS
q
Apply URL Parameters
q
Process URL Parameters
q
Apply STRING, date-time
values, and boolean data types
q
Create CF string,
expressions & functions
q
Apply a typeless
expression evaluation
UNDERSTAND DATA VALIDATION
q
Describe data validation
& its importance
q
Design client side / server side
validation
q
Develop data validation
techniques such as completeness checks, data type checks, range and limit checks,
etc using CFML
q
Use dynamically populated
select boxes with data extracted from a database
UNDERSTAND APPLICATION
FRAMEWORK
q
Describe the concept of state
& statelessness
q
Use HTTP cookies
q
Develop a CF application framework
q
Develop client variables
q
Develop session / application
variabl