Monday

Bell Ringer

Copy the chapter 11folder from the K drive to your drive if you have not. We will need the Spectactular Shows Forecast worksheet that was not there before today for the worksheet we are working on in class. Do not overwrite any work you have already completed.

 

Objectives

1. Use a choose function in Excel
2. Use a vlookup function in Excel
3. Name a range or block of cells in Excel

Agenda

• Worksheet 11.1 - choose function, vlookup function
• Work on chapter 11 questions and exercises
• Closure

Assignments:

Microsoft Office Chapter 11

Tuesday

Bell Ringer

Open the Loan.xls worksheet from practice 7 of chapter 11.

 

Objectives

1. Create an amortization table
2. Use an amortization table to understand a periodic loan
3. Find a car on the internet
4. Compare different interest rates and terms in a loans

Agenda

• Create the amortization table
• Car assignment
  • Dream car - no maximum - use 4% for 6 years
  • Reality Car - $8000 maximum - use 8% for 4 years
• Example -
• Worksheet starter
• Dream worksheet
• Completed Example
• Closure

Assignments:

Microsoft Office Chapter 11

Wednesday

Bell Ringer

Update your Stock portfolio

Objectives

1. Use the business functions PMT, FV, PV, and NPER in Excel
2. Answer what if questions using a spreadsheet application

Agenda

• Update stock portfolio
• Work on chapter 11
• Worksheet 11.2
• Business Worksheet chapter 11
• Closure

Assignments:

Microsoft Office Chapter 11

Thursday

Bell Ringer

Use an amortization table to answer the following questions.

1. What would be the monthly payment on a car loan of $15,000 financed at 8% for 5 years.
2. How much interest would you pay?
3. How much would you owe the bank after making payments for 2 years?
4. How much of your first payment would go to interest?

Objectives

1. Use the business functions PMT, FV, PV, and NPER in Excel
2. Answer what if questions using a spreadsheet application

Agenda

• Bell Ringer
• Business Worksheet
• Quiz 11
• Check chapter 11 exercises
• Study for chapter 11 Exam - friday

Assignments:

Microsoft Office Chapter 11

Friday

Bell Ringer

Chapter 11 Quiz

Objectives

1. Use the business functions PMT, FV, PV, and NPER in Excel
2. Answer what if questions using a spreadsheet application

Agenda

• Bell Ringer - Quiz
• Finish chapter 11 and check answers to exercises, print off questions
• If done with chapter 11 you can work o the photoshop elements tutorials
  • http://www.photoshopelementsuser.com/tutorials/index.php
  • http://www.photoshoproadmap.com/Photoshop-tutorials/Photoshop-Elements-tutorials

Assignments:

Microsoft Office Chapter 11

Back to Computer 4 main page

Back to SHS main page