Introduction to Computers and Windows Operating System

• History,Generations, Types, Advantages and Applications of Computers.
• Concepts of Hardware and Software. Computer Hardware basics.
• Introduction to various processors.
• Introduction to the functions of an Operating System, Popular Operating Systems in Use.
• Main features of Windows O.S
• Various Input/ Output devices in use and their features.
• Using Scanner, Printer and Webcam

 

Computer Hardware basics and Software Installation

• Introduction to the booting process, BIOS settings and their modification.
• Introduction to various types of memories and their features.
• Basic Hardware and software issues and their solutions.
• Formatting and Loading O.S and Application software and Antivirus.

 

Introduction to DOS Command Line Interface & Linux Operating System.

• Introduction to basic DOS Internal and External Commands.
• Introduction to Open Source Software.
• Introduction to Linux Operating System features, structure, files and processes.
• Introduction to various Linux Shells.
• Basic Linux commands.

 

Word Processing

• Introduction to the various applications in office.
• Introduction to Word features, Office button, toolbars.
• Creating, saving and formatting and printing documentsusing Word.
• Working with inserting objects, macro, mail merge, templates and other tools in Word.
• Page setup and Printing Documents using word.

 

Spread Sheet Application

• Introduction to Excel features and Data Types.
• Cell referencing. Use of functions of various categories, linking Sheets.
• Introduction to various functions in all categories of Excel.
• Concepts of Sorting, Filtering and Validating Data.
• Analyzing data using charts, data tables, pivot tables, goal seekingand scenarios.
• Introduction to Reporting.

 

Image editing, Creating presentations & Using Open Office

• Introduction to Open Office.
• Introduction to the properties and editing of images.
• Introduction to Power Point and its advantages.
• Creating Slide Shows.
• Fine tuning the presentation and good presentation techniques.

 

Database Management Systems

• Concepts of Data, Information and Databases. Overview of popular databases, RDBMS, OODB and NOSQL.
• Rules for designing good tables. Integrity rules and constraints in a table.
• Relationships in tables.
• Introduction to various types of Queries and their uses.
• Designing Access Reports and Forms.
• Introduction to macros, designer objects controls, their properties and behavior.

 

Networking Concepts

• Introduction to Computer Networks, Necessity and Advantages.
• Client Server and peer to Peer networking concepts.
• Concept of Proxy Server and proxy firewall server.
• Network topologies. Introduction to LAN, WAN and MAN.
• Network components, viz. Modem, Hub, Switch, Router, Bridge, Gateway etc.
• Network Cables,Wireless networks and Blue Tooth technology.
• Concept of ISO - OSI 7 Layer Model.
• Overview of various Network protocols Viz. TCP/IP, FTP, Telnet etc.
• Logical and Physical Addresses, Classes of Networks.
• Network Security &firewall concepts.
• Concept of DHCP Server
•  

Internet Concepts

• Introduction to WWW, Concept of Internet, Web Browsers, internet servers and search engines.
• Concepts of Domain naming Systems and E mail communication.
• Introduction to video chatting tools, VOIP and Social Networking concepts.
• Concept of Cloud storage and Open Web Server.
• Introduction to Internet Security, Threats and attacks, Malicious Software types, Internet security products and their advantages.

 

Web Design Concepts

• Concepts of Static and Dynamic Web pages.
• Introduction to HTML and various tags in HTML.
• Creating Forms with controls using HTML.
• Concepts of CSS and applying CSS to HTML
• Introduction to open source CMS viz,. Joomla, Wordpress etc. and Web authoring tools viz. Kompozer,FrontPageetc.