IT 235
3 Credit Hours
Instructor: Chet Cunningham Semester: Fall 2009
Office: 261 JHG Lecture: Online
Office Phone: (270) 824-8699 Room: Online
Instructor E-mail: Chet.Cunningham@kctcs.edu Home Phone: (270) 884-7540
Website: http://www.madisonville.kctcs.edu/ccunningham
|
Office Hours: |
|
Monday & Wednesday: 12:00 p.m. – 1:00 p.m. |
|
Tuesday & Thursday: 9:30 a.m. – 10:30 a.m. |
|
& others by appointment |
Textbook: PHP Programming with MySQL.
Don Gosselin. Course Technology. 2006.
ISBN: 0-619-21687-5.
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)
General Education Competencies:
I. Communicate
Effectively
1. Read with comprehension.
Assessment:
Complete comprehensive projects after reading the text.
2.
Interact cooperatively with others using
both verbal and non-verbal means.
a. Students will communicate with instructor and other
students via e-mail and required discussion board assignments.
Assessment:
Student will be graded on required discussion board posts.
3.
Demonstrate information processing
through basic computer skills.
a. Students will demonstrate basic computer skills
through successful completion of assignments.
Assessment:
Complete comprehensive projects after reading the text.
II. Think Critically
1. Demonstrate problem solving through
interpreting, analyzing, summarizing, and/or integrating a variety of
materials.
a. Students will demonstrate problem solving skills by
successfully completing the assignments.
Assessment:
Complete comprehensive projects after reading the text.
III. Learn Independently
1. Apply learning in academic, personal, and public situations.
a. Students will apply learning and be expected to work
and learn independently using appropriate resources in this online environment.
Assessment: Apply all acquired skills when
constructing required materials for other courses, for self, or in career
situations.
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 submitted prior to the specified due date/time. The course management system being used for this online class states all times in Eastern Standard Time. Therefore, if you are not in the Eastern Standard Time Zone, you will need to adjust your due time in accordance to the time zone you are in. For example, if a student is in the Central Time Zone, they would have to submit their assignment one hour prior to the stated due time. Laboratory assignments cannot be submitted after the due date/time. 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 19. After this date, it is up to the instructor’s discretion to
grant a “W”.
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 139 JHG, 270-824-1708.
Students with documented disabilities that require individualized
accommodations should do two things: contact the Disability Resource
Coordinator at their Home College and inform their instructors. Once the
student has contacted the Disability Resource Coordinator at the
This syllabus is tentative and subject to change at the discretion of the instructor to meet class needs.
Tentative Course Schedule
IT 235
Fall 2009
|
Topic |
Chapter Reading |
Assignment |
Hands-on Projects |
|
Week 1 8/17 |
|
Getting to Know You |
|
|
Week 2 8/24 |
Chapter 1 |
Introduction to Web Development |
RQ Project 1-1 |
|
Week 3 8/31 |
Chapter 2 |
Getting Started with PHP |
RQ Project 2-1 |
|
Week 4 9/7 |
Chapter 3 |
Working with Data Types
and Operators |
RQ Project 3-1 |
|
Week 5 9/14 |
Chapter 4 |
Functions and Control
Structures |
Project due 11/5 |
|
Week 6 9/21 |
Chapter 5 |
Manipulating Strings |
RQ Project 5-1 |
|
Week 7 9/28 |
Chapter 6 |
Working with Files and Directories |
RQ Project 6-1 |
|
Week 8 10/5 |
|
Catch-up/review |
|
|
10/12-16 |
|
Fall Break – no assigned work |
|
|
Week 9 10/19 |
Chapter 7 |
Manipulating Arrays |
RQ Project 7-1 |
|
Week 10 10/26 |
Chapter 8 |
Working with Databases and MySQL |
RQ Project 8-1 |
|
Week 11 11/2 |
Chapter 9 |
Manipulating MySQL Databases with PHP |
RQ Project 9-1 |
|
Week 12 11/9 |
Chapter 10 |
Managing State Information |
RQ Project 10-1 |
|
Week 13 11/16 |
Chapter 11 |
Developing Object-Oriented PHP |
RQ Project 11-1 |
|
Week 14 & 15 11/23 |
Chapter 12 |
Error Handling and Debugging |
RQ Project 12-1 |
|
12/9 |
|
Final Exam |
|