Course number: CIS 206
Credit/Contact hours: 3
Term: Fall, August 27 - December 14, 2001
Course title: Business Programming Concepts I
College website: www.mansfield.edu
Instructor name: John Phillips
Instructor office location: Elliott 209 B
Instructor office hours: 9:00 - 11:00 MWF
Instructor office telephone: 570-662-4704
Instructor e-mail address: jphillip@mnsfld.edu
Instructor website: www.programbetter.com
An introduction to analyzing and designing solutions to business-related problems using a business programming language. Topics covered include Unix, HTML, Perl, CGI, and SQL.
Prerequisite: CIS 104.
Sams Teach Yourself Perl in 21 Days, Laura Lemay, 1999, Sams Publishing, ISBN: 0-672-31305-7.
www.programbetter.com for the syllabus and course information
www.coursenotebook.com for the class discussion board
1. The UNIX / Linux work environment
2. The Perl programming language
3. Systems administration and Perl
4. The HyperText Markup Language (HTML forms) and Perl
5. The Common Gateway Interface (CGI scripting) and Perl
6. The Structured Query Language (SQL database commands) and Perl
7. Building Internet-based business solutions using HTML, CGI, Perl, and SQL
TuTh 9:30 AM - 10:45 AM
or
TuTh 11:00 AM - 12:15 PM
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 a backup copy of all work you do on one or more diskettes.
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 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 | 40 |
| Homework and participation | 15 |
| Project report and presentation | 15 |
| Final Exam | 30 |
Quizzes are 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. 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 posted within the specified time frame or no credit will be given. Homework must be the student's own work.
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.
Work that is late will lose one letter grade for each day late. No excuses. Computer, server, ftp, and Internet problems will happen, therefore, make it a point to complete all assignments at least one day before the deadline.
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.
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.
This course requires previous programming experience. We will cover the basics of the Perl programming language very quickly. Considerable outside of class time will be required to complete the assignments.
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.
As stated in the MU catalog, "students are expected to do their own academic work. Dishonesty in academic work, including cheating, academic misconduct, fabrication, or plagiarism is unacceptable. Faculty are expected to instruct students in ways of avoiding these forms of academic dishonesty. Faculty are also responsible for assessing and reporting all charges of academic dishonesty to the Office of the Provost. The student handbook, The Password, outlines the procedures faculty will use to initiate disciplinary action in cases of academic dishonesty."
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 a quiz you have taken with another student before they take it, that is cheating. 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.
All violations of academic integrity will be referred directly to the Office of the Provost no matter how small the incident.
The last day to withdraw from a College course with a "W" grade is October 26th. 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.
The instructor reserves the right to make changes to this syllabus as the course progresses.
| Week | Date | Tuesday | Thursday |
| 1 | 08/28 |
1. Introduction to the course |
1. Linux commands 2. The vi text editor 3. Perl chapters 1, 2 |
| 2 | 09/04 |
1. Perl chapters 3, 4, 5 |
1. Example programs 2. Homework assigned |
| 3 | 09/11 | 1. Homework #1 due 2. In class quiz #1 3. Perl chapters 6, 7 |
1. Example programs 2. Homework assigned |
| 4 | 09/18 |
1. Homework #2 due |
1. Example programs 2. Homework assigned |
| 5 | 09/25 |
1. Homework #3 due |
1. Example programs 2. Homework assigned |
| 6 | 10/02 |
1. Homework #4 due |
1. Example programs 2. Homework assigned |
| 7 | 10/09 |
1. Homework #5 due |
1. Example programs 2. Homework assigned |
| 8 | 10/16 | 1. Homework #6 due 2. In class quiz #6 3. Perl chapters 15, 17 |
1. Example programs 2. Homework assigned |
| 9 | 10/23 |
No CIS 206 class today. |
1. Homework #7 due |
| 10 | 10/30 | 1. Homework #8 due 2. In class quiz #8 3. Perl DBI and SQL |
1. Example programs 2. Homework assigned |
| 11 | 11/06 | 1. Homework #9 due 2. In class quiz #9 3. Perl DBI and SQL |
1. Example programs 2. Homework assigned |
| 12 | 11/13 | 1. Homework #10 due 2. In class quiz #10 3. Project workday |
Project workday |
| 13 | 11/20 | Project workday | Holiday |
| 14 | 11/27 | Project Presentations | Project Presentations |
| 15 | 12/04 | Perl advanced topics | Review |
| 16 |
Final exam for 11:00 section is on 12/11 beginning at 10:15 AM |
Final exam for 9:30 section is on 12/13 beginning at 8:00 AM |