The DCA Course (Diploma in Computer Applications) provides complete training in computer fundamentals, MS Office, Internet, typing, data entry, Excel formulas, PowerPoint, basic accounting, and digital skills. Students learn documentation, spreadsheets, presentations, online tools, and office workflows. This course builds strong computer confidence and prepares learners for office, admin, back-office, and entry-level IT roles.
Module 1: Computer Fundamentals & OS
· Day 1: What is Computer? History and Generations
· Day 2: Classification of Computers
· Day 3: Basic Computer Terminologies
· Day 4: Input and Output Devices
· Day 5: Memory Types – RAM, ROM, Cache
· Day 6: Central Processing Unit (CPU)
· Day 7: Number Systems and Conversions
· Day 8: Software Types – System, Application, Utility
· Day 9: Operating Systems – Basics
· Day 10: Windows Desktop, Icons, Start Menu
· Day 11: File and Folder Management
· Day 12: Using Control Panel
· Day 13: System Settings – Time, Date, Display
· Day 14: File Extensions and Formats
· Day 15: Practice Day – Navigation and Shortcuts
· Day 16: Paint, Notepad, Calculator, WordPad
· Day 17: Keyboard and Mouse Skills
· Day 18: Computer Security Basics
· Day 19: Shortcut Keys and File Compression
· Day 20: Practice Day – Revision and Internal Test
· Day 21–30: Typing Practice – 10 Days Continuous
Module 2: MS Word – Word Processing
· Day 31: MS Word Interface
· Day 32: Document Creation and Management
· Day 33: Text Formatting and Editing
· Day 34: Paragraph Formatting
· Day 35: Page Layout – Margins, Size, Orientation
· Day 36: Inserting Tables, Images and Shapes
· Day 37: Header, Footer, and Page Numbers
· Day 38: Columns, Watermark, Page Border
· Day 39: Mail Merge Basics
· Day 40: Mail Merge Project
· Day 41: Resume Preparation in Word
· Day 42: Report Drafting
· Day 43: Official Letter Writing
· Day 44: Editing Tools – Spellcheck, Find & Replace
· Day 45: Saving, Printing, PDF Export
· Day 46: Practice Assignment – Company Letter
· Day 47: Practice Assignment – Certificate Format
· Day 48: Practice Assignment – Exam Paper Design
· Day 49: Practice Assignment – Template Usage
· Day 50: MS Word Test
· Day 51–60: Typing Practice – Focused on Word Formatting
Module 3: MS Excel – Data Entry & Formulas
· Day 61: Introduction to Excel and Interface
· Day 62: Cell Formatting and Navigation
· Day 63: Data Entry and Editing
· Day 64: Rows, Columns, Merge, Wrap
· Day 65: Basic Formulas – SUM, AVERAGE
· Day 66: Functions – MIN, MAX, COUNT, COUNTA
· Day 67: Logical Functions – IF, AND, OR
· Day 68: Date & Time Functions
· Day 69: Sorting and Filtering Data
· Day 70: Conditional Formatting
· Day 71: Charts – Column, Pie, Line
· Day 72: Page Setup, Printing, Gridlines
· Day 73: Excel Project – Salary Sheet
· Day 74: Excel Project – Marksheet
· Day 75: Excel Project – Invoice
· Day 76: Data Entry Project – Staff List
· Day 77: Attendance Sheet
· Day 78: Expense Sheet
· Day 79: Practice Day – Review Assignments
· Day 80: MS Excel Test
· Day 81–100: Practice Days – Reinforcement & Typing in Tables
Module 4: MS PowerPoint – Presentations
· Day 101: PowerPoint Interface Overview
· Day 102: Slide Layouts and Themes
· Day 103: Inserting Text, Shapes, and Images
· Day 104: Transitions and Animations
· Day 105: Inserting Charts and SmartArt
· Day 106: Multimedia – Audio & Video
· Day 107: Slide Master and Design Templates
· Day 108: Hyperlinking Slides
· Day 109: Preparing Final Presentations
· Day 110: Practice – My Resume in Slides
· Day 111: Practice – Business Proposal
· Day 112: Practice – School/College Project
· Day 113: Practice – Company Profile
· Day 114: Tips for Effective Presentation
· Day 115: MS PowerPoint Test
· Day 116–120: Project-Based Practice
Module 5: Internet, Email & Digital Awareness - Module 8: Basic Programming Concepts...
No reviews yet. Be the first to review this course!
Enroll in your desired course
Copyright © 2025 DITRP INDIA. All Rights Reserved