Physics Logo

CIS 435: Business Systems Programming II using Java
Professor: Ricky J. Sethi Instructor Info

Sethi Family HomePage

CIS 435
Syllabus
Fall 2006



Professor Ricky J. Sethi
Email rickys @ sethi.org
HomePage This page! (http://www.sethi.org/classes/cis435/)
Phone 909-868-4031
Office Hours By appointment in the Adjunct Office


Catalog Description

This course introduces students to advanced programming concepts using JAVA. Topics include GUI classes, control mechanisms and constructs, data types, functions, and basic file processing. Using design tools, such as pseudocode and structured flowcharts, students focus on developing programming logic in a top-down modular fashion. In this course students build on the skills developed in CIS-430 as they construct business-oriented programs that incorporate a variety of advanced techniques such as database access, embedded Structured Query Language (SQL), and retrieval optimization.

Pre-requisite CIS-430 / 6-0-5
Credit hours CIS 435 is 6 hours.
Meetings Wednesday 6:30 - 9:30p.m., Room TBD

Texts and Materials

Required:

  • Textbook cover

    Java How to Program, Sixth Edition
    by Deitel & Deitel
    © 2003 Prentice Hall

    Note! icon Click here to visit the online bookstore, Follett Express, if you have not yet ordered your books and supplies!

Recommended:

  • Mitchell Waite Signature Series: Object-Oriented Design in Java by Bill McCarty and Stephen Gilbert

Suggested:

References:



The Grading Policy

Grades will be assigned on a 100% scale but given scores will be based on a curve taking into account the overall performance of your class.

Assignment Percentage
Labs 25%
Threaded Discussions 25%
Pop Quizzes (on-line) 10%
Midterm 10%
Final 15%
Participation/Professionalism (subjective and objective, on-line and on-site) 15%

Please Note:

  • You must make prior arrangements for submitting late assignments and receive approval. Even then, points may be deducted depending upon the circumstances.
  • Threaded Discussions will always close on their Due Date each week at 11:59 P.M. Pacific Standard Time (PST) and may not be made up.
  • The graded components will include everything that will be graded in the schedule along with the discussions.

Strategy

Exams and Quizzes:

All exams and quizzes will be taken online and the final will be comprehensive. Absences from these exams are handled according to Devry policies. On all tests, all quizzes, and the final, you are responsible for everything covered in class, covered in the threaded discussions, assigned in class, and assigned in this syllabus. There are no make-ups on anything.

There will be pop quizzes scheduled throughout the course. Quizzes are taken online and will cover material from the lecture, threaded discussions, and labs/exercises. You will have 30 minutes to complete the quiz online. eCollege/iOptimize will control at which times, during the week, you will be allowed to take the quiz. You will have the full (regular) week to take the quiz but you will only be allowed to take it once. Failure to take the quiz the week it is assigned will result in zero points for that particular quiz.

My policy on the pop quizzes is to determine how the class, as a whole, is performing on the Threaded Discussions. If the performance of the class (again, as a whole), in my estimation, needs improvement, I will schedule a quiz for the following week. If, however, the class seems to be keeping up with the reading and engaging in a lively, informative discussion, then I likely won't schedule a quiz for the following week. In order to allow for consistent quality of discussion, there won't be any pre-announcement for the quiz so please check the week's introduction and the items listed for each week diligently to ensure you don't miss a quiz!

The Midterm Exam is normally during the half-way point of the term and the Final Exam is typically scheduled during the last week of class. No early Final or Midterm Exams will be given. If you miss the Final Exam for any reason, you will receive an "Incomplete" for the course or a passing grade if you have earned one. Please be sure to make up the missing exam by the end of the first week of the new term, before the Incomplete automatically reverts to a failing grade.

Lab Assignments:

In this course, we will emphasize a hands-on approach. As such, the lab assignments (and threaded discussions!) will be where all of your learning will likely occur. Spend a lot of time on the labs and discussions and, if you need any clarifications whatsoever, please feel free to post questions in the Discussions or drop me an email! Please post your Labs in the Dropoff box. Also, be ready to show and explain your Labs in follow-ups. In this class, one of the best ways to learn is to try to explain your work and make lots of mistakes.

Participation/Professionalism:

I expect everyone to conduct themselves in a professional manner and to participate fully. However, since participation is an inherently subjective evaluation, it is not a mandatory part of your evaluation in this course. Even so, I will be keeping a keen eye out for those individuals who go above and beyond, especially in the Threaded Discussions. Students who engage their peers, pose interesting questions, craft thoughtful responses, all the while maintaining the highest level of professionalism will garner points in the area of Participation and Professionalism. I award these points as extra-credit at the end of the term and the maximum amount of extra-credit that can be earned is listed above.

Chapter Reading Memos

Subject matter is covered pretty much in the sequence presented in the required textbook. It is therefore recommended that you scan the chapters prior to the scheduled lectures to become familiar with new terms that will be introduced. In order to facilitate this, every reading assignment, will have a required reading memo due the meeting day following the meeting day it was assigned.

The idea is to have you write down questions and other "instantaneous gut reactions" as you do each reading assignment in the text. It is very important that you create these memos as you read, and on the first pass through the material. They must not be edited or "cleaned up" afterward, and they should not be just outlines or notes. In other words, your reading memos should not simply be a summary/rehashing of the chapter; instead, they should reflect your questions, observations, and insights.

What is the purpose of these reading memos? First, it shows me that you've done the reading. In addition, it encourages active reading (reading scientific tomes is a very different experience from reading a novel or other leisure book where you can passively scan the pages). And, even more importantly, it gives me insight into what you're learning, and, more significantly, what I might need to concentrate on more in lecture. Lastly, they give me a student's perspective on the material and often point out common misconceptions or exceptional insights.

So why should you do them? Well, if all that insight and learning wasn't sufficient motivation, it might help to know that your reading memos will contribute significantly towards your participation grade (see grading policy below). In addition, I'll be using at least one question from your reading memos on the weekly quizzes.

Format of the reading memo: nothing terribly elaborate. Just have a sheet of paper handy as you read the text and jot down your notes. As long as they're legible, I'll be happy. They don't have to be any specific length; I'm just looking for your first impressions and questions you might have. As far as the grading is concerned, I'll basically just be checking off if you're doing them or not. So if you hand one in, you'll get the credit for it. But I'll also be reading them so if you want to impress me, come up with some great memos/questions! Finally, if you're more comfortable jotting them on your computer, feel free to email them to me.

Threaded Discussions:

  • Respond at least once to each original threaded discussion question.
  • On a different day of the week, respond to at least one response from other students for each threaded discussion question.
  • Please note:  you must answer all parts of the question completely for total threaded discussion credit.

Nota Bene: some of the threaded discussion questions might appear on the quizzes/midterm/final.

Threaded Discussion Questions Guidelines:

  • Students must post to threaded discussions questions a minimum of three times a week on three different days.
  • For each threaded discussion question, students must respond to the original question and post one follow-up to another student's response.
  • It is imperative that you attempt to access your eCollege/iOptimize course site as soon as possible. If any initial problems are encountered, please contact the helpdesk at helpdesk@devryu.net.

NOTHING MAY BE LATE AND NO MAKEUPS ON ANYTHING!

The Threaded Discussion Grading Policies:

In the "Discussion" areas of the course, you, as a student, can interact with your instructor and classmates to explore questions and comments related to the content of this course.

A successful student in online education is one who takes an active role in the learning process. You are therefore encouraged to participate in the discussion areas to enhance your learning experience throughout each week.

The discussions will be graded for:

  1. Frequency: Number and regularity of your discussion comments,
  2. Timeliness: Promptness of comments, and
  3. Quality: Content of your contributions

Frequency: Number and regularity of your contributions. Students are expected to log into the course and post (respond) in the threaded discussion topics on a minimum of three separate days per week.

Timeliness: Promptness of your contributions. I.e., whether they're before the deadline, timely, relevant, etc.

Quality: Content of your contributions. Examples of quality posts include:

  • providing additional information to the discussion;
  • elaborating on previous comments from others;
  • presenting explanations of concepts or methods to help fellow students;
  • presenting reasons for or against a topic in a persuasive fashion;
  • sharing your own personal experiences that relate to the topic;
  • providing a URL and explanation for an area you researched on the Internet; and
  • suggesting relevant and insightful questions.

Quality Measurement

High

Your contributions to each Topic indicate your mastery of the materials assigned. Your responses might integrate multiple views and/or show value as a seed for reflection for other participants' responses to the thread.  You provide evidence that you are reading the assigned materials and other student postings and are responding accordingly, bringing out interesting interpretations.  You know the facts and are able to analyze them and handle conceptual ideas.

Medium

Your responses build on the ideas of another participant (or more) and dig deeper into assignment questions or issues. When you make intelligent posts during the week, including some good critique of the course material, then you have demonstrated you have an understanding of the material, are reading posts of your colleagues, and are contributing to the class.  Your posts demonstrate confidence with the materials, but may be just a bit off target in one area or another.

Low

You have meaningful interaction with other participants' postings. Posts that state I agree or I disagree include an explanation of what is disagreed or agreed upon and why, or introduce an argument that adds to the discussion.  However, you may have rambling, lengthy posts that show no sign of having been re-read and refined before posting, and your writing suffers lack of clarity and comprehension. 

Unsatisfactory

You will receive little credit in the week's discussion by just showing up and making trivial comments, without adding any new thought to the discussion.  At the low end of the spectrum, no participation gets a "0." If you are not in the discussion, you do not earn any points.

Full credit is awarded when high quality, required frequency, and timeliness criteria are met.

It is the DeVry University discussion policy that there is NO MAKE-UP option for Threaded Discussions. You will not be given "other assignments" or extra credit to make-up for not being able to participate in the Threaded Discussions.

For DeVry University policy on discussions (and all other DeVry University policies), please review the information contained in "Policies" under the Course Home section of your course.

Course Policies and Procedures:

All information is subject to change at my discretion. Any changes will be given in class and/or posted on http://www.devryu.net

Communication Procedures Between the Instructor and Students:

  1. General communication from me to the students will be done via http://www.devryu.net  or email.
  2. You should check the http://www.devryu.net  course pages and your email on a regular basis.
  3. The type of information that is available on http://www.devryu.net  is:
    • Course Syllabus
    • Handouts
    • Quizzes/Exams
    • Announcements of a general nature for all students enrolled in this course
    • Postings and discussions of Labs
  4. You should communicate with me through e-mail. Please include your name, a valid email return address the name/number of the course and DEVRY. DO NOT SEND ME ANY ATTACHMENTS. COPY ALL YOUR MATERIAL AS PLAIN TEXT INTO THE BODY OF THE EMAIL.
    • You may use the Email tab at the top of this course site to send me an e-mail.
  5. I will use your e-mail for confidential communication.

Some Final Notes...
  • My email response time is a maximum of 12-24 hrs but, if I'm in town, you'll usually get a response from me within a few minutes. I usually respond to both, emails sent directly to me and to posts in the Threaded Discussions, with equal alacrity.
  • About posting in the Threaded Discussions:
    • Feel free to cite other sources but any parts copied must be explicitly put in quotes and a supporting ORIGINAL post must be provided, in addition to the source. If any part of a post is found to be copied from an external source without being quoted and cited, the grade for that whole week will automatically be a 0.
    • Post lots of questions and your own discussion topics for maximum credit!
    • Don't worry if you're uncertain about the answer to a discussion topic thread (just be sure to mention that you delineate between what you know and what you guess); the important thing is to post some kind of answers to these great questions and get a discussion going!
  • Since this course is hybrid (on-line AND on-site), consistent and high-quality posting is more important than ever!



Terminal Course Objectives

Following are the objectives for this course. Individual faculty, based upon their experience and expertise, may add to these objectives to meet local campus needs. Any such additions will be communicated to the class. While the instruction remains focused in helping students, accomplishing these objectives is a shared responsibility of students and faculty. The outcomes of this course will depend upon the motivation and capabilities of the students, sufficient time allocation for studying, and the effectiveness of that effort.

DeVry University is committed to the continual improvement of its curriculum and instruction and to meet the needs of students and employers in a rapidly changing global economy. Students, faculty, and the university must all be actively involved to accomplish these objectives, as well as the objectives of this particular course.

  1. Given a business system application that needs to retrieve a row of data from a relational database and display that row to a user using a high-level language such as Java: design, code and document the business application.
  2. Given a business system application that needs to retrieve a row of data from a relational database and display that row to a user using a high-level language such as Java and handle errors that may occur: design, code and document the business application.
  3. Given a business system application that needs to get data from a user, insert a row of data into a relational database table and display success of that action to a user using a high-level language such as Java: design, code and document the business application.
  4. Given a business system application that needs to load a database table from a file of data using a high-level language such as Java: design, code and document the business application.
  5. Given a business system application that needs to get data from a user, display several rows of data on the screen at one time and allow the user to navigate thru multiple pages of records using a high-level language such as Java: design, code and document the business application.
  6. Given a business system application that needs to get a key value from a user, display a row of data on the screen that corresponds to that key and allow the user to update that record using a high-level language such as Java: design, code and document the business application.
  7. Given a business system application that needs to get data from a user, display several rows of data on the screen at one time, allow the user to navigate thru multiple pages of records and allow the user to update any record currently on the screen using a high-level language such as Java: design, code and document the business application.
  8. Given a business system application that needs to populate a user screen using data from rows in several related tables, such as displaying the order and its items, using a high-level language such as Java: design, code and document the business application.
  9. Given a business system application that needs to apply a file of add, update and delete transactions to a database using a high-level language such as Java: design, code and document the business application.

Official School Policies

A) Academic and Professional Conduct

