HOME

COURSE SYLLABUS

WEBD 166 - Database Driven Websites

CRN# 73753

This is a hybrid course - part of your work will be on campus and the remainder of your work will be done online.

On campus meetings: Thursdays, 6:00-8:00 p.m. - Mesa campus, Room K103

Online course work: http://blackboard.sdccd.edu/ Login = student ID

Password= your birth date mmddyyyy format

3 Units

Letter Grade or Credit/No Credit Option

FALL 2013: Aug 19-Dec 16

Professor Marianne Gibson | mgibson@sdccd.edu

Office hours: Thursdays 8:00-9:00 p.m.

COURSE INFORMATION

Course Description

This course is a hands-on study of the skills required to build and manage dynamic database driven websites. Students create database-driven websites to support eCommerce and dynamically built pages. This course is designed for all students and professionals who wish to acquire skills in website creation and development. This course may be repeated three times to update skills as technology changes. Associate Degree Credit & transfer to CSU and/or private colleges and universities.
TOTAL LECTURE HOURS: 40 - 45
TOTAL LAB HOURS: 24 - 27

Requisites

Advisory:
ENGL 048 with a grade of "C" or better, or equivalent or Assessment Skill Level R5
and
ENGL 049 with a grade of "C" or better, or equivalent or Assessment Skill Level W5
and
CBTE 101 with a grade of "C" or better, or equivalent
and
CBTE 114 with a grade of "C" or better, or equivalent
and
WEBD 162 with a grade of "C" or better, or equivalent
or
CBTE 162 with a grade of "C" or better, or equivalent
or
WEBD 165 with a grade of "C" or better, or equivalent
or
CBTE 165 with a grade of "C" or better, or equivalent

NOTE: An Advisory will not prevent you from enrolling in this course. It advises you of the skills and knowledge you need to have to be successful in this course. Email your professor if you have questions on this topic.

Student Learning Outcomes

Students will be able to create a database to be used with HTML pages.
Student will be able to upload their website to a web server that supports an individual database.
Students will be able to communicate to end users the function of the database fields on a webpabe by clearly labeling them following industry standards.

Student Learning Objectives

Upon successful completion of the course the student will be able to:

  1. Identify the major components and technologies needed to create and maintain a dynamic Web site.
  2. Analyze the goals, purpose and mission for the Web site and develop the design documents based on this analysis.
  3. Set up a simple Apache server, an SQL database, and an application server.
  4. Integrate a simple database into Dreamweaver’s HTML pages and control the layout and formatting using templates and CSS.
  5. Test the Web site and its database for technical accuracy.
  6. Evaluate the effectiveness of the Web site and database in meeting the goals of the site.
  7. Publish a dynamic Web site to the Internet.

Outline of Topics

The following topics are included in the framework of the course but are not intended as limits on content. The order of presentation and relative emphasis will vary with each instructor.

  1. Introduction to dynamic database applications using Dreamweaver
    A. Static vs. dynamic webpages
    B. Describing a dynamic application
    C. How dynamic applications are used
    D. Goals, purpose and mission
    E. Choosing a web server
    F. Choosing an application server
    G. Choosing a database
  2. Overview of working with databases
    A. Introduction to databases
    B. Installing a database
    C. Using the database administrative tools
  3. Setting up the application server
  4. Creating, editing and deleting in an SQL database
    A. Creating a database
    1. Tables
    2. Records
    3. Reports
    B. Populating a database
    C. Creating a relational database
  5. Setting up a dynamic application
  6. Linking the SQL database and server application (i.e. PHP or Coldfusion)
    A. Exploring the database connection from Dreamweaver
    B. Creating a template to use with the database application
  7. Inserting data into dynamic pages
    A. Using the Bindings panel
    B. Building a simple RecordSet
    C. Generating a dynamic table
    D. Building an advanced RecordSet
    E. Using repeating regions
    F. Using Server Debug and the Live Data View
    G. Updating the application template
    H. Displaying the total number of records
    I. Limiting the number of records with paging controls
    J. Showing which records are being displayed
    K. Creating conditional regions
    L. Creating a Master-Detail page set
    M. Using Dreamweaver templates and CSS to format the web pages.
  8. Building data entry forms
    A. Building HTML forms
    B. Inserting database records with a server behavior
    C. Displaying existing data in an HTML form
    D. Updating database records with a server behavior
    E. Creating links to delete database records
    F. Deleting database records with a server behavior
  9. Authenticating users
    A. Creating a login form
    B. Protecting page access with server behaviors
    C. Logging in the user with a server behavior
    D. Logging out the user with a server behavior
    E. Using access levels
  10. Using Spry in Dreamweaver
    A. An overview of the Spry Framework
    B. Creating a Spry XML dataset
    C. Creating a Spry table
    D. Formatting Spry tables
    E. Creating a Spry repeating region
    F. Creating dynamic navigation with Spry
  11. Validating and testing
  12. Publishing a dynamic website to the Internet
 

