Course Outline

Title:	PHP/MySQL Web Development	Course Number:	CS- 234P

		Credits:	3

		Date:	November 2010

Institution:	Clackamas Community College

Outline Developed by:	Douglas B. Cross, PhD

Type of Program:	Lower Division Collegiate

Course Description:
Use PHP and MySQL to develop dynamic web sites for user on the Internet. Develop web sites ranging from simple online information forms to complex e-commerce sites. MySQL database, building, connectivity, and maintenance.

Course Objectives:
•	To understand the general concepts of PHP scripting language for the development of Internet websites.
•	To understand the basic functions of MySQL database program.
•	To learn the relationship between the client side and the server side scripts.
•	To develop a final project using the learned techniques.

Student Learning Outcomes:
Upon successful completion of this course, a student should be able to:
•	Use a PHP editing program.
•	Develop functional  PHP script.
•	Develop a MySQL database.
•	Understand the use of PHP with HTML.
•	Understand the ability to post and publish a PHP website.
•	Develop Database connectivity using MySQL.
•	Debug script.
•	Develop Web Applications.

Length of Course:	33 lecture hours

Grading Method:	Letter grades (A-F) or Pass/No Pass

Prerequisites:	Pass CS-125H.

Major Topic Outline:
1. 	Introduction 
2. 	Introduction to PHP
3. 	Programming with PHP
4. 	Creating Dynamic Web Sites
5. 	Introduction to MySQL
6. 	Introduction to SQL
7. 	Advanced SQL and MySQL
8. 	Common Programming Techniques

9. 	Web Development
10. 	Web Application Development 
A. 	Example: Message Board
B. 	User Registration
C. 	E-Commerce

CCC AAOT/ASOT GENERAL EDUCATION OUTCOMES 	Course Title and Number:   CS-234P   
COURSE OUTLINE MAPPING CHART	PHP/MySQL Web Development

 Mark outcomes addressed by this course:
•	Mark “C” if this course completely addresses the outcome. Students who successfully complete this course are likely to have attained this learning outcome.
•	Mark “S” if this course substantially addresses the outcome. More than one course is required for the outcome to be completely addressed. Students who successfully complete all of the required courses are likely to have attained this learning outcome.
•	Mark “P” if this course partially addresses the outcome. Students will have been exposed to the outcome as part of the class, but the class is not a primary means for attaining the outcome and assessment for general education purposes may not be necessary.

 As a result of completing the AAOT /ASOT general education requirements, students will be able to:
WR: Writing Outcomes		
1. Read actively, think critically, and write purposefully and capably for academic and, in some 
              cases, professional audiences.		
2. Locate, evaluate, and ethically utilize information to communicate effectively.		
3. Demonstrate appropriate reasoning in response to complex issues.		
SP: Speech/Oral Communication Outcomes		
1. Engage in ethical communication processes that accomplish goals.		
2. Respond to the needs of diverse audiences and contexts.		
3. Build and manage relationships.		
MA: Mathematics Outcomes		
1. Use appropriate mathematics to solve problems.		
2. Recognize which mathematical concepts are applicable to a scenario, apply appropriate 
    mathematics and technology in its analysis, and then accurately interpret, validate, and
    communicate the results.		
AL: Arts and Letters Outcomes  		
1. Interpret and engage in the Arts & Letters, making use of the creative process to enrich the quality of
    life. 		
2. Critically analyze values and ethics within a range of human experience and expression to engage 
    more fully in local and global issues. 		
SS: Social Science Outcomes		
1. Apply analytical skills to social phenomena in order to understand human behavior.		
2. Apply knowledge and experience to foster personal growth and better appreciate the diverse social
    world in which we live.		
SC: Science or Computer Science Outcomes		
1. Gather, comprehend, and communicate scientific and technical information in order to explore 
    ideas, models, and solutions and generate further questions.		
2. Apply scientific and technical modes of inquiry, individually, and collaboratively, to critically
    evaluate existing or alternative explanations, solve problems, and make evidence-based decisions 
    in an ethical manner.		
3. Assess the strengths and weaknesses of scientific studies and critically examine the influence of 
    scientific and technical knowledge on human society and the environment.		
CL: Cultural Literacy Outcome		
1. Identify and analyze complex practices, values, and beliefs and the culturally and historically 
              defined meanings of difference. 		
IL: Information Literacy Outcomes		
1. Formulate a problem statement.	P	
2. Determine the nature and extent of the information needed to address the problem.	P	
3. Access relevant information effectively and efficiently.		
4. Evaluate information and its course critically.		
5. Understand many of the economic, legal, and social issues surrounding the use of information.