Ensuring academic integrity is an educational objective DeVry takes very seriously. The School's Academic Policy is printed in the catalog, and the following explanations may be helpful in interpreting what are considered to be violations of the policy. 

Students have a responsibility to maintain both the academic and professional integrity of the School and to meet the highest standards of academic and professional conduct. Students are expected to do their own work on examinations, class preparation and assignments and to conduct themselves professionally when interacting with fellow students, faculty and staff. Students must also make equitable contributions to both the quality and quantity of work performed on group projects.

Academic and/or professional misconduct is subject to disciplinary action including course failure, probation or dismissal. Academic dishonesty includes, but is not limited to, cheating on examinations, plagiarism, bribery, falsification of student records and improper attempts to influence Instructors or School officials.

Examinations: Using notes, looking at another student's test paper, or providing another student with answers during an examination are violations of the policy.

Course Assignments/Projects: Unless a course assignment is specifically designated as a group/team assignment, collaborating with another student in completing assignments intended to be completed independently or submitting another student's work as your own are violations of the policy.

Research Reports: To use another person's ideas, words, expressions, or findings in your writing without acknowledging the source is to plagiarize. A writer who does not give appropriate credit when quoting, or even paraphrasing, another's writing is guilty of plagiarism and in violation of the Academic Policy. 

