2 hours lecture, 3 hours laboratory, 3 units
Monday 5:00PM - 7:45PM
2.5 hours per week online (discussion, quizzes, and lab assignments)
Course Web Site: www.cuyamaca.edu/jreed/219
Jodi's Spring 2014 Office Hours
E-107 or E-206
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.
In this 3-unit course, students will use PHP and MySQL create dynamic web sites. The course will cover 3 main topics:
- web programming - how to code PHP
- database development - how to work with a MySQL databases using phpMyAdmin or PHP
- common applications - common uses for database-driven web sites
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).
At the end of this course, each student will be able to:
- Describe fundamental concepts of server side scripting and the PHP scripting language and explain how they apply to dynamic web development.
- Describe the advantages of database-integrated web development and demonstrate practical applications of the technology.
- Write and debug syntactically and semantically correct PHP programs based on criteria established in class.
- Use PHP scripting to display, query, edit, add and delete data from a MySQL database.
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)|
A 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.
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.
Murach's PHP and MySQL by Joel Murach
$38 on Amazon
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.
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.)
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.
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)
|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.