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. Exams                            20%
    3. Final                              35%
  5. Information on Books
    1. Required Book: MYITLAB: 0133775062 with full e-text--enables you to access your textbook online.
  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

 

Course Content

 

Logon instructions for MYITLAB & getting started with labs

GO! Office 2013 Excel

Chapter 7

Chapter 7: Creating PivotTable and PivotChart Reports and Using BI Tools in Excel

GO! Office 2013 Excel

Chapter 8

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

GO! Office 2013 Excel

Chapter 9

Chapter 9: Using Macros and Visual Basic for Applications

GO! Office 2013 Excel

Chapter 10

External Data, Database Functions, & Side by Side Tables

GO! Office 2013 Excel

Chapter 11

Collaborating with Others and Preparing a Workbook for Distribution

GO! Office 2013 Excel

 

Final Review

GO! Office 2013 Excel

 

Final Exam

GO! Office 2013 Excel

***Disclaimer: Assignments due to change by instructor

 

Last Modified: October 9, 2017