Info. Tech Apps. II

Week 6 - November 27-December 1

MONDAY-

  • Bell Ringer:Lesson 5 Formulas Review
  • Lesson 10 Advanced Formulas
  • Using Formulas to Conditionally Summarize Data 293
    Using SUMIF 293
    Using SUMIFS 296
    Using COUNTIF 297
    Using COUNTIFS 298
    Using AVERAGEIF 299
    Using AVERAGEIFS 300
    • Complete Step-by-Steps Pages 293-300)
  • Using Formulas to Look Up Data in a Workbook
    Using VLOOKUP /HLOOKUP
    • VLOOKUP /HLOOKUP Complete Step-by-Steps 301-305
Assign: Complete

TUESDAY-

  • Bell Ringer:Lesson 5 Formulas Review
  • Grade go over Fabrikam Sales Inc. WS (Step-by-Steps Pages 293-300)
  • Review: Lesson 10 Advanced Formulas
  • Adding Conditional Logic Functions to Formulas 306
    Using IF 307
    Using AND 308
  • Using Formulas to Modify Text 313
  • Complete Projects 10-1, 10-2
Assign: Projects 10-1, 10-2

WEDNESDAY-

  • Bell Ringer:Review Lesson 10 Notes
    • Creating your own Advanced Problems
  • Con't work on Lesson 10 Projects
  • 10-3 to 10-6

THURSDAY-

  • Bell Ringer: Lesson 11 Notes
  • Securing Your Work Before Sharing It with Others 329
  • Passwords and Security 333
  • Distributing a Workbook by Email and the cloud 339
  • Tracking Changes to a Workbook 344
    • Complete Lesson 11 Step-by-Steps 329-350
  • Securing Your Work Before Sharing It with Others 329
  • Passwords and Security 333
  • Distributing a Workbook by Email and the cloud 339
  • Tracking Changes to a Workbook 344
    • Complete Lesson 11 Step-by-Steps 329-350

Assign:Complete Projects Lesson 11 Step-by-Steps 329-350

FRIDAY-

Assign: Gather Data for Top 10 Chart