Microsoft Office

Course Description:

This course provides an overview of microcomputer applications including Microsoft Windows 8, Microsoft Office 2013, Microsoft Word 2013, Microsoft Excel 2013, and Microsoft PowerPoint 2013. No experience with a computer is assumed, and no mathematics beyond the high school freshman level is required.

Course Outcomes:

The objectives of this offering are to:

To teach the fundamentals of Microsoft Windows 8, Microsoft Word 2013, Microsoft PowerPoint 2013, Microsoft Excel 2013, and Microsoft Outlook 2013.

  • To expose students to practical examples of the computer as a useful tool.
  • To acquaint students with the proper procedures to create documents, presentations, worksheets, and databases suitable for coursework, professional purposes, and personal use.
  • To help students discover the underlying functionality of Office 2013 so they can become more productive.
  • To develop an exercise-oriented approach that allows learning by doing.
  • Word chapter 1
    • Enter text in a Word document
    • Check spelling as you type
    • Format paragraphs
    • Format text
    • Undo and redo commands or actions
    • Change theme colors
    • Insert digital pictures in a Word document
    • Format pictures
    • Add a page border
    • Adjust spacing
    • Change document properties
    • Correct errors and revise a document
    • Print and read a document
  • Word chapter – 2
    • Describe the MLA documentation style for research papers
    • Modify a style
    • Change line and paragraph spacing in a document
    • Use a header to number pages of a document
    • Apply formatting using keyboard shortcuts
    • Modify paragraph indentation
    • Insert and edit citations and their sources
    • Add a footnote to a document
    • Insert a manual page break
    • Create a bibliographical list of sources
    • Cut, copy, and paste text
    • Find text and replace text
    • Find a synonym
    • Check spelling and grammar at once
    • Look up information
  • PowerPoint chapter – 1
    • Select and change a document theme and variant
    • Create a title slide and a text slide with a multilevel bulleted list
    • Add new slides and change slide layouts
    • Insert photos and illustrations into slides with and without content placeholders
    • Move and resize photos and illustrations
    • Change font size and color
    • Bold and italicize text
    • Duplicate a slide
    • Arrange slides
    • Select slide transitions
    • View a presentation in Slide Show view
    • Print a presentation
  • PowerPoint chapter 2
    • Search for and download an online theme
    • Insert and format pictures
    • Insert and size a shape
    • Apply effects to a shape
    • Add text to a shape
    • Change the text font
    • Insert and format WordArt
    • Insert a picture to create a background
    • Format slide backgrounds
    • Find and replace text and check spelling
    • Add and print speaker notes
  • Microsoft Excel chapter – 1
    • Describe the Excel worksheet
    • Enter text and numbers
    • Use the Sum button to sum a range of cells
    • Enter a simple function
    • Copy the contents of a cell to a range of cells using the fill handle
    • Apply cell styles
    • Format cells in a worksheet
    • Create a 3-D pie chart
    • Change a worksheet name and worksheet tab color
    • Change document properties
    • Preview and print a worksheet
    • Use the AutoCalculate area to display statistics
    • Correct errors on a worksheet
    • Microsoft Excel chapter 2
    • Enter formulas using the keyboard
    • Enter formulas using Point mode
    • Apply the MAX, MIN, and AVERAGE functions
    • Verify a formula using Range Finder
    • Apply a theme to a workbook
    • Apply a date format to a cell or range
    • Add conditional formatting to cells
    • Change column width and row height
    • Check the spelling on a worksheet
    • Change margins and headers in Page Layout view
    • Preview and print versions and sections of a worksheet
  • Outlook Chapter 1
    • Add a Microsoft account to Outlook
    • Set language preferences and sensitivity levels
    • Apply a theme
    • Compose, address, and send an email message
    • Open, read, print, and close an email message
    • Preview and save a file attachment
    • Display the People Pane
    • Reply to an email message
    • Check spelling as you type an email message
    • Attach a file to an outgoing email message
    • Forward an email message
    • Copy another person when sending an email message
    • Create and move messages into a folder
    • Delete an email message
    • View the mailbox size
  • Outlook Chapter – 2
    • Describe the components of the Outlook Calendar
    • Add a personal calendar to Outlook
    • Add a city to the calendar Weather Bar list
    • Navigate the calendar using the Date Navigator
    • Display the calendar in various views
    • Add national holidays to the default calendar
    • Enter, save, move, edit, and delete appointments and events
    • Organize your calendar with color categories
    • Set the status of and a reminder for an appointment
    • Import an iCalendar and view it in overlay mode
    • Schedule and modify events • Schedule meetings
    • Respond to meeting requests
    • Peek at a calendar
    • Print a calendar
    • Save and share a calendar


What you will receive:

Every student who completes the course will receive a certificate in “Understanding Microsoft Office”

 

 

Course Curriculum

Getting Started
Course Discussion
Microsoft Word – 1
Course Discussion
Microsoft Word Turtorial – Part 1
Microsoft Word
Overview
Microsoft Word – 2
Microsoft Word Turtorial – Part 2
Microsoft Word
Overview
Microsoft PowerPoint – 1
PowerPoint 2016 Tutorial – A Complete Tutorial on Using PowerPoint
Microsoft PowerPoint
Overview
Microsoft PowerPoint – 2
Microsoft PowerPoint
Overview
Microsoft Excel – 1
Excel Tutorial Part – 1
Microsoft Excel
Overview
Excel 1 Quiz
Microsoft Excel – 2
Excel Tutorial Part – 2
Microsoft Excel
Overview
Microsoft Outlook – 1
Microsoft Outlook 2013 and 2016 (Setup_Configure Options) – Part 1
Microsoft Outlook
Overview
Microsoft Outlook – 2
Microsoft Outlook 2013 and 2016 (Email, Contacts, Calendar, Tasks, Notes) – Part 2
Microsoft Outlook 2013 and 2016 (Read Receipts, Voting option, Rules, Quick Steps..) – Part 3
Microsoft Outlook
Overview

Source:http://www.nationalcybersecurityuniversity.net/courses/microsoft-office

Print Friendly

Leave a Reply