Introduction to Computers and Windows Operating System

Introduction to Computer

History of Computer

Generations of Computer

Classification of Computers

Components of Computer

Computer Languages

Language Translator

Advantages of Computer

Applications of Computer

Concept of Hardware and Software

Introduction to Processor

Operating System

Windows

Computer Hardware Basics and Software Installation

Introduction to Computer Hardware

Input Devices

Output Devices

Introduction to Booting Process

BIOS Setting

Memory

Hardware and Software Issues

Formatting and Loading OS

Antivirus

Introduction to DOS and Linux Operating System

Introduction to DOS

Main Files of DOS

File Names in DOS

DOS Commands

Introduction to Open Source Software

Introduction to Linux Operating System

Features of Linux

Architecture of Linux

Linux File System Structure

Linux Process

Types of Shell

Linux Commands

Word Processing

Introduction to Word Processor

Introduction to MS Word

Features/Characteristics of MS Word

Loading MS Word

Parts of MS Word Window

Different Menu in MS Word

Cursor Movement Keys and Shortcut Keys in MS Word

MS Word Practical Work

Special Effects in Text

Creating Drop Cap

Inserting Book Mark

Mail Merge

Spread Sheet Application

Introduction to MS Excel

Features of MS Excel

Workbook and Worksheet

Loading MS Excel

Parts of Excel Window

Menu Bar in Excel

Cursor Movement, Shortcut and Function Keys

Making Entries in Worksheet

Data Editing

Function in MS Excel

Operators

Charts in MS Excel

MS Excel Practical Work

Printing

Deletion of Workbook File

Move or Copy Worksheet

Merge Cells

Changing Column Width and Row Height

Insert Blank Cells, Rows or Column

Hide/Unhide or Row/Column

Cut, Copy and Paste

Delete Cell, Row and Column

Clear Cell Formats or Contents

Add Numbers using Autosum

Formatting Worksheet

Charts

Sort the Records

Auto filter the Data List

Pivot Table

Introduction to Reports

Open Office and Power Point

Introduction to Open Office

Creating Presentation using Open Office's Impress

Normal View in Impress

Views in Impress

Layout, Text and Slides in Impress

Design Templates and Images

Drawing Tools

Printing Impress Presentation

Saving Presentation

Introduction to Power Point

Advantages of Power Point

Creating Presentation using Power Point

Working with Text in Power Point

Background and Slide Organization in Power Point

Adding Graphics using Power Point

Drawing Objects

Effective Presentation Technique

Database Management System

Concept of Data, Information and Database

Introduction to DBMS

Overview of Popular DBMS

Introduction to RDBMS

Integrity Rules and Constraints in a Table

Relational Algebra

Rules for Designing Good Table

Introduction to OODBMS

Introduction to NoSQL

Introduction to SQL

Commands used in SQL

Introduction to MS Access

Introduction to Macro

Networking Concept

Introduction to Computer Networks

Advantage of Computer Networks

Client-server Concept

Peer-to-Peer Concept

Concept of Proxy Server and Firwall Proxy Server

Network Topologies

Introduction to LAN, WAN and MAN

Network Components

Network Cable

Wireless Network

Bluetooth Technology

Concept of ISO-OSI Model

Overview of TCP/IP

Network Addressing

Network Security

Firewall Concept

Concept of DHCP

Internet Concept

Introduction to WWW

Internet

Internet Servers and Search Engine

Domain Name System

E-Mail

Video Conferencing

Voice Over IP (VOIP)

Social Networking

Concept of Cloud Storage

Open Web Server

Internet Security

Threats and Attack

Malicious Software and its type

Internet Security Product

Web Design Concept

Introduction to Web Design

Concept of Static and Dynamic Web Pages

Introduction to HTML

Creating Forms with Control Using HTML

Concept of CSS

Applying CSS to HTML

Introduction to Open Source CMS

Introduction to Web Authoring Tools

JavaScript

Introduction

Concept of Algorithm and Flow Chart

Introduction to Web Servers

Scripting vs a Programming Language

Starting with JavaScript

JavaScript - Datatypes, Variables and Constants

JavaScript Reserved Words

Conversion between Data Type

JavaScript Operators

Program Control Statements and Loops in JavaScript

Array in JavaScript

JavaScript Functions

Built-in JavaScript Functions

Introduction to String and Date Function

Concept of Pop up Boxes in JavaScript

Document Object Model

Visual Basic for Application (VBA)

Introduction to VBA

Features of VBA

Applications of VBA

Introduction to Visual Basic Editor

VBA Data Types, Variables and Constants

Operators in VBA

Operator Precedence

Mathematical Expression in VBA

Introduction to String in VBA

Conditional Processing in VBA

Loops in VBA

Arrays in VBA

Functions and Subroutines in VBA

Procedure in VBA

Built-in Functions

Creating and Editing Macro

Introduction to Object Oriented Programming Concept

VBA Message Boxes and Input Boxes

User Forms and Controls in Excel VBA

Events and Event Driven Programming Concept

Overview of ActiveX Data Object (ADO)

Debugging Techniques

Hardware and Software Requirements

Smart Accounting

Basics of Accounting

Basics of Book-Keeping

Distinction between Book-Keeping and Accounting

Golden Rules of Accounting and Types of Accounts

Methods of Accounting

Journal and Ledger

Final Account Preparation

Cash Book

Analysis of VAT, Cash Flow, Fund Flow Accounting

Concept of Costing System and Ratios

Stock Management

Inventory Basics

Inventory-Costing Methods

Analysis of Financial Statement

Ratio Analysis

Depreciation

Budgeting System

Scenario Managment and Variance Analysis

Introduction to Tally

Voucher Entry

Implementing Accounts in Tally

POS Invoicing

TDS

TCS

FBT

VAT

Service Tax

E-commerce

Introduction to E-commerce

Functions of E-commerce

Benefits of E-commerce

Differences between E-commerce and Traditional Commerce

Technologies in E-commerce

Technological Issues in E-commerce

Types of E-commerce Websites

Concept of Online Catalogs

Concept of Shopping Cart

Concept of Checkout Pages

Payment Processing in E-commerce

Concept of Authorization

E-commerce Order Processing

Concept of Charge Back

Security Issues in E-commerce

Payment Gateway

Building Business on Internet

Cyber Security

Overview of Information Security

Do's and Don'ts in Information Security

Security Threats

Information Security Vulnerabilities

Risk Management

Introduction to Directory Services

Software Development Security

Audit and Security

Introduction to IT Act

Cyber Crime

Penalities for Cyber Crime