Microsoft IT Academy

Week 2

August 22-26

 

Info. Tech Apps II - Excel

Academy - Access

MONDAY-

  • Bell Ringer: Open "Customers" Lesson 2 (Review L1 & L2)
  • Excel Lesson 3 Notes
    • Printing with Backstage 64
      Printing and Previewing a Document 64
      Using Quick Print to Print a Worksheet 66
      Setting the Print Area 67
      Printing Selected Worksheets 68
      Printing Selected Workbooks 70
      Applying Printing Options 71
      Changing a Printer
    • LESSON 4 STEP-BY-STEPS 92-99

WEDNESDAY-

  • Bell Ringer: Log in to 1. Network, 2.Gmail, Open Excel spreadsheet (Step-by-Steps pages 9-14)
  • Excel Lesson 4 Notes
    • Understanding and Displaying Formulas 92
      Understanding Order of Operations 93
      Building Basic Formulas 94
      Creating a Formula that Performs Addition 95
      Creating a Formula that Performs Subtraction 95
      Creating a Formula that Performs Multiplication 96
      Creating a Formula that Performs Division 96
    • Using Cell References in Formulas 97
      Using Relative Cell References in a Formula 97
      Using Absolute Cell References in a Formula 98
    • Using Mixed Cell References in a Formula 100
      Using External Cell References 101
      Using Cell Ranges in Formulas 103
      Naming a Range 103
      Using the New Name dialog box to name a range 104
      Changing the Size of a Range 106
      Creating a Formula that Operates on a Named Range 107
      Keeping Track of Named Ranges 108
  • COMPLETE LESSON 4 STEP-BY-STEPS 100-108

FRIDAY

  • Bell Ringer: Open Bowling File (Review Lesson 4)
  • Complete Lesson 4 Projects, 4-1, 4-2, 4-3, 4-4, 4-5.

 

 

MONDAY-

  • Bell Ringer: Project Check Lesson 3
  • Con't work on Lesson 4 Step-by-Steps (Pages 94-106)
  • Validation Rules Complete Step-by-Steps (Pages 107-119)
  • Lesson 4 Projects 4-1 to 4-6

WEDNESDAY-

  • Bell Ringer: Project Check Lesson 4
  • Complete Lesson 4 Projects 4-1 to 4-6
  • Begin work on Lesson 5 FORMS Step-by-Steps Pages (127-146)

 

FRIDAY

  • Bell Ringer: Con't Work On Lesson 5 Step-by-Steps Pages 127-146
  • Complete Access Lesson 5 Projects 5-1 to 5-6

 

Friday