Syllabus
Database Programming: Oracle

Database Programming: Oracle

ITSE-2309

Credit Summer 2020
06/01/2020 - 08/02/2020

Course Information

Section 004
Distance Learning
ONL DIL
David Trevino

Office Hours

  • M T W Th
    NULL - NULL
    HLC Bldg 4000 4.2310.13
    By Appointment only due to COVID-19

Course description / rational

Course Description: 

            Credit Hours: 3

            Classroom Contact Hours per week: 3

            Laboratory Contact Hours per week: 3

Applications development using database programming techniques emphasizing database structures, modeling, and database access. This course instructs the student in the essential concepts and design methodology for the Relational Database Model as implemented by Oracle. Other topics include: the Data Definition Language, the Data Manipulation Language, database normalization, transaction processing, security, multi-user problems and solutions.  

Transferability of workforce courses varies. Students interested in transferring courses to another college should speak with their Area of Study (AoS) advisor, Department Chair, and/or Program Director.

 

Course Rationale:  This course is designed as a survey course to teach students to design, implement, and maintain databases. The Relational Database Model and the SQL language will be emphasized. On-line Transaction Processing Systems will be studied and contrasted with Distributed Database Management Systems and Data Warehousing Systems. Web databases will be introduced. The Oracle DBMS will be used throughout the course in Lectures and in labs.

This course is part of the Computer Information Technology Database Certificate plan. Completion of this course provides the student with the initial knowledge required in preparation for consideration as an entry level database programmer, and acts as preparation for Oracle Certification test .

 

Pre-requisite:  COSC1315 Fundamentals of Programming,  COSC1336  Programming Fundamentals  or department approval.

 

 

Student Learning Outcomes/Learning Objectives

Course Objectives/ Learning Outcomes:

 Establish a basic understanding of the analysis and design of a database.
 Establish a basic understanding of the process of Database Development and  Administration using SQL.
 Enhance Programming and Software Engineering skills and techniques using SQL.
 Establish a basic understanding of background materials needed for technical  support using SQL.
Solve Database problems using Oracle11g Express with Oracle 12c SQL  by applying SQL commands to Create, Insert, Update, and Retrieve a  simple database.
Understand the services provided by a Database Management System.
Understand the use and application of the Relational Database Model.
Understand Transaction Processing and Multi-user Database support.
Understand the difference between a Production transaction database and a Data Warehouse.
Understand the Client/Server structures used in Database Management Systems.
Design and Implement a basic database using the Oracle Database Management

 

SCANS ITEMS COMPETENCIES:

CODE DESCRIPTION ITSE2309 LEVEL
F1     READING: Locates, understands, and interprets written information in prose and documents such as manuals, graphs, and schedules 2
F3     ARITHEMETIC: Performs basic computations; uses basic numerical concepts such as whole  numbers, etc. 2
F4     MATHEMATICS: Approaches practical problems by choosing appropriately from a variety of mathematical techniques. 2
F5     LISTENING: Receives, Attends to, interprets, and responds to verbal messages and other cues. 2
F9     PROBLEM SOLVING: Recognizes problems and devises and implements plan of action 2
F10  SEEING THINGS IN THE MINDS EYE: Organizes and processes symbols, pictures, graphs, objects, and other information. 2
F12  REASONING: Discovers a rule or principle underlying the relationship between two or more objects and applies it when 2
C1   TIME: Selects goal relevant activities, ranks them, allocates time, and prepares and follows schedules.  2
C5   Acquires and evaluates information 2
C6   Organizes and maintains information 2
C7   Interprets and communicates information  2
C8   Uses computers to process information 2

Readings

Approved Course Text:  Set by taskforce

Database Systems Design, Implementation, and Management – 121th Edition By
Coronel/Morris – Thompson/Course Technology

            ISBN 978-1-305-62748-2

Oracle 12c: SQL Set by taskforce

Author:          Joan Casteel

Edition:          3nd  

Publisher:       Cengage

ISBN:             978-1-305-25103-8

Course Requirements

Grading System:   Grade will be based both on concepts and practical application.

Grade Scale:
           
90%  - 100%         A

            80%  -  89%          B

            70%  -  79%          C

            60%  -  69%          D

            0%    -  59%          F

Assignment composition