The policies and procedures set forth in the DeVry Handbook will be the guide for standards of conduct, including cheating, plagiarism, grading and other policies. 

Students should adhere to the same types of conduct for cheating, plagiarism, etc. that are followed in the traditional classroom.

Students should be familiar with the consequences of cheating, plagiarism, or rules infractions as set out in the DeVry Handbook.

B) Computer Virus Disclaimer

"Students have a responsibility to maintain both the academic and professional integrity of the School, and to meet the highest standards of academic and professional conduct."  Any intentional, willful or reckless transferring of viruses, as the result of an email message or attachment will be considered professional misconduct.  Professional misconduct is subject to disciplinary action including being placed on probation, failing a graded course component, failing a course, or being dismissed from the School.  DeVry will not be liable to any affected student for any indirect, special, incidental or consequential damages that may occur as a result of this type of misconduct by any person.

Faculty and DeVry staff have a responsibility to maintain both the academic and professional integrity of the School, and to meet the highest standards of academic and professional conduct.  Any intentional, willful or reckless transferring of viruses, as the result of an email message or attachment will be considered professional misconduct.  Professional misconduct is subject to disciplinary action. DeVry will not be liable to any affected person or organization for any indirect, special, incidental or consequential damages that may occur as a result of this type of misconduct by any person. 

