Don Bosco Institute Logo
DON BOSCO INSTITUTE Building Dreams. Shaping Lives β€’ Guwahati
Back
IT & Software

Diploma in Computer Application (DCA)

Office Applications, Financial Accounting, Hardware & Networking, Graphic Design, Coding & Artificial Intelligence. A comprehensive 1-year multi-disciplinary diploma.

Program Overview & Fees

DIPLOMA IN COMPUTER APPLICATION (DCA)
Duration 12 Months
12 Months
Eligibility Class XII and above
Course Fee β‚Ή14,650
(Total Course Fee β€’ 1st: β‚Ή1,450, Remaining 11 Mo: β‚Ή1,200/mo)
1st: β‚Ή1,450 | Remaining 11 Mo: β‚Ή1,200/mo (Total: β‚Ή14,650)
Hosteler Fee (Includes Course Fee) β‚Ή61,450
(Total Course Fee with Hostel & Meals β€’ 1st: β‚Ή5,350, Remaining 11 Mo: β‚Ή5,100/mo)
1st: β‚Ή5,350 | Remaining 11 Mo: β‚Ή5,100/mo (Total: β‚Ή61,450)
Apply for this Course Now Download Prospectus

Key Learning & Course Competencies

Computer Fundamentals
MS Word
MS Excel
MS PowerPoint
Internet & Email
Computerized Accounting & Tally
GST & Payroll
Computer Hardware
Networking
Graphic Designing
Python Programming
Artificial Intelligence
Generative AI & Prompt Engineering
AI Tools

Detailed Curriculum & Syllabus

A comprehensive 1-year program structured across office suites, financial accounting, IT hardware, networking, graphic design, Python coding, and applied AI.

1. Computer Fundamentals & MS Word

Operating system essentials, file management, document creation, tables, mail merge, and printing.

Computer Fundamentals
Operating System Basics
File & Folder Management
MS Word
Document Creation & Formatting
Tables & Graphics
Mail Merge
Page Layout & Printing

2. MS Excel & Data Management

Worksheet management, complex logical functions, lookup formulas, data validation, and pivot tables.

Workbooks & Worksheets
Cell Referencing
Formatting
Formulas & Functions
IF, AND, OR
VLOOKUP & HLOOKUP
COUNTIF & SUMIF
Sorting & Filtering
Pivot Tables
Charts
Conditional Formatting

3. MS PowerPoint & Internet Basics

Presentation design, transitions, animations, slide masters, Google Drive cloud storage, and cyber safety.

Slide Creation
Themes & Transitions
Animations
Multimedia
Slide Master
Internet & Email
Google Drive
Basic Cybersecurity

4. Computerized Accounting – Tally

Accounting rules, journal entries, Tally Prime / ERP9, vouchers, inventory, GST compliance, and payroll.

Accounting Principles
Golden Rules of Accounting
Journal Entries
Ledgers
Tally.ERP9 / Tally Prime
Company Creation
Groups & Ledgers
Receipt, Payment, Contra & Journal Vouchers
Inventory Management
Purchase & Sales Vouchers
GST
Payroll
Balance Sheet
Profit & Loss Account
Trial Balance

5. Hardware & Networking

PC components, hardware assembly, BIOS, OS setup, network devices, cabling crimp, and IP subnetting.

PC Components
PC Assembly
BIOS/UEFI
Windows Installation
Driver Installation
Antivirus Configuration
LAN, MAN & WAN
Network Topologies
OSI & TCP/IP Models
Routers, Switches & Modems
Cable Crimping
IP Addressing & Subnetting
Wi-Fi Setup
Network Troubleshooting

6. Graphic Designing

Design theory, typography, Photoshop layer masking, retouching, vector logo design, and social media branding.

Design Principles
Color Theory
Typography
Alignment, Contrast & Balance
Adobe Photoshop
Layers & Selection Tools
Masking & Retouching
Background Removal
Blending Modes
Vector Design
Logo Design
Social Media Posts
Flyers & Banners

7. Basic Coding – Python

Introduction to programming, Python environment, variables, data types, and logical operations.

Introduction to Programming
Python Setup & IDEs
Variables
Data Types
Input & Output
Type Conversion
Arithmetic & Logical Operators
Comparison Operators
Python Programming Basics

8. Control Flow & Logic Building

Conditional branching, loops, Python data structures (lists, tuples, dicts), and mini calculator utilities.

if, elif & else
For Loops
While Loops
range()
Lists
Tuples
Dictionaries
Basic Python Programs
Calculators
Age Checkers
Grade Generators
Number Guessing Games

9. Basic AI & Machine Learning

AI vs ML vs Deep Learning, prompt engineering, ChatGPT, Google Gemini, Canva AI, and generative visual tools.

AI Fundamentals
Artificial Intelligence
Machine Learning
Deep Learning
Supervised & Unsupervised Learning
Generative AI
Prompt Engineering
ChatGPT
Google Gemini
Canva AI
AI for Text Summarization
AI for Brainstorming
AI-Assisted Code Debugging
AI Image & Visual Generation

10. Projects & Practical Applications

Integrated capstone portfolio: Word/Excel reports, Tally accounting, network setup, branding, and Python app.

Business Report using Word, Excel & PowerPoint
Accounting Project using Tally
PC Assembly & Local Network Setup
Graphic Design Branding Project
Basic Python Application
AI-Assisted Project Documentation
Final Report & Presentation
Admissions Open 2026–2027

Ready to Join Diploma in Computer Application (DCA)?

Submit your online admission form today or connect with our student counselor to reserve your batch seat.

Apply for this Course Now Browse All Courses

Smart Bosco Assistant

Hello! I am Smart Bosco, your DBI assistant. Ask me about courses, fees, hostel accommodation, or how to apply!