Title: Introduction to Spreadsheets (TEMPLATE)

Syllabus
  Syllabus
Course Schedule
  Course Schedule
Book
  Microsoft Excel 2013 Book
Course Orientation
  Welcome Video
  Orientation Learning Outcomes
  Orientation Steps
  Syllabus/Course Schedule
  Student Information Sheet
  SAM Tutorials
    Getting Started in SAM
    Accessing the SAM Reading
    Completing a SAM Project
    Taking a SAM Exam
    Completing a SAM Training
  Blackboard Tutorials
    Learn to Use Blackboard
  Self-Introduction
  Orientation Quiz
Competency Modules
  Competency One: Generate basic Excel Workbooks
    Introduction
    Competency 1.1: Create a Workbook
      Introduction
      Learning Objectives
      Read It
      Watch It: Create a Workbook
      Competency 1.1 Practical Assignment
      Competency 1.1 Quiz
    Competency 1.2: Format a Workbook
      Introduction
      Learning Objectives
      Read It
      Watch It: Format Cells
      Competency 1.2 Practical Assignment
      Competency 1.2 Quiz
    Competency 1.3: Apply Formulas and Functions
      Introduction
      Learning Objectives
      Read It
      Watch It: Formulas and Functions
      Competency 1.3 Practical Assignment
      Competency 1.3 Quiz
    Competency 1.4: Apply Charts and Graphics
      Introduction
      Learning Objectives
      Read It
      Watch It: Charts
      Competency 1.4 Practical Assignment
      Competency 1.4 Quiz
    Competency 1 Assessment (Check for Due Date)
  Competency Two: Employ Advanced features in Excel
    Introduction
    Competency 2.1: Create Tables, PivotTables and Pivot Charts
      Introduction
      Learning Objectives
      Read It
      Watch It: Pivot Tables
      Competency 2.1 Practical Assignment
      Competency 2.1 Quiz
    Competency 2.2: Manage Multiple Worksheets and Workbooks
      Introduction
      Learning Objectives
      Read It
      Watch It: Link Multiple Workbooks
      Competency 2.2 Practical Assignment
      Competency 2.2 Quiz
    Competency 2.3: Developing an Excel Application
      Introduction
      Learning Objectives
      Read It
      Watch It: Macro
      Competency 2.3 Practical Assignment
      Competency 2.3 Quiz
    Competency 2.4: Working with Advanced Functions
      Introduction
      Learning Objectives
      Read It
      Watch It: Advanced Functions
      Watch It: VLOOKUP function
      Competency 2.4 Practical Assignment
      Competency 2.4 Quiz
    Competency 2 Assessment (Check for Due Date)
  Competency Three: Apply Data in Excel
    Introduction
    Competency 3.1: Apply Financial Tools
      Introduction
      Learning Objectives
      Read It
      Watch It: Using PMT Function
      Competency 3.1 Practical Assignment
      Competency 3.1 Quiz
    Competency 3.2: Perform What-If Analyses
      Introduction
      Learning Objectives
      Read It
      Watch It: What-If Analysis--Data Tables
      Competency 3.2 Practical Assignment
      Competency 3.2 Quiz
    Competency 3.3: Connect to External Data
      Introduction
      Learning Objectives
      Read It
      Watch It: Create Web Query
      Competency 3.3 Practical Assignment
      Competency 3.3 Quiz
    Competency 3.4: Collaborate on a Shared Workbook
      Introduction
      Learning Objectives
      Read It
      Watch It: Sharing Workbooks
      Competency 3.4 Practical Assignment
      Competency 3.4 Quiz
    Competency 3 Assessment (Check for Due Date)
Class Meeting (Adobe Connect)
  Class Meeting Link
  Class Meeting Recordings
  Adobe Connect Tutorial for Students
Course Disclaimers
  U. S. Department of Labor Disclaimer
  Creative Commons License