ORIENTATION QUIZ-- Due first three days of course

                1ea.   Orientation Quiz                                                                       =   10 Points

Lecture text book

                16ea.    End of Chapter  quizzes 10 points each                            =                    150   Points

                16ea.    Chapter  Key Terms 4.69 points each                                               =     75  Points

3ea.      Major Exams 125 point each                                                            =    375   Points

Lab text book

                12ea.   End of Chapter  quizzes  (7.5 points each)                                        =    90  Points

                3ea.   Laboratory Assignment           (100 points ea.)                                    =    300  Points

                                                                                                                              1000 total possible points

Note:1) ALL COURSE WORK IS SUBMITTED/CONDUCTED IN BLACKBOARD

         2)    Allow an average of 15 hours per assignment

         3.     Multiple attempts on submittals will be averaged (max of three attempts)

         4)     Please be aware of the grading system which is using a weighted average method, as

                 such, --  for example – a grade of 80 on a lab quiz would be 80% of  7.5 points or 6

                 points

           5)    The format of exams multiple choice, short answer, essay, matching, combination.
     
           6)   Submissions/Assignments/Exams/Quizzes must be in the students own words  --Any

                  Copy/pasting from any source -- such as from text -- end of text glossary terms—

                  Definitions etc.--could be considered   plagiarism – the idea is for the student to use

                  his/her own words

              7)  Assignments/quizzes/Labs  submitted 7 days after due date will be assessed a

                   20%  penalty

Examinations for Distant Learning Courses- requires an ACC Testing Center

Three (3) major examinations will be assessed (see course schedule)

  1.    Examinations are taken at an ACC Testing center or COVID-19 accapeable testing site.
  2.    Any changes to course schedule will announced by e-mail via the official student 
       ACC   E-mail address.
  1.   Students will be allowed to bring 1 page (both sides) of notes and a calculator to
       the exams.

 

If an Exam is missed, you will have made arrangements with the Instructor in advance  and have 1 week to take the make up Exam at the Test Center.

Taking the make up Exam is subject to Instructor approval.

If you fail to take the make up Exam in the 1 week period, a Zero will be assigned. 

 

Laboratory/Homework Assignments:  Assignments will be submitted using Blackboard

            There will be three (3) Lab assignments. (see course schedule )

           

You may either download Oracle 11g Express Edition and build a remote location  database  or may choose to visit/ use the  computer  science laboratory facilities which are available at various Austin Community College Campuses

 

The combined 27 lecture and lab based  quizzes are due no less than two weeks from the date assigned unless other arrangements have been made with Instructor.

 

 

course / class policies

For in-classroom courses:

Regular and punctual class and laboratory attendance is expected of all students.  If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class.

 

For  online courses:

Regular and timely use of Blackboard participation in discussions and completion of work is expected of all students.  If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class.

 

In the event the college or campus closes due to unforeseen circumstances (for example, severe weather or other emergency), the student is responsible for communicating with their professor during the closure and completing any assignments or other activities designated by their professor as a result of class sessions being missed.

Withdrawal Policy

The College defines withdrawals as occurring after the official reporting date of the semester, typically the 12th class day.  In addition, the Legislature has mandated the Rule of Six (see below).  There may also be financial aid issues.

It is the responsibility of each student to ensure that his or her name is removed from the rolls should they decide to withdraw from the class.  The instructor does, however, reserve the right to drop a student should he or she feel it is necessary.  If a student decides to withdraw, he or she should also verify that the withdrawal is recorded before the Final Withdrawal Date.  The Final Withdrawal Date for this semester is [insert date here].  The student is also strongly encouraged to keep any paperwork in case a problem arises.

 

Students are responsible for understanding the impact that withdrawal from a course may have on their financial aid, veterans’ benefits, and international student status.  Per state law, students enrolling for the first time in Fall 2007 or later at any public Texas college or university may not withdraw (receive a W) from more than six courses during their undergraduate college education. Some exemptions for good cause could allow a student to withdraw from a course without having it count toward this limit. Students are strongly encouraged to meet with an advisor when making decisions about course selection, course loads, and course withdrawals.

Incomplete:

