24065 Dragan
M&IS 24065 – 001 Web Programming
Fall 2014
CRN: 16067
Instructor Dr. Natalia Dragan ndragan at kent dot edu
Office: BSA A407
Office hours: TR 1:15 PM – 2:45 PM, W 3:30 PM – 5:00 PM and by appointment
Course Location BSA 110
Course Time TR 9:15 AM – 10:30 AM
Course Description
An introduction to programming, Web design and databases using HTML, JavaScript, PHP, and
MySQL
Prerequisite M&IS 24053
Students in the course who do not have the proper prerequisite risk being deregistered from the
class.
Course Objectives
To learn how to create database driven interactive websites.
• To learn about and use the principles of visual design as applied to Web site interface
development using HTML
• To learn the basics of programming in JavaScript and PHP, how to process Web forms
and access relational databases using MySQL
Summary of Key Components
• The Internet
• HTML
• JavaScript, PHP
• Database and MySQL
• Complete Website
Learning Outcomes
You will learn how to:
• Build a user interface
• Develop a database driven interactive website
• Think about and design programming logic
• Use relational database
• Use these technologies:
o HTML
o JavaScript
o PHP
o MySQL
What You are Expected to Bring to the Table
• energy
• dogged determination
• no fear or anxiety
• interest in the subject
• willingness to ask questions
• willingness to try
• willingness to put in the time required to learn programming
NOTE: To do well in this course you must pace yourself through the semester. There are 28
homework, five quizzes, a project and a final exam. Programming cannot be learned by
cramming on the due date. If you are not willing to put in the time needed to learn programming
this course is not for you. If you are truly willing to apply yourself you may be amazed at what
you can accomplish.
Textbook
The textbook is on the course website (e-book) and is provided by the instructor (required).
Programming the World Wide Web, Robert W. Sebesta, 7th Edition, Pearson Education,
ISBN-10: 0-13-266581-6, ISBN-13: 978-0-13-266581-0 (optional).
Software
You will need to install the WAMP web server (if you have a PC) or MAMP web server (if you
have a Mac). Both are free and can be found at:
WAMP: http://www.wampserver.com/en/
MAMP: http://www.mamp.info/en/index.html
Five assignments plus the final project require you have a computer operating as a server.
Generally the installation goes smoothly but some students have difficulties. It is suggested that
you download and install WAMP or MAMP without delay. The College and University do not
provide computers operating as servers; that is your responsibility. You will also need to use a
text editor like NOTEPAD (PC) or TextEdit (Mac). Any text editor (not a word processor or
RTF editor) you like is fine.
Course Organization
Course Website
The course website requires an access code that the instructor will provide you. Use the website
(gobobgo.net) to:
• Access course material
• Learn about assignment requirements and due dates
• Submit your work
• Learn your current status and grade computation
Homework Assignments
Computer programs either work or they do not. Therefore no partial credit is given for individual
programs. The weight and due date of each assignment/project/final exam will be given on the
course website (gobongo.net).
Each assignment includes multiple programs or HTML segments so each is scored as 0% or
100%. The weighted average of all parts determines the assignment's grade. All assignments are
due at 11:59 PM on the date given.
Complete and test all of your work on your computer before submitting it for grading.
Remember, there is no partial credit for individual programs. Get it right before turning it
in.
The assignments are scheduled in this order:
HTML A - GETTING STARTED
HTML B - STYLE, IMAGE, HYPERLINK
HTML C - STYLE, CLASSES, TABLE
HTML D - FORMS AND DATA OBJECTS
HTML QUIZ
JAVASCRIPT A - GETTING STARTED
JAVASCRIPT B - ARITHMETIC AND LOGIC, FUNCTIONS
JAVASCRIPT C - ARRAYS, FORM DATA, LOCAL STORAGE
JAVASCRIPT D - STRINGS, ARRAYS, LOGIC, FUNCTIONS
JAVASCRIPT E - ARRAY, LOGIC, LOCAL STORAGE
JAVASCRIPT F - ARRAY, LOGIC, LOCAL STORAGE
JAVASCRIPT G - ARRAYS, LOCAL STORAGE, FUNCTIONS
JAVASCRIPT QUIZ
PHP A - SERVER TEST
PHP B - GETTING STARTED
PHP C - LOGIC AND LOOPS, FUNCTIONS
PHP D - ARRAYS
PHP E - PHP ON YOUR SERVER
PHP F - STRINGS
PHP G - FILE OPERATIONS
PHP H - FILE OPERATIONS AND LOGIC
PHP QUIZ
MYSQL A - SQL / DML
MYSQL B - GETTING STARTED
MYSQL C - SELECT AND UPDATE RECORDS
MYSQL D - MYSQL ON YOUR SERVER #1
MYSQL E - INSERT A RECORD AND DATA ANALYSIS
MYSQL F - MYSQL ON YOUR SERVER #2
MYSQL G - MYSQL ON YOUR SERVER #3
MYSQL QUIZ
FINAL EXAM
FINAL PROJECT
Quizzes
There will be 4 quizzes – one for each general topic. The quizzes are similar to the
assignments/examples and cover topics from the e-book chapters.
Final Project
You will create a database and HTML/PHP pages. More details will be given on the course
website.
Final Exam
There will be one final exam during the course. There will be several functions for you to write.
You will need to create a test database and test records. More details will be given before the
exam on the course website.
Labs/Practice
There will be a lab/practice the last fifteen minutes/half hour of class most weeks, during which
you can work on examples and also get help from the instructor and your classmates. There will
be a few scheduled labs that will take place in BSA 224. If you elect not to attend labs, please do
not expect me to help you during office hours. If you work during labs time and need more help,
feel free to come to my office.
Topic Schedule in Sequence
1. Introduction: The Internet
2. HTML
3. HTML/ JavaScript
4. PHP
5. Database
6. MySQLs
7. PHP/MySQL
8. Complete Website
To Make Your Life Easier Do These
• Do the current assignments - do not delay
• When doing assignments do exactly as directed
• Do not read anything into the assignments that is not specified
• Go beyond what the assignments require. Experiment and try to stretch or at least certify
that you understand what was presented and expected of you.
When there are schedule changes or other announcements, the instructor will e-mail you using
your KSU e-mail address. Check this frequently. If you commonly use another address, forward
your Kent e-mail to that address. In your Google e-mail, go to Settings and then Forwarding and
POP/IMAP.
Grading
Grading Scale
This scale is followed closely. Anything above .5 will be rounded up. Nothing else will be
rounded up, no matter how close. There is no extra credit.
Once I have completed grading for the semester I will enter grades into Learn and on FlashLine.
Per university policy, "once grades are submitted, they are final and will not be changed except
in the cases of administrative error". There are no exceptions to this policy.
A (4.0) 93-100
A- (3.7) 90-92
B+ (3.3) 87-89
B (3.0) 83-86
B- (2.7) 80-82
C+ (2.3) 77-79
C (2.0) 73-76
C- (1.7) 70-72
D+ (1.3) 67-69
D (1.0) 60-66
F (0.0) 0-59
About Your Grade
Your grade is the weighted average of all assignment grades. See course website for assignment
weights. Some assignments may be submitted multiple times. The number of submissions is not
the same for each assignment. See course website for details. The last grade (not necessarily the
highest) for each assignment is the one that counts.
Lateness
The following are the Kent State accepted excuses for absence and late submission of
assignments. No other excuses are accepted.
1. sickness with medical note
2. athletic event - with coach's note
3. religious observation
4. military responsibility with documentation
5. death in family with documentation
Notice about Help
I am happy to help. The best way to get help is to email me a question. Use address above.
No questions will be answered about an assignment on the day it is due.
Code Hygiene
To be blunt and direct: the cleanliness, clarity, and structure of your work will have a direct
impact on:
• Whether or not your programs work
• Your grade
Read all documents on the course website in RESOURCES / YOU NEED TO KNOW.
Academic Honesty
College of Business Policy
Cheating means to misrepresent the source, nature, or other conditions of your academic work
(e.g., tests, papers, projects, assignments) so as to get undeserved credit. In addition, it is
considered to be cheating when one cooperates with another in any such misrepresentation. The
use of the intellectual property of others without giving them appropriate credit is a serious
academic offense. It is the University's policy that cheating or plagiarism result in receiving a
failing grade for the work or course. Repeat offenses may result in dismissal from the
University.
Course Policy
Collaboration
You are encouraged to discuss course material and assignments with other students. You will
learn a lot more if you talk with other students. There is no better way to learn than to share
what you know and ask questions of others. Do not hesitate. Please remember, however, that
your work must be yours and not a ‘copy and paste’ of someone else’s work.
HELPING fellow students is acceptable. COPYING is NOT acceptable, and will result in loss
of credit for the assignment, and possibly failure of the course for all students involved.
If copying is suspected, both (or all) students involved will receive zeros for that assignment at
the least, and possibly a failure for the course. DO NOT GIVE OTHERS YOUR WORK.
Course Withdrawal
The course withdrawal deadline is Sunday, November 2, 2014.
Students with Disabilities
University policy 3342-3-01.3 requires that students with disabilities be provided reasonable
accommodations to ensure their equal access to course content. If you have a documented
disability and require accommodations, please contact the instructor at the beginning of the
semester to make arrangements for necessary classroom adjustments. Please note, you must first
verify your eligibility for these through Student Accessibility Services (contact 330-672-3391 or
visit www.kent.edu/sas for more information on registration procedures).
Enrollment
Students have responsibility to ensure they are properly enrolled in classes. You are advised to
review your official class schedule (using Student Tools/Flashfast) to ensure you are properly
enrolled in this class and section. Should you find an error in your class schedule, you have until
Sunday, September 7, 2014 to correct the error with your advising office. If registration errors
are not corrected by this date and you continue to participate in classes for which you are not
officially enrolled, you are advised now that you will not receive a grade at the conclusion of the
semester for any class in which you are not properly registered.