Urban Campus http://www.dmacc.edu		Syllabus CIS332 Introduction to SQL
SEMESTER: Fall 2008
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 or web site
Course Information
Course title	Introduction to Structured Query Language
Course number	CIS332		Credits	3
Section number			CRN number	12086
Days & Time	Thurs 5:00 – 7:00pm		Location	U1-234
Course description	College CIS332 Course Description
Prerequisites	CIS303
Course competencies	CIS332 competencies
Important Dates
Midterm	http://www.dmacc.edu/academiccal.asp
Final	http://www.dmacc.edu/academiccal.asp
Textbooks & Materials
Required textbooks	“A Guide to MySQL”; PJ Pratt and MZ Last, ISBN: 1-4188-3635-4
Required materials	Flashdrive
Software applications	MySQL and email
Software notice	MySQL is “open source software”, you may download and use freely without violating any copyright laws.
Course Policies
Attendance	It is STRONGLY suggested that you spend the required four 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.
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. Scripts will be evaluated on the basis of one grading unit for documentation of the script, one grading unit for the professionalism of the code, and one grading unit if the script executes according to the requirements of the question. EVALUATION: 70 percent = Test(s)/Quiz(s) during the semester 20 percent = Scripts (Labs) 10 percent = class participation Truncating will be applied. Grading scale is: 91 – 100 = A 81 – 90 = B 71 – 80 = C 61 – 70 = 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 posted 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, and any student who assisted them, is subject to disciplinary action at the discretion of the instructor up to and including an F for the course. Each assignment will receive a zero grade where the instructor finds a violation of academic honesty for both the students whose work is the same. If it involves copied work, then all similar submissions will receive a zero grade on the assignment. 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 in 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. You are expected to research the terms presented in the course on the internet. MySQL has many sites you can visit for help and information.
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:

CIS332 class schedule