Urban Campus

Syllabus CIS 303

Intro to Databases

SEMESTER: Spring 2009 Changed 01/06/09

Instructor Information

Name

Kenneth Lambert

E-mail address

knlambert@dmacc.edu

Phone number

515-248-7230

Fax number

515-248-7253

Office location

U1-243

Office hours

See door schedule

Course Information

Course title

Intro to Databases

Course number

CIS 303

Credits

Section number

WB1

CRN number

20624

Days & Time

Mon Wed 12:20 – 1:15pm

Location

U1-234

Course description

In this course, you will learn the most important topics of Microsoft Office Access 2007.

Prerequisites

CSC 110 or CIS 125 or CIS 402

Course competencies

CIS 303 Course Competencies

Important Dates

Midterm

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

Final

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

Textbooks & Materials

Required textbooks

Lisa Friedrichsen, Microsoft Office® Access 2007 - Illustrated Complete, Course Technology. ISBN: 1-4239-0519-9

ISBN-13: 978-1-4239-0519-6

Student downloads at:

Text website

Required materials

Student downloads at:

Student Downloads

Software applications

Microsoft Office 2007

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 Des Moines Area Community College.

Course Policies

Attendance

It is STRONGLY suggested that you spend the required class hours per week in the classroom or working on your own. 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. Unit homework is due before the unit exams.

Grading criteria

Each student is expected to be honest in their 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, and the student who helped them, is subject to disciplinary action at the discretion of the instructor up to and including an F for the course.

List of projects in the course		TOTAL POSSIBLE POINTS
Projects	Unit A	16
	Unit B	16
	Unit C	16
	Unit D	16
	Unit E	16
	Unit F	16
	Unit G	16
	Unit H	16
	Unit I	16
	Unit J	16
	Unit K	16
	Unit L	16
	Unit M	16
	Unit N	16
	Unit O	16
	Unit P	16
TOTAL:		256
Exams
3@ 100 points each		300

Class Participation		34

TOTAL:		600

Your grade: (Total points you earned * 100) / 600, truncated

Grading scale is:

91 – 100 = A

81 - 90 = B

71 – 80 = C

61 – 70 = D

<= 60 = F

Your homework/work (turned into the instructor with a cover sheet if on paper) should return to you, graded, in no more than two class sessions after you turn it in.

The instructor will post your grade from the cover sheet in his electronic grade book.

You must keep all your work for the course as you will be expected to give the instructor your original work if a grade has been recorded incorrectly for your assignment(s). If you cannot show the original work, then the instructor’s recorded grade will prevail.

All projects and assignments are due at the beginning of class on the EXAM due. Late submission of assignments will not be accepted. No exceptions.

Classroom conduct

1. Attend class regularly. It is STRONGLY suggested that you spend the required two hours per week in the classroom or working on your own. 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.

2. 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.

3. 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, and the student who helped them, is subject to disciplinary action at the discretion of the instructor.

4. 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.

5. 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.

7. 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.

Refer to the DMACC Student Handbook:

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

Missed exams

Except for extreme emergencies, you must take 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 lecture. Up to three hours per credit per week study will be expected outside of the class hours.

Academic dishonesty

Refer to the DMACC Student Handbook:

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

Weather policy

Individual circumstances such as health, childcare, rural roads, distance from the College, etc. can vary greatly among students and staff. It is always DMACC’s goal to provide safe learning conditions, as well as provide the opportunity for students to attend classes when the vast majority is able to safely attend. The final decision to come to College can only be made by the individual student based on their specific extenuating circumstances that may make it unsafe for them to travel. During adverse weather, DMACC faculty is considerate of students who are unable to attend classes due to unique extenuating circumstances. It is the responsibility of each faculty member to notify their students (in addition to their dean or provost) through some predetermined means if they are must postpone or cancel a specific class due to weather or illness.

Please check our class schedule often as it is where your weather changes will appear.

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.asp

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.

Nondiscrimination Policy

Des Moines Area Community College shall not engage in or allow discrimination covered by law. This includes harassment based on race, color, national origin, creed, religion, gender, sexual orientation, age, and disability. Veteran status in educational programs, activities, employment practices, or admission procedures is also included to the extent covered by law. Individuals who believe they have been discriminated against may file a complaint through the College Discrimination Complaint Procedures. Complaint forms may be obtained from the DMACC Web site, the Ombudsperson, Judicial Officer, Human Resources Department, the campus Provost's Offices, and Academic Deans’ Offices.

Students who wish additional information or assistance may contact the Executive Dean, Student Services, Laurie Wolf, Building 1, 515-964-6437 or the EEO/AA Officer, Dr. Sandy Tryon, Human Resources, Bldg. 1, 515-964-6301 or they may refer to Student Services procedure 4645 located on the DMACC Intranet at http://my.dmacc.edu/procs.aspx. Go to Policies & Procedures and choose Student Services Procedures. Employees and applicants who wish additional information or assistance may contact the EEO/AA Officer, Dr. Sandy Tryon, Human Resources, Bldg. 1, 515-964-6301 or refer to HR Procedures 3000, 3005, 3010, 3015, and 3020 at http://www.dmacc.edu/hr/hrpp.asp .

For requests for accommodations, the Accommodation/Section 504/ADA Coordinator, Sharon Bittner, can be contacted at 515-964-6857. Students with requests for accommodations should refer to the Student Services procedure 4610 located on the DMACC Intranet at http://my.dmacc.edu/default.aspx . Go to Policies & Procedures and choose Student Services Procedures.

Course Schedule:

CIS 303 class schedule