A student may receive a temporary grade of “I” (Incomplete) at the end of the semester only if     

                              ALL of the following conditions are satisfied:

  1. The student is unable to complete the course during the semester due to circumstances beyond their control.
  2. The student must have earned at least half of the grade points needed for a “C” by the end of the semester.
  3. The request for the grade must be made in person at the instructor’s office and necessary documents completed.
  4. To remove an “I”, the student must complete the course by two weeks before the end of the following semester.  Failure to do so will result in the grade automatically reverting to an “F”.

 

 

Course Subjects

  ITSE 2309 Standard Semester Sequence Schedule Lab work and Lecture materials
are to be worked on concurrently
  Note: Last day to submit any item this semester will be July 31st 5pm --
** Ability to Submit will be disabled at 5pm **
  Competency Topic Lecture Reading Lab Reading  Activity Assessment No later due dates 9 week Session
 
  Competency 1 Competency 1 Introduction to Structured Query Language (SQL) Lecture -text Chapter 7  Casteel Oracle 11g  Note:  The Casteel lab text  has          6 Practices
 by Feb 17th
Lab 1 Lab 1 No later than
   June 5th
  Ch 2, 3, 4, 5, 6 (Submit on Blackboard)
                 
  Competency 2 Competency 2.1  Database System Lecture  text  Chapter 1   Note:  There are Five quizzes in this lecture section
 
Exam 1 No later than
   June 11th
  Competency 2.2  Data Models Lecture text  Chapter 2  
  Competency 2.3 The Relational Database Model Lecture  text  Chapter 3 Lecture  text Chapters 1,2,3,4,6
  Competency 2.4 Entity Relationship Modeling (ERD) Lecture text  Chapter 4  
  Competency 2.5 Normalization of Database Tables  Lecture text  Chapter 6 (Taken in testing center)
                 
                 
  ITSE 2309 Standard Semester Sequence Schedule Lab work and Lecture materials
are to be worked on concurrently
                 
  Competency Topic Lecture Reading Lab Reading  Activity Assessment No later due dates 9 wk Session
 
  Competency 3 Competency 3 More SQL Queries and Modification Commands   Casteel Oracle 11g  Note:  The Casteel Lab text  has      7 Practices Lab 2  No  later than
    July 10th
  Ch 7, 8, 9, 10, 11, 12,13  (Submit on Blackboard)
                 
  Competency 4 Competency 4.1 Advanced Data Modeling Lecture  text Chapter 5   Note:  There are  four quizzes in this lecture section
 
Exam 2 No later than
July 10th
    Review  of  SQL chapter  Lecture text  Chapter 7    
  Competency 4.2 Advanced SQL Lecture  text  Chapter 8   Chapters
  5,7,8,9,10
  Competency 4.3 Database Design Lecture  text  Chapter 9    
  Competency 4.4 Transaction Management and Concurrency Control Lecture text  Chapter 10   (Taken in  a testing center)
               
                 
  ITSE 2309 Standard Semester Sequence Schedule Lab work and Lecture materials
are to be worked on concurrently
                 
  Competency Topic Lecture Reading Lab Reading  Activity Assessment No later due dates 9 week Session
 
  Competency 5 Competency 5 Normalization and Creating Tables Review  Lecture  text Chapter 6      Lab 3 No later than
  July 31st
  (Submit on Blackboard)
                 
  Competency 6 Competency 6.1 Database Performance Tuning and Query Optimization Lecture  text Chapter 11   Note:  The lecture text  has
  5  quizzes
Exam 3 No later than  
  July 31st
  Competency 6.2 Distributed Database Management Systems Lecture  text  Chapter 12  
  Competency 6.3 Business Intelligence and Data Warehouses Lecture text Chapter 13 Chapters 11,12,13,14,15
  Competency 6.4 Database Connectivity and Web Technologies Lecture  text  Chapter 14  
  Competency 6.5 Database Administration and Security Lecture  text  Chapter 15 (Taken in   a testing center)
                 
  Note: Last day to submit any item this semester will be July 31st 5pm --
** Ability to Submit will be disabled at 5pm **

 

COLLEGE POLICIES

Statement on Academic Integrity

