DCA – Diploma in Computer Applications

Detailed Syllabus (6 Months)

Module 1: Computer Fundamentals

• Introduction to computers
• Types of computers
• Hardware components (CPU, memory, input/output devices)
• Software types (system & application software)
• Operating system basics (Windows)
• File & folder management
• Basic troubleshooting concepts

Module 2: Internet & Email

• Introduction to Internet
• Web browsers & search engines
• Creating & managing email accounts
• Professional email writing
• Online forms, uploads & downloads
• Internet safety & cyber awareness
• Introduction to cloud storage & online tools

Module 3: MS Word

• Introduction to word processing
• Creating, editing & formatting documents
• Fonts, styles & page layout
• Tables, images & shapes
• Headers, footers & page numbering
• Mail merge
• Resume, letters & report preparation

Module 4: MS Excel (Basics)

• Introduction to spreadsheets
• Workbook & worksheet handling
• Data entry & formatting
• Basic formulas & functions
• Charts & tables
• Sorting & filtering data
• Basic data analysis

Module 5: Advanced Excel

• Advanced formulas & functions (IF, VLOOKUP, HLOOKUP, XLOOKUP, COUNTIF, SUMIF, etc.)
• Logical & text functions
• Conditional formatting
• Data validation
• Pivot tables & pivot charts
• Dashboard basics
• Excel for reports & data analysis
• Practical case studies

Module 6: MS PowerPoint

• Introduction to presentations
• Slide creation & design
• Themes & layouts
• Animations & transitions
• Inserting multimedia
• Presentation delivery techniques
• Professional presentation preparation

Module 7: Programming with C

• Introduction to programming concepts
• Algorithm & flowcharts
• Structure of C program
• Data types & variables
• Operators & expressions
• Conditional statements
• Looping statements
• Arrays & strings
• Functions
• Pointers (basics)
• File handling (introduction)

Module 8: Programming with C++

• Introduction to C++
• Difference between C & C++
• Object-oriented programming concepts
• Classes & objects
• Constructors & destructors
• Inheritance
• Polymorphism
• Encapsulation & abstraction
• Basic file handling
• Simple C++ programs

Module 9: Practical Lab & Project Work

• Hands-on practice for all modules
• Office-based practical assignments
• Programming logic building exercises
• Mini project (Excel / C / C++)
• Debugging & problem-solving
• Viva & final assessment

Assessment & Certification

• Regular tests & assignments
• Practical evaluations
• Final examination
• Course completion certificate