ITE 140
Spreadsheet Software (MSExcel)
Excel 2000
Course Guide

PROJECT ONE:  Creating a Worksheet and Embedded Chart

Week 1

• Write and submit the Introductory Letter
• Read and work through Project 1:  pages E1.6 - E1.58

Week 2

• Read and work through Project 1: pages E1.6 - E1.58
• Complete the Reinforcement Activites for Project 1  (not to be turned in to the instructor)
• Complete and submit Assignment 1

PROJECT TWO:  Formulas, Functions, Formatting, and Web Queries

Week 3

• Read and work through Project 2:  pages E2.4 - E2.64

Week 4

• Read and work through Project 2:  pages E2.4 - E2.64
• Complete the Reinforcement Activites for Project 2 (not to be turned in to the instructor)
• Take Practice Exam 1 (Spring 2005 students)
  

Week 5

• Complete and submit Assignment 2
• Take Exam 1 (covers Project One and Project Two)

PROJECT THREE: What-If Analysis, Charting, and Working With Large Worksheets

Week 6

• Read and work through Project 3: pages E3.4 - E3.67

Week 7

• Read and work through Project 3: pages E3.4 - E3.67
• Complete the Reinforcement Activites for Project 3 (not to be turned in to the instructor)
• Complete and submit Assignment 3

PROJECT FOUR:  Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks

Week 8

• Read and work through Project 4: pages E4.4 - E4.54

Week 9

• Read and work through Project 4: pages E4.4 - E4.54
• Complete the Reinforcement Activites for Project 4 (not to be turned in to the instructor)
• Take Practice Exam 2 (Spring 2005 Students)
  

Week 10

• Complete and submit Assignment 4
• Take Exam 2 (covers Project Three and Project Four)

PROJECT FIVE:  Creating, Sorting, and Querying a Worksheet Database

Week 11

• Read and work through Project 5: pages E5.4 - E5.49

Week 12

• Read and work through Project 5: pages E5.4 - E5.49
• Complete the Reinforcement Activites for Project 5 (not to be turned in to the instructor)
• Complete and submit Assignment 5

PROJECT SIX:  Creating Templates and Working with Multiple Worksheets and Workbooks

Week 13

• Read and work through Project 6: pages E6.4 - E6.64

Week 14

• Read and work through Project 6: pages E6.4 - E6.64
• Complete the Reinforcement Activites for Project 6 (not to be turned in to the instructor)

Week 15

• Complete and submit Assignment 6
• Take Practice Exam 3 (Spring 2005 Students)
  

Week 16

• Take Exam 3 (covers Project Five and Project Six)
• Complete End of Course Evaluation