Austin Community College values academic integrity in the educational process.  Acts of academic dishonesty/misconduct undermine the learning process, present a disadvantage to students who earn credit honestly, and subvert the academic mission of the institution. The potential consequences of fraudulent credentials raise additional concerns for individuals and communities beyond campus who rely on institutions of higher learning to certify students' academic achievements, and expect to benefit from the claimed knowledge and skills of their graduates. Students must follow all instructions given by faculty or designated college representatives when taking examinations, placement assessments, tests, quizzes, and evaluations.  Actions constituting scholastic dishonesty include, but are not limited to, plagiarism, cheating, fabrication, collusion, falsifying documents, or the inappropriate use of the college’s information technology resources.  Further information is available at https://www.austincc.edu/about-acc/academic-integrity-and-disciplinary-process

Student Rights & Responsibilities

Academic freedom is a foundation and hallmark of higher education.  In the context of college-level courses, it specifically refers to the rights of free expression and respect for others with differing opinions.  Students at the college have the rights accorded by the U.S. Constitution to freedom of speech, peaceful assembly, petition, and association. This concept is accompanied by an equally demanding concept of responsibility on the part of the student.  Just as you are expected to exercise these rights with respect for state and federal law in the larger world, you are expected to exercise these rights as a student with respect for the college’s standards of conduct.  These rights carry with them the responsibility to accord the same rights to others in the college community and not to interfere with or disrupt the educational process.  Students and faculty alike should enable a climate of mutual respect and civility while fostering the freedom to debate and discuss the merits of competing ideas.

Enrollment in the college indicates acceptance of the rules set forth in the student standards of conduct policy, which is administered through the office of the campus dean of student services. Due process, through an investigation and appeal process, is assured to any student involved in disciplinary action.

Student Complaints

A defined process applies to complaints about an instructor or other college employee. You are encouraged to discuss concerns and complaints with college personnel and should expect a timely and appropriate response. When possible, students should first address their concerns through informal conferences with those immediately involved; formal due process is available when informal resolution cannot be achieved.

Student complaints may include (but are not limited to) issues regarding classroom instruction, college services and offices on the basis of actual or perceived race, color, national origin, religion, age, gender, gender identity, sexual orientation, political affiliation, or disability.

Further information about the complaints process, including the form used to submit complaints, is available at: http://www.austincc.edu/students/students-rights-and-responsibilities/student-complaint-procedures

Statement on Privacy

The Family Educational Rights and Privacy Act (FERPA) protects confidentiality of students’ educational records. Grades cannot be provided by faculty over the phone, by e-mail, or to a fellow student.

Grades are posted in Blackboard – also of note – a weighted average method is used

Safety Statement

Health and safety are of paramount importance in classrooms, laboratories, and field activities. Students are expected to learn and comply with ACC environmental, health and safety procedures and agree to follow ACC safety policies.  Emergency Procedures posters and Campus Safety Plans are posted in each classroom and should be reviewed at the beginning of each semester.  All incidents (injuries/illness/fire/property damage/near miss) should be immediately reported to the course instructor. Additional information about safety procedures and how to sign up to be notified in case of an emergency can be found at http://www.austincc.edu/emergency

 

Everyone is expected to conduct themselves professionally with respect and courtesy to all. Anyone who thoughtlessly or intentionally jeopardizes the health or safety of another individual may be immediately dismissed from the day’s activity and will be referred to the Dean of Student Services for disciplinary action.

 

In the event of disruption of normal classroom activities due to an emergency situation or an illness outbreak, the format for this course may be modified to enable completion of the course. In that event, students will be provided an addendum to the class syllabus that will supersede the original version.

Campus Carry

The Austin Community College District concealed handgun policy ensures compliance with Section 411.2031 of the Texas Government Code (also known as the Campus Carry Law), while maintaining ACC’s commitment to provide a safe environment for its students, faculty, staff, and visitors.  Beginning August 1, 2017, individuals who are licensed to carry (LTC) may do so on campus premises except in locations and at activities prohibited by state or federal law, or the college’s concealed handgun policy.  In addition, concealed weapons are not allowed on ACC-sponsored field trips where the school owns or has chartered or leased vehicles for transportation.

 It is the responsibility of license holders to conceal their handguns at all times.  Persons who see a handgun on campus are asked to contact the ACC Police Department by dialing 222 from a campus phone or 512-223-7999.   Please refer to the concealed handgun policy online at http://austincc.edu/campuscarry

Discrimination Prohibited

The College seeks to maintain an educational environment free from any form of discrimination or harassment including but not limited to discrimination or harassment on the basis of race, color, national origin, religion, age, sex, gender, sexual orientation, gender identity, or disability.

 

