IT 235
3 Credit Hours
Instructor: Chet Cunningham Semester: Fall 2005
Office: 261 JHG Lecture: Online
Office Phone: (270) 824-8699 Room: Online
Instructor E-mail: Chet.Cunningham@kctcs.edu Home Phone: (270) 821-7909
Website: http://www.madcc.kctcs.edu/ccunningham
|
Office Hours: |
|
Monday & Wednesday: 2:30 p.m. – 3:30 p.m. |
|
Tuesday & Thursday: 8:00 a.m. – 9:00 a.m. |
|
& others by appointment |
Textbook: The Web Warrior Guide to Web Database
Technologies.
Bob Leasure and James Leasure. Course Technology.
2004.
ISBN: 0-619-15990-1.
This course is designed to provide students with the knowledge and skills to design, deploy, and manage a database driven web site, such as would be used for electronic commerce.
Course Competencies
Upon completion of this
course the student can:
1. Install and configure a web server
2. Understand the uses of databases in commerce
3. Understand the implications of transaction
processing
4. Write client-side scripting applications
5. Write server-side scripting applications
6. Design a functional e-commerce supporting database
7. Use scripting and SQL to input and output data from the
database
8. Collect and analyze customer behavior data from a
web site
9. Integrate common database applications such as
inventory, billing, and shipping with the web site
Across the Curriculum Competencies
Writing Across the Curriculum:
To
satisfy the new general education requirements of writing across the
curriculum,
"All faculty are expected to call
attention to and penalize for errors in English usage and require the rewriting
of papers which do not meet acceptable standards." (CCS Rules, Section V, 2.32)
Writing:
There will be exams, which will include questions that will require a written
response. A written report may be required at the end of the semester.
Integrated Learning: On exams, the students will be required to
identify and solve problems that involve applying concept to particular
situations.
Creative Thinking: On exams, students will be required to solve
problems that integrating concepts to create appropriate processes.
Ethics/Values: All students are expected to comply with the MCC Code of Conduct.
Plagiarism and cheating, as well as sanctions of these offenses, are defined in
Article III of this Code.
Prerequisites
IT 230 – Advanced Web Page Development AND
IT 170 – Introduction to Database Design – or - Consent of
Instructor
Online
Prerequisites/Technical Requirements
Supplies
None
Grading
|
|
% of |
|
Grading Scale |
|
|
Lab/Homework Assignments |
55 |
|
A |
90- 100% |
|
Mid-Term Exam |
20 |
|
B |
89 - 80 % |
|
Final Exam |
20 |
|
C |
79 - 70 % |
|
Discussion
Board |
5 |
|
D
|
69 - 60 %
|
|
Total: |
100% |
|
F |
Below 60% |
|
|
|
|
|
|
Instructional Methods
This course is an Internet
course. This means the majority of the
work will be independent work. This does
not make the material any easier or require any less work than a class that
meets regularly.
A combination of
discussions, hands-on chapter exercises and labs, and chapter tests will be
utilized to help you gain proficiency in the application of computer concepts
and principles.
There will be 10 discussion
topics posted throughout the semester.
You are expected to respond to each topic at least once. When you respond to each discussion topic,
you will receive 10 points for a maximum of 100 points.
Hands-on Chapter Projects
You will be responsible for
reading and understanding each assigned chapter. Each assignment should be properly labeled
with your name and exercise number.
Library Information
Library information can be
found on the Internet at http://www.kctcs.edu/distancelearning/libraries.htm.
Program Help
For student
registration and student login issues, contact KYVU at
Toll Free: 877-740-4357 or www.kyvu.org
Student instructions for activating
KCTCS email accounts are available online at: http://www.kctcs.edu/student/email.html
Course Policies
Examination Policy:
Two examinations will be given. No make-up exams will
be allowed without prior arrangements being made. Make-up exams must be taken when scheduled.
Late Assignment Policy:
Laboratory assignments
should be handed in on the specified due date.
This can be any time on that day up till midnight. Laboratory assignments handed in after the
due dates are considered late. No assignments will be accepted late.
Cheating
Policy:
Students
are expected to uphold the school’s standard of conduct relating to academic
honesty. Students assume full responsibility for the content and integrity of
the academic work they submit. The guiding principle of academic integrity shall
be that a student's submitted work; examinations, reports, and projects must be
that of the student's own work. Students shall be guilty of violating the honor
code if they:
1. Represent the work of others as their own.
2. Use or obtain unauthorized assistance in any
academic work.
3. Give unauthorized assistance to other students.
4. Modify, without instructor approval, an examination,
paper, record, or report for the purpose of obtaining additional credit.
5. Misrepresent the content of submitted work.
The penalty for violating
the honor code is severe. Any student violating the honor code is subject to
receive a failing grade for the course and will be reported to the Office of
Student Affairs. If a student is unclear about whether a particular situation
may constitute an honor code violation, the student should meet with the
instructor to discuss the situation.
For this class, it is
permissible to assist classmates in general discussions of computing
techniques. General advice and interaction are encouraged. Each person,
however, must develop his or her own solutions to the assigned projects,
assignments, and tasks. In other words, students may not "work
together" on graded assignments. Such collaboration constitutes cheating.
A student may not use or copy (by any means) another's work (or portions of it)
and represent it as his/her own. If you need help on an assignment, contact
your instructor, not other classmates.
Incomplete Policy:
Incompletes will only be
considered in the most extreme cases of hardship.
Make-up Policy:
Make-up exams will be given
ONLY in the most extreme cases of hardship or unavoidable interruption of
participation. These are handled on an individual basis. Quizzes cannot be made up.
Any
acts of classroom disruption that go beyond the normal rights of students to
question and discuss with instructors the educational process relative to
subject content will not be tolerated, in accordance with the Academic Code of
Conduct described in the Student Handbook.
The Student Code of Conduct is available on the web at http://www.kctcs.edu/student/code.htm.
Withdrawal Policy:
The last day for a student
to officially withdraw from class with a grade of "W" at his or her
discretion is October 17, 2005. After
October 17, the instructor’s signature is required to withdrawal.
If you have a documented disability and need any type of
accommodation, you are required to register with the Disability Resource
Coordinator. Contact Valerie Wolfe,
Disability Resource Coordinator, Room 112 LRC, 270-824-1670.
This syllabus is tentative and subject to change at the
discretion of the instructor to meet class needs.
Tentative Course Schedule
IT 235
Fall 2005
|
Topic |
Chapter |
Assignment |
Hands-on Projects
|
|
Week 1 8/15 |
|
Getting
to Know You |
|
|
Week 2 8/22 |
Chapter
1 |
Designing
Relational Databases |
RQ Project
1-1 |
|
Week 3 & 4 8/29 |
Chapter
2 |
Creating
a Database with Access 2003 |
RQ Project
2-1 |
|
Week 5 & 6 9/12 |
Chapter
3 |
Creating
a Database with MySQL |
RQ Project
3-3 |
|
Week 7 & 8 9/26 |
Chapter
4 |
Using
SQL |
RQ Project
4-1 |
|
10/10-10/15 |
|
Fall Break – no assigned work |
|
|
Week 9 & 10 10/17 |
Chapter
5 |
Java Primer |
RQ Project
5-1 |
|
Week 11 & 12 10/31 |
Chapter
6 |
Interfacing to Relational Databases with Java |
RQ Project
6-3 |
|
Week 13 & 14 11/14 |
Chapter
7 |
XHTML
Primer |
RQ Project
7-2 |
|
Week 15 11/28 |
Chapter
9 (Skip
Ch. 8) |
Servlets (and
Web Server install) |
RQ Project
9-1 |
|
12/5 |
|
Final Exam |
|