(806) 337-2116 - Cell (Call or Text)
Monday: 11:30 am - 2:30 pm
Tuesday, Thursday: 4:30 pm - 5:30 pm
Wednesday and Friday - by appointment
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
The Tutoring for Success policy applies to any student whose grade or performance in the course falls below a departmentally determined minimum threshold. In either of those cases, the instructor will direct the student to the appropriate tutoring service, which may be faculty-led, discipline-specific, and/or general. Under this policy, the instructor will follow specific departmental guidelines governing the use, duration, and grade component of the tutoring need.
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-DC002 Application Software Problem Solving
Prerequisites: BCIS 1305
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 Exploring Microsoft Office 2019 series utilized in BCIS-1305.
Access to the accompanying learning management system, MyLabIT, is a required element of this course.
MyLabIT access codes remain active for 1 full year. If you completed BCIS 1305 before Summer of 2019, 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 linked in the course.
MyLabIT access includes an electronic version (e-text) of the appropriate textbooks, Exploring Microsoft Office 365, Excel 2019, Comprehensive and Exploring Microsoft Office 365, Access 2019, Comprehensive.
If you prefer to have a printed text for reference, you may purchase the texts directly from the publisher using a credit card (cost is approximately $35/textbook). A link will be provided in MyLabIT for this purpose.
Microsoft Office 2019 or Office 365 subscription software (Access, Excel, Word).*
Access to a PC (personal computer) running the Windows 8 (or above) operating system.^
Reliable access to the Internet.^
A USB flash drive or cloud account (Google Drive or Microsoft OneDrive) 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 program 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. Integrity violations are automatically flagged by MyLabIT software whenever elements of another person's file are detected in an uploaded student file.
COURSE GRADE
>89.5% = A
>79.5% = B
>69.5% = C
>59.5% = D
<59.5% = F
SUMMARY OF ASSIGNMENTS
Chapter Notes (10%)
Chapter notes will be completed for each textbook chapter covered in the course. Students will be provided with a template and a list of terms and concepts of focus for the chapter. Students will either type or write responses and upload the completed work to a Blackboard dropbox. Responses are expected to be brief and written in simple and easy to understand language.The purpose of this note-taking is to drive students to the e-text, a valuable learning resource, and to assist students in focusing on the key elements of each chapter.
Simulation Training (20%)
Simulation trainings are activities that teach students how to complete tasks and commands introduced in specific chapters of the textbook. Simulation training is conducted in MyLabIT, in an online, simulated ("fake") computer program that mimics the software application. Simulation training is required and will be graded. Training will always remain open, however. 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 gradebook in Blackboard. 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 the student will alter based upon a set of instructions and then upload to MyLabIT for grading. Projects are an effective tool for demonstrating an understanding of chapter concepts. Students are permitted two attempts on each of these chapter projects. 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 taken in three parts: Final Exam: Excel Capstone Project, Final Exam: Access Capstone Project, and Final Exam: Word Capstone Project. These capstones projects are similar to the chapter projects in MyLabIT; however, each project is cumulative, covering all chapters in the application, and only one attempt is permitted on each capstone. In addition, each of the capstones can be substituted by taking a Microsoft Office Specialist certification exam. See the MOS Certification Exam substitution option below.
MOS CERTIFICATION EXAM (optional)
A MOS certification exam may substitute for one or more of the final exam capstones. All three parts of the final may be substituted. In fact, it’s encouraged!
Completion of MOS Certification Exams will satisfy the Final Exam requirements (see below):
Microsoft Office Specialist: Excel Associate (Excel and Excel 2019), MO-200* substitutes for Part 2 of the Final Exam (Excel Capstone Project)
Microsoft Office Specialist: Word Associate (Word and Word 2019), MO-100* substitutes for Part 3 of the Final Exam (Word Capstone Project)
Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019), MO-201, or Microsoft Office Specialist: Microsoft Word Expert (Word and Word 2019), MO-101 substitutes for Part 1 of the Final Exam (Access Capstone Project). FYI, Microsoft has not yet released a 2019 MOS certification exam for Access.
How a MOS exam score correlates to a Final Exam grade:
>700 points = 95 on Final Exam (and MOS certification)
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*
Check your email daily. The email address used by your instructor is the @amarillocollege.com email address issued to each AC student. Your instructor will communicate important course updates, guidance, and hints via email.
Complete assignments by the scheduled date/time. The more effort you put into keeping on top of the assignments, the more you will learn, the more you will enjoy the course, and the more likely the workload will not feel burdensome.
Your instructor, Lynne Kenney, may be contacted by email through the course in Blackboard. If Blackboard is not available, please email lkenney@actx.edu. In-person meetings or additional help are available if needed or desired. Please contact by email to set up a convenient day/time.
Emails are typically answered within 24 hours. If you do not receive a response within that timeframe, please resend your message as a reminder.
WEEK 1 (January 21 - January 26)
Access Chapter 1: Introduction to Access
Access Chapter 2: Tables and Queries in Relational Databases
WEEK 2 (January 27 - February 2)
Access Chapter 3: Query Calculations and Expressions
Access Chapter 4: Basic Forms and Reports
WEEK 3 (February 3 - February 9)
Access Chapter 6: Action and Specialized Queries
WEEK 4 (February 10 - February 16)
Access Chapter 7: Automated Forms and Reports
Access Chapter 10: Enhanced Database Techniques
WEEK 5 (February 17 - February 23)
Review of BCIS 1305 - Excel Chapter 2: Formulas and Functions
Review of BCIS 1305 - Excel Chapter 3: Charts
WEEK 6 (February 24 - March 1)
Excel Chapter 7: Specialized Functions
WEEK 7 (March 2 - March 8)
Excel Chapter 7: Specialized Functions
WEEK 8 (March 9 - March 15)
Review of BCIS 1305 - Excel Chapter 4: Datasets and Tables
Excel Chapter 6: What-if Analysis
Week XX (March 16 - March 22)
Spring Break: No New Coursework Assigned
Week 9 (March 23 - March 29)
Excel Chapter 6: What-if Analysis
Week 10 (March 30 - April 5)
Excel Chapter 8: Statistical Functions
Week 11 (April 6 - April 12)
Excel Chapter 9: Multiple Sheet Workbook Management
Excel Chapter 11: Collaboration and Workbook Distribution
Week 12 (April 13 - April 19)
Excel Chapter 5: Subtotals, PivotTables, and PivotCharts
Week 13 (April 20 - April 26)
Excel Chapter 10: Imports, XML, and Power Add-Ins
Week 14 (April 27 - May 3)
Excel Chapter 10: Imports, XML, and Power Add-Ins
Week 15 (May 4 - May 10)
Word Chapter 5: Creating a Newsletter, Working with Graphics
Week 16 (May 11 - May 14)
Final Exam - Part 1: Excel Capstone Project
Final Exam - Part 2: Word Capstone Project
Final Exam - Part 3: Access Capstone Project
Schedule a MOS Exam (optional substitute for final exams; see Grading Criteria section above)
IMPORTANT DATES TO REMEMBER:
January 20 : Martin Luther King, Jr. Holiday (AC Closed)
January 21 : Spring 2020 Semester Begins
February 5 : Census Day (Administrative Drop for Non-Attendance)
March 13 - March 22 : Spring Break (no classes)
April 10 - April 12 : Easter Holiday (AC campus closed)
April 23 : Last Day to Withdraw from Course
May 14 : Last Day of Course (all work due by 10pm)
01/16/20 7:54 PM
01/20/20 1:45 PM