Faculty at the College are required to report concerns regarding sexual misconduct (including all forms of sexual harassment and sex and gender-based discrimination) to the Manager of Title IX/Title VI/ADA Compliance.  Licensed clinical counselors are available across the District and serve as confidential resources for students.

 

Additional information about Title VI, Title IX, and ADA compliance can be found in the ACC Compliance Resource Guide available at: https://drive.google.com/file/d/1o55xINAWNvTYgI-fs-JbDyuaMFDNvAjz/view

Use of ACC email

All College e-mail communication to students will be sent solely to the student’s ACCmail account, with the expectation that such communications will be read in a timely fashion. ACC will send important information and will notify students of any college- related emergencies using this account. Students should only expect to receive email communication from their instructor using this account.  Likewise, students should use their ACCmail account when communicating with instructors and staff.  Information about ACC email accounts, including instructions for accessing it, are available at:  http://www.austincc.edu/help/accmail/questions-and-answers

For- On-line Courses – Use of an ACC Testing Center

Under certain circumstances, examinations may have to be taken in a testing center. The ACC Testing Centers follow standard procedures so students know what to expect when they arrive to take their tests. Students should familiarize themselves with the student guidelines.

Students must present an ACC student ID card or government issued ID and know their ACC ID number before they can test.

It is necessary to check in at the Testing Center kiosk before taking a test. To check in, one must know the following information:

  • Student ID number
  • Course prefix and number
  • Course synonym
  • Course section number
  • Test number
  • Instructor’s name

 

Personal belongings such as backpacks, books, and electronic devices (including, but not limited to, cell phones and smart watches) are not allowed in the Testing Center. Possession of prohibited items or accessing unapproved resources in the testing room will result in the immediate termination of the exam and possible disciplinary action.

 

For additional information on using the Testing Center, please go to: http://www.austincc.edu/students/testing-services/instructional-testing

STUDENT SUPPORT SERVICES

The success of our students is paramount, and ACC offers a variety of support services to help, as well as providing numerous opportunities for community engagement and personal growth.

Student Support

ACC strives to provide exemplary support to its students and offers a broad variety of opportunities and services.  Information on these campus services and resources is available at  http://www.austincc.edu/students.

Student Accessibility Services

Students with documented disabilities who need classroom, academic, or other accommodations must request them through the office Student Accessibility Services (SAS).   SAS offices are located at each major campus.  Students are encouraged to request accommodations when they register for courses or at least three weeks before the start of the semester; otherwise, the provision of accommodations may be delayed.  Students who have received approval for accommodations from SAS for this course must provide the instructor with the document titled “Notice of Approved Accommodations” from SAS before accommodations will be provided. Accommodations will not be provided retroactively.  Arrangements by the instructor for academic accommodations can only be made after he or she receives the “Notice of Approved Accommodations” from the student.

 

Additional information about Student Accessibility Services is available at https://www.austincc.edu/offices/student-accessibility-services-and-assistive-technology

Academic Support

ACC offers academic support services on all of its campuses. These services, which include face-to-face and online tutoring, academic coaching, and supplemental instruction, are free to enrolled ACC students. Tutors are available in a variety of subjects ranging from accounting to pharmacology. Students may receive these services on both a drop-in and referral basis. Tutoring schedules can be found at:  https://www.austincc.edu/students/tutoring/tutoring-schedules

Library Services

ACC has a full-service library at each of its campuses to support ACC courses and programs and to provide students with research and assignment assistance from expert faculty librarians, computers, course reserves, laptop and tablet check out, study spaces, and copying, printing, and scanning services.  In addition, ACC students have full rights and privileges to access Library Services online 24/7 via the ACC Library website and students can use their ACCeID logins to access all online materials, including ebooks, articles from library databases, and streaming videos.   ACC Libraries also provide an “Ask a Librarian” service, which allows  students to reach a librarian 24/7 through online chat.  Faculty librarians are also available via email, phone, and in person seven days a week during hours of operation. Visit:

In partnership with ACC’s Student Support Center, ACC Libraries also maintain a limited collection of textbooks for students to borrow. Priority access to the textbook collection is given to students receiving assistance. More information is available on the ACC website by searching “Student Support Center Textbook Collection.”

Student Organizations

