Thursday, September 13

 

Essential Question:
How do I use Excel to create industry appropriate documents?
Key Questions:
How do I locate and open exisiting workbooks? How do I insert worksheets into a workbook? How do I format worksheet tabs? How do I format cells? How do I modify cell alignment? How do I apply cell formats? How do I create and edit formulas using the Formula bar? How do I use VLOOKUP? How do create formulas using functions? How do I add protection to a worksheet?
Activating Strategy:
Fact of the Day: Americans spend more that 5.4 billion dollars on their pets each year.
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 56-60
  • Complete Vocab Quiz 2
  • If needed, students will complete yesterday's assignment. See yesterday's lesson plan for complete details
  • Students will complete Job 7-1 Create Payroll Worksheet for Salaried Employees - page 115-120 in IBP textbook (7-1 Payroll)
  • Students will complete Job 7-2 Update Payroll Workbook - page 122 in IBP textbook (7-2 Payroll)
  • Follow printing instructions to print both assignments
  • Due today at the end of class
Summarizing Strategy:

TOD: What is payroll?

Assessment:
Observation; grade completed work
Resources:
MS Excel, Integrated Business Projects 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