POLICES

Attendance Requirements

It is your responsibility to drop and withdraw from this course. If you find you cannot complete this course, you will need to drop it in order to avoid getting an F. I will not drop or withdraw you if it appears to me that you have been active in the course. To avoid being dropped, you need to work in the course at least once a week. I do not sign late drop forms. Following is the stated District policy:

Statement of Retention

You must attend at least one course meeting activity prior to August 30th. This will demonstrate that you intend to complete the coursework.  If you do not attend the course regularly prior to this date, you will be dropped from the course for non-attendance and your seat will be opened up to allow someone on the waiting list to add the course by the last day to add.

Students, please discuss your plans to withdraw from class with me. There may be other options for you that may allow you to continue in class.

Important Dates

Start of the semester Aug. 19
Receive, process, and pay for add codes and to drop classes with no “W” recorded Aug. 30
Refund deadline ‐ enrollment fees and/or non‐resident tuition Aug. 30
Holiday - Labor Day Sep. 2
Last day to file a petition for Pass/No Pass grade option Sep. 20
Withdrawal deadline - No drops accepted after this date; will receive a "W Oct. 25
Holiday - Veterans Day Nov. 11
Thanksgiving Holiday Nov. 25-30
Last day to submit work; all work due at (10:00 PM) Dec. 12
End of the semester Dec. 16
Grades available on e-Grades Jan. 7

Class Behavior and Student Code of Conduct

Students are expected to respect and obey standards of student conduct while in class and on the campus. The student Code of Conduct, disciplinary procedure, and student due process (Policy 310, 3100.1 and 3100.2) can be found in the current college catalog in the section Academic Information and Regulations and at the office of the Dean of Student Affairs. Charges of misconduct and disciplinary sanctions may be imposed upon students who violate these standards of conduct or provisions of college regulations.

Cheating and plagiarism: Students are expected to be honest and ethical at all times in the pursuit of academic goals. Students who are found to be in violation of Administrative Procedure 3100.3 Honest Academic Conduct, will receive a grade of zero on the assignment, quiz, or exam in question and may be referred for disciplinary action in accordance with Administrative Procedure 3100.2, Student Disciplinary Procedures.

My philosophy as your instructor:
Learning is a community endeavor. There is an amazing amount of skill and knowledge in the class as a whole that one instructor cannot hope to duplicate. Students + teacher, blended together, we will help one another to build a strong learning foundation in our classroom.

How we will achieve this together:

Disabled Students Programs and Services

Students with disabilities who may need academic accommodations should discuss options with the Disabled Students Program and Services (DSPS) immediately.

Call or visit Disabled Students Program and Services (DSPS) located on the San Diego Mesa College campus. Contact information is listed on the DSPS webpage: http://www.sdmesa.edu/dsps/

Textbook and Software

REQUIRED:
book cover Textbook: PHP and MySQL for Dynamic Web Sites
Fourth Edition
ISBN-13:978032178407
by Larry Ullman

SUGGESTION:
PHP Programming with MySQL: Second EditionA Guide to MySQL
ISBN-13:9781418836351
by Phillip J. Pratt
Mary Z. Last

OPTIONAL:
PHP for the WebTextbook: PHP for the Web
Fourth Edition

ISBN-13:9780321733450
by Larry Ullman

SUGGESTION:
PHP Programming with MySQL: Second EditionPHP Programming with MySQL:
The Web Technologies Series

ISBN-13:9780538745840
Cengage Learning; 2 edition

Supplies:
1. USB drive
2. Access to a internet
3. Software for writing HTML (Dreamweaver, Notepad++, NetBeans, Eclipse), MySQL, and PHP (XAMPP, MAMP, or USB Webserver)

Buy your textbook anywhere that meets your needs. Check the book name and ISBN numbers on the sites below carefully as publishers often change their links as new books are added to their stock; since the prices change periodically, carefully check the price online.

Software: Dreamweaver CS6 PC or Mac (If you do not have Dreamweaver, go to the Learning Resource Center, fourth floor, or K404 at Mesa College.) This class will use Dreamweaver CS6 to be in sync with the software at Mesa College. You can also use NetBeans or Eclipse, if you prefer.

NOTE: There are minor differences between the PC and the Mac version.

You can purchase your software anywhere. (Prices and software packages subject to change. Follow the links to confirm the current prices and packaged software configurations.)

The Foundation for California Community Colleges
The Foundation for the California Community Colleges has negotiated a special price for students, for both Mac and PC. Select the software package that needs your educational needs; pricing and software offerings can change at anytime CollegeSoftware.org.

Dreamweaver CS6 = about $125 (link straight to Dreamweaver software) http://www.journeyed.com/dept/Brands/Adobe/284060?SKW=ADSELECT1

You can buy either Dreamweaver alone or one of the bundles. The Foundation's software discount site features software from Adobe, Microsoft and more!

Mesa College Bookstore http://www.bookstore.sdccd.edu/mesa/ has a variety of software. Call the bookstore, visit their website, or stop by to see their current selection.

Make sure that any software you purchase will work with your computer and operating system. Shop around for the service and price that best matches your needs. Links and pricing may change. If you notice a change before I do, please let me know.

Correct your textbook

Your textbooks has errors. You need to correct them. Take a minute and open your book to the page listed below and write in the correction. If you don't, you may become frustrated when you are doing a Chapter. Also here is a link to the errata page. It is always updating! Check out the book's forum, if you would like additional assistance.

