Special Topics
COP 2930 - AMP

Instructor: Robert Mudge
Email: Professor@mudge.net (Email read periodically)
Web Site: http://mudge.net/
College Important Dates: Link
Office Hours: Special Appointment or Email
Classes: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Final
Grade Book - Required Valencia ID (i.e. V13249201, upper case)
Test Center - Required Valencia ID (i.e. V13249201, upper case)
Valencia Community College Web Site
amp
  • Course Location, Times and Prerequisite
    Course Title Credit
    Hours
    Class Days Campus Building Room # Prefix
    Section
    Starts Ends
    COP 2930
    Special Topics
    3 Tues West Mod 7  122 W02 7:00p 9:45p
    Prerequisite: Basic knowledge of a programming language like C, C++ or Java, basic HTML web page design (by hand preferred) and basic SQL.  Campus Lab Fee Applies.
  • Core Competencies:
    Valencia faculty have defined four interrelated competencies (Value, Think, Communicate, Act) that prepare students to succeed in the world community. These competencies are outlined in the College Catalog. In this course, through classroom lecture and discussion, group work, and other learning activities, you will further develop your mastery of these core competencies.
  • Course Catalog Description
    COP 2930 Special Topics
    A special topics course which addresses current trends and technology for the net-centric industry. Focus is on using the Apache web server with Php scripting and a MySQL database to create dynamic, secure ecommerce like web sites.
  • Course Text
    Beginning PHP5, Apache, and MySQL Web Development
    By: Elizabeth Naramore, Jason Gerner, Yann Le Scouarnec, Jeremy Stolz, Michael K. Glass
    • Paperback: 816 pages
    • Publisher: Wrox (February 4, 2005)
    • Language: English
    • ISBN: 0764579665
    AMP Book
  • Suggested Tools
    A USB or Jump drive of about 512 Mb would be useful to contain you entire web development environment for working in class and at home.
  • Course Objective
    The objective of this course is to provide the student with the fundamental knowledge and skills to design, build and operate a professional web site/application.. The student will learn to install, configure and code to the Apache web server, PHP scripting language and operate a MySQL database. Industry standard software engineering techniques will be presented and used to architect the system design.

    The course provide an installable and operational web environment for the student to run from a lab or personal computer running Windows XP. The course will use a professional e-commerce web site as a live example to the concepts presented in this course.
  • Evaluation Process
    Each student will be expected to perform out of class assignments and programming projects.   Quizzes and examinations will cover the concepts, syntax and theory used in the course.

    Homework will be evaluated as an aid to the student's progress in the course.  The course grade will be determined by the quiz, exam and project grades. Grading Method:

    Attendance    25 %   ( Unless excused, 2 Max Absences )
    Homework    25 %   ( Assigned Problems & Project )
    Midterm        25 %   ( Chapters 1-5 )
    Final Exam    25 %   ( Chapters 1-12 + 17)

    A     90 to 100 %  
    B     80 to 89 %
    C     70 to 79 %
    D     60 to 69 %
    F      < 59 %


    Failure to sit for the Final exam will yield a WF per school policy.
    Changing from grade to audit must occur before the withdraw deadline.
  • Withdrawal Policy and Important Dates
    A student may withdraw at any time before 11/3/2006 for filing a withdrawal form in the Admissions Office in Building I and receive a W for a grade. After this date, if a student withdraws or is withdrawn by the professor for excessive absence or other reasons, the professor will assign a withdrawal of WP (Withdrawal Passing) or WF (Withdrawal Failing), based upon the student's academic achievement in the class as of the last date of attendance. A W or WP will not be calculated in the grade point average. If a student fails to take the required final examination, the professor will assign a WF.
  • Classroom Policies
    Valencia's attendance policy is that a student will be present for all class meetings. After two absences (one in a night class), a student will receive an excessive absence notice and must schedule a conference with the instructor immediately. After two absences (one in a night class), a student may be withdrawn at any time at the discretion of the instructor. Continual tardiness will be viewed as absences and treated as such.

    A student is responsible for all material covered during absences. Make-ups for scheduled tests must be requested before the test date and are subject to approval of the instructor. Unscheduled tests cannot be made up.

    There will be no eating or drinking in the classroom. Class begins at a scheduled time and is over when the instructor dismisses class. Leaving early without prior permission will result in a class-work grade of zero. Tardiness is unacceptable class behavior. If you are tardy and class has begun, take a seat near the door and do not disrupt class by crossing the room.

    Students must do their own work; there are no exceptions. Students who plagiarize or cheat in any way risk dismissal from class and expulsion from the college.

    Disclaimer:  The content of this syllabus or course may change at any time at the instructor's discretion.
  • Homework

    All homework shall consist of PRINTED source code and program output.
    Homework will be graded on correctness in style and content.

    1. All homework is due the following week, unless otherwise specified
    2. All homework questions are to be printed.
    3. All homework code assignments are to be printed with output
    4. All homework must have name, homework assignment number, campus location, date
      // John Smith
      // Homework 3
      // West Campus
      // 11/14/2006
    5. Late homework will NOT be scored unless excused by the instructor
