National Cyber Security Training Academy

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

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.
• 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 
  • 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 

  • 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 

  • 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 

  • 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 
  • 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
  • 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"