Microsoft IT Academy

Week 1

August 16-19

Info. Tech Apps II - Excel

Academy - Access

TUESDAY-

  • Bell Ringer: Have a Seat
  • Attendance
  • Classroom Notes
  • Video
  • Seating Chart
  • Network Log-in
  • My Computer- Creating Folders
  • Setting up Default Printer/Folders Y:Drives
  • Getting Assignments K:Drive
  • Bookmarks Bar (Power School, Info. Tech Apps. II, G-Mail, (Start up Page)

WEDNESDAY-

  • Bell Ringer: Log in to 1. Network, 2.Gmail, Open Excel spreadsheet (Step-by-Steps pages 9-14)
  • Excel Lesson 1 Notes
  • Key Terms 1
  • Starting excel 3
  • Working in the excel window 4
  • Changing Excel’s View 9
  • Working with an Existing Workbook 14
  • Working with Excel’s Help System 19
  • Excel Lesson 2 Notes
    • Key Terms 27
    • Creating workbooks 29, Saving Workbooks 31, Organization File Conventions 32
    • Entering and Editing Basic Data in a Worksheet 38

FRIDAY

  • Bell Ringer: Complete Project 2-1
  • Open "Customers" - Review Lesson 1 & 2 Notes
  • Review Lesson 2 Notes / Con't L2
  • Using Data Types to Populate a Worksheet 43
  • Cutting, Copying, and Pasting Data 50
  • Editing a Workbook’s PROPERTIES 54
  • Complete Lesson 2 Projects 2-2 to 2-5

 

 

TUESDAY-

  • Bell Ringer: Have a Seat
  • Attendance
  • Classroom Notes
  • Video
  • Seating Chart
  • Network Log-in
  • My Computer- Creating Folders
  • Setting up Default Printer/Folders Y:Drives
  • Getting Assignments K:Drive
  • Bookmarks Bar (Power School, Info. Tech Apps. II, G-Mail, (Start up Page)

WEDNESDAY-

  • Bell Ringer: Log in
  • Complete Access Projects 2-1, 2-2, 2-3
  • Begin work on Lesson 3 Projects 3-1 to 3-5

 

FRIDAY

  • Bell Ringer: Project Check Lesson 2
  • Complete Access Lesson 3 Projects 3-1 to 3-6
  • Begin work on Lesson 4 Step-by-Steps Pages (94-106)

 

Friday