Syllabus Schedule Project Labs Server Access phpMyAdmin Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Assignment 6 Assignment 7 Assignment 8 Assignment 9
Syllabus
Course: MIS 314 - Fundamentals of Web Development
Quarter: Fall 2016
Instructor: Dr. El-Sharo
Office: Parks Hall 422
Office hours: MW 1:00pm - 3:00pm and by appointment
Phone: 360-650-2904
E-mail:

Course Objectives

In MIS 314 you will learn how to use PHP to build interactive database-driven web sites. PHP is the most popular server-side scripting technology used today. It is open-source (free) and runs on several operating systems including Windows, UNIX/Linux and Mac OS X.

A primary benefit of server-side programming is its ability to interact with databases. This course covers the fundamentals of relational database design and SQL (Structured Query Language). We will use the popular mySQL open-source database program. php mysql logos

You will practice your programming and design skills by building an interactive online storefront. The store retrieves product information from a database, allows clients to search for products, uses a shopping cart, writes customer and order information to the database, allows the user to review her order history and sends the user an e-mail confirmation for each order. A link to the GeekBooks sample is located on the class web site (right column).

This course will also extend your knowledge of web page design and site navigation.  Specific design topics covered include defining the needs of the target audience, page layout, navigation tools, site architecture, usability and testing.  MIS 314 is the third required course in WWU's Internet Studies Center certificate curriculum (ISC ppt).

