De La Salle - College of Saint Benilde

School of Management and Information Technology

Information Systems Program

COURSE SYLLABUS

COURSE CODE : WEBDEVT

COURSE TITLE : WEB DEVELOPMENT (PHP and MySQL)

COURSE CREDIT : 3 Units

PRE-REQUISITE : IS-EBIZ

PRE-REQUISITE TO :

TYPE OF COURSE : Major Course

FACULTY :

TERM/ TIME/ ROOM :

Course Description:

The course provides an overview of web application development using PHP, MySQL and Apache. Topics covered includes: PHP scripting fundamentals, client and server side scripting, database interactions and web security. It aims to train the students to develop practical web applications using PHP and MySQL.

Course Objectives:

At the end of the course, students will be able to:

1. Explain the fundamental concepts of PHP and MySQL for developing browser based applications.

2. Develop dynamic web pages using PHP.

3. Design MySQL database tables that interact with PHP web pages.
4. Develop web forms that performs data validations
5. Implement a robust web application using PHP and MySQL.

Course outline:

Week	Competency Skills	Topics
1		Review on HTML/Javascript/CSS Review on Dynamic Web Applications Introduction to PHP and MySql
2-4	Develop dynamic web pages using PHP	PHP Basics Variables Control Structures Loops and Arrays Functions
5-6	Develop web forms that performs data validations	Developing dynamic Web Forms Cookies Session Management Data validations
7-8	Design the MySQL database that interact with PHP	Introduction to MySQL Database Create and populating a MySQL database Review on Normalizations SQL Query Statements using MySQL Connecting MySQL database with PHP Accessing data in MySQL database with PHP
9		Object Oriented Programming with PHP5
10-11		Writing secure PHP code Error Handling in PHP
12-13	Implement robust web applications using PHP and MySql	Web development projects using PHP/MySql
14	Finals (Final Project Presentation & Final Exam)

Teaching Methods / Strategies:

The course is delivered mostly through learner-centered methodology with emphasis on individual and collaborative activities where teachers prepare the environment for learning and guide the learners to develop the important competencies. These methods are geared towards the belief that students learn best and retain much of the learning in an atmosphere where they are allowed to apply their creativeness and self expression.

Requirements / Deliverables:

1. Preparation and Participation in Lectures / Discussions

2. Exercises

3. Major Examinations

4. Final Project

5. Midterm and Final Exam

CLASS POLICIES, REQUIREMENTS AND FEEDBACK:

Plagiarism Policy:

Using the oral or written words and ideas of others without proper acknowledgment is plagiarism and is an academic offence. As a form of academic misconduct, students found guilty face serious consequences as stipulated in the College guidelines.

Submission Policy:

To promote professionalism and competence, submission of requirements and deliverables must always be on time. The teacher reserves the right NOT to accept late submissions and will rate the requirement as failed or zero. In case the teacher decides to accept late requirement due to valid reasons, the teacher will impose point deductions on the score obtained or deduct 10% of the total score per day of delay. Students must present a letter from their parent or legal guardian appealing for the teacher to accept the late requirement. Valid proof must be attached to the letter of appeal.

Quiz & Exam Policy:

Students must attend all required scheduled quizzes and exams at the designated time and place. Individual professors may accommodate for illness or personal crisis. Surprise or unannounced quizzes are a prerogative of the professor. Additional accommodation will not be made unless a written request is sent to and approved by the Chairperson or Dean prior to the scheduled exam or as prescribed by the student manual. Any student who misses a scheduled quiz or exam without approval will be given a failing grade for the quiz or exam. Behaviour during exams is expected to conform to College guidelines. No further warnings will be given prior or during the exams, the penalty for cheating is immediate failure in this course.

Assessment / Evaluation:

To asses the performance and competencies of the learners…

1. Quizzes and Exams will be administered to determine if the learners can remember basic information

2. Exercises will be given to determine if learners can apply the information in another familiar situation

3. Final Project will be given to confirm if learners can apply the lesson learned

4. Rubrics will be used to assess Authentic Learning Activities

Requirements:

The student’s academic performance will be evaluated based on the following requirements:

• Attendance

  • Students are evaluated based on presence, tardiness or absence in class.

  • Attendance is to be accounted for every class period

• Exercises and Short Quizzes

  • Activities given to assess a student’s ability to retain concepts taught in class.

  • This activity is also given for hands-on applications that require student involvement in order to ensure long term retention of the lessons taught during the period.

  • The students may be given a set of 4-8 exercises and short quizzes for the duration of the term

  • Machine projects are practical problems that tests whether students are able to perform extensions and researches in order to further their learning, customizing learned concept to a develop solutions to real-life problems.

• Long Exams

  • These activities are given to assess if students are able to prepare for challenging applications to the concepts that they have learned and if they are able to use and apply concepts learned to create concrete solutions to a related problem.

  • These activities may be hands-on or written.

  • There should be at least 3 long quizzes every term.

• Examinations

  • Major examinations given to ensure that students learned the needed concepts or is able to deliver the required output by the end of the term.

  • These examinations may come as hands-on or written activities, whichever is deemed appropriate by the facilitating professor.

  • Only 1 mid-term and 1 final examination may be given each term.

Grading System (Simplified):

In order to get a passing mark, students should acquire a final grade of no less than 70%. The summary below indicates how the final grade is distributed for this subject.

MIDTERMS			PRE-FINALS
Class Activities (Short Quizzes, Recitation, Presentation) Lab Exercises (Machine problem) Project Deliverables / Blog Reaction (Assignments)	65%		Class Activities (Short Quizzes, Recitation, Presentation) Lab Exercises (Machine problem) Project Deliverables / Blog Reaction (Assignments)	65%
Values	5%		Values	5%
Attendance	5%		Attendance	5%
Major Examination	25%		Major Examination	25%
TOTAL	100%		TOTAL	100%

Final Grade = 50% midterm grade + 50% finals grade

REFERENCES:

Books:

1. Lerdolf, R. Tatroe, K. 2006. Programming PHP. O’Reilly Media, Inc.

2. Wandschneider, M. 2005. Core web application development with PHP and mySQL. (Pap/Cdr Ed.) Prentice Hall.

3. Powers, D. 2006. PHP solutions, dynamic web design made easy. Friends of Ed.

4. Gilmore, J. 2008. Beginning PHP and mySql : from novice to professional. (3rd Ed.) Apress.

5. Kofler, M. 2005. The definitive guide to mySQL 5. (3rd. Ed.) Apress.

Films:

Websites:

1. Companion course wiki (http://webdevt.pbwiki.com )

2. PHP Online Manual. (www.php.net) 

3.  MySQL Documentation (http://dev.mysql.com/doc/ )

4.  Nettuts PHP Tutorials http://nettuts.com/category/tutorials/php/

5.  http://del.icio.us/tag/php

Professor’s Consultation Hours and Venue: ____________________



COURSE SYLLABUS ACKNOWLEDGEMENT FORM (SUBMIT THIS FORM TO THE TEACHER)	COURSE CODE : WEBDEVT COURSE TITLE : Web Development COURSE CREDIT : 3 Units COURSE SCHEDULE : Days : Time : Term : S.Y. : SECTION & ROOM : Section : Room : PROFESSOR :
This is to certify that I, ___________________________ have read and WRITE YOUR FULL NAME understood the entire syllabus and agree with its content, policies and consequences. ___________________ ____________ SIGNATURE DATE SIGNED