Introduction to Computers and Windows Operating System

Computer: An introduction

History of computer

Computer generation

Computer in india

Types of computers

Advantages of computers

Applications of computers

Limitations of computers

Computer hardware, software, a firmware

Introduction to various processors

Introduction of operating system

Windows operating system

Hardware

Input devices

Output devices

Computer Hardware and Software Installation

Introduction of computer hardware and software

Anatomy of computer

Booting

Bios setting

Memory

First aid maintenance

Trouble shooting

Formatting and loading OS

Virus and antivirus

Introduction of DOS and Linux OS

Introduction of desk operating system/DOS

Introduction to open source software

Linux operating system

Components of linux OS

Shell

Basic linux commands

MS Word

Introduction of MS word

Features/Characteristics of MS word

System requirement for MS word

Loading of MS word

Parts of Ms word window

Different menu in MS word 2003

Cursor movement keys and shortcut keys in MS word

Ms word practical work

Create macro

Special effects in text

Creating drop cap

Inserting book mark

Mail merge

MS Excel

Introduction of MS excel

Features of MS excel

Workbook and worksheet

Loading MS excel

Parts of excel windows

Menu bar in excel

Cursor movement, shortcut and function keys

Making entries in worksheet

Data editing

Function in Microsoft excel

Operators

Charts in MS excel

MS excel practical work

Printing

Deletion

Move or copy worksheet

Merge cells

Changing column width and row height

Insert blank cells, rows or columns

Hide/unhide of row/column

Cut, copy and paste

Delete the contents of cells row columns

Clear cell formats or contents

Add numbers using autosum

Formatting worksheet

Limitations of worksheet protection

Charts

Sort the records

Autofilter the data list

Pivot table

Report

Open Office and Power Point

Open office

Power points

Database Management System

Concept of data, information and database

Database management system/ DBMS

Overview of popular databases : RDBMS, OODB and NOSQL

Rules for designing good tables

Integrity rules and constrains in a table

Relationship in tables

Introduction to various types of queries and their uses

Commands uses in SQL

MS access

Features of MS access

Important units used in database management

Start Microsoft access

Design database by using wizard

Create database by design view

Creative table by design view

Shortcut keys used in MS access

Designing accesses reports and forms

Macros

Networking Concepts

Introduction of computer networks

Client server networking concepts

Peer to Peer networking concept

Proxy server

Firewall proxy server

Network topologies

Types of network LAN, MAN and WAN

Components of network

Network cables

Wireless network and bluetooth technology

Physical, logical addresses and classes of network

Network security

Firewall

Concepts of DHCP

Concept of ISO-OSI 7 layer model

Network protocol

Internet Concepts

Introduction

World wide web- WWW

Internet and web

Domain naming system

Electronic mail

Video chatting

Voice over IP/VOIP

Social networking

Cloud storage

Open web server

Introduction to internet security, threat and attacks

Malicious software

Internet security products

Web Designing Concepts

Concepts of static and dynamic web pages

HTML

Introduction of cascading style sheet

Content management system

Joomla

Wordpress

Drupal

Plone

Web authoring tool

JAVAScript

Introduction

Algorithm : Flowchart, pseudocode

Web server

Introduction to programming and scripting languages

JAVAscript basics elements of JAVAscript

Statements of JAVAscript

Arrays

Functions in JAVAscript

Dialog boxes

Message box

Input box

Document object model

Event handling in JAVAscript

Using forms with JAVAscript

Functions and methods in JAVAscript

User defined objects

Visual Basic for Application

Introduction

VBA data types, variables and constants

Operators

Mathematical expression

Conditional and branching statement

Looping

Introduction to string in VBA

Arrays

VBA message box

VBA input box

Procedures and functions

Builtin function/methods

Object oriented programming concepts

Even driven programming

User forms and control

Properties events and methods associated with controls

Macro

ADO

Debugging technique

Smart Accounting

Introduction of accounting

Book keeping

Practical system of accounts

Golden rules of accounting

Financial according

Voucher entry

Ledger posting

Cash book

Ratio analysis

Stock management

Introduction of tally

Point of sales invoicing

Tax deducted at source (TDS)

Tax collected at source (TCS)

Fringe benefit tax (FBT)

Service tax processing in tally

Budgeting system

Scenario management

Inventory processing system

Financial statement analysis

Value added tax (VAT)

Variance analysis

Costing system

Cash flow and fund flow accounting

E-Commerce

Introduction

Difference between e-commerce and traditional commerce

Using technology in E-commerce

Types of E-commerce

Application of E-commerce

Construction of E-commerce

Different modes of payment in E-commerce

Concepts of online catalogue

Shopping cart

Concept of check out pages

Payment processing in E-commerce

E-Commerce order processing

Authorization

Settlement

Charge back

Security in E-commerce

Payment gateway

Cyber Security

Introduction to information security

Do’s and don’t’s in information security

Security threads

Information security vulnerabilities

Risk management

Directory services

Security in software development

Cyber crimes

Cyber law

Information technology act-2000

Rules related with cyber crime under IPC