Advance Diploma in Computer Applications

Duration: 12 Months

MS-Word

• Introduction to MS-Word
• Basic File Options
• Random Text & Keyboard Shortcuts
• Selection and Edit Selection
• Font Settings
• Advance Lists
• Paragraph Settings
• Find and Replace
• Tables & It's Usages
• Pictures, Shapes, SmartArt and Charts
• Quick Parts
• Drop Cap & Objects
• Symbols
• Page Backgrounds
• Page Setup
• A Complete Book Project
• Mail Merge
• Proofing & Languages
• Comments, Track Changes, Compare & Protection
• Views & Zooming
• Windows
• Macros

MS-Excel

• Introduction to Excel
• Basic Calculations
• Basic Functions
• Text Functions
• Date and Time Functions
• IF Condition
• Lookup Functions
• Mathematical Functions
• PMT Functions
• Conditional Formatting
• Cell & Table Formats
• Insertion and Deletion
• Sorting and Filtering
• Pivot Table and Pivot Chart
• Slicer & Timeline
• Cell Name Management
• Formula Auditing
• Calculations
• Import & Export Data
• Data Tools - Text To Column, Flash Fill, Remove Duplicates, Data Validation & Consolidate
• What If Analysis - Scenario Manager, Goal Seek & Data Table
• Group, Ungroup & Subtotal
• Sheet & File Protection
• Freeze Panes
• Macros

MS-PowerPoint

HTML 5

• Introduction to HTML
• Document Structure
• Meta Tags
• Lists in HTML
• Images in HTML
• Hyperlinks
• Tables
• Forms in HTML
• IFrame in HTML
• Basic SVG
• Audio & Video Tags
• Entities

CSS 3

• Where and Why we use CSS
• Selectors of CSS
• Colors in CSS
• Backgrounds in CSS
• Borders in CSS
• Width and Height in CSS
• Margins & Paddings
• Fonts & Text Styling
• Box Model
• Display Property
• Flexbox
• Floating
• Navbar Project
• Card Projects
• Banner Projects
• Advance CSS Selectors
• Transformations
• Transition Animation
• Advance Animation
• Display Grid
• Media Query

JavaScript

• JavaScript Introduction
• Outputs in JS
• Variables & Constants
• Operators
• Functions in JS
• Arrays in JS
• Loops
• Array Functions
• Objects
• String Functions
• Math Functions
• Date and Time in JS
• For In & For Of Loops
• New Loop Functions in JS
• DOM Introduction
• DOM Forms
• DOM CSS & Classes
• DOM Event Listener
• DOM Animation
• BOM Introduction
• Form API
• History API
• Fetch API
• Storage API

Photoshop

• New File in Photoshop
• Brush Tool

Tally Prime

• Create a New Company
• Groups and Ledgers
• Accounting Ledgers
• Payment and Receipt Voucher
• Contra Voucher
• Accounting Project
• Sales, Purchase, Sundry Debtors & Sundry Creditor Ledgers
• Inventory Making - Groups, Categories, Units, Items
• Godowns in Tally Prime
• Accounting with Inventory Project
• Journal Voucher
• Stock Journal
• Order Processing System
• Credit Note & Debit Note
• TDS
• GST
• Interest Calculation
• Cost Center
• POS - Point of Sale
• Price List
• Budget
• Payroll
• Physical Stock

C++

• Introduction to C++
• Variables, Inputs and Outputs
• Operators
• Strings in C++
• Math Functions in C++
• IF & Switch Conditions
• Loops
• Array & Structures
• Pointers
• Functions
• OOPs Introduction
• Constructors & Access Specifiers
• Encapsulation
• Inheritance
• Polymorphism
• Filesystem in C++
• Exceptions