BIM 2 Honors Lesson Plans & Assignments
for the 5th Six Weeks
Lesson Plans are subject to change
|
Week 23: 2-13-23 Objective: Students will be able to create charts, shapes, and templates in Microsoft Excel 2016 |
Week 24: 2-20-23 Objective: Students will be able to create macros and use data analysis tools with Microsoft Excel 2016 |
Week 25: 2-27-23 Objective: Students will be able to create macros and use data analysis tools with Microsoft Excel 2016 |
Week 26: 3-6-23 Objective: Students will be able to analyze data using Microsoft Excel 2016 |
Week 27: 3-20-23 Objective: Students will be able to analyze data using Microsoft Excel 2016 |
Week 28: 3-27-23 Objective: Students will be able to analyze data using Microsoft Excel 2016
|
Week 29: 4-3-23 Objective: Students will be able to Collaborate with others and prepare a final workbook for Distribution |
Monday |
ACTIVITY: Lesson 60 Working with Macors pg. 408-415 ASSIGNMENTS Lesson 60 Practice & Apply pg. 415-417 |
No School |
Chapter 8 Review |
ACTIVITY: Lesson 67 Working with Excel Tables pg. 470-476 ASSIGNMENTS Lesson 67 Practice & Apply pg. 476-477 |
ACTIVITY: Lesson 72 Linking workbooks pg. 517-519 ASSIGNMENTS Lesson 72 Practice & Apply pg. 520-521 |
ACTIVITY: Lessons 77 Working with the Excel Data Model pg. 557-561 ASSIGNMENTS Lesson 74 Practice & Apply pg. 562-563 |
ACTIVITY: Lessons 78 Tracking Changes pg. 572-578 ASSIGNMENTS Lesson 78 Practice & Apply pg. 578-579 |
Tuesday |
ACTIVITY: Lesson 61 Working with Logical Functions pg. 418-423 ASSIGNMENTS Lesson 61 Practice & Apply pg. 423-426 |
ACTIVITY: Lesson 64 Creating and Interpreting Financial Statements pg. 442-446 ASSIGNMENTS Lesson 64 Practice & Apply pg. 446-448 |
Chapter 8 Test |
ACTIVITY: Lesson 68 Using Get & Transform pg. 479-484 ASSIGNMENTS Lesson 68 Practice & Apply pg. 485 |
ACTIVITY: Lesson 73 Using PivotTables pg. 524-528 ASSIGNMENTS Lesson 73 Practice & Apply pg. 529-530 |
ACTIVITY: Chapter 8 Review |
ACTIVITY: Lessons 79 Ensuring Data Integrity pg. 582-588 ASSIGNMENTS Lesson 79 Practice & Apply pg. 588 |
Wednesday |
ACTIVITY: Lesson 62 Working with ddData and Time Functions pg. 427-431 ASSIGNMENTS Lesson 62 Practice & Apply pg. 431-434 |
ACTIVITY: Lesson 65 Creating Scenarios and Naming Ranges pg. 449-452 ASSIGNMENTS Lesson 65 Practice & Apply pg. 453-455 |
Chapter 8 Application test |
ACTIVITY: Lesson 69 Using Advanced Filters and Slicers pg. 489-494 ASSIGNMENTS Lesson 69 Practice & Apply pg. 494-495 |
ACTIVITY: Lessons 74 Manipulating PivotTable Data pg. 532-536 ASSIGNMENTS Lesson 74 Practice & Apply pg. 537-38 |
ACTIVITY: Chapter 8 Test |
ACTIVITY: Lessons 80 Protecting Data pg. 591-595 ASSIGNMENTS Lesson 80 Practice & Apply pg. 595 |
Thursday |
ACTIVITY: Lesson 63 Wokint with Absolute References and Using Financial Functions pg. 435-439 ASSIGNMENTS Lesson 63 Practice & Apply pg. 439-444 |
ACTIVITY: Lesson 66 Finding and Fixing Errors in Formulas pg. 456-460 ASSIGNMENTS Lesson 66 Practice & Apply pg. 461-463 |
Chapter 8 Application test |
ACTIVITY: Lesson 70 Using Database Functions pg. 499-504 ASSIGNMENTS Lesson 70 Practice & Apply pg. 505-506 |
ACTIVITY: Lessons35 Using PivotChart pg. 540-544 ASSIGNMENTS Lesson 74 Practice & Apply pg. 544-545 |
ACTIVITY: Chapter 8 Application test |
ACTIVITY: Lessons 81 Securing a Workbook pg. 5598-600 ASSIGNMENTS Lesson 81 Practice & Apply pg. 601 |
Friday |
Staff Development Day |
Finish All of Chapter 8 Practices |
Chapter 8 Application test |
ACTIVITY: Lesson 71 Using Flash Fill and Data Consolations pg. 509- 512 ASSIGNMENTS Lesson 71 Practice & Apply pg. 513 |
ACTIVITY: Lessons 76 Using Power Pivot and Power View pg. 548-553 ASSIGNMENTS Lesson 76 Practice & Apply pg. 554 |
ACTIVITY: Chapter 8 Application test |
Student Holiday |