18 12/8-12/12 Chapter 2: Formulas, Functions, Formatting EX 65 Apply Your Knowledge EX 122 Extend Your Knowledge EX 124 Lab 3: Stock Club Investment Analysis EX 133 19 12/15-12/19 Finals Week-Must have all previous assignments completed 20-21 1/6-1/16 Chapter 3: What-if Analysis Charting, and Working with Large Worksheets EX 137 Lab 2: Analysis of Indirect Expense Allocations EX 214 Lab 1: Six-Year Financial Projection EX 209 Textbook: Office 2010 Advanced Concepts and Techniques (Ch. 4 - 7) – 22 1/20-1/23 Chapter 4: Financial Functions, Data Tables, and Amortization Schedules EX 225 Lab 1: Mortgage Analysis and Amortization Schedule EX 286 Lab 2: Analyzing Retirement Savings EX 289 23 1/26-1/30 Chapter 5: Creating, Sorting, and Querying a Table EX 297 Cases and Places 2: Conditional Formatting and Sorting Table EX 360 Lab 1 Part 1, 2 & 3: a Master Sheet to Create a Multiple-Sheet Worksheet EX 415 24 2/2-2/6 Chapter 6: Working with Multiple Worksheets and Workbooks EX 361 Cases and Places 1: Analyzing Annual College Expenses and Resources EX 422 Lab 1 Part 1, 2 & 3: Using a Master Sheet to Create a Multiple-Sheet Worksheet EX 415 25 2/9-2/13 Chapter 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots EX 425 Lab 2: Inserting a Balance Chart & Image on a Worksheet EX 485 Textbook: Office 2010 Post-Advanced Concepts and Techniques (Ch. 8-9) 26 2/17-2/20 Chapter 8: Working with Trendlines, PivotTable Reports, PivotChart Reports, and Slicers EX 489 Lab 2: Creating Charts for Sports Departments EX 548 2/23-7/27 Chapter 9: Formula Auditing, Data Validation, and Complex Problem Solving EX 553 27 Lab 2: Finding the Optimal Production Combinations EX 619 28-30 3/2-3/27 Projects– See Mrs. Garrett See Mrs. G. 30 3/9-3/27 Brainbench Certification Post-Test MS Excel 2010 – Textbook: The Office 5e Procedures and Technology Assignment (located in your U:) All questions & answers are to be typed using correct grammar and spelling.
18 12/8-12/12 Chapter 2: Formulas, Functions, Formatting Apply Your Knowledge Extend Your Knowledge Lab 3: Stock Club Investment Analysis EX 65 EX 122 EX 124 EX 133 19 12/15-12/19 Finals Week-Must have all previous assignments completed 20-21 1/6-1/16 Chapter 3: What-if Analysis Charting, and Working with Large Worksheets Lab 2: Analysis of Indirect Expense Allocations Lab 1: Six-Year Financial Projection EX 137 EX 214 EX 209 Textbook: Office 2010 – Advanced Concepts and Techniques (Ch. 4 - 7) 22 1/20-1/23 Chapter 4: Financial Functions, Data Tables, and Amortization Schedules Lab 1: Mortgage Analysis and Amortization Schedule Lab 2: Analyzing Retirement Savings EX 225 EX 286 EX 289 23 1/26-1/30 Chapter 5: Creating, Sorting, and Querying a Table Cases and Places 2: Conditional Formatting and Sorting Table Lab 1 Part 1, 2 & 3: a Master Sheet to Create a Multiple-Sheet Worksheet EX 297 EX 360 EX 415 24 2/2-2/6 Chapter 6: Working with Multiple Worksheets and Workbooks Cases and Places 1: Analyzing Annual College Expenses and Resources Lab 1 Part 1, 2 & 3: Using a Master Sheet to Create a Multiple-Sheet Worksheet EX 361 EX 422 EX 415 25 2/9-2/13 Chapter 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots Lab 2: Inserting a Balance Chart & Image on a Worksheet EX 425 EX 485 Textbook: Office 2010 Post-Advanced Concepts and Techniques (Ch. 8-9) 26 2/17-2/20 Chapter 8: Working with Trendlines, PivotTable Reports, PivotChart Reports, and Slicers Lab 2: Creating Charts for Sports Departments EX 489 EX 548 27 2/23-7/27 Chapter 9: Formula Auditing, Data Validation, and Complex Problem Solving Lab 2: Finding the Optimal Production Combinations EX 553 EX 619 28-30 3/2-3/27 Projects– See Mrs. Garrett See Mrs. G. 30 3/9-3/27 Brainbench Certification Post-Test – MS Excel 2010 Textbook: The Office 5e Procedures and Technology Assignment (located in your U:) All questions & answers are to be typed using correct grammar and spelling.