Course:
|
MIS 314 - Fundamentals of Web Development
|
Quarter:
|
Winter 2020
|
Professor:
|
J. Christopher Sandvig
|
Office:
|
Zoom (see "help lab and office hour" link in Canvas) |
Office hours:
|
MW 10:00 am -
noon and by appointment (On the fews days that MIS 314 has synchronous classes office hours will start at 11am.) |
Phone:
|
360-650-7952
|
E-mail:
|
|
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.
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
-
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%
|
|
100%
|
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 (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.