ITSW 1304
Introduction to Spreadsheets

Western Texas College

  1. Basic Course Information
    1. Course Description: Instruction in the concepts, procedures, and application of electronic spreadsheets.
    2. Required Prerequisite: None
  2. Student Learning Outcomes
    1. Define spreadsheet terminology and concepts, create formulas and functions, use formatting features, and generate charts, graphs, and reports.
  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%
  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 1

Creating a Worksheet and Charting Data

Chapter 2

Using Functions, Creating Tables, and Managing Large Workbooks

Chapter 3

Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools

Chapter 4

Chapter 4: Creating PivotTables and PivotCharts

Chapter 5

Managing Large Workbooks and Using Advanced Sorting and Filtering

Chapter 6

Creating Charts, Diagrams, and Templates

Review

 

Final

 

 

***Disclaimer: Assignments due to change by instructor

 

Last Modified: August 19, 2019