MANSFIELD UNIVERSITY
CIS 2206 COURSE SYLLABUS

revised 8/21/2003

GENERAL INFORMATION

Course number: CIS 2206
Credit/Contact hours: 3
Term: Fall, August 25 - December 12, 2003
Course title: Business Programming Concepts I
College website: www.mansfield.edu

INSTRUCTOR INFORMATION

Instructor name: John Phillips
Instructor office location: Elliott 205 A
Instructor office hours: online at http://www.mnsfld.edu/~jphillip/
Instructor office telephone: 570-662-4704
Instructor e-mail address: jphillip@mnsfld.edu

COURSE INFORMATION

Course Description

An introduction to analyzing and designing solutions to business-related problems using a business programming language. Topics covered include Unix, HTML, Perl, CGI, JavaScript, and SQL.

Prerequisite: CIS 1104

CIS 2204 or equivalent knowledge is highly recommended

Textbook

Sams Teach Yourself Perl in 21 Days (2nd Edition), Laura Lemay, 2002, Sams Publishing, ISBN: 0672320355. Note that the older first edition book will not work for this class.

Course Websites

www.programbetter.com for the syllabus and course information

www.coursenotebook.com for the class discussion board

Course Outline

1. The UNIX / Linux work environment
2. The Perl programming language
3. The HyperText Markup Language
4. The Common Gateway Interface (CGI server-side scripting)
5. JavaScript (client-side scripting)
6. The Structured Query Language (SQL database commands)
7. Building Internet-based business solutions using HTML, CGI, Perl, JavaScript, and SQL

Class schedule

TuTh 11:00 AM - 12:15 PM in Elliott 206

Equipment and supplies

Access to the Internet is required either using your own computer or by using a computer in the school's computer lab. Presentation materials and other supplies may need to be purchased for your project. You should keep at least 2 separate backup copies of all work you do on diskettes.

Grading scale and policy

For subjectively graded assignments such as program style and quality, essay questions, reports, or projects, work that meets the stated requirements will in general earn a C grade. Work that goes beyond the basic requirements will in general earn anywhere from a C+ to a B- grade. Work that is very good and exceeds the instructor's expectations will in general earn a B or B+ grade. Only the most outstanding work will earn an A grade.

(Refer to the Mansfield University Catalog for grades that can be awarded.)

A >= 90%
B >= 80%
C >= 70%
D >= 60%
F < 60%

In addition, the instructor may choose to further differentiate grades with plus and minus subdivisions as outlined in the catalog.

Course Grade
% of Grade
Quizzes
30
Assignments
20
Project report and presentation
20
Final Exam
30

Quizzes are closed book and timed (typically given at the beginning of class--late excuses are not excepted for quizzes). You will be allowed a one-page (8.5 x 11 inch) handwritten and non-photocopied original note sheet that you yourself have created, i.e. it may not be copied from another student in any way. Neither early quizzes nor makeup quizzes will be given, however, your 2 lowest quiz grades will be dropped to allow for any unavoidable or excused absences.

Homework assignments will be displayed on-line at http://coursenotebook.com. Follow the directions found at that location. Homework must be completed within the specified time frame or no credit will be given. Homework must be the student's own work unless otherwise specified.

The programming project is a substantial part of the student grade. Therefore, a very high quality product will be required. Grading will be based on the program design and implementation, level of difficulty, written documentation, oral presentation, organization, and overall level of quality.

The final exam will be comprehensive, closed book, and timed. You will be allowed a one-page (8.5 x 11 inch) handwritten and non-photocopied original note sheet that you yourself have created, i.e. it may not be copied from another student in any way.

Late assignment policy

Work that is late will lose one letter grade for each day late. No excuses. Computer, server, ftp, disk, and Internet problems will happen, therefore, make it a point to complete all assignments at least one day before the deadline.

Instructor's expectations

This course places an emphasis on out-of-class experimentation, research, and programming. You will need to go beyond the textbook and draw from the extensive resources available on the Internet. You will need to spend a large amount of time exploring the lecture topics covered in a hands-on environment, either on your own computer or in the computer lab.