Page # Description
107 The second line of code under Step 3, and line 30 of Script 3.10 on page 106, should use multiplication, not division: $dollars = $gallons * $ppg;.
193 Step 6 should suggest that you repeat Steps 3-5.
205 The first sentence of the third paragraph should say “This join is selecting two columns…”.
210 The query in Step 3 is missing the % before the “Y” (as in the figure). This error is also repeated in the final tip on page 211.
277 The code in Step 8, which assigns the query to the $q variable is missing its terminating double quotation mark. The corresponding code in Script 9.3 is correct.
320 In the first paragraph, it should say “the first ten records—0 through 9—should be retrieved”.
334 The code in Step 6 should end with a closing PHP tag.
354 The code in Step 8 is missing the closing </li>.
360 The code in Step 9 is missing the readfile() line included in the corresponding script.
389 On line 19 of Script 12.8, the opening [ is missing after $data. The corresponding code in Step 2 is correct.
403 The second sentence at the top of the right-hand column should identify Chapter 14 as "Perl-Compatible Regular Expressions".
405 The parenthetical near the end of the first paragraph should say "i.e., $v was found in $value".
405 On line 58 of Script 13.1, the $scrubbed array should be reset instead of $_POST, as this new array is what the form will use.
450 The first line of the second paragraph should begin "Of these modifiers,"
514 On lines 79-80 of Script 16.5, the form elements should be named just "start" and "end". The code in the corresponding step is correct.
563 At the end of Script 18.2, the phrase "paste code here" should not be there. Ugh.
586 The code in Step 2 should refer to $_GET['x'] not $trimmed['email'] (that’s what I get for copying and pasting). The code in the corresponding script is correct.
598 Figure E is incorrect.
621 On line 138 of Script 19.2, the two references to $_POST['existing'] should be to $_POST['artist']. This also applies to the code in Step 15 on page 627.
635 On line 35 of Script 19.6, the closing </a> is missing. This also applies to the code in Step 5 on page 636.

Blackboard Course Management System

Hardware and Software Requirements

Students who do not have access to the equipment, software, and services necessary to take this course at home may use the resources at Mesa College. Computers are available for use in the LRC or classroom K404. Local public libraries may also have these resources available. Map of the Mesa College campus

Blackboard Orientation Material and Help Desk

You are expected to know how to use the Blackboard system. 

Help Desk

Blackboard technical support is available to students 24/7. If you are having a technical problem with Blackboard, please reach out for help. Call the Help Desk via this toll-free phone 866-271-8794.

You can also visit them online at https://www.sdccdonline.net/help for assistance with any technical issue that you experience with Blackboard and to view the FAQ's.

Internet Access

You will also need to have an ISP (Internet Service Provider) in order to fulfill the hybrid portion of this course online.

NOTE: Students have had problems accessing their course web site and their system locking up when they use AOL—if possible, avoid AOL.

Course Work and Evaluation

  1. Print out this syllabus and read it.
  2. You may order your textbook for this course online or buy it in the Mesa College Bookstore.  For complete ordering directions, read the section in this syllabus on textbook and ordering Information. 
  3. Before starting work on this course, study the Blackboard Learn 9.1 tutorials, on the Get Ready for Online Learning Success! page, which show you how to use the Blackboard tools so that you can successfully complete this online course. 
  4. To access all the work for each week, click on the Lessons link. The activities, assignments and quizzes that you will be turning in to be graded are linked on the weekly Lessons pages and are listed in this syllabus.
  5. If any of the assignments, quizzes, or graded activities are missing after the deadline submission, you will receive a ZERO.
  6. One quiz may be redone. You will receive the highest grades.
  7. Please allow a minimum of 72 hours for assignments and tests to be corrected, a response to be sent to you, and your grade to be entered into the grade log. If I do not check your submissions or email during the weekend, I will do so on Monday.
  8. Any changes to this syllabus will be posted.
  9. Be sure to check both your E-mail and the Discussion Board frequently.
  10. Except as discussed below, no work for this class will be accepted after 11:59pm on the last day for the semester.
  11. Students who remain enrolled in this class beyond the published withdrawal deadline, as stated in the class schedule, will receive an evaluative letter grade (A, B, C, D, or F) in the class. 
  12. A temporary grade of Incomplete ("I") may be assigned in very rare cases. Specifically, to be eligible for a grade of “I” a student must:
    1. request an Incomplete grade only after the published withdrawal deadline for the course. (Before that deadline the student should withdraw from the class with a “W.”)
    2. have achieved at least a “C” average for all work and tests due before the withdrawal deadline. (Missing work and tests that were due before the withdrawal deadline will be counted as “F” when determining this average.)
    3. provide written documentation by a police report or a statement from a medical doctor on official stationary to verify one or more of the following:
      1. a serious disaster, such as a major fire, flood, or earthquake.
      2. a death in the student’s immediate family.
      3. a very serious medical issue with respect to the student.

    If a grade of “I” is assigned, it must be cleared within one year or less.  If the “I” is not cleared within the allowed time, it will change to the grade that would have been assigned at the normal end-date of the class—based only upon  the work that had actually been submitted by the end date of the course.

    A grade of “I” should be viewed primarily as a humanitarian procedure that provides an opportunity for a good student to complete all the course requirements and to achieve the same grade that would have been assigned had a tragedy not occurred. 

    A grade of “I” is not appropriate if used merely to provide additional time for a student to make up usual coursework that is overdue, incomplete, or unsatisfactory.

ASSIGNMENTS AND GRADING SCALE

On-campus lecture: Thursdays, 6:00-8:00 PM in K103. Participation points are awards for participating in the on campus lecture, discussions, and in-class exercises - 5 points a week for 15 weeks for 75 possible points.
WEEK TOPICS ACTIVITIES AND ASSESSMENTS POINTS
Week 1 -Aug. 22
  Introductions and orientation Read the syllabus  
Go through the Student Tutorials on how to use the features of your online course. You will see the link on the homepage.

Read A Tour of the Main PHP Features in Dreamweaver (by David Powers)  
Discussion board - Introductions 10
Week 2 - Aug. 29
  Ch. 1: Introduction to PHP Read Chapters 1: Introduction to PHP  
Complete exercise files - Set up a Local Testing Server on your USB - show me your flash drive 20
Quiz 20
Weeks 3 - Sept. 5
  Ch. 2: Programming with PHP Read Chapter 2: Programming with PHP  
Complete exercise files 20
In Class Assignment: Days Array Variable - Post your results to Blackboard  
Quiz 25
Week 4 - Sept. 12
  Ch. 3: Creating Dynamic Web Sites Read Chapter 3: Creating Dynamic Web Sites  
Complete exercise files 20
Quiz 20
Week 5 - Sept. 19
  Ch. 4: Introduction to MySQL Read Chapter 4: Introduction to MySQL  
Complete exercise files 20
Quiz 20
Week 6 - Sept. 26
  Ch. 5: Introduction to SQL Read Chapter 5: Introduction to SQL  
Complete exercise files 20
Quiz 15
Week 7 - Oct. 3
 

Ch. 6: Database Design

Read Chapter 6: Database Design  
Complete exercise files 20
Quiz 15
Week 8 - Oct. 10
  Ch. 7: Advanced SQL and MySQL Read Chapter 7: Advanced SQL and MySQL  
Complete exercise files 20
Quiz 10
Week 9 - Oct. 17
  Ch. 8: Error Handling and Debugging Read Chapter 8: Error Handling and Debugging  
Complete exercise files 20
Quiz 10
Week 10 - Oct. 24
 

Ch. 9: Using PHP and MySQL

Read Chapter 9: Using PHP and MySQL  
Complete exercise files 20
Quiz 15
Week 11 - Oct. 31
  Ch. 10: Common Programming Techniques Read Chapter 10: Common Programming Techniques  
Complete exercise files 20
Quiz 20
Week 12 - Nov. 7
  Ch. 11: Web Application Development Read Chapter 11: Web Application Development  
Complete exercise files 20
Quiz 20
Week 13 - Nov. 14
  Ch. 12: Cookies and Sessions Read Chapter 12: Cookies and Sessions  
Complete exercise files 20
Quiz 20
Week 14 - Nov. 21
  Ch. 13: Security Methods Read Chapter 13: Security Methods  
Complete exercise files 20
Quiz  
Week 15 - Dec. 5
  Ch. 13: Security Methods
Chapter 13: Security Methods  
   
   
Final's Week - Dec. 12
  Final Exam

Final Exam – 50 points (On Blackboard) Completed by 12/12/13, no exceptions!

50
Participation points for participating, attending, and staying the entire on-campus lectures - 5 points @15 weeks for 75 possible points. 75

A = 90-100% B = 80-89% C = 70-79% D= 60-69% F = 0-59%
Your grade will be based on your assignments, quizzes, and discussion postings. The final grade in this class will be affected by active participation in the discussion postings.

I reserve the right to change the syllabus as the course progresses.