Syllabus
Management Department
Professor Information
Professor: Terry Byrd
Department of Management
Office: 408 Lowder Business
Building
Phone: (334) 844-6543
E-mail: tbyrd@business.auburn.edu
Office Hours:
Class Hours:
PREREQUISITES: 2.2 GPA junior standing or Graduate Student.
Please note that
satisfaction of the prerequisites is the student’s responsibility. Students who have not satisfied the
prerequisites may be removed from the class.
Students who are not removed from the class but who have not satisfied
the prerequisites will not receive credit for the class.
Course Description
This class will focus primarily on server-side Internet
programming technologies including PHP, HTML, MySQL,
and XML. The principle language in this
course is PHP. PHP is a server-side,
cross platform, HTML-embedded scripting language. It offers a clever approach to common gateway
interface (CGI) programming that moves functionality from the more traditional cgi-bin directory of Perl scripts into an integrated
environment where complex scripting code combines with plain HTML. PHP has become one of the most popular
languages on the Web and its use in even large corporations has skyrocketed
over the last few years. The course
provides students with a working knowledge of programming with PHP especially
in its use with MySQL. Topics include the basics of PHP, mixing PHP
and HTML, displaying dynamic content, creating cookies with PHP, and MySQL database access using PHP.
Upon completion of the course, the student should be able
to:
Required
Course Material
TextBook:
Carey, Patrick, HTML
and XHTML, Thomson Course Technology, 2005, ISBN: 0-619-26746-1.
Gosselin, Don., PHP Programming with MySQL, Thomson Course Technology, 2006, ISBN
0-619-21687-5.
Other Materials on Internet.
Course Approach:
Since our class is in the Computer Teaching Lab, we will make extensive use of the computers and tools of the Lab. Students are expected to have read the written assignments and to have attempted some of the exercises suggested in the text and in the syllabus.
Students are encouraged to be "entrepreneurial" in their approach to this class, in their assignments, and in their class presentations and interactions. Students' observations or experiences, and how they might relate to the subject at hand, have the potential to enhance the class sessions. Please share those of value so that you may be a resource to all participants, including the instructor. Students are also encouraged to employ the systems perspective and wear the "manager's hat" in relating to the issues so that we will be able to think about them critically from multiple dimensions.
Exam I: 10% HTML Exam (Paper)
Exams II & III: 20% each (Hands-On In-Class Exam, Open Book)
The student will be required to complete three exams on the HTML, PHP and MySQL concepts taught in the class.
Quizzes: 10%
In-class short paper quizzes on material from chapters.
Homework: 25%
Students will be assigned weekly assignments to
complete. I may randomly choose one of the
problems in an assignment to grade every week for every student. This means that you must complete all of the
problems in each assignment since you will not know which of your problems I
will grade that week.
Project: 15%
Each student will participate in a team project featuring a
database driven web site during the last few weeks of class. I expect each student to participate in every
aspect of the project including programming.
Therefore, it is critical that each student learn as much as they can about
HTML, PHP, and MySQL during the semester. I will discuss specifics of the project
during the semester.
Personal Policy: Please be respectful of your instructor
and your classmates. Arrive on time and
ready to participate. Do not leave
during class except in an emergency.
Please remember to turn off audio on your cell phones and/or pagers.
Tentative
Schedule:
Key:
Carey (CA)
Gosselin (GO)
Week 1 (Aug 17): HTML
Topics:
Introduction
to Course
Introduction to Web
Introduction to HTML
Tutorial 1 (CA)
Chapter 1 (GO)
Assignment:
Complete Case Problem 2, Tutorial 1 (CA): Due Aug 22
Week 2 (Aug 22, 24) HTML/CSS
Topics:
HTML Text Formatting
Hyperlinks
Working with Fonts, Colors, and Graphics
Tutorials 1, 2, 3 (CA)
Chapter 1 (GO)
CSS Notes or Book(s)
Assignments:
Complete Case Problem 3, Tutorial 1 (CA): Due Aug 24
Complete Case Problem 3, Tutorial 2 (CA): Due Aug 29
Week 3 (Aug 29, 31): HTML/CSS
Topics:
Working with Fonts, Colors, Graphics
Cascading Style Sheets
Tables
Tutorials 3, 4
Chapter 1 (GO)
CSS Notes or Book(s)
Assignments:
Complete Case Problem 3, Tutorial 3 (CA): Due Aug 31
Complete Case Problems 2 and Case Problem 3, Tutorial 4 (CA): Due Sept 5
Week 4 (Sept 5, 7) Introduction
to PHP
Topics:
Exam I (Multiple Choice Exam) Sept 5
Introduction to PHP
Using Variables in PHP
Working with Data Types and Operators
Chapters 2, 3 (GO)
Assignments:
Hands-On Project 2-2 (GO) and Case Project 2-1 (GO): Due Sept 21 (HW6)
Hands-On Project 3-5 (GO) and Case Project 3-2 (GO): Due Sept 21 (HW7)
Week 5 (Sept 12, 14): Functions
and Control Structures
Topics:
Functions
if-else Statements
switch Statements
do-while Statements
for Statements
Chapter 4 (GO)
Assignments:
Hands-On Project 4-2 (GO) and Hands-On Project 4-5 (GO): Due Sept 21 (HW8)
Case Project 4-2 (GO) and Case Project 4-4 (G): Due Sept 21 (HW9)
Week 6 (Sept 19, 21): Manipulating Strings; Form Processing
Topics:
Working with String Operators
Form Processing
Validating Input Data
Chapter 5 (GO)
Assignments:
Hands-On Project 5-3 (GO): Due Sept 28 (HW10)
Hands-On Project 5-6 (GO) and Case Project 5-3 (GO): Due Sept 28 (HW11)
Week 7 (Sept 26, 28): Arrays
Topics:
Working with Arrays
Finding Data in Array
Manipulating Arrays
Multidimensional Arrays
Chapter 7 (GO)
Assignments:
Hands-On Project 7-1 (GO) and Hands-On Project 7-2 (GO): Due Oct 3 (HW12)
Hands-On Project 7-4 (GO) and Case Project 7-3 (GO): Due Oct 3 (HW13)
Week 8 (October 3, 5): Exam, Working with Databases and MySQL
Exam
II: Oct 5
Topics:
Database Basics
Working with Databases and MySQL
Chapters 8, 9 (GO)
Assignments:
Practice setting up databases with PHPMyAdmin
Practice SQL Queries using PHPMyAdmin
Week 9 (Oct. 10, 12): Connecting
to MySQL with PHP
Topics:
Connecting to MySQL with PHP
Handling MySQL Errors
Executing SQL Statements
Working with Databases and Tables
Manipulating Records
Chapter 9 (GO)
Assignments:
Hands-On Project 9-1 (GO): Due Oct 12 (HW14)
Hands-On Project 9-2 (GO) and Case Project 9-1 (GO): Due Oct 17 (HW15)
Week 10 (Oct. 17, 19):
Connecting to MySQL with PHP
Topics:
Connecting to MySQL with PHP
Handling MySQL Errors
Executing SQL Statements
Working with Databases and Tables
Manipulating Records
Chapter 9 (GO)
Assignments:
Hands-On Project 9-3 (GO): Due Oct 19 (HW16)
Case Project 9-3 (GO) and Case Project 9-4 (GO): Due Oct 24 (HW17)
Week 11 (Oct 24, 26): Managing State Information
Topics:
Using
Hidden Form to
Using
Query Strings to
Using
Cookies to
Using
Sessions to
Chapter 10 (GO)
Assignments:
Hands-On Project 10-2 (GO): Due Oct 26 (HW18)
Hands-On Project 10-4 (GO) and Case Project 10-2 (GO): Due Oct 31 (HW19)
Week 12 (Oct 31, Nov 2): Help for Project
Week 13 (Nov 7, 9): Help for Project
Assignment
Case Project 10-4: Due Nov 7 (HW20)
Week 14 (Nov 14):
Exam III
Week 15 (Nov 28, 30) Help for Project
Week 16 (Dec 5) Project is
Due
Communication: I
will use your
Academic Honesty:
ALL PORTIONS OF THE
Special Accommodations for Students with Disabilities: