Computer all concepts
Introduction to Computer Components
- Computer input and output device
- Functions
- Introduction to Computer system
- Motherboard and Its Functions
Introduction Windows Operating System
Computer basic and Software installation
- Introduction to the booting process.
- Introduction to various types of memories and their features.
- Basic Hardware and software issues and their solutions.
- Usage of Application software and Antivirus.
Introduction to DOS Command Line interface & Linux Operating Systems
- Introduction to basic DOS internal and External Commands.
- Introduction to Open Source Software.
- Introduction to Linux Operating System features, structure, files and processes.
- Basic Linux commands.
Word Processing Software
- Introduction to the various applications in MS office.
- Introduction to Word features, Office button, toolbars.
- Creating, saving and formatting and printing documents using word.
- Working with objects, macro, mail merge, templates and other tools in Word.
Spread Sheet Application
- Introduction to Excel features and Data Types.
- Cell referencing and linking Sheets.
- Introduction to various functions in all categories of Excel.
- Concept of Sorting, filtering and validating data.
- Analyzing data using charts, data tables, pivot tables, goal seek and scenarios.
Image editing and Presentations
- Introduction to Open Office.
- Introduction to the properties and editing of images.
- Introduction to different formats of images and their uses.
- Introduction to power point and its advantages.
- Creating Side Shows.
- Fine tuning the presentation and good presentation technique.
Database Management Systems
- Concept of Data & 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.
- Concept of DHCP 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 Modal.
- Overview of various Network protocols Viz. TCP/IP, FTP, Telnet etc.
- Concept of Logical and Physical Addresses, subnetting and classes of Networks.
Internet Concepts
- Introduction to www, Concept of internet, Web Browsers, internet servers and search engines.
- Concepts of Domain naming Systems and Email communication.
- Introduction to video chatting tools and Social Networking concepts.
Web Design Concepts
- Concepts of Static and Dynamic Web pages.
- Introduction to HTML and various tags in HTML.
- Concepts of different controls used in Web Pages.
- Concepts of CSS and applying CSS to HTML.
- Introduction to open source CMS viz, Joomla, Word press etc. and Web authoring tools viz. Kompozer, Front Page etc.
- concept of good web page designing techniques.
Introduction to JavaScript
- Introduction to Programming and Scripting Languages.
- Introduction to JavaScript and its application for the web.
- Introduction to Web Servers and their features.
- JavaScript Basic - Data types, Variables, Constants and Conversion between data types.
- Arithmetic, Comparison, Logical Operators in JavaScript. Operator precedence.
- Program Control Statements and loops in JavaScript.
- Arrays in JavaScript - concepts, types and usage.
- The String data type in JavaScript. Introduction to String, Math and Date.
- Introduction to Functions in JavaScript.
- Built in JavaScript functions overview.
- Concepts of Pop Up Boxes in JavaScript.
- Introduction to the Document Object Model.
- Concepts of using Animation and multimedia files in JavaScript.
Introduction to VBA, Features and Applications.
- Introduction to VBA features and applications.
- Properties, events and methods associated with the Button, Check Box, Label, Combo Box, Group Box, Option Button, List Box, Scroll Bar and Spin button controls.
- VBA Data types, Variables and Constants.
- Operators in VBA and operator precedence.
- Mathematical Expressions in VBA.
- Introduction to Arrays in VBA.
- Introduction to Strings in VBA.
- Conditional processing in VBA, using the IF, Else-if, Select Case Statements.
- Introduction to Loops in VBA.
- VBA message boxes and input boxes.
- Introduction to creating functions and procedures in VBA.
- Using the built in functions.
- Introduction to Object Oriented Programming Concepts. Concepts of Classes, Objects, Properties and Methods.
- The user forms and control in Excel VBA.
- Introduction to Debugging Techniques.
Using Accounting Software
- Basics of Accounting, Golden Rules of Accounting, Voucher Entry, Ledger Posting, Final Accounts Preparation.
- Cash Book. Ratio Analysis, Depreciation, Stock Management.
- Analysis of VAT, Cash Flow, Fund Flow Accounting.
- Introduction to Tally, features and Advantages.
- Implementing accounts in tally.
- Double entry system of book keeping.
- Budgeting Systems, Scenario management and Variance Analysis.
- Costing Systems, Concepts of Ratios, Analysis of financial statements.
- Inventory Basics, POS Invoicing, TDS, TCS, FBT, VAT & Service Tax.
- Tally Interface in different languages.
E Commerce concepts
- Introduction to E-Commerce and advantages.
- Building business on the net.
- Payment and Order Processing, Authorization, Chargeback and other payment methods.
- Security issues and payment gateways.
Cyber Security
- Overviews of information Security, SSL, Https, Security threats, information Security vulnerability and Risk management.
- Introduction to Directory Services, Access Control, Security, Privacy protection, Audit and Security.
- Introduction to IT Act and penalties for cyber crimes.
टिप्पणियाँ
एक टिप्पणी भेजें
If you have any doubt Please let me know.