Office hours are available upon request.
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 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.
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
Students who do not attend class on or prior to the census date will be administratively dropped. Effective Fall, 2016
Students who wish to withdraw from a course must complete all steps indicated on the Academic Withdrawal Request form by the course withdrawal deadline.
NOTE: Students who are 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. This withdrawal limitation does not include dual credit or developmental classes (Senate Bill 1231 Rule 4.10.) For more information on Drop and Withdrawal Policies, please visit the Registrar's Office Web site.
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 .
ITSC-2335-DC003 Application Software Problem Solving
<p>Prerequisites: BCIS 1305</p>
Utilization of appropriate application software to solve advanced problems and generate customized solutions.
Student ResourcesStudent Resources Website
Notice to Students enrolled in an educational program for preparation of issuance of certain occupational licenses:
Students enrolled in an educational program in preparation for obtaining certain occupational licenses are potentially ineligible for such license if the student has been convicted of an offense. For further information, please contact:
Melodie Graves
Justice Involved Advocate
Student Service Center 117
mgraves24@actx.edu
806-371-5995
Make appointment at https://melodiegraves.youcanbook.me
You can also contact the Legal Clinic, or the faculty member in charge of the educational program that you seek to enroll in. The further information you will receive will include notification to you of your right to request a criminal history evaluation letter from the licensing authority in order to clarify your particular situation.
(3 sem hrs; 2 lec, 4 lab)
Dual Credit Course
ITSC-2335 continues with the Microsoft Office 2013 Exploring Series utilized in BCIS-1305.
Access to the accompanying learning management system, MyLabIT, is a required element of this course. If you obtained a MyLabIT access code for BCIS 1305 recently (Fall 2018), this same account will remain active for Spring 2019—no additional purchase is required.
MyLabIT access codes remain active for 1 full year. If you completed BCIS 1305 before Fall 2018, you will need to purchase a MyLabIT access code. An access code may be purchased from the AC Bookstore or directly from the MyLabIT website.
MyLabIT access includes an electronic version (e-text) of the appropriate textbook, Microsoft Office 2013 Exploring Series - Volume 2.
If you prefer to have a printed text for reference, you may purchase one directly from the publisher using a credit card (cost is approximately $35 each). A link will be provided in MyLabIT for this purpose.
Access to a PC (personal computer) running the Windows 7 (or above) operating system. Computers are available in the CIS Computer Lab on the 2nd Floor of the Byrd Business Building (Washington Street Campus, Amarillo College).
Microsoft Office 2013 software (Word, Excel, and Access). Software is available on computers in the CIS Computer Lab.
Reliable access to the Internet. Internet access is available in the Computer Lab on the 2nd Floor of Byrd Business Building. Check the CIS website for lab hours (http://cis.actx.edu).
A USB flash drive or Google Drive / OneDrive account for file transport between computers.
After studying the material presented in this course of study, the student will be able to demonstrate understanding of the following as evaluated by the faculty in the department/program.
After completing the Word section the student will be able to:
After completing the Excel section the student will be able to:
After completing the Access section the student will be able to:
The main focus of this course is to understand and use various business software applications including word processing, spreadsheets, databases and other miscellaneous business applications.
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".
Students are expected to maintain a high standard of individual honor in their scholastic work. Students who are guilty of cheating, plagiarism, copying, dishonesty, or an integrity violation in MyLabIT may be excluded from class with a grade of F; or, in flagrant cases, may be suspended from the College,
The faculty of the CIS Department reserve the right to ask a student to verify any portion of a test, exam, or project by reproducing any specific section or all sections of any 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.
Integrity violations (using all or part of another student’s file) in MyLabIT will result in both parties receiving a 0 on the assignment and no make-up assignment is permitted.
COURSE GRADE
>89.5% = A
>79.5% = B
>69.5% = C
>59.5% = D
<59.5% = F
SUMMARY OF ASSIGNMENTS
Simulation Training (30%)
Training activities are required and will be graded.
Training will always remain open. Thus, even though a due date has passed, students may return to training and repeat training as often as desired. For grading purposes, only the first attempt will be added to the Blackboard gradebook.
Trainings are set in learning mode, so each student should be able to obtain a 100 on each training. As long as you do not give up, this is a nice way to add some points to your grade.
Chapter Projects (40%)
Chapter project entail downloaded files that you alter based upon a set of instructions and then upload to MyLabIT for grading.
Projects are effective tools for demonstrating an understanding of chapter concepts.
Students are permitted two attempts on each project. Students are highly encouraged to locate and correct any errors on the first attempt in order to support learning and integration of the chapter concepts.
The higher grade of the two attempts will be recorded in the Blackboard gradebook. Another simple way to add points to your grade.
Final Exam (30%)
The Final Exam is a comprehensive exam.
The exam is given in two parts and is conducted in the simulation environment in MyLabIT.
See the MOS Certification Exam substitution option below.
MOS Certification Exam (optional)
A MOS exam may substitute for part of the final exam.
Word MOS or Access MOS will substitute for Part 1 of the final exam
Excel MOS will substitute for Part 2 of the final exam
Both parts of the final may be substituted. In fact, it’s encouraged!
Completion of MOS 2013 Certification Exams will satisfy the Final Exam requirements (see below):
MOS 77-418* (Word) or MOS 77-424* (Access) substitute for Part 1 of the Final Exam
MOS 77-420* (Excel) substitutes for Part 2 of the Final Exam
How a MOS exam score correlates to a Final Exam grade:
>700 points = 95 on Final Exam (and MOS certification and refund of exam fee)
600-699 points = 85 on Final Exam
500-599 points = 75 on Final Exam
<500 points = retake MOS Exam or take Final exam
Actual MOS certification is ONLY awarded for an exam score >700
*If you have already obtained some MOS certifications, speak with your instructor about additional/alternative
MOS certifications that will substitute for the Final Exam*
DAILY – Check your AC email (xxxxx@amarillocollege.com) and any course announcements in AC Connect/Blackboard for communications and additional instructions.
For successful completion of the course, students should anticipate spending 10 – 12 hours per week developing skills and completing assignments.
The schedule below represents a planned outline for the course. Actual dates are subject to change. Please check your email daily for course updates from your instructor.
WEEK 1 (January 14 – January 20)
Topics Covered:
Access Chapter 1: Introduction to Access
Access Chapter 2: Tables and Queries in Relational Databases
Assignments:
Email Instructor through Blackboard
Activate MyLabIT account
Access CH01/CH02: Training
Access CH01: Project
Access CH02: Project
WEEK 2 (January 21 – January 27)
Topics Covered:
Access Chapter 3: Customize, Analyze, and Summarize Query Data
Assignments:
Access – CH03: Training
Access – CH03: Project
WEEK 3 (January 28 – February 3)
Topics Covered:
Access Chapter 5: Data Validation and Data Analysis
Assignments:
Access – CH05: Training
Access – CH05: Project
WEEK 4 (February 4 – February 10)
Topics Covered:
Access Chapter 6: Action and Specialized Queries
Assignments:
Access – CH06: Training
Access – CH06: Project
WEEK 5 (February 11 – February 17)
Topics Covered:
Access Chapter 4: Creating and Using Professional Forms and Reports
Assignments:
Access – CH04: Training
Access – CH04: Project
WEEK 6 (February 18 – February 24)
Topics Covered:
Excel – Review of Concepts Learned in BCIS 1305
Assignments:
Excel – BCIS 1305 Review: Training
Excel – BCIS 1305 Review: Project
WEEK 7 (February 25 – March 3)
Topics Covered:
Excel Chapter 5: Subtotals, Pivot Tables, and Pivot Charts
Assignments:
Excel – CH05: Training
Excel – CH05: Project
WEEK 8 (March 4 – March 10)
Topics Covered:
Excel Chapter 6: What-If Analysis
Assignments:
Excel – CH06: Training
Excel – CH06: Project
WEEK XX (March 11 - March 17)
Assignments:
None--Enjoy Spring Break!!
WEEK 9 (March 18 – March 24)
Topics Covered:
Excel Chapter 7: Specialized Functions
Excel Chapter 11: Collaboration and Workbook Distribution
Assignments:
Excel – CH07/CH11: Training
Excel – CH07/CH11: Project
WEEK 10 (March 25 – March 31)
Topics Covered:
Excel Chapter 8: Statistical Functions
Assignments:
Excel – CH08: Training
Excel – CH08: Project
WEEK 11 (April 1 – April 7)
Topics Covered:
Excel Chapter 9: Multiple-Sheet Workbook Management
Assignments:
Excel – CH09: Training
Excel – CH09: Project
WEEK 12 (April 8 – April 14)
Topics Covered:
Excel Chapter 10: Imports, Web Queries, and XML
Assignments:
Excel – CH10: Training
Excel – CH10: Project
WEEK 13 (April 15 – April 21)
Topics Covered:
Excel Chapter 12: Templates, Styles, and Macros
Assignments:
Excel – CH12: Training
Excel – CH12: Project
WEEK 14 (April 22 – April 28)
Topics Covered:
Word Chapter 5: Desktop Publishing and Graphic Design
Assignments:
Word – CH05: Training
Word – CH05: Project
WEEK 15 (April 29 – May 5)
Topics Covered:
Word Chapter 6: Time Saving Tools
Assignments:
Word – CH06: Training
Word – CH06: Project
WEEK 16 (May 6 – May 10)
Assignments:
Final Exam – Part 1
Final Exam – Part 2
Schedule a MOS exam (optional--replaces Part 1 and/or Part 2)
IMPORTANT DATES TO REMEMBER:
January 14: Spring Courses Begin
January 21: Martin Luther King, Jr. Holiday (Amarillo College Closed)
January 30: Census Day (Administrative Drop for Non-Attendance)
March 8 - 17: Spring Break (Amarillo College Closed, 3/14-3/17)
April 8: Summer/Fall Registration Begins
April 17: Last Day to Withdraw from Course
April 19 - April 21 Easter Holiday (Amarillo College Closed)
May 10: Last Day of Course
01/09/19 10:08 PM
01/09/19 10:16 PM