What you'll learn
Diploma in Computer Applications (DCA)
Duration: 6 Months
Total Modules: 6
Total Chapters: 72
Total Marks: 200
Module 01: Computer Fundamentals & Windows (12 Chapters)
Computer Fundamentals
- Introduction to Computers
- Generations of Computers
- Types of Computers
- Hardware and Software
- Input Devices
- Output Devices
- Memory Devices
Windows Operating System
- Operating System Basics
- Windows Environment
- File and Folder Management
- Control Panel
- Computer Security & Antivirus
Module Marks: 30
Module 02: MS Word Professional (12 Chapters)
Document Creation
- Introduction to MS Word
- Creating and Saving Documents
Formatting
- Text Formatting
- Paragraph Formatting
- Page Setup & Layout
Advanced Features
- Tables
- Pictures and Shapes
- Header & Footer
- Page Numbering
- Mail Merge
Practical Projects
- Resume Design
- Certificate Design
Module Marks: 30
Module 03: MS Excel Professional (12 Chapters)
Excel Basics
- Introduction to Excel
- Workbook & Worksheet
- Cell Formatting
Formulas & Functions
- Formulas
- Functions
- Logical Functions (IF)
Data Analysis
- Charts & Graphs
- Sorting & Filtering
- Data Validation
Practical Projects
- Salary Sheet
- Marksheet Preparation
- Inventory Management
Module Marks: 30
Module 04: MS PowerPoint (12 Chapters)
Presentation Basics
- Introduction to PowerPoint
- Slide Creation
- Themes & Templates
- Slide Formatting
Design & Effects
- SmartArt Graphics
- Charts
- Animations
- Transitions
Multimedia
- Audio & Video Integration
- Slide Show Settings
Practical Projects
- Presentation Design
- Project Presentation
Module Marks: 30
Module 05: MS Access & Database Management (12 Chapters)
Database Fundamentals
- Introduction to Database
- Database Concepts
- Tables
- Fields & Records
- Data Types
- Primary Key
Database Operations
- Relationships
- Queries
- Forms
- Reports
Practical Projects
- Student Database Project
- Library Database Project
Module Marks: 30
Module 06: Internet, E-Mail & Project Work (12 Chapters)
Internet Basics
- Introduction to Internet
- Web Browsers
- Search Engines
- Searching Techniques
E-Mail Management
- E-Mail Basics
- Creating E-Mail Accounts
- Sending & Receiving E-Mails
- Attachments & Signatures
Online Tools
Security & Project
- Cyber Security Awareness
- Final Project Work
Module Marks: 50
Examination Pattern
ModuleSubjectMarksModule 01Computer Fundamentals & Windows30Module 02MS Word Professional30Module 03MS Excel Professional30Module 04MS PowerPoint30Module 05MS Access & Database Management30Module 06Internet, E-Mail & Project Work50Grand TotalAll Modules200 Marks
Important Exam Rules
- Theory and Practical examinations are conducted for all modules.
- Students must pass each module separately.
- Successful candidates will receive the DCA Certificate.
Course Summary
✅ 6 Modules
✅ 72 Chapters
✅ 6 Months Duration
✅ Practical + Theory Training
✅ 200 Marks Final Examination
✅ Certificate after successful completion
Bestseller
