House Bill 2504

Spring 2011 Course Syllabus

ITSW-2337-01 (Adv Database)

Faculty Information
SemesterSpring 2011
InstructorSchipplein, Patricia Lynn
Phone(409) 984-6384
Business and Technology
Chair:Michael Trahan
Telephone:(409) 984-6378
Hours:MW 10:00-11:00; F 10:00-12:00; TR 9:30-10:45 and 12:30-1:30
Building:Student Center (PAMP)
Room #:405
Course Information
Course ID #10191
Course Subject-Number-SectionITSW-2337-01
Course TitleAdv Database
Course Description Advanced concepts of database design and functionality.
Course Prerequisites ITSW 1307 Introduction to Database with a C or better
Required Textbooks New Perspectives Microsoft Office Access 2007, by Joseph Adamski and Kathleen Finnegan, Thomson/Course Technology, ISBN # 978-1-4239-0589-9
Learning Objectives Explain relational database theory; collect and distribute data; analyze data; and perform complex queries, data validation and table relationships.

Major Assignments Panorama Database

Products Database

Contract Database

Agency Database

Vacation Database

Lucky Tire Database

Discussion Topics 1. Creating Custom Forms using Form Tools

2. Creating Custom Reports

3. Action Queries and Advanced Table Relationships

4. Macros

5. Using and Writing VBA Code

6. Managing and Securing a Database

Attendance Policy Attendance Policy:

Research has shown a cause and effect relationship between attendance and college success. See Additional CIS Class Policies below.

1. You should attend every class meeting. The instructor reserves the right to drop you from the class if you miss more than 6 hours of class.

2. Tardiness is not acceptable. You are required to be on time. Once the class is in progress, the instructor reserves the right to deny access to the classroom or impose other penalties.

3. Missed quizzes will each be recorded as a zero. No makeup quizzes will be given.

4. You are responsible for completing all assigned homework and for being prepared for each class meeting. This applies even if you were absent for the previous class meeting.

5. Cell phones should be set to vibrate during class time. You may quietly leave the room to answer an important call if needed—be sure to return quietly as well. Cell phones may not be visible during a testing period. Any violation of this rule will result in the student receiving a Zero on the test.

CIS Policies:

1. If you are absent and miss an exam, you will receive a grade of zero unless the instructor agrees to give you a makeup exam or make other arrangements. Requests for makeup exams are granted only if you have an exceptional reason for missing an exam--such as a medical emergency or death in the family.

2. Only one missing exam grade may be made up. All other missed exams will be recorded as a zero. It is the student’s responsibility to initiate arrangements for a makeup. Approval for the makeup should be cleared with the instructor prior to the date of absence. If this is not possible, the student must ask for such approval the first day upon returning to class.

3. The format of a makeup exam often differs substantially from that of a regularly scheduled exam.

4. If you are tardy for any exam or quiz, you will be allowed to take the exam or quiz only with the instructor’s approval.

5. Academic dishonesty in any form will not be tolerated. Please consult the student handbook for consequences of academic dishonesty. These policies will be strictly enforced.

6. No assignment will be accepted after its assigned due date unless prior arrangements have been made with the instructor.

Determination of Final Grade Daily Assignments: 20%

Major Tests: 60%

Final Exam: 20%

Final Exam Date May 12, 2011 - 8:00 AM
Campus Policies
Lamar State College - Port Arthur

Mission Statement

Lamar State College-Port Arthur is an open-access, comprehensive public two-year college offering quality instruction leading to associate degrees and a variety of certificates. The college, a member of The Texas State University System, has provided affordable, quality educational opportunities to residents of the Southeast Texas area since 1909.Lamar State College-Port Arthur embraces the premise that education is an ongoing process that enhances career potential, broadens intellectual horizons, and enriches life. The faculty, staff, and administration share a commitment to a mission characterized by student learning, diversity, and community service. The foundations for student success include compensatory education programs designed to fulfill our commitment to accommodate students with diverse goals and backgrounds, technical education programs that provide for the acquisition of the skills and demeanor necessary for initial and continued employment, and a core curriculum that develops the values and concepts that allow the student to make a meaningful contribution in the workplace or community. Student achievement is measured by the completion of courses and programs of study, successful performance following transfer to a baccalaureate program, and the attainment of individual goals.

Lamar State College-Port Arthur operates in the belief that all individuals should be:

* Treated with dignity and respect;

* Afforded equal opportunity to acquire a complete educational experience;

* Given an opportunity to discover and develop their special aptitudes and insights;

* Provided and opportunity to equip themselves for a fulfilling life and responsible citizenship in a world characterized by change.

 College Grading Scale

Below 59F

(Some specialized programs may have different grading scales)


 Academic Dishonesty

Academic dishonesty in any form will not be tolerated.  Please consult the student handbook for consequences of academic dishonesty.  These policies will be strictly enforced.


 Facility  Policies

        No food, drinks, or tobacco products are allowed in the classroom.

        Only students enrolled in the course are allowed in the classroom.

        Cell phones and/or pagers are allowed ONLY on vibrate mode. Leaving the classroom to answer a page or phone call may constitute an absence or a tardy.


 Special Considerations

         The American with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Special Populations Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.

Copyright ©2010 Lamar State College - Port Arthur. All Rights Reserved.