CRN# 01983
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, 9:00-11:30 AM - 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
SPRING 2013: Jan 28-May 25
Professor Marianne Gibson | mgibson@sdccd.edu
Office hours: Thursdays 11:30 a.m. - 12:30 p.m.
This course provides a hands-on introduction to relational databases in a Web environment. Emphasis is placed on hand-coding Structured Query Language (SQL), specifically MySQL. Students master an open source database editor, XAMPP, to create and work with a database. Basic PHP: Hypertext Preprocessor (PHP) and Dreamweaver are used to bind data on a Web page. This course is designed for students studying web design and professionals updating their skills.
TOTAL LECTURE HOURS: 40 - 45
TOTAL LAB HOURS: 24 - 27
FIELD TRIP: Required
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.
The students will be able to create a database table.
The students will be able to analyze the purpose of a database table and create fields that express the purpose.
The students will be able to create field labels that clearly communicate the field's purpose in the database.
Upon successful completion of the course the student will be able to:
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.
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:
You must attend at least one course meeting activity prior to February 8th. 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.
Start of the semester | Jan. 28 |
Receive, process, and pay for add codes and to drop classes with no “W” recorded | Feb. 8 |
Refund deadline - enrollment fees and/or non-resident tuition | Feb. 8 |
Holiday - AbrahamLincoln's Birthday | Feb. 15 |
Holiday - George Washington's Birthday | Feb. 18 |
Last day to file a petition for Pass/No Pass grade option | Mar. 4 |
Spring Break | Mar. 25-30 |
Holiday - Cesar Chavez Day | Mar. 29 |
Withdrawal deadline - No drops accepted after this date; will receive a "W | Apr. 12 |
End of the semester | May 25 |
Grades available on e-Grades | June 3 |
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.
As your instructor, I have the following expectations of your behavior in this class:
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/
REQUIRED:![]() Fourth Edition ISBN-13:9780321784070 by Larry Ullman |
OPTIONAL: |
Supplies:
1. USB drive
2. Access to a Web hosting server
3. Software for writing HTML, 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.
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!
Chapter | Page # | Description |
---|---|---|
Chapter 3: Creating Dynamic Web Sites | 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;. |
Chapter 6: Database Design | 193 | Step 6 should suggest that you repeat Steps 3-5. |
Chapter 7: Advanced SQL and MySQL | 205 | The first sentence of the third paragraph should say “This join is selecting two columns…”. |
Chapter 7: Advanced SQL and MySQL | 201 | 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. |
Chapter 9: Using PHP with MySQL | 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. |
Chapter 10: Common Programming Techniques | 320 | In the first paragraph, it should say “the first ten records—0 through 9—should be retrieved”. |
Chapter 11: Web Application Development | 334 | The code in Step 6 should end with a closing PHP tag. |
Chapter 11: Web Application Development | 354 | The code in Step 8 is missing the closing </li>. |
Chapter 11: Web Application Development | 360 | The code in Step 9 is missing the readfile() line included in the corresponding script. |
Chapter 12: Cookies and Sessions | 389 | On line 19 of Script 12.8, the opening [ is missing after $data. The corresponding code in Step 2 is correct. |
Chapter 13: Security Methods | 403 | The second sentence at the top of the right-hand column should identify Chapter 14 as "Perl-Compatible Regular Expressions". |
Chapter 13: Security Methods | 405 | The parenthetical near the end of the first paragraph should say "i.e., $v was found in $value". |
Chapter 13: Security Methods | 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. |
Chapter 14: Perl-Compatible Regular Expressions | 450 | The first line of the second paragraph should begin "Of these modifiers," |
Chapter 16: An OOP Primer | 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. |
Chapter 18: Example—User Registration | 563 | At the end of Script 18.2, the phrase "paste code here" should not be there. Ugh. |
Chapter 18: Example—User Registration | 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. |
Chapter 18: Example—User Registration | 598 | Figure E is incorrect. |
Chapter 19: Example—E-Commerce | 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. |
Chapter 19: Example—E-Commerce | 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. |
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
You are expected to know how to use the Blackboard system.
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.
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.
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.
A = 90-100% B = 80-89% C = 70-79% D= 60-69% F = 0-59% I reserve the right to change the syllabus as the course progresses. |