Plagiarism & MLA Citations

Plagiarism is a violation of the Academic Integrity code of this institution and will not be tolerated.  The plagiarism policy applies to every aspect of DeVry University coursework including threaded discussions, exams, quizzes, essays, assignments, etc.  It is important that students fully cite any text they apply to their work.  Please see the materials in document sharing and the webliography on MLA to learn how to avoid plagiarism. 

If you copy from, rely on, or paraphrase from your text or from any other source, you must include in-text citations. For any source other than your text, you must also include the proper reference material including the full URL and date accessed if the source is the web. Failure to do so is a violation of DeVry Academic Standards, and will mean a zero for your assignment and an investigation of plagiarism by Student Services.

note icon small Please take a moment to review these important tutorials.

To learn more about avoiding plagiarism in your work:
Tutorial icon
How to Avoid Plagiarism

To learn more about MLA Style Citations in your work:
Tutorial icon MLA Method of Citing Sources

For a complete explanation of DeVry University Online's Academic Integrity Policy, please see the Policies item under the Course Home tab.  For additional information see your student handbook (available in the student services website).

C) Required Policy Guidelines

Attendance Policy

Each student is required to attend every lecture and laboratory in which he or she is enrolled. A swipe-card terminal in each classroom is used to record attendance electronically. Students are responsible for arriving before class begins, sliding their identification card through the wall-mounted reader, and remaining for the duration of the course meeting. Students who are absent for two or more days must contact their assigned Academic Coordinator for advisement. Students who miss more than five (5) consecutive days of school are in violation of the DeVry attendance policy and will be dismissed.

Examination Make-Up Policy

Since responsible behaviour -- including daily class attendance -- is expected of all DeVry students, absence from a scheduled examination is considered to be an extremely serious matter. It is school policy that no faculty member shall be required to schedule a make-up examination unless the student presents a statement from a licensed physician stating that he or she was physically unable to attend school on the day of the exam. The faculty member may schedule a make-up for other equally serious reasons, provided that arrangements are made prior to the date of the exam. An individual faculty member may also schedule a make-up exam if, in his or her opinion, a situation exists that does not fall under the provisions of this policy yet merits special consideration.

