Menu Categories
Our Course :
Admission Open for 2026–2027 at Sardar Vallabh Bhai Patel College – Apply Now for Job-Oriented Paramedical & Pharmacy Courses with 10+ Years of Experience, 5,000+ Trained Students, 98% Satisfaction, and Proven National & International Placements!

DCA (Diploma in Computer Applications)

DCA (Diploma in Computer Applications)

The Diploma in Computer Applications (DCA) is a basic-level diploma program designed to provide fundamental IT literacy, practical computing skills, and hands-on exposure to key office productivity tools.

It covers core computer operating systems, application software (like MS Office), basic database management, internet usage, financial accounting tools (like Tally), and introductory programming or web design. DCA is ideal for students, administrative job seekers, data entry professionals, and accountants looking to enhance their digital skill set for entry-level corporate and government roles.

  • Standard Duration: 1 Year (or 6 Months).

  • Structure: Typically divided into 2 Semesters.

  • Internal / Practical Assessment (30% to 50% Weightage):

    • Computer lab practical exams (typing accuracy, spreadsheet formatting, presentation creation).

    • Lab records, assignments, and viva-voce.

    • Internal class tests and attendance.

  • External Theory Examination (50% to 70% Weightage):

    • Written paper featuring a mix of Multiple Choice Questions (MCQs), short answers, and long analytical questions on IT concepts and software logic.

  • Final Project Work:

    • A minor practical project (e.g., designing a basic website, setting up an Access database, or performing data analysis in Excel) submitted at the end of the second semester.

Semester 1 – Fundamentals & Office Automation

  • Fundamentals of Information Technology (IT):

    • Introduction to Computers (Hardware, Input/Output devices, CPU, RAM/ROM).

    • Computer Generations, Memory Types, and Number Systems.

  • Operating Systems:

    • GUI basics (Windows OS setup, File Management, Control Panel).

    • Basic Command Line Interface (DOS Commands).

  • MS Office Productivity Suite:

    • MS Word: Document formatting, Mail Merge, Tables, Page layouts.

    • MS Excel: Spreadsheets, Data Sorting/Filtering, Formulas & Functions, Chart Wizards.

    • MS PowerPoint: Slide creation, animations, transition effects, and presentation modes.

  • Practical Lab I: Hands-on training on Windows and Office Automation tools.

Semester 2 – Advanced Tools, Databases & Web Basics

  • Database Management Systems (DBMS):

    • Database concepts, Relational Databases (RDBMS).

    • Working with MS Access or SQL basics (Tables, Queries, Forms, and Reports).

  • Financial Accounting & Software (Tally/ERP):

    • Basics of Accounting, Voucher Entry, Ledger Creation, Profit & Loss Statements, Balance Sheets.

  • Internet, Networking & Web Design:

    • Internet Basics (Browsers, Web Search, Protocols, Emailing, Cloud Storage).

    • Networking Concepts (LAN/WAN, Wi-Fi, IP Address).

    • HTML/CSS Fundamentals for basic webpage creation.

  • Introductory Programming or Multimedia (Optional Module):

    • Programming logic using C / C++ / Visual Basic OR Graphic tools like Photoshop / DTP.

  • Practical Lab II & Final Project Submission

main10
main9
main6
main7