Class
Description Homework
1
08/29/06
The Internet
The Web Server
Chapter 1 - Textbook
Apache, MySQL and PHP Installation and Configuration
Read Chapter 1
Homework 1
Install the distribution CD install the course software, run the PhpInfo Screen in the web browser, print a screen capture using ScreenGrabPro.  Run the Web Site Brag-n-Bracelets, Order a Bracelet and print using PDFCreator the order confirmation.
2
09/05/06
Chapter 2
HTML and PHP Web Page Programming

Read Chapter 2
Read "How Internet Infrastrucutre Works"
Class PowerPoint Slides Php Class 2.ppt
Homework 2
o Create a Login Web Page
o User enters “username” and “password”
o Upon successful input and comparison to a hard coded password, present a welcome page showing the username and password.
o Turn in your source code and screen captures from the operation through a web server.

3
09/12/06
Chapter 2 - Arrays and a Brief OOP
Php MySQL - Connect , Select
Simple Database Design

Read Chapter 2 & 3
Read "How Microsoft Lost the API War"
Review of Homework 2
Class 3 and Homework

4
09/19/06
Using MySQL
Designing and Building a Database
SQL Insert, Join

Read Chapter 3
Read " Joel On Software - Language Wars"
Bringing Login with MySQL to an Application
Class 4 and Homework

5
09/26/06
Chapter 3 - Using PHP with MySQL

Read Chapter 4
Article: Is PHP the Cure for the Broken Web?
Class 5 and Homework
BaseApp 0.0.1

6
10/03/06
Chapter 4 - Using Tables to Display data

Read Chapter 5
Begin Project Functional Specification
Class 6 - Functional Specifications and Homeworks 7,8 & 9
BaseApp 0.0.2

7
10/10/06
Class Change
Chapter 5 - Forms and Data
Review Base App Version 0.0.2

Read Chapter 6
Read Chapter 10
No Class (10/10)
Optional Class Saturday 10/14
9-11 AM
Bld 7 Lobby then move to class room, Questions, Answers and help)
GenApp Functional Specification (Work in Progress)

8
10/17/06
Class Change
Midterm Exam

No Class (10/17) do to Prof. Mudge on Travel
No Class Sat
Midterm is available in the Test Center
User name is your Valenica ID with Capital V

9
10/24/06

Class Change
Chapter 6 - Programmatic Database Operations
Chapter 10 - Designing a database

Read Chapter 7
No Class (10/24) do to Prof. Mudge on Travel
Class Saturday (10/28) 9 to 11:45 AM Same Class Location
Midterm is available in the Test Center
User name is your Valenica ID with Capital V

10
10/31/06
Valencia
Class
Change
Chapter 7 - Images in PHP

Read Chapter 8
No Class Valencia Learning Day - This class is rescheduled for Sat - 11/4
Homework for the next 8 weeks is executing the project.
Present Functional Specifications to Class
Turn in Project Functional Specification
(3 to 5 page PowerPoint)

11
11/07/06
Chapter 8 - Validating User Input Read Chapter 9
12
11/14/06
Chapter 9 - Handling and Avoiding Error Read Chapter 11
13 11/21/06 Chapter 11 - Sending Email Read Chapter 12
14
11/28/06
Chapter 12 - Persistent information Read Chapter 17
15
12/05/06
Chapter 17 - Using Logs and Miscellaneous Prepare final presentation (Final Exam Presentation Requirements)
16
12/12/06
Final Exam
Project Presentations, Live Web Applications