Required Textbooks

  1. Learning PHP, MySQL & JavaScript, 3rd Ed. Robin Nixon ISBN 9781491949467
    (Either the 2nd or 3rdd editions may be used. However, page numbers are only provided for the 3rd edition in the reading schedule.)

  2. Teach Yourself SQL in 10 Minutes, 4th ed., Ben Forta, ISBN 9780672336072
    (Either the 3rd or 4th editions may be used. There are only minor differences between the two editions.

    NOTE: This book is available as a Kindle book. See: Teach Yourself SQL in 10 Minutes, 4th ed - Kindle Version

Both books are available at the University bookstore.

Additionally, WWU's library subscribes to Safari Books Online which includes full-text of several programming books. Books that may be useful on-line references include Beginning CSS Web Development: from Novice to Professional and Beginning PHP and mySQL: from Novice to Professional.

Course Prerequisites

All students should have taken the required prerequisite course CS 202 (previously CS 112) or receive instructor permission. You should be able to create a HTML document and publish it on the web, work with images, create style sheets and be proficient with HTML formatting and layout. Some experience with JavaScript or another programming language is desirable but not required.

Course Web Site

Assignments, lab times and location, grades and other course information is available on the course web site (web search "MIS 314"). 

Please add your name to the on-line class roster during the first week of class. Go to the class web site and click on roster.  Your assignment and other course grades will be available on-line.  They cannot be recorded until you have added your name to the roster.

Server Accounts

You will be provided with an account on the Yorktown server. Yorktown supports PHP, mySQL, ASP.NET, ASP and SQL Server. Your access to the server will be via network drive mapping (instructions).  Yorktown is a HP ProLiant server running Windows Server 2008 R2 and IIS 7.0. It has a XeonĀ® 2.26 GHz Quad Core Processor, 8 GB RAM, and 558 GB disk storage. It is located in WWU's server room on 32nd St.

Your accounts are accessible to Professor El-Sharo and the course teaching assistant for the purposes of grading and trouble shooting. Do not put any private information into your accounts. You may use your accounts for non-class purposes as long your usage complies with WWU's Policy for Responsible Computing. Abuse of your account will result in the loss of account privileges on the server.

Your accounts are created specifically for this course and you should assume that it will disappear at the end of the quarter. To assure that none of your work is lost you should make backup copies of all your files at the end of the quarter.  The College is experimenting with keeping Yorktown accounts active as long as your WWU login is active (typically to graduation) but this cannot be guaranteed.

Course Policies

Grading:  Course grades will based on the following criteria:

Assignments (9) 25%
Mid-term Exam 20%
Final Exam 30%
Bookstore Project 25%
  100%


There will be one midterm exam worth 80 points and a final exam worth 120 points. In addition, there will be homework worth 100 points, and project worth 100 points. Thus, there will be a total of 400 points for the determination of grades. Grades will be assigned based on a class curve, not a rigid point cutoff basis. The curve will be calculated, and grades will be assigned as follows:

  • First, a "top-of-the-curve" point will be calculated which will become equal to 100%. This number will be determined by averaging 300 points and the highest number of points actually attained by a member of the class.
  • Second, all point totals will be converted to percentages by dividing each person's point total by the "top-of-the-curve" point. Percentages will be calculated to one decimal place, and thus 89.9% is used as 89.9%, not rounded to 90%.
  • Third, percentage grade divisions will be determined. Although these cannot be determined until the end of the quarter, they will not be higher that a 90.0%-and-up = A, 80.0-89.9% = B, etc, distribution. Plus and minus grades will be assigned, with, for example, 80.0%-82.9%=B-, 83.0%-86.9%=B, 87.0%-89.9%=B+. A+ grades will not be assigned.

Assignments:Homework will be assigned each week and is due 15 minutes before class on the assignment due date unless specified otherwise in the class schedule. Mail two copies of the email containing the URLs for your assignments: one to Professor El-Sharo and the TA at and cc one to yourself (so that you have a time-stamped copy of your submission). The subject line of your email should read MIS-314-FALL-2014 Ax {YourName}, where x is the assignment number, and {YourName} is your own name!

Assignment files should not be modified after the assignment has been submitted. Doing so will result in an F for the entire assignment. After each assignment has been graded Professor El-Sharo will send an email to notify you. Once you have received the email you can edit your files. If you want to work on files before they are graded make copies and work on the copies.

Late Assignments:  Late work and broken URLs will be penalized one letter grade per 24-hours, starting at the due date (one minute after the due date is late). Please check your URLs carefully to make sure they are correct. To avoid typing errors in your URLs it is highly recommended that you cut and paste them directly from your browser.  You can expect to have technical problems and should build safety time in your schedule.

Extensions : Should you be ill for an extended period, have a family emergency, or have other circumstances that may justify an due date extension, you may request an extension by sending an email to Professor El-Sharo. Please explain your circumstances and specify how much extra time you need. Extensions are not granted for busy schedules, projects due in other courses, or other typical situations.

Exams:  A midterm and a final will be given during the quarter.  The final exam is cumulative.

E-mail Policy: I usually reply to emails within a few hours on weekdays. I do not reply to email messages that are poorly written, unclear or disrespectful.  If it is not worth your time to send a thoughtful message it is not worth my time to reply to it. I suggest that you include:

  1. A subject line that starts: MIS-314-Fall-2014:
  2. a salutation (e.g.: Professor El-Sharo - )
so that it is clear that the message is not junk mail and therefore gets deleted by me.

Plagiarism: You are encouraged to work with other students in the class, but all work that you turn in for grading must be your own. Taking credit for another students work is plagiarism and is a violation of WWU academic policy. Two unfortunate unfortunate outbreaks of cheating have occurred in this course. The first, during spring quarter 2002, resulted in six students received Fs for the course and being reported for cheating.  The second, during fall quarter 2003, resulted in seven students received Fs for the course and being reported for cheating.  In addition during spring 2012 two students cheated, failed the course, and were reported for cheating.  Don't let this happen to you! Remember, all work that you turn in for grading must be your original work. Professor El-Sharo and Professor Sandvig have a copy of every assignment ever turned in for this course. Cheating is easy to detect and student work is routinely checked for originality.

If you have any questions regarding cheating, plagiarism or WWU's Academic Policies see the Office of Student Life's Academic Dishonesty web page, Appendix D of the University Bulletin or talk with Professor El-Sharo.

Microsoft DreamSpark Software

Students enrolled in MIS courses may download free copies of Microsoft's developer software. The complete developer software list available is quite extensive and includes Windows OS, Office, Visual Studio, Expression Studio and SQL Server. None of these products are required for MIS 314.

You will receive an email via your WWU email from eAcadamy during the first week or two of the quarter containing instructions on how to download the software.

Some of these tools are very large. Before downloading the software it would wise to compare your computer's free disk space to the recommend system requirements for the software (Amazon.com lists the system requirements for the products).

You must be currently enrolled in a MIS course to be eligible for the free software. You will not be eligible after the quarter ends unless you are enrolled in another MIS course. This offer is available through Microsoft's DreamSpark program.

Assessment of Student Performance

The following table summarizes how student performance is assessed relative to the course objectives. The learning outcomes in the left-hand column are assessed by the assessment method marked with an "X" in the right-hand columns.

Learning Outcome Assignments
(9)
Term
Project
Midterm
Exam
Final
Exam
Server-side Programming (PHP) X X X X
Database design & normalization X X X X
SQL X X X X
Web Design concepts   X   X
Analytical skills X X X X
Problem-solving skills X X X X