Methods of instruction

Material will be presented in lecture format. You are expected to read each assigned chapter prior to the lecture. Feel free to ask questions on any material you need clarified during the lecture.

Unique requirements of the course

This course requires previous programming experience in a language such as C, C++, or Java. We will cover the basics of the Perl programming language very quickly. Considerable outside of class time will be required to complete the assignments!

Attendance

Students are expected to attend all courses and course activities for which they are registered. Any class meeting missed, regardless of cause, reduces the opportunity of learning and may adversely affect a student's achievement in the course.

Bad Weather Policy

On days that we have icy or snowy weather, the instructor may choose to hold class on-line. This will be announced on coursenotebook.com.

Academic Integrity

It may be tempting to cheat in this class. Do not do it! You will be posting some of your work for all to view. Feel free to browse other students' posted work, on-line web sites, and other books for ideas. However, if you copy that work and you do not give credit for it, that is plagiarism. Likewise, if you discuss an exam you have taken with another student before they take it, that is cheating. Working together on graded homework in this class is also considered cheating. You may get help on homework if you get stuck, but you must carefully document the help you receive. You may not do anything that gives you or another student an unfair advantage. If you are in doubt then discuss the situation with your instructor.

Exceptionalities

Any students with documented psychological or learning disorders or other significant medical conditions, please work through Mr. William Chabala (South Hall 216) to provide me with the appropriate letter so that I may serve your particular needs better.

Withdrawal Policy for Individual Courses

The last day to withdraw from a College course with a "W" grade is published in the Academic Calendar. It is the responsibility of the student to complete and submit the necessary forms to the Registrar's Office. An official withdrawal would entitle the student to a grade of "W" in the course.

Syllabus Change Policy

The instructor reserves the right to make changes to this syllabus as the course progresses.

COURSE TIMELINE

Week
Week Of
Tuesday Thursday
1 08/25

1. Introduction to the course
2. CNB and Linux accounts
3. The Linux work environment
4. Programming pre-test

1. Linux commands
2. The vi text editor
3. Perl chapters 1, 2
2 09/01

No CIS 206 class today.
Monday class schedule instead.

1. Perl chapters 3, 4
2. Example programs
3. Homework assigned

3 09/08 1. Homework #1 due
2. In class quiz #1
3. Perl chapters 5, 6
1. Example programs
2. Homework assigned
4 09/15

1. Homework #2 due
2. In class quiz #2
3. Perl chapters 7, 8

1. Example programs
2. Homework assigned
5 09/22

1. Homework #3 due
2. In class quiz #3
3. Perl chapter 9, 10

1. Example programs
2. Homework assigned
6 09/29

1. Homework #4 due
2. In class quiz #4
3. Perl chapters 11, 12, 13

1. Example programs
2. Homework assigned
7 10/06

1. Homework #5 due
2. In class quiz #5
3. Perl chapters 14, 15, 17

1. Example programs
2. Homework assigned
8 10/13 1. Homework #6 due
2. In class quiz #6
3. Perl chapter 16, HTML, CGI
1. Example programs
2. Homework assigned
9 10/20

Fall Holiday - no classes

1. Homework #7 due
2. In class quiz #7
3. Perl chapters 15, 17
4. Example programs
5. Homework assigned

10 10/27 1. Homework #8 due
2. In class quiz #8
3. Perl DBI and SQL
1. Example programs
2. Homework assigned
11 11/03 1. Homework #9 due
2. In class quiz #9
3. Perl chapters 18, 19, 20, 21
1. Example programs
2. Homework assigned
12 11/10 1. Homework #10 due
2. In class quiz #10
3. JavaScript
1. Example programs
2. Homework assigned
13 11/17 1. Homework #11 due
2. In class quiz #11
3. XML, CSS, Advanced topics
1. Example programs
2. Homework assigned
14 11/24

1. Homework #12 due
2. In class quiz #12
3. Project workday

Holiday - no classes
15 12/01 Project Presentations Review
16 12/08

Final exam for 11:00 section is on 12/9 beginning at 10:15 AM