Diploma in Computer Application (DCA)

Course Overview

The Diploma in Computer Application (DCA) is a job-oriented computer course designed to provide fundamental as well as practical knowledge of computer applications used in offices, educational institutions, and business environments. This course focuses on building strong computer basics, internet usage skills, and proficiency in popular Microsoft Office tools.

Course Duration

• 6 Months / 12 Months (as per institute structure)

Eligibility

• Minimum qualification: 8th / 10th Pass (recommended)

Detailed Syllabus

1. Fundamental of Computer

• Introduction to Computers

• History and Generations of Computers

• Types of Computers

• Hardware Components (CPU, Input & Output Devices)

• Software: System Software & Application Software

• Operating System Basics (Windows)

• File & Folder Management

• Computer Memory (RAM, ROM, Storage Devices)

• Introduction to Computer Security

2. Internet & Computer Network

• Introduction to Internet

• Internet Services and Applications

• Web Browsers and Search Engines

• Email (Create, Send, Receive, Attachments)

• Online Forms and Downloads

• Basics of Computer Networking

• Types of Networks (LAN, MAN, WAN)

• Network Devices (Modem, Router, Switch)

• Cyber Safety & Internet Security

3. MS Word

• Introduction to Word Processing

• Creating, Saving & Editing Documents

• Text Formatting (Font, Size, Style)

• Paragraph Formatting

• Page Setup & Printing

• Tables, Images & Shapes

• Header, Footer & Page Numbering

• Mail Merge

• Shortcut Keys

4. MS Excel

• Introduction to Spreadsheet

• Workbook & Worksheet Basics

• Data Entry & Formatting

• Basic Formulas and Functions

• Mathematical & Logical Functions

• Charts & Graphs

• Sorting & Filtering Data

• Conditional Formatting

• Data Analysis Basics

5. MS PowerPoint

• Introduction to Presentation Software

• Creating Slides

• Slide Layouts & Design

• Text, Images & Multimedia

• Animations & Transitions

• Slide Show & Presentation Techniques

• Printing Presentations

6. MS Access

• Introduction to Database Management System

• Creating Database

• Tables, Fields & Records

• Data Types

• Queries

• Forms

• Reports

• Database Applications

Course Outcome

After completing this course, students will be able to:

• Operate computers confidently

• Use internet and email services effectively

• Work efficiently with MS Office tools

• Handle basic database tasks

• Apply for office assistant, computer operator, and data entry jobs

Certification

Students will receive a Diploma in Computer Application (DCA) certificate after successful completion of the course.

Career Opportunities

• Computer Operator

• Office Assistant

• Data Entry Operator

• Back Office Executive

• Freelance Office Work

This syllabus is designed to meet current industry and office requirements.