About SHDCA Course

Dur: 16 Months


Module-1

Computer Basics and Fundamentals:

What is a computer or its history?

Types of data and information

About CPU and its FSB or Clock Speed.

Generations of Computers

Types of computer

About input and output devices

Types of printers and their uses

About input and output process

About Computer Virus and its types.

Block Diagram of a Computer

Functions of the Different Units:

Input unit, Output unit, Memory unit, CPU (ALU+CU).

Input & Output Devices

Memory and its types

Types of Softwares.

Windows 7/10 Operating System and its interface:

Logging On to Windows 7

Exploring the Desktop

Using the Start Menu

Quick Access to Windows Functionality

Using the Windows Taskbar

Taskbar Buttons

Notification Area

Exploring Control Panel

Control Panel Categories

Accessing Individual Control Panel Items.

Different Ways of Opening Control Panel

items.

Understanding User Account control

Finding Information About Your Computer

System

Updating Windows System Files

Types of Updates

Windows Update Options

Ending a Computing Session

Office Package:

Explore Microsoft Word

Working in the user interface

Creating, editing text and saving documents.

Creating a new blank document

Saving the document, saving into a new folder.

Compatibility with older versions, viewing documents in different ways. Office clipboard

Find and replace text

Thesaurus, Mini-translator

Correcting spelling and grammatical errors.

Spell check, Auto Correct

Viewing document statistics

Inserting saved text, Building Blocks, Create a new building block, Inserting one document into another. Changing the Look of Text

Paragraph styles

Changing a documents theme

Format Painter, font dialog box, highlights text, Clear Formatting, Manually changing the look of paragraphs.

Indenting, First Line and hanging indents.

Paragraph alignment, setting up Tabs.

Adjusting line spacing, Paragraph spacing

Borders and Shading

Customizing bullets and numbering

Sorting lists, Formatting text as you type.

Inserting a table

Inserting and deleting columns and rows.

Resizing columns merge cells, Table alignment, and Converting text to table.

Performing calculations in tables

Formatting tables

Inserting pictures, clip art and shapes.

Table of Contents

About footnote and endnote

About page settings

Cross-Reference

Mail Merge and its uses.

Rectify spelling and grammar.

Comment, Track Changes

All Views and its uses.

Explore Microsoft Excel

Introduction to Microsoft Excel

About all types of function such as vlookup, hlookup, etc.

Conditional formatting

About cell merging, text wrapping

About fill series

Pivot Table, Inserting Chart

About Print area and print title

Awareness about scale to fit

Name Manager, Formula Auditing,

Data Sorting, Data Validation

Goal seek, Consolidate

Use of Subtotal

Explore Microsoft Power Point

Introduction to Power point

About Slides and its uses

How to create presentation

Slide designs and their Layout

About Animation Scheme.

Use of custom animation and Slide Transition Effect.

Use of Rehearse Timing

Custom Show, Record Show

Use of Notes Master and Handouts.

About all types of views in Power Point.

Module - II

Explore Internet

What is Internet and how does it work?

About LAN, MAN, WAN

Creation of Google account

Sending emails, and attachments

About Search Engines and its uses.

Save data on cloud or Google Drive.

Awareness about e-commerce

Online Shopping, recharge and more.

Online Train Enquiry, Bus and Flight Enquiry

Online Reservation, Movie and Train Tickets Booking.

About OLX, Quikr and Just Dial.

Module - III

Explore Corel Draw

Introduction to Corel Draw

Use of Corel Draw

How to design Logo, Pamphlets, Banner, Hoarding, Prospectus, Visiting Card, Marriage Card etc.

Usage of Printer

About graphics sizes.

Types of Graphics

About CMYK Printing

Difference between Vector and Raster graphics.

Explore Adobe Photoshop

Introduction to Photoshop

About Layer and its uses

Professional photo editing

About Image and its sizes

How to design passport size photograph.

About different filters in Photoshop.

