IT 235
3
Credit Hours
Instructor: Chet Cunningham Semester: Fall 2004
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: |
|
Tuesday & Thursday: 8:00 a.m. – 9:00 a.m. |
|
Tuesday & Thursday: 12:45 p.m. – 2:15 p.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.
Reading: Each homework assignment includes reading the appropriate section of the textbook as well as completing the assigned problems.
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 18, 2004. After October 18, 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 2004
|
Topic |
Chapter Reading |
Assignment |
Hands-on Projects |
|
Week 1 8/16 |
|
Getting to Know You |
|
|
Week 2 8/23 |
Chapter 1 |
Designing Relational Databases |
RQ Project 1-1 |
|
Week 3 & 4 8/30 |
Chapter 2 |
Creating a Database with Access 2003 |
RQ Project 2-1 |
|
Week 5 & 6 9/13 |
Chapter 3 |
Creating a Database with MySQL |
RQ Project 3-3 |
|
Week 7 & 8 9/27 |
Chapter 4 |
Using SQL |
RQ Project 4-1 |
|
10/11-10/15 |
|
Fall Break – no assigned work |
|
|
Week 9 & 10 10/18 |
Chapter 5 |
Java Primer |
RQ Project 5-1 |
|
Week 11 & 12 11/1 |
Chapter 6 |
Interfacing to Relational Databases with Java |
RQ Project 6-3 |
|
Week 13 & 14 11/15 |
Chapter 7 |
XHTML Primer |
RQ Project 7-2 |
|
Week 15 11/29 |
Chapter 9 (Skip Ch. 8) |
Servlets (and Web Server install) |
RQ Project 9-1 |
|
12/6 |
|
Final Exam |
|