**ALL Projects are to be completed in class and DUE on the day assigned.

First Class Meeting - Overview and Expectations

• Task #1 (Click on Link)
• Task #2 (Click on Link)
• Task #3 (Click on Link)
• Task #4 (Click on Link)
• Task #5 (Click on Link)

Jan. 21

Microsoft Excel: Lesson 1

Step-By-Step Exercises 1.1 ~ 1.11

Microsoft Excel: Lesson 2

Step-By-Step Exercises 2.1 ~ 2.10

Excel Projects:

**Don't forget FOOTERS**

• Page EX 23
• Project 1-3: (Properties Estimates)
• Page EX49
• Project 2-2: (Birds Census)
• Project 2-3: (Technology Shop)
• Project 2-4: (Wireless Bill Estimate) -- **PRINT ONLY THIS** (Print in Landscape if needed to fit on one page).
• UPLOAD ALL

Microsoft Excel: Lesson 2 (contd).

Microsoft Excel: Lesson 3

Step-By-Step Exercises 3.1 ~ 3.8

Excel Projects:

**Don't forget FOOTERS**

• Page EX 50
• Project 2-5: (TechSoft Balance Sheet)
• Page EX 76 - 78
• Project 3-4: (Inventory Purchase)
• Project 3-7: (Club Equipment) - **PRINT ONLY THIS** (Print in Landscape if needed to fit on one page).
• UPLOAD ALL

Microsoft Excel: Lesson 4

Step-By-Step Exercises 4.1 ~ 4.7

Excel Projects:

**Don't forget FOOTERS**

• Page EX 97
• Project 4-4: (Investment Record Updated)
• **PRINT ONLY THIS** (Print in Landscape if needed to fit on one page).

• Additional Files
• Use Computer/My Computer, enter the following address:
• ftp://ycflores.dyndns.org
• Username: CS151More
• Drag the folder to your folder on the Desktop.
• Complete the 2 Projects.
• Instructions are on the Worksheet.
• SAVE AS using the same name followed by your initials.
• Insert Footers.
• Upload the 2 projects when done into your Excel folder.
• UPLOAD ALL

Microsoft Excel: Lesson 5

Step-By-Step Exercises 5.1 ~ 5.6

Excel Projects:

**Don't forget FOOTERS**

• Page EX 116-118
• Project 5-2: (National Bank)
• Project 5-3: (Exam Scores)
• Project 5-4 (Part I Only): (Coyote Stats)
• Project 5-5: (Golf Tryouts)
• Project 5-6: (Xanthan Promotion) - **PRINT ONLY THIS** (Print in Landscape if needed to fit on one page).
• UPLOAD ALL

More Projects on Formulas & Functions.

• Use Computer/My Computer, enter the following address:
• ftp://ycflores.dyndns.org
• Username: CS151More2
• Drag Folder to your folder on the Desktop.
• Complete the 5 Projects
• Not in the Book, instructions are on the Worksheet.
• SAVE AS using the same name followed by your initials.
• Insert Footers.
• Upload the 5 projects into your Excel folder when you are done.

Excel Projects:

**Don't forget FOOTERS**

Not in the Book, instructions are on the Worksheet.

• 1Sweets_4_My_Sweet
• 2Global_Direct
• 3Degree_Completers
• 4MediaLoftAdvertising Expenses
• 5Morrison_Commission

UPLOAD ALL

Microsoft Excel: Lesson 8

Excel Projects:

**Don't forget FOOTERS**

• Page EX 198 - 199
• Project 8-5: (Cash Surplus)
• Project 8-6: (Study and Grades)
• Project 8-7: (Starburst Growth)
• Project 8-8: (Chico Temperatures) - **PRINT ONLY THIS** (Print in Landscape if needed to fit on one page).
• UPLOAD ALL

Microsoft Excel: Lesson 6

Microsoft Excel: Lesson 7

Excel Projects:

**Don't forget FOOTERS**

• Page EX 152
• Project 6-1: (Zoom Salaries)
• Page EX 171 - 172
• Project 7-2: (Vote Tally)
• Project 7-3: (Alamo Industries) - **PRINT ONLY THIS** (Print in Landscape if needed to fit on one page).
• UPLOAD ALL

**Wrap up Microsoft Excel**

Excel Test Review Topics:

**TEST PRACTICE **

• Use Computer/My Computer, enter the following address:
• ftp://ycflores.dyndns.org
• Username: CS151ExcelTestReview
• Drag Folder to your folder on the Desktop.
• 1, 2, 3 are NOT in the Book, instructions are on the Worksheet.
• Project 1, Project 4 is on Page EX202 ~ 206
  • Project 1: (Gas Sales)
  • Project 4: (CompNet Expenses)

**Excel Mastery TEST**

**Introduction to Microsoft Access**