-
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
|

|
- 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.
- All homework is due the following week, unless otherwise specified
- All homework questions are to be printed.
- All homework code assignments are to be printed with output
- All homework must have name, homework assignment number, campus location, date
// John Smith
// Homework 3
// West Campus
// 11/14/2006
- 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
|
|