Syllabus Schedule Project Labs Canvas Server Access phpMyAdmin Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Assignment 6 Assignment 7 Assignment 8 Assignment 9
Course: MIS 314 - Fundamentals of Web Development
Quarter: Spring 2017
Professor: J. Christopher Sandvig
Office: Parks Hall 313
Office hours: MW 11:00 am - 1:00 pm and by appointment
Phone: 360-650-7952

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 Textbook

  1. Learning PHP, MySQL & JavaScript, 4nd Ed. Robin Nixon ISBN 9781491918661

Textbook is available at the University bookstore.

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 information, and other course information is available on the course web site (web search "MIS 314").  The Canvas course management system is used for submitting assignments and viewing grades.

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 Yorktown accounts are accessible to Professor Sandvig 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 typically retains student Yorktown accounts 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 25%
Bookstore Project 30%

Assignments: Homework is assigned each week and is due 15 minutes before class on the assignment due date unless specified otherwise in the class schedule. Submit assignments via the Canvas course management system. Submit the full URL for each exercise in the assignment, listing the URLs in the same order that they are listed in the assignment. To minimize typos in URLs it is strongly recommended that you cut-and-paste URLs from the browser to canvas. Incorrect URLs will not be graded and no credit will be given.

Assignment files should not be modified after the assignment has been submitted. Doing so will result in an F for the entire assignment. If you want to work on files before they are graded make copies and work on the copies.

Late Assignments:  Late assignments and broken URLs will be penalized two points (out of 10 points per assignment) per 24-hours, starting at the due date (assignments submitted one second after the due date are tagged as late by Canvas). Please check your URLs carefully to make sure they are correct. 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 Sandvig. 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 a salutation (e.g. Dear Dr. Sandvig or Dear Professor Sandvig) so that it is clear that the message is not junk mail and deleted.

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 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 Sandvig has 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 Sandvig.

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 ( 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
Server-side Programming (PHP) X X X X
Database design & normalization X X X X
Web Design concepts   X   X
Analytical skills X X X X
Problem-solving skills X X X X
Regular Expressions HTML Color Names Color Picker ASCII Character Codes Unicode Character Codes