Databases Syllabus for 2016-2017
Return to Syllabus List

Instructor Information

Course Information

Recording Policy

Disability Statement

If you have a disability (learning, mental, physical) that affects your ability to participate effectively and have access to any program or service at Amarillo College please contact Disability Services at (806) 345-5639 . Our offices are located in the Student Service Center office 112. More information may be found at www.actx.edu/disability.
Disability Services facilitates access to all programs and services according to the ADA, Americans with Disabilities Act and Section 504 of the Rehabilitation Act, as well as other federal and state laws.

Amarillo College Web Accessibility Policy Statement

Amarillo College is committed to providing equal access to all programs and services, including all working, learning, and service environments that affect equal access for persons with disabilities. This commitment to provide equal access and opportunity for persons with disabilities is in compliance with federal and state law. Amarillo College also strives to provide Electronic and Information Resources (EIR) that are accessible to all authorized users.

If you find you are unable to access material in an accessible format please contact the Disability Services Office at (806) 345-5639 . This office will work in conjunction with other campus resources to address and accommodate your issue in a timely manner.

Statement for Mental Health and Advocacy & Resource Center:

As a student you may experience a range of issues that can cause barriers to learning, such as strained relationships, increased anxiety, alcohol/drug problems, feeling down, difficulty concentrating and/or lack of motivation. These mental health concerns or stressful events may lead to diminished academic performance or reduce a student's ability to participate in daily activities. Amarillo College offers services to assist you with addressing these and other concerns you may be experiencing. If you or someone you know are suffering from any of the aforementioned conditions, you can learn more about the broad range of confidential mental health services available on campus by calling the AC Counseling Center at 806-371-5900. The AC Counseling Center website is https://www.actx.edu/counseling/ . Also, if you are in need of social services (affordable housing, utilities, transportation, food, clothing, childcare, medical/dental/vision, legal), please call the AC Advocacy & Resource Center at 806-371-5439. The AC Advocacy & Resource Center website is https://www.actx.edu/arc

Amarillo College Tutoring for Success Policy:

Administrative Drop Policy

Students who do not attend class on or prior to the census date will be administratively dropped. Effective Fall, 2016

Student Withdrawal Procedures

Students who wish to withdraw from a class must:

• consult with their instructor to obtain a signed academic withdrawal request form to submit to the AskAC department for processing
• consult with the financial aid office if receiving financial aid
• consult with the Veterans Benefit Coordinator if receiving veteran benefits
• consult with their academic advisor to determine how withdrawing may affect their enrollment in future semesters
  • NOTE:  The Texas Education Code stipulates that students attending Texas institutions of higher education for the first time fall 2007 and later may not withdraw from more than six courses during their academic career, including courses from which transfer students have withdrawn at other Texas institutions of higher education. (Senate Bill 1231) Rule 4.10.

Privacy Statement

The Amarillo College Privacy Policy is found at https://www.actx.edu/-amarillo-college-privacy-notice , and applies to all Amarillo College students.  If you have questions about this privacy statement or you believe that your personal information has been released without your consent, send email to humanresources@actx.edu .

Course

POFI-2350-001 Databases

Prerequisites

Prerequisite: BCIS 1305

Course Description

In-depth instruction of database theory and the practical applications of a database. This course is designed to be repeated multiple times to improve student proficiency.

Student Resources Student Resources Website

Department Expectations

Occupational License Disclaimer

Hours

(3 sem hrs; 2 lec, 4 lab)

Class Type

Hybrid

Syllabus Information

Textbooks

Exploring: Microsoft Access 2013, Introductory
by Mary Anne Poatsy, Cynthia Krebs, Eric Cameron, Robert T. Grauer
Publisher: Pearson
ISBN -13: 9780133412192

Supplies

1. A USB flash drive, 4GB or higher
2. Access to a PC/laptop running the Windows Operating System (Windows 7, 8 or 10)
3. Microsoft Access 2013. Software is available on computers in the CIS computer Lab. If you are running the 2016 version of Microsoft Office, that version will work for this course. Realize, however, that the training, textbook, and projects are all geared toward Access 2013.
4. Reliable access to the Internet. Internet access is available in the CIS computer labs

Student Performance

At the end of this course, students will learn

1. Understand Database Fundamentals
2. Understand Relational Databases and the difference between Access & Excel
3. Table Design, Creation & Modification
4. Entering data into the Database
5. Determine the Data types used for various fields in a table
6. Create Queries to pull relevant and useful information from the database.
7. Create Reports for presenting information in a professional setting.

In addition to learning how to use Microsoft Access 2013, we will be looking at online databases such as Research databases, legal database, etc. and how to find and pull information from these databases.

The main focus of this course is to understand how a database works and to be comfortable enough to manage and extract information from the database.

Students Rights and Responsibilities

Log in using the AC Connect Portal

In order to receive your AC Connect Email, you must log in through AC Connect at https://acconnect.actx.edu .

If you are an active staff or faculty member according to Human Resources, use "Exchange". All other students, use "AC Connect (Google) Email".

Expected Student Behavior

Students are expected to maintain a high standard of individual honor in their scholastic work. Students who are guilty of cheating, plagiarism, copying, or dishonesty may receive a 0 on an assignment; may be excluded from class with a grade of F; or, in flagrant cases, may be suspended from the College.

Students should be prepared to put in  time at home working on the Assignment. Students should expect to put in atleast 5 hours work per week at home/lab

The Faculty of the Office Administration Program reserve the right to ask a student to verify any portion of a test or assignment by reproducing any specific section or the entire test/assignment in question. Any action that compromises the computer systems at Amarillo College, including but not limited to hacking or cracking, can result in a grade of "F" in this course and possible further disciplinary action.

Grading Criteria

Course grades will be assigned based upon the following criteria:

• >89.5 = A
• >79.5 = B
• >69.5 = C
• >59.5 = D
• <59.5 = F

Student evaluation is based upon the following criteria and weights:

• Attendance – 10%
• Chapter Quiz – 10%
• Hands-On Exercise – 15%
• Practice Exercises – 10%
• Grader Projects – 20%
• Mid-term Exam – 15%
• Final Exam – 20%

Attendance

Calendar

Additional Information

No additional information available