COURSE OUTLINE

Module 1: Introduction to Computers and Windows Operating System

• Basic computer terminologies.
• What are the major physical components of the computer?

• File and Folders Management
• Create a shortcut to an often-used files and folders or application.
• Utilize the hard drive and other drives for file management.
• Use the Recycle Bin appropriately.

Module 2: Microsoft Word

• Introduction
• Starting Microsoft Word
• Quitting Microsoft Word
• File Management
• Creating A New Document
• Saving A Document in Microsoft Word
• Saving To Different Locations
• Opening An Existing Document
• Editing
• Moving around the Document
• Delete Text
• Selecting Text
• Move and Copy Text
• Checking Spelling and Grammar

• Document Enhancements

• Page and Document Attributes
• Introduction
• Document Views
• Custom Margins and Page Layout
• Page Numbers, Headers and Footers
• Page Breaks

• Tables and Styles
• Introduction
• Tables
• Columns
• Mail merge
• Graphics
• Introduction
• Drawing Bar
• Inserting Objects Vs Linking Objects
• Editing and Formatting Graphics
• Table Of Contents And Printing
• Introduction
• To compile a table of contents by using built-in heading styles:
• List of Figures
• Table of Index
• Printing

Module 3: Microsoft Excel

• Introduction
• Creating a Basic Worksheet
• Performing Calculations
• Modifying a Worksheet
• Formatting a Worksheet
• Printing Workbook Contents
• Data Analysis and Presentation
• Validating and Updating data
• Types of spread sheets
• Examples of spread sheets
• Advantages of electronic spread sheets
• Functions of spread sheets
• Applications of spread sheets
• Getting Started

• To launch Ms Excel 2003;
• Parts of Ms Excel Applications Window
• Features of microsoft excel
• Data entry in ms excel
• Types of formula
• Entering data in a cell
• Selecting data in a work sheet

• Formatting A Worksheet
• Auto formats
• Data reference

• Types of cell reference

• Editing a worksheet
• Functions and formula
• Calculation operators:
• Using various functions

• Data management functions
  • Goal seek
  • Sorting and filtering
  • Sorting
  • Filtering
  • Auto filter
  • Advanced filter
  • Subtotal
  • Data validation
• Microsoft excel charts and graphs
  • Steps of creating a chart
  • Types of charts
  • Creating a pivot table
  • Formatting charts
• Printing
  • Setting print area, page setup and passwords
  • Page setup and printing
  • Repeating titles in every page (column labels)
  • Print order/ print area
• Other functions
  • To protect your work book / work sheet
  • To protect a work book
  • Data forms
  • Errors values
  • Freeze pane
  • Split panes

Module 4: Microsoft Outlook

• How to use features of Outlook
• How to compose and organize your email
• How to work with contacts
• How to use calendar features
• How to do Outlook tasks

Module 5: Microsoft PowerPoint

• New Features of PowerPoint
• Creating presentations with PowerPoint
• Apply pre-production organizational concepts (such as storyboarding and visual organizers)
• Open and close a presentation or presentation template
• Save a presentation file
• Create an original presentation or use a template
• Rearrange slides using slide sorter or a storyboard feature to organize a presentation
• Choose a slide format

• Use icons and menus
• Type/enter text or create a text box
• Change (Font size, Font type, Style or effects, Color )
• Cut, copy, and paste text
• Use undo and redo icons
• Select and resize graphics, pictures, clip art
• Select multimedia clips or sounds
• Use page setup
• Print
• Use slide show tool
• Transitions and animations
• Graphics, clip art, sounds, and multimedia files (including narration)
• Modifying background and layout of presentation slides
• Use of spell check, grammar check, and thesaurus
• Use find, change, and replace tools
• Apply principles and elements of graphic design
• Use tools to rotate, edit, or highlight text
• Insert objects such as graphs, charts, and spreadsheets
• Insert hyperlinks
• Use print preview
• Print audience handouts to support a multimedia presentation
• Insert page/slide numbers
• Manage headers and footers
• Edit master slide(s)
• Adjust presentation timing, action buttons, and looping
• Import animations, sounds, and multimedia from other files/applications (such as background music and visual organizers)
• Create presentations using navigation buttons and non-linear design
• Work in various modes/views (such as outline, notes, and presentation)
• Use function keys and keyboard shortcuts
• Adjust page/slide views
• Troubleshoot formatting problems -- use Help feature
• Modify tool bars to reflect current use for tool(s)

Module 6: Microsoft Access

• How to create and design Access databases
• How to work with Access tables, relationships, keys and constraints
• How to query data
• How to manage and design interfaces with Access Forms
• How to create basic to advanced reports
• How to automate tasks with Macros and VBA

Module 7: Web Surfing

• Social Media Security
• Drop box
• Google Drive
• Emails

Module 8: Virus Control (Antivirus Management Techniques)

• Viruses
• Definitions
• Types of viruses
  • Software Bugs.
  • Trojan Horses.
  • Software Chameleons.
  • Software Bombs.
  • Logic Bombs.
  • Time Bombs.
• Classification Of Viruses
  • Resident viruses
  • Non-resident viruses
• Vectors and hosts
• History Of Viruses
• Ways in which a virus can infect a computer
• Different Approaches Of Dealing With Virus
  • Dictionary approach
  • Suspicious approach
  • Heuristic approach
  • Sandbox approach
  • File type approach
  • White listing approach

• Issues Of Concern
• Replication strategy
• Types of transmission media and files commonly targeted by viruses.
• Methods that viruses use to avoid detection
• Vulnerable computer spots
• Virus Detection
• What to do if infected

• Introduction to antivirus softwares
  • Types of antivirus softwares
  • How antivirus softwares work
  • Installing, managing, updating and using antivirus softwares
  • Preventive measures
  • Counter measures (user education)
  • Recovery methods
  • Policies that can be implemented to control virus risk in computers

Module 9: Social Media and Communication

• Social Media Skills and tricks
• Emails
• Conferencing facilities including Skype, Zoom, Hangout