SECOND NINE Business Information Management II OUTLINE DATE / LECTURES ACTIVITIES ASSIGNMENTS Week 1 Chapter 1 Creating a Worksheet and Chapter Presentation and Formatting a Worksheet and an Embedded Chart Discussion Adding Additional Charts pg. Oct 17 -21 56-57 Excel Comprehensive Project SAM Modules Week 2 Chapter 1 Creating a Worksheet and Chapter Presentation and Lab 3: Projected College Cash an Embedded Chart Discussion Flow Analysis Worksheet pg. Oct 24 - 28 61-63 Excel Comprehensive Project SAM Modules Week 3 Chapter 2 Formulas, Functions, and Chapter Presentation and / Presentation: Strong vs. Formatting Discussion Weak Interview Behaviors Oct 31 Nov 4 – Excel Comprehensive Project SAM Modules Week 4 Chapter 2 Formulas, Functions, and Chapter Presentation and Applying Conditional Formatting Formatting Discussion to Cells pg. 124-125 Nov 7 -11 Lab 2: Sales Summary Nov 11th: Worksheet pg. 129-131 Veteran’s Day Holiday Excel Comprehensive Project Exam Review SAM Modules Week 5 Chapter 2 Formulas, Functions, and Chapter Presentation and Lab 2: Sales Summary Formatting Discussion Worksheet pg. 129-131 Nov 14 - 18 Excel Comprehensive Project SAM Modules Microsoft Excel Ch. 1-2 SAM Exam Week 6 No School No School No School Nov 21 Nov 25 – Thanksgiving Holiday Week Week 7 Chapter 3 What-If Analysis, Charting, Chapter Presentation and Understanding Logical Tests and Working with Worksheets Discussion and Absolute Cell Referencing Nov 28 Dec 2 – pg. 204-205 Lab 3: Modifying a Weekly
SECOND NINE Business Information Management II OUTLINE DATE / LECTURES ACTIVITIES ASSIGNMENTS Week 1 Oct 17 -21 Chapter 1 Creating a Worksheet and an Embedded Chart Chapter Presentation and Discussion Formatting a Worksheet and Adding Additional Charts pg. 56-57 Excel Comprehensive Project SAM Modules Week 2 Oct 24 - 28 Chapter 1 Creating a Worksheet and an Embedded Chart Chapter Presentation and Discussion Lab 3: Projected College Cash Flow Analysis Worksheet pg. 61-63 Excel Comprehensive Project SAM Modules Week 3 Oct 31 – Nov 4 Chapter 2 Formulas, Functions, and Formatting Chapter Presentation and Discussion / Presentation: Strong vs. Weak Interview Behaviors Excel Comprehensive Project SAM Modules Week 4 Nov 7 -11 Nov 11th: Veteran’s Day Holiday Chapter 2 Formulas, Functions, and Formatting Chapter Presentation and Discussion Exam Review Applying Conditional Formatting to Cells pg. 124-125 Lab 2: Sales Summary Worksheet pg. 129-131 Excel Comprehensive Project SAM Modules Week 5 Nov 14 - 18 Chapter 2 Formulas, Functions, and Formatting Chapter Presentation and Discussion Lab 2: Sales Summary Worksheet pg. 129-131 Excel Comprehensive Project SAM Modules Microsoft Excel Ch. 1-2 SAM Exam Week 6 Nov 21 – Nov 25 Thanksgiving Holiday Week No School No School No School Week 7 Nov 28 – Dec 2 Chapter 3 What-If Analysis, Charting, and Working with Worksheets Chapter Presentation and Discussion Understanding Logical Tests and Absolute Cell Referencing pg. 204-205 Lab 3: Modifying a Weekly
Second_Nine_Weeks_Outline.docx