Course Grading Standards

A final letter grade is to be awarded to each enrolled student in accordance with the 4.00 grading system shown below.

Letter Grade Percent of Total Points Grade Points
A 90 - 100% 4.00
B 80 - 89% 3.00
C 70 - 79% 2.00
D 60 - 69% 1.00
F Below 60% 0.00

Academic Integrity Policy

Ideas and learning form the core of the academic community.  In all centers of education, learning is valued and honoured.  No learning community can thrive if its members counterfeit their achievement and seek to establish an unfair advantage over their fellow students. The academic standards at DeVry are based on a pursuit of knowledge and assume a high level of integrity in every one of its members.  When this trust is violated, the academic community suffers injury and must act to ensure that its standards remain meaningful. The vehicle for this action is the Academic Integrity Policy outlined in the Student Handbook.

The Academic Integrity Policy is designed to foster a fair and impartial set of standards upon which academic dishonesty will be judged. All students are required to read, understand, and adhere to these standards, which define and specify the following mandatory sanctions for such dishonest acts as copying, plagiarism, lying, unauthorized collaboration, alteration of records, bribery, and misrepresentation for the purpose of enhancing one's academic standing:

  • The first recorded offense will result in the student receiving zero credit for the entire paper, exam, quiz, lab, homework assignment, or other graded activity in which the incident of academic dishonesty occurred. No partial credit may be given.  Where the incident involved a graded assignment normally subject to a "drop" option, the student may not exercise that option.
  • The second recorded offense will result in the student receiving a failing grade for the course in which the second offese occurs. The second offense need not be in the same course, program, or term as the first offense to invoke this sanction.
  • The third recorded offense will result in the student being permanently expelled from the DeVry system. Again, the third offense need not be in the same course, program, or term as either the first or second offense to invoke the sanction.


The Tentative Schedule

This list is intended to act as a planning guide for students. The timing of the Exams are set and Homework/Quizzes are planned weekly. Timing of all activities will be continuously communicated in classes and/or via email.

Changes to Syllabus: The contents of this syllabus are subject to change with appropriate notice to the students.

Weeks & TCOs

Topics per Week

Text and other Readings

In-class Activities

Online Activities

Labs and Project Tasks Due

1

TCO 1

Introduction

JBuilder 2005 DB components

Deitel-Ch 25

Borland DB tutorial

Lecture Discussions

Class Exercise #1

Build interface & bind to database fields

Participate in TDs

Review notes

dbSwing components

Lab #1 - Add navigation buttons and code to in-class exercise.

JBuilder DB tutorial

2

TCOs 2, 4

Importing data from a text file

Creating tables

Chapters 25 Deitel

Borland DB tutorial

Lecture Discussions

Class Exercise #2

Borland tutorial on importing data from a file

Participate in TDs

Review notes-Borland tutorial on exporting data to a file

Online quiz

Lab #2 - Exporting data to a file from a database

3

TCOs 3, 5, 6, 7

Querying a database

Inserting records

Deitel-Ch 25

Borland DB tutorial

Lecture Discussions

Class Exercise #3

Displaying multiple records and inserting using dbSwing components

Participate in TDs

Review notes-updating records

Lab #3 - Updating database records.

4

TCOs 8, 9

Table joins

Midterm Exam

Deitel-Ch 25

Borland DB tutorial

Lecture Discussions

Class Exercise #4

Retrieving data from multiple tables

Participate in TDs

Review notes-Introduction to servlets and Tomcat

Lab #4 - Hello Servlet

5

TCO 9

HttpServletRequest Interface

Deitel-Ch 26

Borland DB tutorial

Lecture Discussions

Class Exercise #5

Inserting records into a database

Participate in TDs

Review notes-HttpServletResponse Interface

Lab #5 - Login Servlet

6

TCOs 1-9

Servlet Database Access

Deitel-Ch 26

Borland DB tutorial

Lecture Discussions

Class Exercise #6

Login servlet using a database

Participate in TDs

Review notes--Project

Online quiz

Lab #6 - Servlet based web project

7

TCOs 1-9

Servlet based web project

Deitel-Ch 26

Borland DB tutorial

Lecture Discussions-Project

Review notes

Lab #7 - Servlet based web project

8

TCOs 1-9

In-class Proctored Final Exam

The proposed schedule (subject to some flexibility) is: Ch. 25, 26, and supplementary readings