Welcome to Insta InfoTech's Advanced Diploma in Computer Applications (ADCA) program, where innovation meets education. Our ADCA course is meticulously crafted to propel your IT career to new heights, providing you with the advanced skills and knowledge.
Knowing Computer
- - Basic Applications of Computer
- - Components of Computer System
- - Other Input/Output Devices
- - Computer Memory
- - Concepts of Hardware and Software
- - Connecting Keyboard, Mouse, Monitor and Printer to CPU
Operating System
- - Basics of Popular Operating Systems
- - Use of Common Icons
- - Folders and Directories
- - Opening and Closing of Different Windows
- - Creating Short Cuts
- - Common Utilities
Internet
- - Basic of Computer Networks
- - Basics of Electronic Mail
- - Opening E-mail Account
- - Sending and Receiving E-mails
- - Accessing Sent E-mails
- - Using E-mails
- - Document Collaboration
MS- Word
- - Word Processing Basics
- - Text creation and Manipulation
- - Page Formatting
- - Text Formatting
COMPUTER OPERATING WITH MIS
- - Table Handling
- - Resume Creation
- - Advertisement Creation
- - Vising Card & Labels Creation
- - Using Watermark
- - Page Cover & Page Border
- - Printing of word document
MS- Excel
- - Creating a New Workbook
- - Typing Text, Numbers, Dates & Formulas
Editing in a Workbook
- - Editing Longer Cells & Formulas
- - Adding Worksheet Comments
- - Navigating Worksheet Comments
- - Editing Worksheet Comments
- - Deleting Comments
Formulas
- - Formulas That Add
- - Formulas That Subtract
- - Formulas That Multiply and Divide
- - EMI Calculation
- - Interest on EMI Calculation
- - Depreciation Calculation
- - Compound Annual Growth Rate Calculation
Number Formatting Techniques
- - Formatting Clock Time & Calculated Time
Functions
- - Finding a Maximum Value
- - Finding a Minimum Value
- - What if Formulas
- - Counting Functions (COUNT and COUNTA,
COUNTBLANK, COUNTIF, SUMIF, SUMIFS, CONCATENATE)
Sheets Creation
- - Creating Salary Sheets
- - Creating Marks Sheets
- - Creating Bonus Sheets & Incentive Sheets
- - Creating Appraisal Sheets
Charts
- - Creating a New Chart From Scratch
- - Working With an Embedded Chart
- - Adding a Trendline, Error Bars & a Data Table
Sorting Data
- - Performing an Alphabetical Sort & a Numerical Sort
- - Sorting on More Than One Column
- - Sorting by Rows
Page Setup
- - Page Layout
- - Setting Custom Margins & a Background
- - Settings Rows as Repeating Print Titles
- - Printing Headings
Module: 5 (MS- PowerPoint)
- - Basics of Presentation Software
- - Creating Presentation
- - Preparation and Presentation of Slides
- - Slide Show
- - Taking Printouts of Presentation / Handouts
Module: 6 (Financial Literacy for Banking Scheme and Applications)
- - Banking Products-ATM card
- - Banking Instruments-Cheque
- - Banking Services Delivery Channels
- - Opening of Bank Account and Documents Required
- - Types of Bank Accounts
- - Bank’s Services Including Remittances
- - Loan, Mobile Banking, Overdraft, Pension etc.
- - Password Security and ATM Withdrawal
- - Ticket Booking Process (Rail, Airplane, Bus etc.)
Module -2 (C, C++)
Basic Structure of C
- - Constants, Variables
- - Data types & Keywords
- - Operators
- - Expression
- - Conditional Operators
- - Decision, Loop & Switch Control Statement
- - Arrays & String Handling, Creating Functions in C
Introduction to Pointers in C.
- - Passing Pointers as Arguments to Function.
- - Structure, Union, File Handling Dynamic Allocation of Memory.
- - Introduction To Linked List Basics.
Basic Structure of C++
- - Introduction to Object Oriented Programming ©++).
- - Tokens, Expression, Data Types & Control Structure.
- - Introduction to Classes, Objects, Constructor & Deconstructor.
- - Functions in C++.
- - Function Overloading, Operator Overloading.
- - Inheritance, Multiple & Multilevel Inheritance.
- - Introduction to Virtual Functions, Classes & Polymorphism.
- - File Operations Using Stream Classes.
- - Exception Handling.
- - Introduction to Templates
Module -3 (HTML & CSS)
- Introduction to HTML & CSS
- What is internet ?
- Overview of Web Browser
- URLs (Uniform Resource Locator)
- World Wide Web (www)
- HTML Tools
HTML Document And Basic Tags
- - Writing Tools
- - Structure of an HTML document
- - Basic tags and Attributes
- - Body Attributes
Text editing
- - Text attributes
- - Marquee tag & its attributes
- - Headings
- - Font
- - Paragraph, Line Break
- - Ordered and Unordered Lists
- - Blockquote
Images
- - Image formats
- - Image attributes
- - Alignment of images
Tables
- - Create a table
- - Combine cells in a row or column
Module -3 (HTML & CSS)
Image Mapping
Forms
- - Create a Form
- - Accept Input and Submit
Module 4 (DHTML & JAVASCRIPT)
Special Things
- - Special Characters
- - Different Graphic Formats
- - Interlacing/Progresive Display
ADVANCED DHTML & CSS
- - Getting a Proper Code Editor and Formatting
- - Lists
- - Parent-Child Relationships
- - Blockquotes
- - Anchors
- - Your First Stylesheet
- - Clean Project Structures
- - The Necessity of Divs
- - Ids and Classes
- - Assignment
- - Floats and a Simple Layout
- - NavigationLists
- - Introduction to Forms
- - Image Replacement
- - Typography Basics
- - Images
- - Creating a Website Fragment
- - The Importance of Validation
Creating Responsive Website
Media Query
What is Media Queries?
- - Properties of Media Queries
- - Width / Height
- - Device-width/height
- - Orientation
- - Aspect-ratio
- - Device-aspect-ratio
- - Color/ Color-index
- - Resolution/ Scan/Grid
(Corel Draw)
Introduction to the CorelDRAW program
Menu bar & Drawing Toolbox
Overview of Drawing Tools
- - Freehand Tool
- - Rectangle Tool
- - Ellipse Tool
- - Polygon, Spiral & Graph Paper Tools
Editing the Object
- - Deleting, Moving, Scaling, Rotating & Skewing
- - Shape Tool
- - Knife Tool
- - Erase Tool
- - Smudge Tool
- - Roughen Tool
How to Combine Two Lines
Learn to use Transformation (Mirror) of object and combine it
Learn to use Transformation(Rotation)to make a
(ILLUSTRATOR/PAGEAKER)
Introduction to Illustrator
- - Interface
- - Bitmap vs Victor Graphics
Drawing Basics
- - Basic Shapes
- - Modifying Shapes
- - Color Fill & Strokes
Drawign-pen Tool
- - Drawign with the Pen Tool
- - Modify, Cut, Join Align Shapes
- Fills & Textures
- - Color Theory RGB/CMYK
- - Creating Patterns
- - Creating Gradients
Transformations
- - Free Hand Tool
- - Scale, Rotate, Re
(ADOBE PHOTOSHOP)
To Start the Photoshop program
Introduction to the Photoshop program
Toolbox & Selection
- - Rectangle Marquee Tool
- - New Selection
- - Add Selection
- - Subtract Selection
- - Inverse Selection
- - Feather
- - Style
- - Elliptical Tool
- - Move Tool
- - Polygon Tool
- - Magnetic Lasso Tool
- - Magic Wand Tool
- - Zoom Tool
- - Pan Tool
- - Default Color
- - Swatches Tool
Editing
- Cut, Copy, Paste
- Free Transform
- Scaling & Rotating
- Perspective
- Layer& its Palette
- - Making Layer Active
- - Duplicate Layer
- - Delete Layer
- - Layer Properties & Opacity
Image Editing
- - Color Mode
- - Color Adjustment
- - Image Size
- - Canvas Size
- - Crop
- - Trim
- - Level
- - Color Balance
- - Brightness/Contrast
- - Hue/Saturation
- Other Effect
- Border
- Fire Effect
- Masking Effect
Module -2 (Tally Prime -Basic)
Fundamentals of accounting
- - Basic Accounting
- (Types of Accounting, Rules of Accounting, Assets, Liabilities, Capital, Payables, Receivables, Debtors, Creditors, Incomes & Gaines.. etc) User Interface and Company Management
- - Creating a Company
- - Altering and Deleting Company
- - Gateway of Tally and User Interface
Ledgers
- - Creating Ledgers
- - Creating Multiple Ledgers
- - Altering and Deleting Ledgers
- - Bill wise Debtors and Creditors Ledgers
Groups
- - Creating Groups
- - Altering and Deleting Groups
Vouchers
- - Contra Voucher (Single Entry Mode/Double Entry Mode)
- - Payment Voucher
- - Receipt Voucher
- - Journal Voucher
Day Book
- - Altering and Deleting Transactions
- Pre-Allocation of Bills
- - Practical Examples
Cheque Printing
- - CTS Cheque Printing System
- - Practical Examples
Inventory
- - Integrating Accounts and Inventory
- - Practical on Stock Group
- - Practical on Godown and Locations
- - Practical on Stock Category
- - Practical on Units of Measure
- - Practical on Stock Items
- - Manual Stock Valuation without Inventory
Goods and Services Tax (GST)
- - Activating Tally in GST
- - Setting Up GST (Company Level, Ledger Level or Inventory Level)
- - GST Taxes & Invoices
- - Understanding SGST, CGST, IGST & UTGST
- - Creating GST Masters in Tally
Purchase Voucher with GST
- - Updating GST Number for Suppliers
- - Practical on Intra-State Purchase Entry in GST (SGST + CGST)
- - Practical on Inter-State Purchase Entry in GST (IGST)
- - GST Purchase Entry for Unregistered Dealer in Tally
- - Reverse Charge Mechanism Entry for GST in Tally
Module 2 (Tally Prime -Advanced)
Sales Voucher with GST
- - Updating GST Number for Suppliers
- - Practical on Intra-State Sales Entry in GST (SGST + CGST)
- - Practical on Inter-State Sales Entry in GST (IGST)
- - Printing GST Sales Invoice from Tally ERP9 Software
GST Reports and Returns
- - GSTR 1 in Tally
- - GSTR 1 Return Filing