3D Text in Photoshop

Layer masking etc.

Module - IV

Explore Adobe Flash

Introduction to Flash

About 2D or 3D animation

Movie clip and movie animation in flash.

Professional Logo making in adobe flash.

Sound inserting in animation.

Module - V

Explore Web Development

Introduction to web designing

About Web Sites and web pages.

Types of Websites as dynamic or static

Introduction to Wordpress

About Hosting and Domain

Creation of Web Page using HTML-5 codes.

Use of CSS and Java Script while creating web pages.

Introduction to Adobe Dream Weaver in creating web pages.

About SEO/SEM

Module - VI

Explore Computer Hardware

About basic electronics

About AC and DC voltage

Use of Multi-meter for checking voltage.

Parts of computer and its components.

About types of Motherboard

About types of processor

About types of RAM

CPU clock speed and FSB

RAM FSB

About North Bridge and South Bridge.

About CPU Fan and LGA socket.

About SMPS and its different voltage wires.

System Backup and Restore

Disk Defragment.

Windows Installation

Drivers and Software Installation

Partition Creation while formatting a disk.

Module - VII

Explore Networking

Introduction to Networking

Types of network

About Router, Bridge, Hub and Switches.

Types of networking

About Server and Client

Introduction to Microsoft Peer to Peer networking

Use of Straight-Through cable and Cross-Over Cable

Remote Access in LAN

File and Printer Sharing

About Different types of protocols

Use of IP Address and its types.

About Static and Dynamic IP

About TCP/IPV4 Protocol

Ping, Netstat and NSlookup command.

Usage of third party software for establishing network or remote access.

About Table 568-A and 568-B

Router Configuration

Networking between two computer using cross-over cables.

Module - VIII

Explore C and C++ Language

Introduction to C language

Data Types

Variables

Assignment operator

Arithmetic operator

Logical operator

Relational operator

Bitwise operator

Special operator

Conditional statement

Switch statement

Looping [while, do-while, for]

Array

Structure

Pointers

Module - IX

Explore Accounting on Tally.ERP 9

Business Manual Accounting Concepts

Accounting Fundamentals

Meaning and process of Accounting

Accounting Equations

Book–Keeping: Journal, Ledger and other subsidiaries books

Financial Statements: Trading Account, Profit & loss Account and Balance Sheet

Accounting as per Tally Conventions

Introduction to Tally and its need to an organization.

Professional methodology of learning.

All Accounting Features such as Multi-Currency, Job Costing, Cost Centre, Budgets and Control, Cheque Printing, Interest Calculation, Bill-Wise Details, etc.

All Inventory Features such as Godown, Material Transfer, Bill of Materials, Batch-Wise Details, Purchase and Sales Order Processing, Debit Note, Credit Note, Additional Cost of Purchase, Price List, Materials In and Out, etc.

Non Accounting Voucher as Reversing Journal and Post-Dated Voucher.

All Screen Configurations.

Data Backup and Restore

Split Data, Security Control

Basic Payroll and Advance Payroll with Payroll Auto-Fill option.

How to Migrate Tally Data

Export Tally data or report into Excel or other formats.

Introduction to GST

Various forms of GST

About CGST and SGST

About IGST

About Registration Process under GST.

Threshold Limit for Composition Dealer or Regular Dealer

Who is liable to pay GST?

Who is Registered Dealer?

Who is Composition Dealer?

About GST Return File

Knowledge about GSTR-1, GSTR-2, GSTR-3 or GSTR-3B

What is e-way bill and who is liable to file e-way bill?

Module - X

Explore Personality Development Program (PDP)

Meaning of Personality

How to groom a personality

Various ways to make your personality effective.

Group Discussion, Presentation Skill, Way of Hand Shaking.

Case Study

Resume Writing

PEG (Personality Enhancement Games)

Interview skills and Mock Interview.

How to improve verbal communication?

Workshop with leading practitioners.