Monday, September 10

 

Essential Question:
How do I use Excel to create industry appropriate documents?
Key Questions:
How do I control the color and thickness of outlines and border? How do I assign a name to a cell and refer to the cell in formula using the assigned name? How do I deteremine the monthly payment of a loan using the financial function PMT? How do I use the financial functions PV (present value) and FV (future value)? How do I create a data table to analyze data in a worksheet? How do I add a pointer to a data table? How do I create anamortization schedule? How do I analyze worksheet data by changing values? How do I add a hyperlink to a worksheet element? How do I use name and the Set Print Area command to print sections of a worksheet? How do I set print options? How do I protext and unprotect cells in a worksheet? How do I use the formula checking features of Excel? How do I hide and unhide cell gridlines, rows, columns, sheets, and workbooks?
Activating Strategy:
Discuss new skills acquired from yesterday. Q&A if needed.
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 51-55
  • Students will Excel Project 4 - page 245-293 (e-Money Lenders Loan Payment Calculator)
  • Key your first and last name in cell B22 before printing!
  • Students will complete In the Lab 1 - page 297-299
  • This assignment creates two spreadsheets - Lab 4-1 Part 1 401(k) Planning Sheet and Lab 4-1 Part 2 401(k) Planning Sheet
  • Key your first and last name in cell B15 before printing!
  • Follow printing instructions
  • Due tomorrow at the end of class
Summarizing Strategy:

TOD: How do you set the print area?

Assessment:
Observation; grade completed work
Resources:
MS Excel, Office textbook
GPS:
BCS-CA2-1,3,6,8

Previous Lesson | Next Lesson
Back to Computer Applications II Calendar | Back to Miss Rock's Homepage

 

 


Computer Applications 1 | Computer Applications 2 | Business Communication & Presentation

Computing in the Modern World | Fundamentals of Web Design | Advanced Web Design

Syllabi | Schedule | Georgia Performance Standards | FBLA | Contact

Updated August 2012

 

Computer Applications 1 Computer Applications 2 Business Communication & Presentation Computing in the Modern World Fundamentals of Web Design Advanced Web Design Animation & 3-D Design