Application Software Problem Solving Syllabus for 2021-2022
Return to Syllabus List

Instructor Information

Office Location

BYRD 352

Office Hours

MW 9:30 AM - 10:30 AM, 1:00 PM - 2:00 PM, 4:30 PM - 5:30 PM

TR 1:00 PM - 2:00 PM, and other times by appointment

Students may contact me from 9:00 AM - 9:00 PM via text at (806) 340-0027.

Students may contact me by email through the course in Blackboard (Messages).  If you would like to schedule a set day and time to meet, flexibility in my scheduling is available.  Please do not hesitate to ask for a different time if needed.

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

ITSC-2335-001 Application Software Problem Solving

Prerequisites

Prerequisites: BCIS 1305

Course Description

Utilization of appropriate application software to solve advanced problems and generate customized solutions.

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; 2 lec, 4 lab)

Class Type

Online Course

Syllabus Information

Textbooks

Two options are available for course materials:
 
(1) Purchase an access code to MyLab IT with E-Text OR
(2) Purchase a physical textbook with MyLab IT access code (also available at the bookstore)
    

**Recommended**

The physical textbook is not required, but highly recommended.

The MyLab IT access code is valid for 1 year.

Supplies

  1. Access to a PC (personal computer) running the Windows 7 (or above) operating system. Computers are available in the Underground of the WARE building (Washington Street Campus, Amarillo College). NOTE:  Computers running macOS will NOT work for this course.  Some advanced functions in Excel do not work in macOS.  Chromebooks will NOT work for this course.
  2. The paid version of Microsoft 365/Office 2019 software (Word, Excel, and Access).
    The link below is an option to subscribe to Microsoft 365 on your personal devices:
    **  Office 365 Personal -- $6.99 per month
  3. A USB flash drive for file transport between computers. OneDrive or Google Drive can also be used as a cloud storage option.

Student Performance

Students will utilize spreadsheet 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:

Use Excel to  manage business data, and analyze empirical data from various sources using complex functions and other tools

Use Excel to prepare visual representation of data through charts and graphs.

Use Excel to create financial models. Students will learn to create amortization models. In addition, students will learn to use tools and features that help with bonds and investment analysis and depreciation of assets in a business.

Use Excel to create statistical models where in students will learn to use tools to predict business outcomes, relationships between data, and predict future values.

Use Excel to manage data to facilitate data driven decision making.

Students will learn to use some powerful features in Excel such as PowerPivot, PowerView etc. These features help you connect to external data within excel and perform analysis.

The main focus of this course is to understand and use business spreadsheets using Microsoft Excel.

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, 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 (see Student Rights and Responsibilities).

Students who give another student their files or allow another student to use their work are committing a violation of the Student Code of Conduct.  Students who engage in this unethical behavior risk being subject to disciplinary action in accordance with College policy.

The Faculty of the CIS 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.

Integrity violations (using all or part of someone else’s file) in MyLab IT will result in both parties receiving a grade of 0 for the assignment and there will be no makeup for that assignment. Integrity violations are automatically flagged by MyLab IT software whenever elements of another person's file are detected in an uploaded student file.

Grading Criteria

COURSE GRADE

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

SUMMARY OF ASSIGNMENTS

Training Projects (30%)
Training Projects are required and will be auto-graded in MyLab IT. These training projects entail downloading files that you then alter based upon a set of instructions. Training projects typically follow the chapter material and provide practice of the chapter concepts. You will have three attempts to complete the training projects successfully. Students are highly encouraged to review their submissions and locate and correct any errors on the initial attempts in order to achieve mastery of the chapter concepts. The highest grade of the three attempts will be recorded in the Blackboard gradebook.


Chapter Quiz (10%)
You will have chapter quizzes based on the textbook material. Each quiz will have questions that will assess your understanding of the concepts being covered during the week including an emphasis on the added features that will help enhance your ability to use the software as needed in your work environment.  Students are permitted two attempts on each of these quizzes.


Grader Projects (30%)
Grader projects are required and will be auto-graded in MyLab IT.  These grader projects entail downloading files that you then alter based upon a set of instructions. Grader projects are an effective method for demonstrating an understanding of chapter concepts. Students are permitted two attempts on each of these projects. Students are highly encouraged to review their submission and locate and correct any errors on the initial attempt in order to achieve mastery of the chapter concepts. The highest grade of the two attempts will be recorded in the Blackboard gradebook.


Midterm Exam (15%)
The Midterm Exam will be a grader project that will cover Excel CH03 - CH06. See the MOS Certification Exam substitution option below.


Final Exam (15%)
The Final Exam is a comprehensive grader project. See the MOS Certification Exam substitution option below.

Microsoft Office Specialist (MOS) Certification Exam (optional)
An Excel MOS exam may substitute for the Midterm Exam and/or Final Exam.


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

  • MOS 77-727* (Excel)  substitutes for Midterm Exam
     
  • MOS 77-728* (Excel Expert ) substitutes for Final Exam
  • How a MOS exam score correlates to a grade:
    • >700 points = 95 on Midterm Exam or Final Exam (and MOS certification)
    • 600-699 points = 85 on Midterm Exam or Final Exam
    • 500-599 points = 75 on Midterm Exam or Final Exam
    • <500 points = retake MOS Exam or take Midterm Exam or 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 Midterm Exam or Final Exam.

Attendance

All Week 1 assignments must be completed by Monday (06/13 @ 11:00 PM) 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.

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

  • Check your email daily!
  • Complete assignments on time!

Calendar

ITSC 2335: APPLICATION SOFTWARE PROBLEM SOLVING

The schedule below represents a planned outline for the course. Actual assignments and dates are subject to change. Please check your email daily for course updates from your instructor.

WEEK 1
Topics Covered:

  • Review Syllabus
  • Excel CH03: Cell References, Named Ranges, and Functions
  • Excel CH04: Effective Charts

WEEK 2
Topics Covered:

  • Excel CH05: Complex Conditional and Retrieval Functions

WEEK 3 
Topics Covered:

  • Excel CH06: Integrating Complex Functions into Business Analysis

WEEK 4 
Topics Covered:

  • Midterm Exam
  • Excel CH09: Organize, Import, Export, and Cleanse Data Sets

WEEK 5 
Topics Covered:

  • Excel CH10: Data Tables, Scenario Manager, and Solver

WEEK 6
Topics Covered:

  • Excel CH11: Loan Amortization, Investment Analysis, and Asset Depreciation
  • Excel CH12: Business Statistics and Regression Analysis

WEEK 7
Topics Covered:

  • Excel CH13: The Excel Data Model and Business Intelligence

WEEK 8
Topics Covered:

  • Final Exam
  • Excel CH07: Multiple Worksheets, Workbooks, and Templates

Additional Information

IMPORTANT DATES TO REMEMBER:

June 6:     Class Begins
June 13:   Census Day (Administrative Drop for Non-Attendance)
June 20:   Juneteenth (AC Campuses Closed)
July 4:       Independence Day (AC Campuses Closed)
July 20:     Last Day to Withdraw and Receive a W
July 28:     Last Day of Class

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 in the Underground below the 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
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, students and counselors 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

Syllabus Created on:

06/05/22 9:42 PM

Last Edited on:

06/05/22 9:45 PM