Kapi`olani Community College Spring 2005

ITS 151 Applied Database Programming

Prerequisites: ITS 113, ITS 118, ENG 160, BUS 100

Instructor: Mary T.P. Hattori

Phone: 734-9013

E-mail: maryh@hawaii.edu

Office Location: Kopiko 213

Office Hours:

Tues:1:00-2:30pm

Thurs:1:00-3:00pm

Other times possible on an appointment basis.

Description

This is a course in developing interactive Database Management Systems (DBMS) in an Object-Oriented Database Environment. Structured programming techniques, good programming style, and event-driven programming are emphasized. Students will develop complete event-driven, menu-based database systems.

Required Course Text

Advanced Programming Using Visual Basic .NET with .NET CDs by Julia Case Bradley & Anita Millspaugh, McGraw-Hill, 2003. This book includes hands-on exercises, which will be done in class, so students MUST bring this book to class on a regular basis. This book is required and students who cannot purchase the book should drop the course, as their learning will be negatively affected by failure to participate in hands-on exercises. Assigned readings must be completed prior to scheduled class times.

Required Diskettes

A 100Mb ZIP disk or USB Mass Storage Device, which MUST be brought to class beginning in the second week of instruction.

COURSE COMPETENCIES

Upon successful completion of this course, the student should be able to:

- Demonstrate an understanding of structured program design and methodologies.

- Develop database programs in an object-oriented environment.

- Develop program modules that perform multi-file references and updates, string processing, interactive processing and handling of user interaction through menus, prompts and other screen presentation.

- Use the modern design tools of object-oriented environments.

CLASS FORMAT

Content will be presented through lectures, projects, discussions, demonstrations, hands-on & review activities, and the World-wide Web (see below for more web info). Highly structured group and individual assignments will be used to demonstrate and reinforce material covered in lectures and readings. Students are to work on projects both in class and outside of class time and will be required to do a formal in-class presentation. Students must be prepared to take notes during lectures and feel free to ask questions. Students must be prepared to devote a considerable amount of time outside of class to practicing on the computer and working on class projects.

USE OF THE WEB AND ELECTRONIC MAIL

A web site has been established to support instruction. The site will be used to:

(1) provide information such as a syllabus, calendar, supplemental material, & projects; (2) deliver exams; (3) provide feedback to students such as grades; (4) provide a vehicle for assignment submission & (5) facilitate communication between students and instructor. Students will be REQUIRED to access the web site on a regular basis. Except for exams and quizzes, students will need to obtain web-based material on their own, outside of class. Directions/hands-on demonstrations regarding the web site will be provided in the first weeks of class. Web address: http://webct.hawaii.edu

ATTENDANCE/CHANGES IN REGISTRATION

Prompt and regular attendance to class is expected of each student. Students who are late or miss class are still responsible for obtaining from classmates, notes on the material and/or assignments covered in class. Students are responsible for any change in registration such as adding/dropping, or withdrawing from the course. Refer to the Schedule of Classes for all deadlines and registration information.

GRADING SCALE

A standard scale will be used to determine final course grades. The scale is as follows:

A: 90 - 100 points C: 70-79 points F: 0 - 59 points

B: 80-89 points D: 60 - 69 points

GRADED LABS

Throughout the course of the semester, students will be placed into groups to create small projects as part of class sessions. These lab projects are required and must be done in class. Students who fail to attend class will receive no credit for the lab. Make-ups for labs are not possible except in dire circumstances.

ASSIGNMENTS & EXAMINATIONS

No extra credit assignments will be given.

Evaluation Items	Points Possible	Evaluation Items	Points Possible
Projects:	Total: 40	Labs:	Total: 5
Project I	7	Lab I	1
Project II	10	Lab II	1
Project III	8	Lab III	1
Project IV	7	Lab IV	1
Project V	8	Lab V	1
Exams:	Total: 35	Final Exam	Total: 20
Exam I	8	Objective/coding	8
Exam II	8	Hands-on coding	12
Exam III	9
Exam IV	10

ASSIGNMENT/EXAM POLICIES

Assigned projects must be submitted by the beginning of the class session in which they are due. Some assignments will be submitted electronically. Late assignments will be assessed a penalty of one point per calendar day. Waiver of this penalty is possible in extenuating circumstances, which are beyond the control of the student, e.g., illness, and death in the family. Documentation of such circumstances may be requested. It is the responsibility of the student to initiate a waiver of the penalty.

Make-up exams may be given only for extenuating circumstances and must be initiated by the student as soon as possible after an exam is missed. Failure to contact the instructor about a make-up will result in an F for the missed exam. No assignments will be accepted and no make-up exams will be given after the last day of class.

Cheating & plagiarism on any project or exam are unacceptable and will result in an “F” for ALL parties involved.

OTHER POLICIES

Class will begin ON TIME. Tardiness will impede your success in this class. If you cannot be prompt for EVERY class, drop the course or be prepared to accept the consequences.

Please set your pagers and cell phones to vibrate mode/OFF during class sessions.

To maintain the quality of the classroom equipment, a strict policy prohibiting all food and beverages in open containers will be enforced.

If you have a disability and have not voluntarily disclosed the nature of your disability and support that you need, you are invited to contact the Special Student Services Office, 734-9552, Ilima 103 for assistance.

ATTESTATION OF ACADEMIC HONESTY IN GRADED PROJECTS

At the beginning of the code for the main form, you MUST include a statement that the work is your own. Use the following paragraph as a model:

I your name, certify that this program represents my own independent labor and conforms to the policies in the KCC schedule of classes & Student Conduct Code governing academic dishonesty.