ITSW 1304
Introduction to Spreadsheets

Western Texas College

  1. Basic Course Information
    1. Instruction in the concepts, procedures, and application of electronic spreadsheets.
    2. Any required prerequisites: None.
  2. Student Learning Outcomes
    1. Define spreadsheet terminology and concepts, create formulas and functions, use formatting features, and generate charts, graphs, and reports.  Spreadsheets will be measured with rubrics.
  3. Major Course Requirements
    1. Requirement: There will be six chapter exams.
    2. Requirement: There will be a proctored final exam.
  4. Information on Books and Other Course Materials
    1. MYITLAB: 0133775062 with Full eText--enables you to access your textbook online.
  5. Other Policies, Procedures and Important Dates
    1. Course Catalog
  6. Course Organization and Schedule
    1. Weekly Course Schedule

Week Number

Section/Online Work

Week 1

Chapter 1: Creating a Worksheet and Charting Data

Week 2

Chapter 1: Creating a Worksheet and Charting Data

Week 3

Chapter 1: Creating a Worksheet and Charting Data

Week 4

Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks

Week 5

Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks

Week 6

Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks

Week 7

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

Week 8

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

Week 9

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

Week 10

Chapter 4: Use Financial and Lookup functions, Define Names, and Validate Data

Week 11

Chapter 4: Use Financial and Lookup functions, Define Names, and Validate Data

Week 12

Chapter 4: Use Financial and Lookup functions, Define Names, and Validate Data

Week 13

Chapter5: Managing Large Workbooks and Using Advanced Sorting and Filtering

Week 14

Chapter 6: Creating Charts, Diagrams, and Templates

Week 15

Chapter 6: Creating Charts, Diagrams, and Templates

Week 16

FINAL EXAM

Disclaimer:¬† Schedule and content is subject to change at the instructor’s discretion.

 

NOT PROCTORED

PROCTERED

Weekly Assignments

40%

 

Exams

25%

 

Mid- Term & Final Exam

35%

 

 

 

 

 

Last Modified: August 24, 2016