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

Source: