Microsoft Office Cutting, copying, and pasting data Editing a workbook’s keywords Academy Course (MOAC) Saving the Workbook Microsoft IT Academy Inserting and deleting cells MOAC Excel Chapter 4: Formatting Microsoft Office Manually formatting cell contents Cells and Ranges Copying cell formatting with the format painter Academy Course (MOAC) Formatting cells with styles Working with hyperlinked data Applying conditional formatting to cells Clearing a cell’s formatting CCStandards: Integrate and evaluate content presented CCS 1, 2, 3, 7 SLE 9.9.8 5th Article Summary in diverse formats and media. Due SLE Standard Comprehension SLE 9.10.7 Students shall apply a variety of strategies to read and SLE 9.11.6 comprehend printed material SLE 9.12.7 Microsoft IT Academy Working with rows and columns MOAC Excel Chapter 5: Formatting Microsoft Office Using themes worksheets Academy Course Modifying a worksheets onscreen and printed appearance (MOAC) Inserting headers and footers Preparing a document for printing Microsoft IT Academy Organizing worksheets MOAC Excel Chapter 6: Managing Microsoft Office Working with multiple worksheets worksheets Academy Course Using zoom and freeze to change the onscreen view (MOAC) Finding and replacing data Microsoft IT Academy Ensuring your data’s integrity MOAC Excel Chapter 7: Working with Microsoft Office Sorting data Data Academy Course Filtering data (MOAC) Subtotaling data Setting up data in a table format Microsoft IT Academy Building Basic Formulas MOAC Excel Chapter 8: Using Basic Microsoft Office Using cell references in formulas Formulas and Functions Academy Course Using cell ranges in formulas (MOAC) Summarizing data with functions Using formulas to create subtotals Controlling the appearance of formulas
Microsoft Office Academy Course (MOAC) Cutting, copying, and pasting data Editing a workbook’s keywords Saving the Workbook Microsoft IT Academy Microsoft Office Academy Course (MOAC) Inserting and deleting cells Manually formatting cell contents Copying cell formatting with the format painter Formatting cells with styles Working with hyperlinked data Applying conditional formatting to cells Clearing a cell’s formatting MOAC Excel Chapter 4: Formatting Cells and Ranges 5th Article Summary Due CCStandards: Integrate and evaluate content presented in diverse formats and media. SLE Standard Comprehension Students shall apply a variety of strategies to read and comprehend printed material CCS 1, 2, 3, 7 SLE 9.9.8 SLE 9.10.7 SLE 9.11.6 SLE 9.12.7 Microsoft IT Academy Microsoft Office Academy Course (MOAC) Working with rows and columns Using themes Modifying a worksheets onscreen and printed appearance Inserting headers and footers Preparing a document for printing MOAC Excel Chapter 5: Formatting worksheets Microsoft IT Academy Microsoft Office Academy Course (MOAC) Organizing worksheets Working with multiple worksheets Using zoom and freeze to change the onscreen view Finding and replacing data MOAC Excel Chapter 6: Managing worksheets Microsoft IT Academy Microsoft Office Academy Course (MOAC) Ensuring your data’s integrity Sorting data Filtering data Subtotaling data Setting up data in a table format MOAC Excel Chapter 7: Working with Data Microsoft IT Academy Microsoft Office Academy Course (MOAC) Building Basic Formulas Using cell references in formulas Using cell ranges in formulas Summarizing data with functions Using formulas to create subtotals Controlling the appearance of formulas MOAC Excel Chapter 8: Using Basic Formulas and Functions
cba_curriculum_map_for_moac3.docx