ACC has over seventy student organizations, offering a variety of cultural, academic, vocational, and social opportunities.  They provide a chance to meet with other students who have the same interests, engage in service-learning, participate in intramural sports, gain valuable field experience related to career goals, and much else.  Student Life coordinates many of these activities, and additional information is available at http://sites.austincc.edu/sl/.

Personal Support

Resources to support students are available at every campus. To learn more, ask your professor or visit the campus Support Center. All resources and services are free and confidential. Some examples include, among others:

 

 

Clinical Counseling services are available throughout the ACC Student Services District to address personal and or mental health concerns: http://www.austincc.edu/students/counseling .

If an emergency occurs during operational hours, please come to the Student Services Office and let the front intake staff know that you are experiencing a crisis. They will alert appropriate personnel. You may also contact the ACC District Police at 222 (on campus) or 223-7999 (off campus or cell phone).

After Hours:

If you are struggling with a mental health or personal crisis, call one of the following numbers to connect with resources for help. However if you are afraid that you might hurt yourself or someone else, call 911 immediately.

Free Crisis Hotline Numbers:

  • Austin / Travis County 24 hour Crisis & Suicide hotline: 512-472-HELP (4357)
  • The Williamson County 24 hour Crisis hotline: 1-800-841-1255
  • Bastrop County Family Crisis Center hotline: 1-888-311-7755
  • Hays County 24 Hour Crisis Hotline: 1-877-466-0660
  • National Suicide Prevention Lifeline: 1-800-273-TALK (8255)
  • Crisis Text Line: Text “home” to 741741
    • Substance Abuse and Mental Health Services Administration (SAMHSA) National Helpline:   1-800-662-HELP (4357)
  • National Alliance on Mental Illness (NAMI) Helpline:1-800-950-NAMI (6264)

Some faculty may consider adding a student sign-off page at the end of the syllabus to be removed and handed back to the instructor providing evidence that the student received a copy of the syllabus and had an opportunity to ask questions, but such a page is optional.  

 

 

 

COLLEGE POLICIES

Statement on Academic Integrity

Austin Community College values academic integrity in the educational process.  Acts of academic dishonesty/misconduct undermine the learning process, present a disadvantage to students who earn credit honestly, and subvert the academic mission of the institution. The potential consequences of fraudulent credentials raise additional concerns for individuals and communities beyond campus who rely on institutions of higher learning to certify students' academic achievements, and expect to benefit from the claimed knowledge and skills of their graduates. Students must follow all instructions given by faculty or designated college representatives when taking examinations, placement assessments, tests, quizzes, and evaluations.  Actions constituting scholastic dishonesty include, but are not limited to, plagiarism, cheating, fabrication, collusion, falsifying documents, or the inappropriate use of the college’s information technology resources.  Further information is available at https://www.austincc.edu/about-acc/academic-integrity-and-disciplinary-process

Student Rights & Responsibilities

Academic freedom is a foundation and hallmark of higher education.  In the context of college-level courses, it specifically refers to the rights of free expression and respect for others with differing opinions.  Students at the college have the rights accorded by the U.S. Constitution to freedom of speech, peaceful assembly, petition, and association. This concept is accompanied by an equally demanding concept of responsibility on the part of the student.  Just as you are expected to exercise these rights with respect for state and federal law in the larger world, you are expected to exercise these rights as a student with respect for the college’s standards of conduct.  These rights carry with them the responsibility to accord the same rights to others in the college community and not to interfere with or disrupt the educational process.  Students and faculty alike should enable a climate of mutual respect and civility while fostering the freedom to debate and discuss the merits of competing ideas.

Enrollment in the college indicates acceptance of the rules set forth in the student standards of conduct policy, which is administered through the office of the campus dean of student services. Due process, through an investigation and appeal process, is assured to any student involved in disciplinary action.

Student Complaints

A defined process applies to complaints about an instructor or other college employee. You are encouraged to discuss concerns and complaints with college personnel and should expect a timely and appropriate response. When possible, students should first address their concerns through informal conferences with those immediately involved; formal due process is available when informal resolution cannot be achieved.

Student complaints may include (but are not limited to) issues regarding classroom instruction, college services and offices on the basis of actual or perceived race, color, national origin, religion, age, gender, gender identity, sexual orientation, political affiliation, or disability.

