dd

Info. Tech Apps. II

Week 3

November 6-10

MONDAY-

  • Bell Ringer: Finish Lesson 5 Exam
  • G-Metrix Exam File
  • Amortization Schedule Project
    • College Car & Dream Car

ASSIGNMENT: UNIT Test CB 1-3 & Formuals File/ Amortization Schedule Project

TUESDAY-

  • Bell Ringer: Project Check Lesson 5
  • Amortization Project
  • LESSON 6 NOTES
  • Inserting Cells into a Worksheet 145
  • Manually Formatting Cell Contents 147
    • Changing Text Orientation 149
      Choosing Fonts and Font Sizes 150
      Changing Font Color 151
      Applying Special Character Attributes 152
      Filling Cells with Color 153
      Applying Number Formats 154
      Wrapping Text in a Cell 157
      Merging Cells and Splitting Merged Cells 158
      Placing Borders around Cells 159
      Copying Cell Formatting with the Format Painter 161
    • Understanding Paste Special Options 161
  • Lesson 6 Projects 6-1, 6-2, 6-3

ASSIGNMENT: Lesson 6 Projects 6-1, 6-3, 6-5, 6-6, Bingo Card Design

WEDNESDAY

  • Bell Ringer: Open Circling Back Project 1 (GRADE)
  • REVIEW: Lesson 6 Notes
    • Inserting Cells into a Worksheet 145, Manually Formatting Cell Contents 147
  • Formatting Cells with Styles 163
    Applying a Cell Style 163
    Customizing Cell Styles 164 Working with Hyperlinked Data 165
    Inserting a Hyperlink into a Worksheet 165
    Using a Hyperlink 166
    Removing a Hyperlink from a Worksheet 166
  • Applying Conditional Formatting to Cells 168
    Applying a Specific Conditional Format 168
    Applying Conditional Formatting for Multiple Criteria 169
    Using the Rules Manager to Apply Conditional Formats 169
    Clearing a Cell’s Formatting 171
  • Lesson 7 Projects 7-1 to 7-6

ASSIGNMENT:

THURSDAY-

  • Bell Ringer: Open 06 Regional Sales" Check Work!
  • Open Fine arts File - Review Lesson 6
  • Intro to Lesson 7 Formatting Worksheets
  • Lesson 7 Notes
    • Working with Rows and Columns 179
    • Using Themes 185
    • Modifying a Worksheet’s Onscreen and Printed Appearance 190
    • Inserting Headers and Footers 193
    • Preparing a Document for Printing 198
  • Begin Bingo Card Project
  • Lesson 7 Vocab Review (Kahoot)

ASSIGNMENT: Lesson 7 Projects 7-1 to 7-6

Assign: Bingo Cards G-Metrix Review Lessons 1-7

  • Bell Ringer: Lesson 8 Notes

  • Organizing Worksheets 210
    Copying a Worksheet 210
    Renaming a Worksheet 212
    Repositioning the Worksheets in a Workbook 213
    Changing the Color of a Worksheet Tab 214
    Hiding and Unhiding Worksheets 215
    Inserting a New Worksheet into a Workbook 216
    Deleting a Worksheet from a Workbook 217
    Working with Multiple Worksheets 218
    Working with Multiple Worksheets in a Workbook 218
    Hiding and Unhiding Worksheet Windows in a Workbook 220
    Workplace Ready: Ideas for Arranging Worksheets in Excel 221
    Using Zoom and Freeze to Change the Onscreen View 222
    Finding and Replacing Data 223
    Locating Data with the Find Command 223
    Replacing Data with the Replace Command 225

  • Work on Lesson 8 Projects 8-1, 8-2, 8-3, 8-4, 8-5, 8-6

Assign: Lesson 8 Projects 8-1, 8-2, 8-3, 8-4, 8-5, 8-6