Syllabus Contents

 


CIS 219 covers development of dynamic web sites using PHP and MySQL. Plan to spend 9 hours per week on this class. You are expected to check Moodle and email at least twice per week.

2 hours lecture, 3 hours laboratory, 3 units

Section 1792
Monday 5:00PM - 7:45PM
Room E-206
2.5 hours per week online (discussion, quizzes, and lab assignments)

Course Web Site: www.cuyamaca.edu/jreed/219

Instructor:

Jodi Reed, MA
Computer & Information Science
Cuyamaca College
jodi.reed (at) gcccd.edu
office:  room E-107

Jodi's Spring 2014 Office Hours

Monday: 10-11AM
online
Tuesday: 4-5PM
E-107 or E-206
Wednesday: 10AM-12PM
online
Thursday: 12-1PM
E-206 or E-107

Please request an appointment if you would like to see me outside office hours. I am also available by email.

Topics/Themes

In this 3-unit course, students will use PHP and MySQL create dynamic web sites.  The course will cover 3 main topics:

  1. web programming - how to code PHP
  2. database development - how to work with a MySQL databases using phpMyAdmin or PHP
  3. common applications - common uses for database-driven web sites

Prerequisites

The prerequisite for this class is CIS 211 (HTML and CSS). If you have not taken CIS 211 but know HTML and CSS, you may challenge the prerequisite.

Recommended Preparation: "C" grade or higher or "Pass" in CIS 140 or 110 or equivalent or database development experience, CS 119 or equivalent or programming experience (this is less important than knowing HTML, but will help you succeed in the class).

Learning Outcomes

At the end of this course, each student will be able to:

  1. Describe fundamental concepts of server side scripting and the PHP scripting language and explain how they apply to dynamic web development.
  2. Describe the advantages of database-integrated web development and demonstrate practical applications of the technology.
  3. Write and debug syntactically and semantically correct PHP programs based on criteria established in class.
  4. Use PHP scripting to display, query, edit, add and delete data from a MySQL database.

 

Grading and Assignments

You will be graded on assignments, online discussion, and tests.  Moodle will link to complete instructions, including a scoring rubric for each Web development project.  You will use Moodle to check your grades, turn in assignments, take quizzes, and participate in class discussion.  Your total grade will include:

60% Lab Assignments Labs give you an opportunity to practice skills covered in the textbooks. Expect several a week, ~ 50 points per week.
5% Discussion Participation You are expected to post at least one message to the general Moodle discussion forums each week.  These can be questions, comments, responses, interesting Web sites, etc.  Your message will be given 1-5 points based on complexity, appropriateness, and helpfulness. Maximum per week: 10 points.
25% Quizzes Moodle quizzes will cover handouts, textbook, and online video material.  Expect ~ 1 per week, ~ 25 points each.
10% Final Exam The final exam will be cumulative and will include a practical section.
  Extra Credit extra credit is sometimes offered and is used to bump up a borderline grade (1-2% below higher grade)

Scale

90-100%, awarded for work that exceeds expectations and shows effort, skill, and creativity
B 80-89%, awarded for work that exceeds expectations
C 70-79%, awarded for work that meets expectations
D 60-69%, awarded for work that is below expectation

Assignments and quizzes are usually due to Moodle a week after they are assigned.  Everything is carefully set up in a specific sequence to help you learn, so DON'T SKIP ASSIGNMENTS. Due dates are shown on Moodle. After the due date, you lose 50%. Some assignments must be completed before you can move on in the course, so DON'T GET BEHIND. If you turn in your work on time, you will usually get one chance to fix mistakes, so TURN IN WORK ON TIME! Be sure to SAVE and BACK UP/UPLOAD everything you do. BEGIN ASSIGNMENTS EARLY in the week they are assigned so you will have time for questions and technical glitches. ASSUME you will have technical problems and turn in work BEFORE the due date. I have built in plenty of time to allow for questions and technical difficulties as long as you begin on the date it was assigned.

An incomplete grade is given only when there is an emergency near the end of the semester.

Attendance/Participation Drop Policy

Students who are inactive will be dropped from the course. If an entire week goes by with no activity on your part either through the discussion board participation, email communication, or submission of work, quiz, or exam, you will be dropped. Therefore, contact me if your contribution to the class will be interrupted.

Though any student not participating in class for 1 week may be dropped from the course by the instructor, it is always the student's responsibility to drop any unattended course.  Failure to drop an unattended course will result in a grade of "F" on your transcript. 

Textbook - available at the campus bookstore or online

textbook

Murach's PHP and MySQL by Joel Murach
$38 on Amazon
ISBN-13: 978-1890774561

NOTE: Join Amazon Student and get FREE Two-Day Shipping for one year with a free Amazon Prime membership ($79 value). The program is available only for students and there is no cost to join--simply sign up by providing your school, major, and campus email address.

An eBook isĀ  available from murach.com.

Materials

You cannot complete this class without reliable access to Internet.

You need adequate storage to SAVE and BACK UP your work.  You are responsible for your work in spite of technical problems, so be sure to back up!  Most students use a USB Flash Hard Drive or cloud storage (e.g. Dropbox or iCloud.)

Course Communication

Post general questions to the online discussion.  You may also send email to jodi.reed (at) gcccd.edu or stop by during office hours. 

NOTE: I must respond to many questions each day, so my responses tend to be brief. Please don't take this personally. I usually respond the same day or the next day. Please try again if you don't hear back within 2 days. I check email most often followed by Moodle discussion and then voice mail.

Students with disabilities who may need accommodations in this class should notify me and contact Disabled Students Programs and Services (DSPS) early in the semester so that reasonable accommodations may be implemented as soon as possible. See www.cuyamaca.edu/eops/dsps.asp for contact information.

Academic Integrity

When creating Graphics or Web sites, treat Web content as you would treat content from a published article or book. Stealing content is unethical, and students guilty of academic dishonesty will receive a zero for the assignment and may be suspended or expelled. It is acceptable to use brief quotes or clip art. It's not ok to copy entire web pages or style sheets or use someone else's images without permission.

Schedule (details on Moodle)

Topic Chapter
Week 1: Introduction 1
Week 2: PHP Programming 2
Week 3: PHP Programming 2
Week 4: MySQL 3
Week 5: PHP with MySQL 4
Week 6: MVC Organization 5
Week 7: Testing & Debugging 6
Week 8: Forms 7
Week 9: Control Statements 8
Week 10: Strings & Numbers 9
Week 11: Dates 10
Week 12: Arrays 11
Week 13: Cookies & Sessions 12
Week 14: Functions 13
Week 15: Objects 14
Week 16: Regular Expressions & Validation 15

Important Dates for Fall 2013

Please mark your calendar!

August 20 Regular Day & Evening Classes Begin
August 31 Last Day to Add Semester-Length Classes
Last Day to Drop Semester-Length Classes Without a "W"
Last Day to Receive a Refund for Semester-Length Classes
September 3 Labor Day Holiday
September 21 Last Day to Apply for P/NP (credit/no credit instead of grade)
October 12 Last Day to Apply for Fall Degree/Certificate
November 8 Last Day to Drop Semester-Length Classes
November 12 Veteran's Day Holiday
November 22, 23, 24 Thanksgiving Holiday
December 10 End of Second 8-Week Session
December 11-17  Final Examination Days
December 19 Instructor Grade Deadline

This course adheres to the policies outlined in the Cuyamaca College catalogue. For further information, see Academic Policies stated in the catalog.