Syllabus Schedule Project Labs Canvas Server Access WWU VPN Info 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 2020
Professor: J. Christopher Sandvig
Office: Zoom (see "help lab and office hour" link in Canvas)
Office hours: MW 10:00 am - 11:00 am and by appointment (On the fews days that MIS 314 has synchronous classes office hours will start at 11am.)
Phone: 360-650-7952

Course Objectives

The primary learning objective of MIS 314 is for students to learn server-side database-driven web development skills. Important concepts covered in the course include good coding practices, relational database concepts, structured query language (SQL), data validation, and web security. The specific tools used in the course are the PHP language and mySql database. 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 on-line 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 include designing for mobile devices and search engine optimization (SEO).  MIS 314 is the third required course in WWU's Internet Studies Center certificate curriculum (ISC ppt).

Required Textbook

  1. Learning PHP, MySQL & JavaScript, 5th ed. Robin Nixon ISBN 9781491978917

Textbook is available at the University bookstore.

WWU's library subscribes to Safari Books On line 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 F grades for the course and being reported for cheating.  The second, during fall quarter 2003, resulted in seven students received F grades 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 Appendix D of the University Catalog or talk with Professor Sandvig.

Microsoft Imagine 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.

Regular Expressions HTML Color Names Color Picker ASCII Character Codes Unicode Character Codes