LOGO

MS-Office -Syllabus

Basic Computer Concepts

  1. Introduction
    • What is a Computer
      Software and Hardware
      Hardware Components
      Hardware Accessories
      Operating System Software
      Software Applications
  2. Working with Computers
    • Computer Terminology
      Starting and Stopping the Computer
      Using the Mouse
  3. Computer Tools & Utilities
    • Disk Utilities
      Files & Directories
      Manipulating Files & Folders
      Working with the Windows Environment
  4. Computer Network
    • LAN
      Internet
      E-Mail
      Browsers, E-Mail Clients
  5. Installation of MS Office Software

MS Word

  1. Introduction
    • Introduction to MSWord
      Menus
      Shortcuts
      Document types
  2. Working with Documents
    • Opening Files – New & Existing
      Saving Files
      Formatting page and Setting Margins
      Converting files to different formats
        Importing
        Exporting
        Sending files to others

      Editing text documents
        Inserting
        Deleting
        Cut, Copy, paste
        Undo, Redo
        Find, Search, Replace

      Using Tool bars, Ruler
      Using Icons
      Using help
  3. Formatting Documents
    • Setting Font Styles
        Font selection – style, size, color etc.,
        Type face – Bold Italic, underline
        Case settings
        Highlighting
        Special symbols

      Setting Paragraph style
        Alignments
        Indents
        Line space
        Margins
        Bullets and Numbering

      Setting Page Style
        Formatting
        Border & Shading
        Columns
        Header & footer
        Setting Footnotes
        Inserting manual Page break, Column break and line break.
        Creating sections and frames
        Inserting Clip arts, pictures, and other files
        Anchoring & Wrapping

      Setting Document Styles
        Table of Contents
        Index
        Page Numbering, data &Time, Author etc.,
        Creating Master Documents
        Web page
  4. Creating Tables
    • Table settings
      Borders
      Alignments
      Insertion, deletion
      Merging
      Splitting
      Sorting
      Formula
  5. Drawing
    • a. Inserting Pictures/Files etc.,
      Drawing Pictures
      Formatting &Editing pictures
      Grouping and ordering
      Rotating
  6. Tools
    • Word Completion
      Spell Checks
      Macros
      Mail merge
      Templates
      Using Wizards
      Tracking Changes
      Security
  7. Printing Documents
    • Printing Documents

MS Excel

  1. Introduction
    • Spreadsheet & its Applications
      Opening spreadsheet
      Menus & Toolbars & icons
      Shortcuts
      Using help
      Shortcuts
  2. Working with Spreadsheets
    • Opening a File
      Saving Files
      Setting Margins
      Converting files to different formats
        Importing, Exporting and Sending files to others

      Spreadsheet addressing
        Rows, Columns & Cells,
        Referring cells and Selecting cells

      Entering and Editing Data
        Entering Data
        Cut, Copy, paste, Undo, Redo, Find, Search & Replace
        Filling continuous rows, columns
        Inserting - Data, cells, column, rows & sheets
        Manual breaks

      Computing data
        Setting Formula
        Finding total in a column or row
        Mathematical operations (Addition, Subtraction, Multiplication, Division, Exponentiation)
        Using other Formulas
  3. Formatting Spreadsheets
    • Formatting – Cell, row, column & Sheet
        Alignment, Font, Border &shading
        Highlighting values
        Hiding/Locking Cells

      Worksheet
        Sheet Name
        Row & Column Headers
        Row Height, Column Width
        Visibility – Row, Column, Sheet
        Security

      Formatting – worksheet
        Sheet Formatting & style - background, color , Borders & shading

      Anchoring objects
      Formatting layout for Graphics, Clipart etc.,
  4. Working with sheets
    • Sorting
      Filtering
      Validation
      Consolidation
      Subtotal
  5. Creating Charts
    • Selecting charts
      Formatting charts, label, scaling etc.,
  6. Using Tools
    • Error Checking
      Spell Checks
      Macros
      Formula Auditing
      Creating & using Templates
      Tracking Changes
      Customization
  7. Printing worksheet

MS Power Point

  1. Introduction
    • Opening new Presentation
      Different presentation templates
      Setting backgrounds
      Selecting presentation layouts
  2. Creating a presentation
    • Setting presentation style
      Adding Text to the presentation
  3. Formatting a presentation
    • Adding style
      Color, gradient fills
      Arranging objects
      Adding Header & Footer
      Slide Background
      Slide layout
  4. Adding Graphics to the presentation
    • Inserting pictures, movies, tables, etc into the presentation
      Drawing Pictures using Draw
  5. Adding effects to the presentation
    • Setting Animation & transition effect
      Adding audio and video
  6. Printing Handouts
  7. Generating standalone presentation viewer

MS Access

  1. Introduction
    • Database concepts
      Tables
      Queries
      Forms
      Reports
  2. Opening & Saving database files
    • Creating Tables
      Table Design
      Indexing
      Entering data
      Importing data
  3. Creating Queries
    • SQL statements
      Setting relationship
      Using wizards
  4. Creating Forms
    • GUI
      Form
  5. Creating & printing reports
Back