Learning Outcomes

Upon successful completion of this course, the student will be able to:

• Identify the user interface components in Microsoft Office.
• Demonstrate creating, editing, saving, and printing data using MS Word, MS Excel, and MS PowerPoint.
• Demonstrate formatting and improving the appearance of documents, workbooks and presentations.
• Apply, modify, and create styles in MS Word.
• Insert, modify and format table layouts and design in documents, workbooks and presentations.
• Apply basic formulae and functions in MS Excel.
• Apply Relative, Absolute and Mixed cell references.
• Create, modify, and format charts.
• Analyze data using the Subtotalling tool in Excel.
• Create and summarize data with Pivot Tables and Pivot Charts in Excel
• Modify slide elements, apply themes, animation, and transitions in MS PowerPoint presentations.
• Insert and format graphic elements in documents and presentations.
• Define MS Access database terminology and components.
• Design, create and modify tables, forms, reports and queries in MS Access.
• Sort and filter data in MS Access and MS Excel.
• Integrate data between Microsoft Office applications by exporting, linking and embedding.

Effective as of Spring/Summer 2020