Urban Campus

Syllabus CIS 338

Advanced PL/SQL

SEMESTER: Spring 2008

Instructor Information

Name

Kenneth Lambert

E-mail address

knlambert@dmacc.edu

Phone number

515-248-7230

Fax number

Office location

U1-243

Office hours

See door or web site

Course Information

Course title

Advanced PL/SQL

Course number

CIS 338

Credits

Section number

WB1

CRN number

23923

Days & Time

Monday 5:30 – 6:30pm

Location

U1-232

Course description

Cis 338 PL/SQL Programming

Prerequisites

It is mandatory that you have met the course pre-requisites prior to enrolling in Cis 338. You should have completed a computer literacy course, programming logic course, COBOL programming course an introduction to relational databases course and an SQL programming course (see cis 332 page for DMACC course numbers). The Oracle Academic Imitative requires you complete CIS 332 at DMACC before you can take this course.

Course competencies

CIS 338 competencies

Important Dates

Midterm

http://www.dmacc.edu/academiccal.asp

Final

http://www.dmacc.edu/academiccal.asp

Textbooks & Materials

Required textbooks

Any Oracle PL/SQL reference book

Required materials

A flashdrive and Oracle software installed on your class computer.

Software applications

Oracle 9i or 10G, and email

Software notice

All the software used in this class is copyrighted; therefore, it is not for distribution, copying, or personal use. This software is the property of Oracle and Des Moines Area Community College.

Course Policies

Attendance

It is STRONGLY suggested that you spend the required 10 hours per week working on this course. Remember that you have 15 weeks to finish the class. Late work will not be accepted unless you have made arrangements with the instructor before the due date.

This course utilizes textbook readings, hand-outs, powerpoint presentations, lab exercises, quizzes, written and lab exams and class discussions in an attempt to facilitate the development of your database programming skills. The goal of each class period is to reinforce learning and to create a fun, informational and useful experience for you. You will be encouraged to be resourceful in obtaining knowledge and will be required to fully participate in the learning process. This course will not follow a specific textbook. The textbook suggested is a research book for you. Most topics covered will require some research on the student’s part.

Grading criteria

Each student is expected to be honest in his or her work and is expected to complete the assignments on an individual basis. The college regards dishonesty in assignments, examinations, or other academic work as a serious offense. A student who cheats is subject to disciplinary action at the discretion of the instructor up to and including an F for the course.

EVALUATION:

80 percent = Tests

20 percent = Projects (Labs)

Truncating will be applied.

Grading scale is:

94 – 100 = A	91 - 93 = A-	88 – 90 = B+
84 - 87 = B	81 - 83 = B-	78 – 80 = C+
74 – 77 = C	71 – 73 = C-	68 – 70 =D+
64 – 67 = D	61 – 63 = D-	60 =< F

Classroom conduct

Participate positively in your educational process. Students who are experiencing difficulty with the course should meet with an instructor during office hours. See an instructor during class to arrange an appointment or check posted office hours.

Uphold the values of academic honesty. Each student is expected to be honest in his or her work and is expected to complete the assignments on an individual basis. The college regards dishonesty in assignments, examinations, or other academic work as a serious offense. A student who cheats is subject to disciplinary action.

Complete a Withdrawal. Students who stop coming to class must officially withdraw. Failure to do so may result in an F on the student's transcript.

Take tests according to the schedule. Except for extreme emergencies, you must take all tests by the due date. Quizzes will be given unannounced throughout the semester. They can not be made up.

Complete the course. An incomplete grade is given only to those students who are unable to complete the work due to serious illness, hospitalization, or a death in your immediate family AND who have only a small portion of course work to complete; for example, one or two tests. An incomplete is not given to students for poor attendance or poor skills.

Missed exams

Except for extreme emergencies, you must turn in all tests by the due date. If you contact me before the test, you will have one week after the test date to complete the test. If you do not contact me before the test, you cannot make up the test. Quizzes can occur at any time and the sum of the quizzes will equal a test for value. Quizzes cannot be made up.

Late assignments

If you fail to submit your work when it is due, no credit will be given for late work.

Extra credit

None available for this course. Exceptional work may be given extra points.

Study expectations

You are expected to read all assignments before a topic begins. Up to 10 hours per week study will be expected to pass this course.

Academic dishonesty

See DMACC Educational Services Procedures ES 262 VII. A. and B for information on plagiarism, cheating, information about appeals procedures or reference publication that addresses this information in detail.

DMACC Information Web Sites

DMACC home page

http://www.dmacc.edu/

Instructor home page

Ken's Home web page

Admissions & registration

http://www.dmacc.org/potienti.asp

WebCT

http://webct.dmacc.edu

Student handbook

http://www.dmacc.edu/handbook/

Add/drop dates

http://www.dmacc.edu/academiccal.asp

Refund policy

http://www.dmacc.org/refund.asp

Support Services

Accommodations

“It is the policy of DMACC to accommodate students with disabilities. Any student with a documented disability who requires reasonable accommodation should contact the special needs coordinator at 515-964-6850 voice or 515-964-6810 TTY.”

Services for students with disabilities

http://www.dmacc.edu/student_services/disabilities.asp

Contact the special needs coordinator at 515-964-6850 voice or 515-964-6810 TTY or contact the counselor on the Urban campus at 515-248-7505 for an Application for Accommodation.

Academic & educational advising

http://www.dmacc.org/student_services/academic_advising.asp

Career counseling

http://www.dmacc.org/student_services/career_resource.asp

Library

http://www.library.dmacc.cc.ia.us/

Room 122

· Monday – Thursday 8:00 a.m. to 9:00 p.m.

· Friday 8:00 a.m. to 4:30 p.m.

· Saturday 8:00 a.m. to 12:00 p.m.

Academic Achievement Center

http://www.dmacc.edu/web2000/student_services/academic_achievement_center.htm

Services include academic help, tutoring, GED, testing (Compass), pre-admission courses, high school diploma courses, and several credit classes.

515-248-7204 or 1-800-362-2127

Room 204/206/208

· Monday – Thursday 8:30 a.m. to 7:00 p.m.

· Friday 8:30 a.m. to 3:00 p.m.

· Saturday 9:00 a.m. to 12:00 p.m. (fall & spring semesters only)

Computer labs

http://www.dmacc.edu/helpdesk/HD_student.htm

Room 202

· Monday – Thursday 8:00 a.m. to 9:30 p.m.

· Friday 8:00 a.m. to 4:00 p.m.

· Saturday 8:00 a.m. to 12:00 p.m.

Rooms 215, 218, 232, 234

Available hours posted

Disclaimer

This syllabus is representative of materials that will be covered in this class; it is not a contract between the student and the institution. It is subject to change without notice. Any potential exceptions to stated policies and requirements will be addressed on an individual basis, and only for reasons that meet specific requirements. If you have any problems related to this class, please feel free to discuss them with me.

Course Schedule:

CIS 338 class schedule Email Ken a note

Ken’s homepage

Top