Skip to main content
DistrictCampusDirectory
CAMPUS

BIM 2 Honors - Lesson Plans 5th Six Weeks

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


 

Jennifer Leverett

Upcoming Events

Contact Jennifer Leverett

Classroom Number:
Com 1
School Phone:
903-737-2800
Conference Time:
5th Period (11:19 am - 12:06 pm)