BIM 2 Honors Lesson Plans & Assignments
for the 4th Six Weeks
Lesson Plans are subject to change
|
Week 17: 1-2-23 Objective:
Students will be able to manage large workbooks in Microsoft Excel 2016 |
Week 18: 1-9-23 Objective:
Students will be able to manage large workbooks in Microsoft Excel 2016 |
Week 19: 1-16-23 Objective: Students will be able to create charts, shapes, and templates in Microsoft Excel 2016 |
Week 20: 1-23-23 Objective: Students will be able to create charts, shapes, and templates in Microsoft Excel 2016 |
Week 21: 1-30-23 Objective: Students will be able to create charts, shapes, and templates in Microsoft Excel 2016 |
Week 21: 2-6-23 Objective: Students will be able to create macros and use data analysis tools with Microsoft Excel 2016 |
Monday |
Teacher Workday |
ACTIVITY:
Lesson 51 Customizing Data pg. 326-331 ASSIGNMENTS: Lesson 51 Practice and Apply pg. 332-334 |
School Holiday MKL Day |
ACTIVITY: Lesson 56 Drawing and Positioning Shapes pg. 373-376 ASSIGNMENTS: Lesson 56 Practice & Apply pg. 376-378 |
ACTIVITY: Chapter 7 Review |
ACTIVITY: Lesson 62 Working with ddData and Time Functions pg. 427-431 ASSIGNMENTS Lesson 62 Practice & Apply pg. 431-434 |
Tuesday |
ACTIVITY: Lesson 47 Customizing the Excel Interface and Converting Text pg. 288-292 ASSIGNMENTS: Lesson 47 Practice and Apply |
ACTIVITY: Excel Chapter 6 Review |
Staff Development |
ACACTIVITY: Lesson 57 Formatting Shapes pg. 379-381 ASSIGNMENTS: Lesson 57 Practice & Apply pg. 382-383 |
ACTIVITY: Chapter 7 Test
|
ACTIVITY: Lesson 63 Wokint with Absolute References and Using Financial Functions pg. 435-439 ASSIGNMENTS Lesson 63 Practice & Apply pg. 439-444 |
Wednesday |
ACTIVITY: Lesson 48 Formatting Cells pg. 296-300 ASSIGNMENT: Lesson 48 Practice and Apply pg. 300-303
|
ACTIVITY: Excel Chapter 6 Test
|
ACTIVITY:
Lesson 52 Formatting Chart Elements pg. 342-346 Lesson 53 Formatting the Value Axis pg. 349-354 ASSIGNMENTS Lesson 52 Practice and Apply pg. 346-348 Lesson 53 Practice & Apply pg. 354-357 |
ACTIVITY: Lesson 58 Enhancing Shapes with Text and Effects pg. 384-388 ASSIGNMENTS Lesson 58 Practice & Apply pg. 389-390 |
ACTIVITY: Chapter 7 Application Test |
ACTIVITY: Lesson 64 Creating and Interpreting Financial Statements pg. 442-446 ASSIGNMENTS Lesson 64 Practice & Apply pg. 446-448 |
Thursday |
ACTIVITY: Lesson 49 Applying cConditional Formatting and International Settings pg. 304 - 312 ASSIGNMENTS: Lesson 49 Practice and Apply pg. 313-315 |
ACTIVITY: Application Test
|
ACTIVITY: Lesson 54 Creating Stacked Area Charts pg. 358-362 ASSIGNMENTS Lesson 54 Practice & Apply pg. 363-367 |
ACTIVITY: Lesson 59 Working with Templates pg. 391-396 ASSIGNMENTS Lesson 59 Practice & Apply pg. 397-400 |
ACTIVITY: Lesson 60 Working with Macors pg. 408-415 ASSIGNMENTS Lesson 60 Practice & Apply pg. 415-417 |
ACTIVITY: Lesson 65 Creating Scenarios and Naming Ranges pg. 449-452 ASSIGNMENTS Lesson 65 Practice & Apply pg. 453-455 |
Friday |
ACTIVITY: Lesson 50 Customizing Styles and Themes pg. 316-322 ASSIGNMENTS: Lesson 50 Practice and Apply pg. 322-325 |
ACTIVITY: Chapter 7 Vocabulary |
ACTIVITY: Lesson 55 Working with Sparklines and Trendlines pg. 366-369 ASSIGNMENTS Lesson 55 Practice & Apply pg. 370-372 |
ACTIVITY: Application test |
ACTIVITY: Lesson 61 Working with Logical Functions pg. 418-423 ASSIGNMENTS Lesson 61 Practice & Apply pg. 423-426 |
ACTIVITY: Lesson 66 Finding and Fixing Errors in Formulas pg. 456-460 ASSIGNMENTS Lesson 66 Practice & Apply pg. 461-463 |