Further information about the complaints process, including the form used to submit complaints, is available at: http://www.austincc.edu/students/students-rights-and-responsibilities/student-complaint-procedures

Statement on Privacy

The Family Educational Rights and Privacy Act (FERPA) protects confidentiality of students’ educational records. Grades cannot be provided by faculty over the phone, by e-mail, or to a fellow student.

Grades are posted in Blackboard – also of note – a weighted average method is used

Safety Statement

Health and safety are of paramount importance in classrooms, laboratories, and field activities. Students are expected to learn and comply with ACC environmental, health and safety procedures and agree to follow ACC safety policies.  Emergency Procedures posters and Campus Safety Plans are posted in each classroom and should be reviewed at the beginning of each semester.  All incidents (injuries/illness/fire/property damage/near miss) should be immediately reported to the course instructor. Additional information about safety procedures and how to sign up to be notified in case of an emergency can be found at http://www.austincc.edu/emergency

 

Everyone is expected to conduct themselves professionally with respect and courtesy to all. Anyone who thoughtlessly or intentionally jeopardizes the health or safety of another individual may be immediately dismissed from the day’s activity and will be referred to the Dean of Student Services for disciplinary action.

 

In the event of disruption of normal classroom activities due to an emergency situation or an illness outbreak, the format for this course may be modified to enable completion of the course. In that event, students will be provided an addendum to the class syllabus that will supersede the original version.

Campus Carry

The Austin Community College District concealed handgun policy ensures compliance with Section 411.2031 of the Texas Government Code (also known as the Campus Carry Law), while maintaining ACC’s commitment to provide a safe environment for its students, faculty, staff, and visitors.  Beginning August 1, 2017, individuals who are licensed to carry (LTC) may do so on campus premises except in locations and at activities prohibited by state or federal law, or the college’s concealed handgun policy.  In addition, concealed weapons are not allowed on ACC-sponsored field trips where the school owns or has chartered or leased vehicles for transportation.

 It is the responsibility of license holders to conceal their handguns at all times.  Persons who see a handgun on campus are asked to contact the ACC Police Department by dialing 222 from a campus phone or 512-223-7999.   Please refer to the concealed handgun policy online at http://austincc.edu/campuscarry

Discrimination Prohibited

The College seeks to maintain an educational environment free from any form of discrimination or harassment including but not limited to discrimination or harassment on the basis of race, color, national origin, religion, age, sex, gender, sexual orientation, gender identity, or disability.

 

Faculty at the College are required to report concerns regarding sexual misconduct (including all forms of sexual harassment and sex and gender-based discrimination) to the Manager of Title IX/Title VI/ADA Compliance.  Licensed clinical counselors are available across the District and serve as confidential resources for students.

 

Additional information about Title VI, Title IX, and ADA compliance can be found in the ACC Compliance Resource Guide available at: https://drive.google.com/file/d/1o55xINAWNvTYgI-fs-JbDyuaMFDNvAjz/view

Use of ACC email

All College e-mail communication to students will be sent solely to the student’s ACCmail account, with the expectation that such communications will be read in a timely fashion. ACC will send important information and will notify students of any college- related emergencies using this account. Students should only expect to receive email communication from their instructor using this account.  Likewise, students should use their ACCmail account when communicating with instructors and staff.  Information about ACC email accounts, including instructions for accessing it, are available at:  http://www.austincc.edu/help/accmail/questions-and-answers

For- On-line Courses – Use of an ACC Testing Center

Under certain circumstances, examinations may have to be taken in a testing center. The ACC Testing Centers follow standard procedures so students know what to expect when they arrive to take their tests. Students should familiarize themselves with the student guidelines.

Students must present an ACC student ID card or government issued ID and know their ACC ID number before they can test.

It is necessary to check in at the Testing Center kiosk before taking a test. To check in, one must know the following information:

  • Student ID number
  • Course prefix and number
  • Course synonym
  • Course section number
  • Test number
  • Instructor’s name

 

Personal belongings such as backpacks, books, and electronic devices (including, but not limited to, cell phones and smart watches) are not allowed in the Testing Center. Possession of prohibited items or accessing unapproved resources in the testing room will result in the immediate termination of the exam and possible disciplinary action.

 

For additional information on using the Testing Center, please go to: http://www.austincc.edu/students/testing-services/instructional-testing

STUDENT SUPPORT SERVICES

