KERN COMMUNITY COLLEGE DISTRICT – CERRO COSO COLLEGE

DMA C213 COURSE OUTLINE OF RECORD

  1. DISCIPLINE AND COURSE NUMBER:
    DMA C213
  2. COURSE TITLE:
    Web Development with PHP and MySQL
  3. SHORT BANWEB TITLE:
    Web Development w/ PHP & MySQL
  4. COURSE AUTHOR:
    Ama, Suzanne N.
  5. COURSE SEATS:
    -
  6. COURSE TERMS:
    30 = Spring
  7. CROSS-LISTED COURSES:
    CSCI Web Development with PHP and MySQL
  8. PROPOSAL TYPE:
    CC Course Revision
  9. START TERM:
    30 = Spring, 2012
  10. C-ID:
  11. CATALOG COURSE DESCRIPTION:
    This course provides students with the skills to create dynamic web pages with PHP and MySQL. Practical applications of PHP include Web form data processing, work with MySQL databases, and read and write text files.

  12. GRADING METHOD

    Default:
    S = Standard Letter Grade
    Optional:
     
    A = Audit;P = Pass/No Pass
  13. TOTAL UNITS:
    3

  14. INSTRUCTIONAL METHODS / UNITS & HOURS:

    Lecture
    36
    Lab
    54
    Activity
    Open Entry/Open Exit
    Volunteer Work Experience
    Paid Work Experience
    Non Standard
    Non-Standard Hours Justification:

  15. REPEATABILITY

    Type:
     
    Non-Repeatable Credit
  16. MATERIALS FEE:
    No
  17. CREDIT BY EXAM:
    No
  18. CORE MISSION APPLICABILITY:
    Associate Degree Applicable (ADA);Certificate of Achievement (COA);CSU Transfer;Career Technical Education (CTE)
  19. STAND-ALONE:
    No

  20. PROGRAM APPLICABILITY

    Required:
     
    Elective:
    Computer Information Systems AS (AS Degree Program)
    Computer Information Systems Associate of Science Degree (AS Degree Program)
    Computer Information Systems Cert (Certificate)
    Web Design AS (AS Degree Program)
    Web Design AS (AS Degree Program)
    Web Design Certificate (Certificate of Achievement)
    Website Design Cert (Certificate)

  21. GENERAL EDUCATION APPLICABILITY

    Local:
    IGETC:
     
    CSU:
    UC Transfer Course:
     
    CSU Transfer Course:
    California State University, Chico = APCG 180 Scripting and Programming for Computer Graphics. This course introduces application scripting and programming to visual artists using scripting and programming environments embedded in applications and integrated graphical development environments. Fundamental scripting techniques for computer modeling, animation, video game and other visual media will be explored. Elementary application programs will be designed, implemented and tested. 2.0 hours lecture, 2.0 hours activity. (020648)
    California State University, Dominguez Hills = CSC 255.Introduction to Dynamic Web Programming
    California State University, Northridge = CIT 270/L. Integrative Programming. Role of integrative programming in information technology: operating systems, system management, application reuse. Tools and techniques for integrative programming, such as Perl, TCL/tk, VBscript, Python. Script programming development environments. Role of scripting in system installation and management. Client-server architecture. Interface management, wrappers, facades, brokers, and proxies. XML and XML related technologies with emphasis on data exchange for application/system integration. Integration technologies, such as web services, Ruby on Rails, CORBA, DCOM. Integration platforms, such as .net and J2EE. Lab: three hours per week.

  22. STUDENT LEARNING OUTCOMES—Upon completion of the course, the student will be able to

    1. Explain what a programming language is and describe the basic syntax of PHP.
    2. Create dynamic web content using programming concepts such as variables, expressions, operators, functions, events, arrays, decision statements, repetition statements, and databases.
    3. Write programs that will add, edit and delete records from a MySQL database.
    4. Write programs that process form input data to a text file, database, or screen display.
    5. Maintain session state.

  23. REQUISITES

    Advisory:
    Mathematics - 3 Levels Prior to Transfer
    Reading - 1 Level Prior to Transfer

    DMA C211

  24. DETAILED TOPICAL OUTLINE:

    Lecture:

    A.      PHP Basics

    1.       Assigning information

    2.       Different data types

    3.       Operators

    4.       Using comments

    B.      Variables

    1.       Variables and literals

    2.       Understanding identifiers

    3.       Creating user-declared variables

    4.       Assigning values to variables

    5.       Declaring and using constants

    6.       Understanding variable scope                          

    7.       Data types

    C.      Operators

    1.       Concatenation operator

    2.       Basic operators

    3.       Comparison operators

    4.       Logical operators

    5.       Operator precedence

    D.      Functions

    1.       Defining a function

    2.       Adding parameters

    3.       Calculations

    4.       Return values

    E.       Control structures

    1.       Selection statements

    2.       Loops

    F.       Manipulating strings (B)

    1.       Concatenation operator

    2.       String functions

    3.       String constraints

    G.      Form handling

    1.       $_Get and $_Post variables

    2.       Form validation

    H.      Working with databases and MySQL

                                         1.            Overview of databases

                                         2.            Database design

                                         3.            Creating tables

                                         4.            Inserting information into tables

                                         5.            Viewing data

                                         6.            Editing and deleting data

                                         7.            Order and pattern matching

                                         8.            Returning records

                                         9.            Amending table structure

                                      10.            Deleting tables and databases

                                      11.            Backing up and restoring data

    I.        Manipulating MySQL Databases with PHP

                                         1.            MySQL connections

                                         2.            Returning records into a table

                                         3.            Inserting a record

                                         4.            Updating a record

                                         5.            Deleting a record

                                         6.            Checking for duplicate entries

    J.        Managing Session States

    1.       Session variables

    2.       Starting a session

    3.       Storing a session

    4.       Destroying a session

    K.      Developing Object-Oriented PHP

    1.       Data members and functions

    2.       Constructors

    3.       Overloading

    4.       Copying and cloning

    L.       Error Handling and Debugging

    1.       Types of errors

    2.       Handling and reporting errors

    3.       Debugging techniques

    M.     Processing XML (B)

    1.       Basics of XML

    2.       Parsing XML documents

    3.       Parsing XML with SimpleXML functions

    N.      Secure Coding with PHP

    1.       Understanding PHP security issues

    2.       Important security steps to take

    Lab:

    Program and database writing exercises and assignments

  25. METHODS OF INSTRUCTION--Course instructional methods may include but are not limited to

    1. Computational Work;
    2. Demonstration;
    3. Discussion;
    4. Laboratory;
    5. Lecture;
    6. Outside reading;
    7. Problem Solving;
    8. Project-based learning;
    9. Other Methods: A. Textbook readings and exercises B. Written lectures C. Synchronous and asynchronous instructor and peer feedback

  26. OUT OF CLASS ASSIGNMENTS:  Out of class assignments may include but are not limited to

    A. Textbook readings B. PHP/MySQL assignments

  27. METHODS OF EVALUATION: Assessment of student performance may include but is not limited to

    A. PHP/MySQL assignments
    Example: Students create a database that will populate a Web page’s content.
    B. Discussion assignments
    Example: Students provide feedback to each other about weekly assignments.
    C. Group Project
    Example: Students work in groups to create several pages that extend the site’s capabilities through PHP/MySQL.
    D. Journal
    Example: Students reflect on the relative success of their group work.

  28. TEXTS, READINGS, AND MATERIALS: Instructional materials may include but are not limited to

    Textbooks
    Gosselin, D., Kokoska, D., Easterbrooks, R.. (2010) . PHP Programming with MySQL: The Web Technology Series, 2nd edition, Course Technology
    Manuals
    Periodicals
    Software
    Other
  29. METHOD OF DELIVERY:
    Online with some required face-to-face meetings (“Hybrid”);Other;
  30. MINIMUM QUALIFICATIONS:
    Computer Information Systems;Computer Science (Masters Required);Multimedia;

  31. APPROVALS:

    Origination Date
    05/06/2011
    Last Outline Revision
    05/06/2011
    Curriculum Committee Approval
    05/06/2011
    Board of Trustees
    06/09/2011
    State Approval
    06/16/2011
    UC Approval
    CSU Approval
    50 = Summer 2005
    IGETC Approval
    CSU GE Approval