ITSW 2334
Advanced Spreadsheets

Western Texas College

  1. Basic Course Information
    1. Course Description: Advanced techniques for developing and modifying spreadsheets. Includes macros and data analysis functions.
    2. Required Prerequisite: None
  2. Student Learning Outcomes
    1. Create and design macros; use data analysis features; and develop solutions using linked worksheets.
  3. Testing Requirements
    1. The final exam must be proctored. (ask your instructor for more details)
    2. Students will be allowed to use the one sheet study sheet provided by instructor for the final exam
  4. Major Course Requirements
    1. Lab Assignments          45%
    2. Attendance                    20%
    3. Final                              35% - Proctored
  5. Information on Books
    1. Required Book: MyLab IT with Pearson eText -- Access Card -- for GO! with Microsoft Office 365, 2019 Edition, ISBN 9780135651261
  6. Other Policies, Procedures and important dates. Please refer to the WTC Catalog for the following:
    1. Campus Calendar
    2. Final Exam Schedule
    3. How to drop a class
    4. Withdrawal Information
    5. Student Conduct/Academic Integrity
    6. Class Attendance
    7. Student with disabilities
  7. Course Content


Logon instructions for MYITLAB & getting started with labs

Chapter 7

Chapter 7: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Chapter 8

Chapter 8: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Chapter 9

Chapter 9: Using Macros and Visual Basic for Applications

Chapter 10

Chapter 10: External Data, Database Functions, Side-by-Side Tables, and Workbook Distribution and Collaboration


Final Review


Final Exam

***Disclaimer: Assignments due to change by instructor


Last Modified: October 9, 2017