HDCA – Honours Diploma in Computer Application
Complete Course Syllabus — In-Depth Description
Duration: 24 Months | Fees: ?30,000 | www.variitm.org
Developed by: Praveen Jangid, IT Software & Franchise Consultant – VARIITM
Helpline: 8814969695 | 9649695296
MODULE 1 — ADVANCE OFFICE AUTOMATION
Sirf basic nahi — HDCA mein complete MS Office Suite ka advance practical training diya jaata hai.
Fundamental of Computer
• Hardware/software structure, Input/Output devices, Memory types (RAM, ROM, HDD, Pen Drive)
• OS basics, File management, Basic troubleshooting
MS Word — Advanced
• Formatting, Tables, Mail Merge, Track Changes, Professional Letters, Templates
MS Excel — with AI Integration
• SUM, IF, VLOOKUP, HLOOKUP, COUNTIF, SUMIF, INDEX-MATCH
• Pivot Tables, MIS Dashboard, Excel AI — Smart Fill, Data Validation, Drop-down Lists
MS PowerPoint — Advanced
• Themes, Animations, SmartArt, Presenter View, Export to PDF/Video
Notepad, WordPad, MS Paint
• Quick editing, basic document creation, image editing basics
MODULE 2 — TALLY ERP-9 WITH GST (Advanced Accounting)
Is module ke baad student CA firm, trading, manufacturing ya service business mein accountant ki role handle kar sakta hai.
• Company creation, Ledgers, Voucher entries, BRS, Trial Balance, Balance Sheet, P&L
GST — Complete
• CGST/SGST/IGST, ITC Adjustments, RCM, GSTR-1, GSTR-3B, GSTR-2A Reconciliation
• E-Invoicing (IRN, QR Code), E-Way Bill generation/modification in Tally Prime
TDS & TCS
• Sections 194C/194J/194H/194I, Challan, TCS on Sales, Form 26Q/27Q
Inventory & Manufacturing
• Job Costing, BOM, Batch/Lot/Expiry, Godown Management, Manufacturing Journal, Process Costing
Payroll & HR
• Salary Structure, Attendance, PF/ESI/PT/Gratuity configuration
Advanced Reporting
• MIS Reports, Real-time filters, Export to Excel/PDF, Email directly from Tally
MODULE 3 — WEB DESIGNING / DEVELOPMENT
Business ya personal website design karna seekhein — freelancing ke liye valuable module.
HTML5
• Tags, Semantic elements (header/footer/section/nav), Tables, Forms
CSS3
• Selectors, Box Model, Flexbox, Border-radius, Gradients, Hover & Transition effects
Responsive Design & DHTML
• Mobile-first design, Media Queries, Fluid Grids, Responsive Navigation
• Dynamic HTML, JavaScript basics — form validation, alerts
MODULE 4 — CHATGPT & AI TOOLS
Artificial Intelligence — aaj ki demand, kal ka future. Practical AI training har field ke liye.
ChatGPT Fundamentals
• AI introduction, Prompt writing, Conversation history, Custom instructions
Practical Use Cases
• Text generation, Summarization, Content creation, Translation (Hindi-English), Research
AI for Office & Business
• Excel formula generation, Email/Proposal writing, Customer support scripts, Interview prep
AI Productivity Tools
• Google Gemini, Canva AI, AI image tools, Automation for repetitive tasks
MODULE 5 — DESKTOP PUBLISHING (DTP) & GRAPHIC DESIGN
Logo, poster, brochure, magazine — sab banana seekhein. Freelancing ke liye complete income source.
Adobe Photoshop — Advanced
• Layers, Masks, Photo Retouching, AI Filters, Color Correction, Composite Images
PageMaker & InDesign
• Page layouts, Master pages, Text flow, Print-ready file export (bleed, crop marks)
CorelDraw — Vector Design
• Logo design, Brand identity (card, letterhead), Banner/Hoarding, Brochure, CMYK/RGB
Printing & Production
• Color proofing, DPI/PPI, File formats (JPEG/PNG/PDF/EPS), Commercial print preparation
MODULE 6 — HARDWARE
Computer hardware practically samajhna aur repair karna — IT support job ke liye must-have.
PC Assembling & Upgrading
• Parts identification, Step-by-step assembly, RAM upgrade, HDD to SSD, BIOS settings
Troubleshooting
• BSOD causes, PC not starting, Overheating diagnosis, Beep codes, Slow PC fixes
Peripherals & IoT
• Printer/Scanner setup, USB troubleshooting, NIC setup, IoT basics, Smart home devices
MODULE 7 — INTERNET & DIGITAL COMMUNICATION
Professional world mein digital communication ek core skill — sabhi online tools ka practical use.
Email & Cloud
• Gmail advanced (labels/filters/auto-reply), Professional email writing, Outlook integration
• Google Drive, Docs, Sheets, OneDrive, Dropbox — cloud collaboration & backup
Meetings & Social Media
• Zoom, Google Meet, MS Teams — hosting, screen share, recording, webinars
• Facebook/Instagram/LinkedIn professional use, Content scheduling, Analytics, Online branding
MODULE 8 — SOFTWARE & WINDOWS INSTALLATION
Windows install karna, system optimize karna, errors fix karna — IT support ke liye zaroori.
OS Installation
• Bootable USB (Rufus), Windows 10/11 clean install, Linux (Ubuntu), Dual boot
Disk, Drivers & Virtual Machines
• Partitioning, Cleanup, Disk health (CrystalDiskInfo), Data recovery basics
• Driver installation, Software management, Registry cleanup, VirtualBox, Snapshots
MODULE 9 — NETWORKING
Computer networks samajhna, configure karna aur troubleshoot karna — complete practical training.
Fundamentals & LAN Setup
• LAN/WAN/MAN, OSI model, TCP/IP, IP address (static/dynamic), DHCP, File/Printer sharing
Router, Switch & Security
• Router admin panel, Wi-Fi setup (SSID/WPA3), Port forwarding, VLAN, QoS
• Firewall, MAC filtering, Network monitoring, Phishing awareness, VPN setup
MODULE 10 — HINDI & ENGLISH TYPING
Sarkari naukri, data entry, office work — dono languages mein professional speed & accuracy.
Hindi Typing
• Mangal font (govt standard), Kruti Dev, Unicode vs Legacy, Speed target: 25-30 WPM
English Typing
• Touch typing, Home row method, Speed target: 35-40 WPM, Professional document typing
Advanced Document Preparation
• Govt form filling, Legal document formatting, Data entry accuracy, SSC/RSMSSB/CPCT prep
COURSE SUMMARY
Total Modules : 10 Professional Subjects
Duration : 24 Months (2 Years)
Total Fees : ?30,000 (EMI / Installment available)
Certificate : HDCA — Honours Diploma in Computer Application
Developed by : Praveen Jangid, IT Software & Franchise Consultant – VARIITM
Helpline : 8814969695 | 9649695296
Website : www.variitm.org