Diploma in Computer Application
Categories: Computer Applications
Share
Share Course
Page Link
Share On Social Media
About Course
The Diploma in Computer Application (DCA) is a comprehensive 6-month program designed to equip students with in-demand computer skills for office, business, and creative work. This course covers everything from basic computer operation to professional software like Adobe Photoshop, Microsoft Access, and Tally Prime. It’s ideal for students, job seekers, small business owners, and professionals looking to upgrade their digital skills.
What Will You Learn?
- Diploma in Computer Application (DCA) — 6-month duration, including Adobe Photoshop, Microsoft Access, and Tally Prime.
Course Content
Fundamentals of Computer
-
Introduction to Computer
-
Basic components of a computer system
-
Hardware vs Software
-
Input, Output, and Storage devices
-
Operating systems and file management
📝 Notepad
-
Creating, editing, saving text files
-
Basic formatting
-
Opening and navigating text files
🎨 Paint
-
Drawing shapes and lines
-
Using tools like pencil, brush, eraser, and color fill
-
Saving and opening images
🧾 Microsoft Office Word
-
Creating and formatting documents
-
Using tables, bullets, numbering, and styles
-
Inserting images and objects
-
Page setup and printing
📊 Microsoft Excel
-
Introduction
-
Workbook
-
Worksheet
-
Cell
-
Column Aand Rows
-
Column and Row Heading
-
Workspace
-
Ribbon
-
Cell Reference
-
Cell Range
-
Merge Cell
-
Template
-
Operator
-
Formula
-
Formula Bar
-
Function
-
Cell Formatting
-
Conditional Formatting
-
Filter
-
Freeze Panes
-
AutoFill
-
Auto Sum
-
Auto Format
-
Data Validation
-
Pivot Table
-
Pivot Chart
-
VLookup
📽 Microsoft PowerPoint
-
Creating presentations
-
Using slide layouts and themes
-
Adding transitions and animations
-
Running a slideshow
📂 Microsoft Access
-
Introduction to Database Concepts
-
Creating a New Database
-
Tables: Fields, Data Types, and Primary Keys
-
Creating and Managing Forms
-
Entering, Editing, and Deleting Records
-
Sorting and Filtering Data
-
Relationships Between Tables
🎨 Adobe Photoshop
-
Introduction to Photoshop Interface and Tools
-
Working with Documents & Layers
-
Selection Tools: Marquee, Lasso, Magic Wand
-
Crop, Resize, and Image Adjustments
-
Using Brush, Eraser, Gradient, and Paint Bucket
-
Layer Styles, Blending Modes, and Opacity
-
Text Tool and Typography Effects
-
Photo Retouching: Clone Stamp, Healing Brush
-
Filters and Effects
-
Creating Posters, Banners, and Social Media Graphics
-
Exporting Images for Web and Print
🌐 Internet & Email
-
Browsing the web (search engines, safe surfing)
-
Creating and using email accounts
-
Sending, receiving, and managing emails
-
Understanding common internet terms
📊 Tally Prime (Accounting Software)
-
Introduction to Tally Prime
-
Features and advantages of Tally Prime
-
Installing and navigating Tally interface
-
Basic Accounting in Tally
-
Chart of Accounts: Groups and Ledgers
-
Creating, editing, and deleting ledgers
-
Voucher types and entry (Payment, Receipt, Contra, Journal, etc.)
-
Inventory Management
-
Stock groups, categories, and items
-
Units of Measure
-
Stock entry and godown management
-
Transactions & Alteration