The success of our students is paramount, and ACC offers a variety of support services to help, as well as providing numerous opportunities for community engagement and personal growth.

Student Support

ACC strives to provide exemplary support to its students and offers a broad variety of opportunities and services.  Information on these campus services and resources is available at  http://www.austincc.edu/students.

Student Accessibility Services

Students with documented disabilities who need classroom, academic, or other accommodations must request them through the office Student Accessibility Services (SAS).   SAS offices are located at each major campus.  Students are encouraged to request accommodations when they register for courses or at least three weeks before the start of the semester; otherwise, the provision of accommodations may be delayed.  Students who have received approval for accommodations from SAS for this course must provide the instructor with the document titled “Notice of Approved Accommodations” from SAS before accommodations will be provided. Accommodations will not be provided retroactively.  Arrangements by the instructor for academic accommodations can only be made after he or she receives the “Notice of Approved Accommodations” from the student.

 

Additional information about Student Accessibility Services is available at https://www.austincc.edu/offices/student-accessibility-services-and-assistive-technology

Academic Support

ACC offers academic support services on all of its campuses. These services, which include face-to-face and online tutoring, academic coaching, and supplemental instruction, are free to enrolled ACC students. Tutors are available in a variety of subjects ranging from accounting to pharmacology. Students may receive these services on both a drop-in and referral basis. Tutoring schedules can be found at:  https://www.austincc.edu/students/tutoring/tutoring-schedules

Library Services

ACC has a full-service library at each of its campuses to support ACC courses and programs and to provide students with research and assignment assistance from expert faculty librarians, computers, course reserves, laptop and tablet check out, study spaces, and copying, printing, and scanning services.  In addition, ACC students have full rights and privileges to access Library Services online 24/7 via the ACC Library website and students can use their ACCeID logins to access all online materials, including ebooks, articles from library databases, and streaming videos.   ACC Libraries also provide an “Ask a Librarian” service, which allows  students to reach a librarian 24/7 through online chat.  Faculty librarians are also available via email, phone, and in person seven days a week during hours of operation. Visit:

In partnership with ACC’s Student Support Center, ACC Libraries also maintain a limited collection of textbooks for students to borrow. Priority access to the textbook collection is given to students receiving assistance. More information is available on the ACC website by searching “Student Support Center Textbook Collection.”

Student Organizations

ACC has over seventy student organizations, offering a variety of cultural, academic, vocational, and social opportunities.  They provide a chance to meet with other students who have the same interests, engage in service-learning, participate in intramural sports, gain valuable field experience related to career goals, and much else.  Student Life coordinates many of these activities, and additional information is available at http://sites.austincc.edu/sl/.

Personal Support

Resources to support students are available at every campus. To learn more, ask your professor or visit the campus Support Center. All resources and services are free and confidential. Some examples include, among others:

 

 

Clinical Counseling services are available throughout the ACC Student Services District to address personal and or mental health concerns: http://www.austincc.edu/students/counseling .

If an emergency occurs during operational hours, please come to the Student Services Office and let the front intake staff know that you are experiencing a crisis. They will alert appropriate personnel. You may also contact the ACC District Police at 222 (on campus) or 223-7999 (off campus or cell phone).

After Hours:

If you are struggling with a mental health or personal crisis, call one of the following numbers to connect with resources for help. However if you are afraid that you might hurt yourself or someone else, call 911 immediately.

Free Crisis Hotline Numbers:

  • Austin / Travis County 24 hour Crisis & Suicide hotline: 512-472-HELP (4357)
  • The Williamson County 24 hour Crisis hotline: 1-800-841-1255
  • Bastrop County Family Crisis Center hotline: 1-888-311-7755
  • Hays County 24 Hour Crisis Hotline: 1-877-466-0660
  • National Suicide Prevention Lifeline: 1-800-273-TALK (8255)
  • Crisis Text Line: Text “home” to 741741
    • Substance Abuse and Mental Health Services Administration (SAMHSA) National Helpline:   1-800-662-HELP (4357)
  • National Alliance on Mental Illness (NAMI) Helpline:1-800-950-NAMI (6264)

Some faculty may consider adding a student sign-off page at the end of the syllabus to be removed and handed back to the instructor providing evidence that the student received a copy of the syllabus and had an opportunity to ask questions, but such a page is optional.