Diploma Programs

Diploma in Computer Applications (DCA)

An all-round computer diploma

About This Course

What you will learn

A comprehensive one-year program that builds broad computer skills: computer fundamentals, office applications, programming basics, database fundamentals and practical projects to prepare you for office and IT support roles.

Why It Matters

Why learn Diploma in Computer Applications (DCA)?

The DCA is a complete, one-year computer education program that builds broad, practical computer skills — from office applications to programming basics. Whether you are a student, a job seeker or preparing for government exams, a DCA gives you a recognized qualification and confidence with computers that benefits every career.

Career Impact

How it helps your career

Earn a recognized computer diploma valued by employers.
Prepare for office, IT support and clerical roles.
Get a strong base for higher computer education.
Add a valuable qualification for government and bank exams.

What Sets It Apart

Key highlights

Computer fundamentals and office applications
Programming basics and database fundamentals
Practical projects and a recognized diploma

Course Curriculum

Syllabus we cover

Basics of Computers

Understand what computers are, how they evolved and what they can do.

Introduction to Computers
What is a Computer?
Characteristics of a Computer
Applications of Computers
Types of Computers
Generations of Computers
Components of a Computer
Hardware and Software
Types of Software
System Software
Application Software
Utility Software
Computer Languages

Computer Hardware

Learn about the physical devices that make up a computer system.

Input Devices
Keyboard
Mouse
Scanner
Joystick
Light Pen
Barcode Reader
Webcam
Microphone
Touch Screen
Output Devices
Monitor
Printer
Speakers
Headphones
Projector
Plotter
Input and Output Devices

CPU and Memory

Understand the brain of the computer and how data is stored.

Central Processing Unit
Components of CPU
Arithmetic Logic Unit
Control Unit
Registers
Computer Memory
Primary Memory
RAM
ROM
Cache Memory
Secondary Memory
Hard Disk
Solid State Drive
Pen Drive
Memory Card
CD and DVD

Operating System

Work confidently with Windows to manage files and software.

Introduction to Operating System
Functions of Operating System
Types of Operating Systems
Windows Operating System
Linux Operating System
Desktop
Icons
Taskbar
Start Menu
File Explorer
Files and Folders
Creating Files
Creating Folders
Copying Files
Moving Files
Renaming Files
Deleting Files
Restoring Deleted Files
Control Panel
Settings
Installing Software
Uninstalling Software

Microsoft Word

Create, format and print professional documents in MS Word.

Introduction to MS Word
MS Word Interface
Creating a Document
Opening and Saving Documents
Text Formatting
Font Formatting
Paragraph Formatting
Text Alignment
Line Spacing
Bullets and Numbering
Page Setup
Margins
Page Orientation
Page Size
Headers and Footers
Page Numbers
Tables
Creating Tables
Formatting Tables
Inserting and Deleting Rows and Columns
Pictures
Shapes
Text Boxes
WordArt
Find and Replace
Spelling and Grammar Check
Printing Documents
Print Preview
Saving as PDF

Microsoft Excel

Build spreadsheets, use formulas and present data in MS Excel.

Introduction to MS Excel
Excel Interface
Workbook and Worksheet
Rows and Columns
Cells and Cell References
Entering Data
Editing Data
Formatting Cells
Formulas
Basic Calculations
Arithmetic Operators
SUM Function
AVERAGE Function
COUNT Function
MAX Function
MIN Function
IF Function
Percentage Calculation
Sorting Data
Filtering Data
Charts
Column Chart
Bar Chart
Pie Chart
Line Chart
Tables
Printing Worksheets
Page Setup
Print Area

Microsoft PowerPoint

Design clear, attractive presentations in MS PowerPoint.

Introduction to MS PowerPoint
PowerPoint Interface
Creating a Presentation
Slides
Slide Layouts
Themes
Templates
Adding Text
Formatting Text
Pictures
Shapes
Icons
SmartArt
Tables
Charts
Transitions
Animations
Slide Show
Presentation View
Printing Presentation
Saving as PDF

Internet and Email

Browse the web, search for information and use email safely.

Introduction to Internet
World Wide Web
Web Browsers
Google Chrome
Microsoft Edge
Search Engines
Searching Information on the Internet
Website
Web Page
URL
Downloading Files
Uploading Files
Introduction to Email
Creating an Email Account
Sending Emails
Receiving Emails
Replying to Emails
Forwarding Emails
Email Attachments
Internet Safety
Online Privacy
Strong Passwords
Cyber Security Basics

Basic Computer Networking

Understand how computers connect and communicate with each other.

Introduction to Computer Networks
Types of Networks
LAN
MAN
WAN
Internet and Intranet
Wi-Fi
Modem
Router

Practical Computer Skills

Apply everything you have learned in daily computer use.

Keyboard Practice
Typing Practice
Creating and Managing Files
Creating and Managing Folders
Copying Data
Moving Data
Using USB Drives
Printing Documents
Scanning Documents
Using PDF Files
Converting Files to PDF

DCA Practical Projects

Build real documents, spreadsheets and presentations.

Creating a Resume in MS Word
Creating an Official Letter
Creating a Student Marks Sheet in MS Excel
Creating a Salary Sheet in MS Excel
Creating an Expense Sheet in MS Excel
Creating Charts in MS Excel
Creating a College Presentation
Creating a Business Presentation
Creating a Project Presentation
Creating and Sending Professional Emails
File and Folder Management Practice

Final DCA Practical Project

Complete a final practical assessment covering all DCA skills.

MS Word Document Project
MS Excel Data and Calculation Project
MS PowerPoint Presentation Project
Internet and Email Practical
Project Submission
Practical Examination

Ready to master Diploma in Computer Applications (DCA)?

Join Prathibha Institute and get expert mentoring, practical training, regular assessments and a clear path to your goals.

Enquire Now View All Courses