Discipline: Computer Information Systems Degree Credit  [X]
Non Credit  [ ]
Nondegree Credit  [ ]
Comm Service  [ ]
 

Riverside Community College District
Integrated Course Outline of Record

Computer Information Systems 12


COURSE DESCRIPTION
12 PHP Dynamic Web Site Programming Units: 3.00
 
Prerequisite(s): None.

Advisory: CIS 5 or CIS 14A and CIS 72A or CIS 14A
Dynamic Web site programming using PHP. Fundamentals of server-side Web programming. Introduction to database-driven Web sites, using PHP to access a database such as MySQL. Web applications such as user registration, content management, and e-commerce. This course is for students already familiar with the fundamentals of programming and HTML. 54 hours lecture and 18 hours laboratory.
 
SHORT DESCRIPTION FOR CLASS SCHEDULE
Introduction to dynamic Web site programming using PHP, featuring database-driven applications such as user registration, content management, and e-commerce.
 
ADVISORY ENTRY SKILLS
Before entering the course, students will be able to:
  1. Write a short working program or script using any programming language.

  2. Understand fundamental programming concepts including variables, decisions, loops, objects, and functions.

  3. Identify basic HTML or XHTML tag structure, including those for text, links, tables, and forms.

  4. Content Review for Advised Courses: Learning Outcomes for CIS/CAT-72A

  5. Design and create Web pages using Extensible Hypertext Markup Language (XHTML).

  6. Use XHTML to create pages with text, hyperlinks, lists, and images.

  7. Use XHTML to create pages with tables, frames, and forms.

  8. Analysis: CIS/CAT-72A learning outcomes 1, 2, and 3 all correspond to CIS-12 entry skill 3. Together, they are highly aligned with this entry skill. In fact they provide more competency than is necessary.

  9. Learning Outcomes for CIS-14A: Students should be able to:

  10. Create JavaScript programs that will run successfully in a browser using various data types, variables, operators, expressions, statements, decisions, loops, and functions.

  11. Demonstrate competency in writing scripts using JavaScript core objects, properties, and methods, including the Array, Math, String, and Date objects.

  12. Demonstrate competency in writing scripts to process and validate forms, manipulate frames and windows, and employ cookies.

  13. Demonstrate competency in writing scripts that use objects, properties, methods, and events of the Document Object Model (DOM).

  14. Analysis: CIS-14A learning outcome 1 corresponds to CIS-12 entry skill 1 and is highly aligned. It also implies correspondence with entry skill 3 and is moderately aligned. Learning outcomes 2, 3, and 4 correspond to CIS-12 entry skill 2 and are highly aligned. Learning outcomes 3 and 4 also correspond to CIS-12 entry skill 3 and are moderately aligned.

  15. Learning Outcomes for CIS-5: Students should be able to:

  16. Create computer programs in C++ using the principles of structured programming.

  17. Apply the principles of logical and programming concepts to develop specific solutions for business, scientific and mathematics problems.

  18. Identify the information input requirements, synthesize the algorithmic steps needed to transform the data input into the required output information, and organize the output format to facilitate user communication.

  19. Demonstrate the use of the C++ IDE and libraries.

  20. Analysis: CIS-5 learning outcome 1 corresponds to CIS-12 entry skill 1 and is highly aligned. Learning outcomes 2 and 3 correspond with CIS-12 entry skill 2 and are moderately aligned. Learning outcome 4 does not correspond to any CIS-12 entry skills.
STUDENT LEARNING OUTCOMES
 Upon successful completion of the course, students should be able to:

1.   Write working PHP scripts to create valid content on Web pages.

2.   Write and use PHP functions and objects effectively.

3.   Create PHP scripts that display dynamic Web page content
      retrieved from a database.

4.   Create form pages using PHP to validate data entry, process form
      data, and update a database.

5.   Understand and create PHP data-driven Web applications.
 
COURSE CONTENT
  TOPICS
 

1.   Short review of HTML, including basic tag structure, tables, and
      forms.
2.   Short review of fundamentals of programming, including variables,
      decisions, loops, and functions.
3.   Introduction to programming with PHP
      a.   PHP syntax for scripts
      b.   PHP variables, decisions, and loops
      c.   PHP objects and functions
4.   Form validation with PHP
5.   Working with databases
      a.   Introduction to database concepts and structure
      b.   Introduction to SQL statements
      c.   Database access with PHP
      d.   Displaying page content from a database
      e.   Form processing and database updates
6.   Writing data-driven applications. Use of databases and PHP to
      create common Web applications such as content management
      systems, e-commerce (such as database driven product catalog
      and shopping cart systems), user registration (such as user
      customized content), and the like. The application(s) should
      incorporate as many of the course content items as possible while
      remaining as topical as possible.
 
METHODS OF INSTRUCTION
 Methods of instruction used to achieve student learning outcomes may include, but are not limited to:

  • Present class lectures/discussions/demonstrations in order to clarify the concepts, show and explain samples of databases, HTML and PHP programming, and apply PHP features to actual Web pages
  • Quizzes designed to motivate and facilitate the acquisition of PHP related programming skills
  • Exercises designed to facilitate and demonstrate the acquisition of PHP related programming skills
  • Online instructional tasks/activities to provide additional HTML, database, and/or PHP related information, samples, and tutorials to facilitate concept clarification and skill building
  • Project(s) designed to facilitate and demonstrate the acquisition of skills required to write database driven Web applications using PHP
  • Collaborative projects/cooperative learning tasks that encourage students to develop and apply PHP programming skills
 
METHODS OF EVALUATION
 Students will be evaluated for progress in and/or mastery of learning outcomes by methods of evaluation which may include, but are not limited to:

  • Quizzes designed to assess the acquisition of PHP related programming skills
  • Exercises designed to demonstrate the acquisition of PHP related programming skills
  • Online instructional tasks/activities to provide additional HTML, database, and/or PHP related information, samples, and tutorials to facilitate concept clarification and skill building
  • Project(s) designed to facilitate and demonstrate the acquisition of skills required to write database driven Web applications using PHP
  • Collaborative projects/cooperative learning tasks that encourage students to develop and apply PHP programming skills
  • Student presentations used to demonstrate knowledge and/or skills attained
ASSIGNMENTS

Required Reading Assignments


Required Writing Assignments


Other Outside-of-Class Assignments
 
COURSE MATERIALS
 All materials used in this course will be periodically reviewed to ensure that they are appropriate for college level instruction. Possible texts include:

  • Ullman, Larry. PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide. Peachpit Press, 2003.
  • Gilmore, W. J.. Beginning PHP 5 and MySQL: From Novice to Professional. Apress, 2004.
  • Vaswani, Vikram. How to Do Everything with PHP & MySQL. McGraw Hill/Osborne, 2005.
  • Welling, Luke, and Thomson, Laura. PHP and MySQL Web Development. 3rd ed. Sams Publishing, 2005.
10/05
507