SADDLEBACK COLLEGE

                                                          BUSINESS SCIENCE DIVISION

                                                                  COURSE SYLLABUS

CIM 289 - SPECIAL TOPICS: LAMP-PHP-MYSQL WEB DATABASE E-COMMERCE
08/22/2005 – 12/18/2005

 

Instructor:          Tom Dedonno                                                             Semester:           Spring 2005

E-mail:                tdedonno@juno.com                                                    Ticket No:         21925

Web-site:   http://saddleback.edu/faculty/tdedonno    Office Hours             Time & Day:     7:00-10:00PM Wed

Class  site: http://saddleback.edu/faculty/tdedonno/lamp                            Room:               BGS 203

 

COURSE DESCRIPTION:

Covers installing and configuring a Linux Apache web server, MySQL, and PHP. Course will emphasize MySQL, provide case sudies of typical Business to Consumer (B2C) E-commerce web sites, and provide highlights of LAMP (Linux, Apache, MySQL, PHP-Perl-Python) tools. This course is geared for both intermediate and advanced Internet users.

 

COURSE OBJECTIVES:

Upon completion of this course, the student will be able to:

  1. Install dual boot version of Linux-MSWindows on a home computer.
    2. Install and configure Apache Web server.
    3. Use Apache virtual hosting, monitoring and performance tuning.
    4. Install and configure an Apache MySQL PHP Web application server.
    5. Use the MySQL language to access, and manipulate data from a database.
    6. Use E-Commerce shopping cart and store fronts.
    7. Explain the design of advance B2C E-Commerce web-sites.
  2.  

STUDENT RESOURCES:

Sams Teach Yourself PHP, MySQL and Apache All in One, By Julie Meloni. ISBN: 0672327252; Published: Dec 3, 2004; Copyright 2005 2nd Edition

Optional: Age of Empires Conqueror Edition Trial or Real Version

Storage:  Invest in a USB Pen Drive (128MB to 1GByte) – Hot Pricing

The course grade will be calculated from:

                 70%............. Homework Assignments

     30%............. Tests                                           

 

Class will have 10-15 homework assignments, these assignments will be taken from end of chapter “Hands-On Projects”, see class web-site homework assignments link. Each homework assignment is worth ten homework points. All students will have the option to obtain extra credit in one of two ways: First, you may complete a project in lu of the homework; Second, you may research the Web for Open Source Web products, OSCommerce and sourceforge.net. Since this class meets only once a week, you will be required to supply an e-mail address that you use frequently, preferably you can forward saddleback account e-mail’s to your main e-mail. When sending me e-mails, make sure you include lamp  in the subject line.

 

Assignments are due on the date specified on the assignment. Late assignments handed in by one week after the assignment was due will be penalized by 50% of the grade for that assignment. Assignments later than one week late will not be accepted.

 

We will have two tests comprising 30%  of the grade. The final is just another test. Each test is worth 15% of the final grade.  Tests will be hands on, using Computers.

 Test 1

10/12/05

 

Final

12/14/05 7:30-9:30

Drop with  Refund

9/2/05

Drop without W

9/23/05

Last Day to  Elect CR/NC

9/23/05

Drop with W

11/3/05

 

Percentage

Grade

92-100

A

84-92

B

70-84

C

60-70

D

0-59

F

 

Attendance: It is the student's responsibility to officially withdraw (drop) from the class. Students who no longer attend class but do not withdraw will receive a failing grade ("F") at the end of the semester. Attendance is not part of the course grade, but students are expected to attend all class meetings. Students who do not attend the first class sessions, or who miss any two class sessions (6 or more classroom hours) may be dropped from the course by the instructor. Detailed attendance policy is maintained online.

 

REGRADING POLICY:

Sometimes you get a grade that you don't like, usually for one of the following reasons:

 

1.  There was a clerical error  (i.e., the points were added up wrong).

2.  You think you did something right, and I think you did it wrong.

 

If you discover a clerical error, tell me immediately. The following Statute of Limitations will apply: You have one week from the day any graded assignment or test is returned to you to appeal the grade you received. After one week, I will assume that you believe the grade you got is the correct one. After one week, grades are unchangeable, fixed, and permanent.

 

Students with disabilities are entitled to appropriate accommodations.  If you have specific disabilities requiring accommodations, let your instructor know the first 10 days of the semester so that your learning needs may be met and for referral to the Special Services office where documentation of your disability will be provided to receive services and accommodations.  The Special Services Office is in Student Services Center, Room 113.

 

Any exceptions to the above statements will be considered individually & only if you approach me about the proposed exception at least a week in advance.


 

 

Tentative Syllabus Schedule
Class Web-site Schedule is Updated during Semester

Ticket

#18490

Tentative SCHEDULE - University Calendar
Last Updated Wednesday, August 24, 2005 10:06:49

Fall 2005

Week

Topic

Reading

1

Web Overview - Introductions - History of Scripting

 

2

 

Chapter 1 & 2

3

 

Chapter 3 & 4

4

Building Blocks of PHP, Flow Control Functions in PHP

Chapter 5 & 6

5

Chapter 7 Working with Functions, Chapter 8 Working with Arrays and Objects

Chapter 7 & 8

6

Chapter 9 - Working with Strings Dates & Time, Finish Chapter 10 Forms

Chapter 9 & 10

7

Chapter 11 Cookies & Sessions,

Chapter 11 & 12

8

 

Chapter 13 & 14

9

 

Chapter 15 & 16

10

 

Chapter 17 & 18

11

 

Chapter 19 & 20

12

 

Chapter 21 & 22

13

 

Chapter 23 & 24

14

 

Chapter 25 & 26

15

 

Chapter 27 & 28

16

 

Chapter 29 & 30

 

 

Chapter 31 & 32