Info. TechApps. II Week 1

October 24-27

TUESDAY-

  • Bell Ringer: Have a Seat
  • Attendance
  • Classroom Notes
  • Video
  • Seating Chart
  • Network Log-in
  • GMail
    • Account Log in
    • Passwords
    • Google Docs
  • 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)
  • 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

ASSIGNMENT:

WEDNESDAY-

  • Bell Ringer: Log in to 1. Network, 2.Gmail, Open Excel spreadsheet (Step-by-Steps pages 9-14)
  • WINDOWS 7 VIDEO
  • About Me Document
  • Review Windows 7 Terms
  • Windows 7 Terms
  • 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
  • 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-1 to 2-5

ASSIGNMENT: Windows 7 Terms , Projects 2-1 to 2-5

THURSDAY-

  • Bell Ringer: Review: Windows 7 Term Quiz
  • Review Lesson 2 Notes - Open Data File
  • 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
    • Changing the Excel Environment 75
      Customizing the Quick Access Toolbar 75
      Customizing the Ribbon 77
      Customizing the Excel Default Settings 79
      Resetting Default Settings, the Ribbon, and Quick Access Toolbar 81
    • Accessing and Using Excel Templates 81
    • Complete Lesson 3 Projects
ASSIGNMENT: Lesson 3 Projects 3-1 to 3-6 Windows 7 Terms

FRIDAY

  • Bell Ringer: Go over Projects
  • Review Lesson 3 Notes
      • Project Check
  • 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
  • Con't Lesson 4 Notes
    • Using Cell References in Formulas 97
      Using Relative Cell References in a Formula 97
      Using Absolute Cell References in a Formula 98
    • Complete Lesson 4 Step-by-Steps pages 92-109

ASSIGNMENT: Excel Lesson 4 Step-by-Steps