Diploma in Computer Applications

Duration: 6 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

Photoshop

• New File in Photoshop
• Brush Tool