Advanced Spreadsheets Syllabus for 2021-2022
Return to Syllabus List

Instructor Information

Course Information

COVID-19 Protocols

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:

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.

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 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.

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

ITSW-2334-001 Advanced Spreadsheets

Prerequisites

Course Description

Advanced techniques for developing and modifying spreadsheets. Includes macros and data analysis functions.

Student ResourcesStudent Resources Website

Department Expectations

Occupational License Disclaimer

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.

Hours

(3 sem hrs; 3 lec, 1 lab)

Class Type

Hybrid

Syllabus Information

Textbooks

 Purchase an access code to myEducator with eText. Link to purchase the specific access code will be in your Blackboard course

    

The myEducator access code comes with a lifetime access to the textbook that we will use in class

Supplies

1. Access to a PC (personal computer) running the Windows 7 (or above) operating system.
2. Microsoft Office 2019 software (Excel 2019).
   The links below is an option to subscribe to Office 365 in your personal devices
   **  Office 365 Personal -- $6.99 per month
3. A USB flash drive for file transport between computers. You could use a One Drive or Google Drive cloud account to store your files as an an alternate option

Student Performance

Students will utilize spreadsheet and word processing software, with a focus on understanding the impact of these applications and technology on our society and in the business world.

At completion of course student will be able to:

 Review Excel basics including Logical and Reference Functions, Charting/Graphing data, functions to aggregate data

Understand the role of Excel charts in Business Intelligence visualization

Build dashboards in Excel

Understand what Pivot tables are, how they are created and how to manipulate elements of a Pivot table to analyse data

Understand the role of Excel charts in Business Intelligence visualization

Create Statistical models to perform corelation analysis, regression analysis

Understand and apply the principles of time series forecasting

Understand and apply the principles of simulation and Monte Carlo methods

Apply the analysis tools and toolpacks that are available with Excel to analyze data

Students Rights and Responsibilities

Student 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, dishonesty, or an integrity violation in MyITLab 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 MyITLab will result in both parties receiving a 0 on the assignment and no make-up assignment is permitted. 

Grading Criteria

COURSE GRADE

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

 

SUMMARY OF ASSIGNMENTS

Attendance & Participation (10%)  - Attend class meetings regularly for the attendance. We will be working on in class files individually or in groups which will count for a grade

Weekly Chapter(s) Quiz (10%) - Quiz will be based on the chapters that are covered in a given week

Practice Assignments (25%)
Practice Assignments are embedded as part of every lesson in the course. These assignments are required and will be graded.  You have 3 attempts to complete the projects successfully.

Test Your Skills Assignments (35%)
Again, these assignments are part of every lesson. These assignment will test your understanding of the lesson completed. There is one Test Your Skills Assignment per lesson

Final Exam (20%)
The Final Exam is a comprehensive assessment which will cover majority of the concepts covered in the course. See the MOS Certification Exam substitution option below.

MOS Certification Exam (optional)
A MOS exam may substitute for part of the final exam. MOS for Excel will substitute for the Final exam;

Completion of MOS Certification Exams will satisfy the Final Exam requirements (see below):

• MO-200 * (Excel 2019 Associate) OR MO-201 Excel 2019 Expert will substitute  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
   

Attendance

All Week 1 assignments must be completed by Monday (1/24 @ 10pm), in order to be considered Present in the course. Failure to complete all assignments by this date may lead to an administrative drop from the course.

DAILY – Check your AC email (xxxxx@amarillocollege.com) and any course announcements in AC Connect/Blackboard for communications and additional instructions.

• Attendance and class participation is required and worth 15% of your grade for on-campus course.
• Check your email daily and have assignments in on time.

Calendar

Additional Information

IMPORTANT DATES TO REMEMBER:
January 18:           Spring Classes Begin
January 25:           Census Day (Administrative Drop for Non-Attendance)
January 28:           General Assembly (Many College Offices Closed after Noon)
March 1:                Preferred Deadline for the AC Foundation General Scholarship Application
March 1:                Last Day to Withdraw
March 10:              Last Day of Spring 1 Classes
March 14-20:         Spring Break
March 21:              Spring 2 Classes Begin

• TECHNOLOGY & COMPUTING ISSUES

• Computer Services Center: Located within the AC Bookstore, trained staff will diagnose computer-related issues and repair problems on a fee-for-service basis. Laptop rentals are also available. Visit the Computer Services Center website for additional details: https://www.actx.edu/bookstore/computer-service-center.
• Student & Faculty Help Center: Located on the first floor of Ware Student Commons, the Help Center provides technical support to students and faculty. The Help Center offers assistance in logging into AC Connect, Blackboard, resetting passwords, and general computing and software questions. Visit the Student & Faculty Help Center website at https://www.actx.edu/ctl/helpcenter.

• COURSE ASSISTANCE

• Tutoring: A variety of options are available when you need a little extra help in a course (online, walk-in, one-on-one). Visit the Tutoring website at https://www.actx.edu/tutoring/.
• Writers' Corner: Writers' Corner offers one-on-one tutoring to review assignment requirements, provide constructive feedback, and guide students through all phases of the writing process. Writer’s Corner will not edit your work, but will help you get on the right path. Visit the Writer’s Corner website at https://www.actx.edu/english/writerscorner.
• DisAbility Services: DisAbility Services helps students by providing necessary accommodations for course success and facilitating access to all services and programs at Amarillo College. Visit the DisAbility Services website at https://www.actx.edu/disability/.
• Learn about using AC Connect (Blackboard) and using features of our course by reviewing the following tutorials:
  • Blackboard On Demand Learning Center for Students
    • Topic list: https://help.blackboard.com/Learn/Student
    • Videos: http://ondemand.blackboard.com/students.htm
  • AC Connect Student Resources
    • https://www.actx.edu/ctl/ac-connect-student-resources

• PERSONAL ISSUES

• Advocacy & Resource Center: The Advocacy & Resource Center is located on the first floor of Ware Student Commons. A variety of resources are available in the areas of social services, a food pantry, a clothing closet, and adult student programs. Visit the Advocacy & Resource Center website at http://www.actx.edu/arc/advocacy-and-resource-center.
• Counseling Center: At the Counseling Center, student and counselor work together to develop more personal awareness and the skills needed to overcome barriers to success. All services are free and confidential. Visit the Counseling Center website at: https://www.actx.edu/counseling/index.php.
• Legal Clinic: The Legal Clinic is a free, walk-in clinic assisting enrolled AC students on various legal issues including family law, immigration, probate, landlord-tenant issues, and general legal matters. Visit the Legal Clinic website at https://www.actx.edu/legalstudies/legal-student-intership