BASIC COMPUTER COURSE

MS-WORD- Microsoft Word or MS Word is a graphical word processing program that users can type with. It is made by the computer company Microsoft.

MS-EXCEL-MS Excel is a commonly used Microsoft Office application. It is a spread sheet program which is used to save and analyse numerical data.

MS-POWER POINT-PowerPoint is a presentation software that enables users to create engaging presentations that consist of individual pages, or slides, which may contain text, graphics, sound, movies, hyperlinks, and other objects. 

WHOLE BASIC COMPUTR SYLLABUS

Introduction of Computer

1. Paint

2. Notepad

  • Instructions for maintaining typing speed
  • Find, Replace and Go to commands
  • Formatting of text size and text styles

3. Wordpad

      • Menu tab
      • Font styles and size setup
      • Paragraph alignment and indent setting
      • Insert dialogue box

4. Additional important tools

    • Folder creation, setup, deletion 
    • Run command
    • Calculator
    • Recycle bin
MS-WORD
  1. Startup of MS-Word
  2. Formatting of text and paragraph
  3. Adding a table and formats
  4. Formation of documentation
  5. Graphics and pictures effects
  6. Graphics and visualization of data
  7. Page appearance setup
  8. References and Mailings
  9. Reviewing documents
  10. Practical work on MS-Word
MS-EXCEL
  1. Introduction of Excel
  2. Formats of cells
  3. Conditional formatting with rules and colors
  4. Working with cells
  5. Protection excel data
  6. Working with charts
  7. Formulae
      • Sum of entire cells, particular cells
      • Subtraction , multiplication and division
      • Average formula, rank
      • Conditional formulae
      • Mark sheet creation
      • Payroll sheet creation
      • Countif and sumif
      • Countifs and sumifs with multiple conditions
      • Lookup, vlookup and hlookup formulas 
      • Fixing of formulae 
      • Pmt (per month installment calculation)
      • Simple interest calculation
      • Running total
      • Text formula
      • Concatenate formula
      • Round formulae

        8. Worksheets

        9. Bills created with GST

       10. Attendance sheet format

MS-POWER POINT
  1. Presentation creation
  2. Graphics effects
  3. Creation and
  4. modifying of
  5. charts and
  6. smartarts
  7. Templates themes and layouts
  8. Custom Design templates
  9. Modify objects
  10. Tables
  11. Animation and transitions
  12. Setting up the slides show

BASIC COMPUTER COURSE

Every day we use computers for all kinds of purposes. It’s now necessary for all of us to get familiar with the basics of computers.