Download PDF Version

Course Name, Prefix, Number: Database Management, CPTR 1310

Campus Name and Address

Central Louisiana Technical College

Credit Hours:

3

Lecture Hours:

2

Lab Hours:

1

Contact Hours:

60

Instructor:

Stephanie Gaspard

Instructor Information:

stephaniegaspard@cltcc.edu (318) 876-2401 EX: 6121

Course Description

This course covers basic methods for creating a database, adding, changing and deleting information in a database, printing data in the form of reports, and the printing of address labels. (2/1/3)

Required Textbooks

Shelly Cashman Series® Microsoft® Office 365 & Access 2016 with SAM: Comprehensive, 1st

Edition Philip J. Pratt; Mary Z. Last

ISBN: 9781305870635

© 2017

 

Cengage Unlimited allows learners to access all course materials except Microsoft Access 2016. Microsoft Access 2016 is required

Additional Materials/Resources

CANVAS: Grades, assignments, messages, and other information pertaining to this class are posted on Canvas. Please login to Canvas and enter a current email address. Students are responsible for checking Canvas Announcements and email accounts on a daily basis .

Grading Criteria

A         90-100                       

B         80-89             

C         70-79             

D         60-69             

F          59-Below

Grading Scale

100-90 
89-80 
79-70 
69-60  
59-below 

Assessments

This class uses the 10-point grading scale.

 

Exams 40%

Training 30%

Projects 30%

 

Training, exams and projects are completed and submitted in SAM. SAM is the homework management system used in this class. Please see your Canvas course for a more complete explanation. All course work must be completed by 11:59PM on December 6, 2020. Any work submitted or completed after this date and time will NOT be considered in the calculation of final grades.

Section

Z01

Term

Fall

Course Outline

Week Module Due Date
1 1: Databases and Database Objects: An Introduction  
2 2: Querying a Database  
3 3: Maintaining a Database  
4 Capstone Project (Exam)  
5 4: Creating Reports and Forms  
6 5: Multiple-Table Forms  
7 6: Advanced Report Techniques  
8 7: Advanced Form Techniques  
9 Capstone Project (Exam)  
10 & 11 8:Macros, Navigation Forms, and Control Layouts  
12 9: Administering a Database System  
13 & 14 10: Using SQL  
15 Capstone Project (Final Exam)  

 

ATTENDANCE

Students must be officially enrolled in any course that they attend. It is expected that students will attend scheduled classes regularly and on time. If an absence occurs, it is the responsibility of the student to make up all missed work, if approved by the instructor. Students who stop attending a course and do not officially withdraw will receive grades of “0” for all work missed and will result in a punitive final grade. This policy shall be superseded by any more stringent attendance policy required by a regulatory or licensing body having jurisdiction over program requirements. Attendance will be tracked and maintained for various reporting purposes.

CLASS WITHDRAWAL POLICY

The deadline for dropping a class is published each semester on the CLTCC website in the academic calendar. A student who officially withdraws from a class prior to the designated date will receive a grade of “W” in that class. Any student who receives financial aid and withdraws from any or all classes is subject to repaying a portion of the funding received.

ACADEMIC HONESTY

The faculty of Central Louisiana Technical College supports the concept of academic honesty. The teaching faculty encourages academic honesty in all classes and we require academic honesty from all students. All students are expected to maintain honesty and integrity when completing all academic assignments and examinations. Plagiarism, cheating, and other forms of academic dishonesty will not be tolerated. Any student found guilty of such dishonorable acts in academic work will receive a “0” for the work presented. The instructor may also refer the student to the appropriate administrator for further disciplinary actions, which could result in an “F” in the course, dismissal from the course, or dismissal from the college.

STUDENT CODE OF CONDUCT

Students will be suspended for actions detrimental to the welfare of other students, instructors, staff, and the campus. These actions include, but are not limited to: Firearms and/or weapons, alcoholic beverages, and illegal drugs will not be permitted on campus. Profanity and fighting are strictly prohibited. Smoking or use of any other tobacco products is prohibited. Students must not eat or drink beverages in classrooms or labs. Vandalism will not be permitted on campus. Dishonesty will not be tolerated under any circumstances. Students who cheat, or aid in the act thereof, may be dismissed from campus. Students must display a respectable attitude and behavior toward instructor and other students. The college has a Zero Tolerance Policy, meaning the campuses should be completely free of threats and assaults to ensure the highest standard of safety for all faculty, staff, students, and visitors on each campus. The college will take all reasonably available steps to protect all such persons from violence. Violators of the Zero Tolerance Policy will be suspended.

 

Title IX

Central Louisiana Technical Community College faculty and staff are committed to helping create a safe and open learning environment for all students. If you (or someone you know) have experienced any form of sexual misconduct, including sexual assault, dating or domestic violence, or stalking, know that help and support are available. The College strongly encourages all community members to act, seek support, and report incidents of sexual misconduct to the Title IX Office. Be advised that we must disclose information about misconduct as per Title IX of the Education Amendments of 1972.

If you wish to speak to a confidential employee who does not have this reporting responsibility, you can contact the Title IX Coordinator for Students at 318-487-5443 ext. 1129. If it is an ADA issue, you can contact CLTCC's ADA Coordinator for Students at 318-487-5443 ext. For more information about reporting options and resources at CLTCC and the community, visit our Title IX page. Please complete the following Incident Report by clicking here to report the incident. Under "Nature of this Report," choose Title IX or Disability Service Request regarding a Reasonable Accommodations issue.

DISCIPLINARY PROBATION

A student may be placed on disciplinary probation when campus rules and policies are disregarded. When a student is placed on disciplinary probation, the student is given a specified time to improve his/her record. If the student’s record does not show improvement, the student may be suspended for a specific time, usually a semester or more.

STUDENTS WITH DISABILITIES

The Central Louisiana Technical College complies with Section 504 and the Americans with Disabilities Act. Students with disabilities who seek accommodations must make their requests known by contacting the Disabilities Coordinator at the beginning of each semester. If a disability is identified later in the semester, a non-retroactive accommodation plan will be developed.

Course Transferability

A student should contact the institution to which he or she intends to transfer to inquire about the potential transferability of the course and to determine whether the course will count in his or her major.

Instructor Credentials

All instructors for this course meet or exceed the criteria for academic and professional preparation as required in the SACS/COC standards for accreditation.