Course Contents

Part A: PGDCA (Post Graduate Diploma in Computer Applications)

Module 1: Computer Fundamentals & IT Concepts

• Computer Architecture
• Hardware and Software Concepts
• Operating Systems
• Information Technology Basics
• Digital Communication

Module 2: Windows & System Management

• Windows Administration
• File and Folder Management
• System Configuration
• Security Settings
• System Maintenance

Module 3: Advanced Microsoft Word

• Professional Document Creation
• Advanced Formatting
• Mail Merge
• Templates and Styles
• Business Documentation

Module 4: Advanced Microsoft Excel

• Advanced Formulas and Functions
• Pivot Tables
• Data Analysis
• Charts and Dashboards
• MIS Reporting

Module 5: Microsoft PowerPoint

• Professional Presentation Design
• Animation and Multimedia
• Business Presentations
• Presentation Management
• Corporate Communication

Module 6: Database Management

• Introduction to DBMS
• Database Concepts
• Tables and Relationships
• Queries and Reports
• Database Applications

Module 7: Internet & Digital Technologies

• Internet Applications
• Cloud Computing Basics
• Online Collaboration Tools
• Email Management
• Cyber Security Awareness

Module 8: Programming Fundamentals

• Introduction to Programming
• Logic Building
• Algorithms and Flowcharts
• Basics of Programming Languages
• Problem Solving Techniques

Module 9: Web Technologies

• HTML Fundamentals
• CSS Basics
• Website Structure
• Web Hosting Concepts
• Introduction to Dynamic Websites

Part B: Tally Prime Professional Accounting

Module 10: Introduction to Tally Prime

• Tally Prime Interface
• Company Creation
• Accounting Principles
• Business Accounting Concepts
• Company Configuration

Module 11: Accounting Management

• Ledger Creation
• Voucher Entry
• Journal Entries
• Purchase and Sales Accounting
• Bank Transactions

Module 12: Inventory Management

• Stock Groups and Categories
• Units of Measurement
• Inventory Transactions
• Stock Reports
• Warehouse Management

Module 13: GST Management

• GST Fundamentals
• GST Setup in Tally Prime
• GST Purchase & Sales Entries
• GST Reports
• GST Return Preparation

Module 14: Payroll & Employee Management

• Employee Database Creation
• Salary Structure
• Attendance Tracking
• Payroll Processing
• Employee Reports

Module 15: Banking & Financial Management

• Bank Reconciliation
• Cheque Printing
• Fund Flow Analysis
• Financial Statements
• Budget Management

Module 16: Taxation & Compliance

• TDS Fundamentals
• Tax Reports
• Statutory Compliance
• Business Taxation Basics
• Financial Documentation

Module 17: Advanced Tally Features

• Cost Centers
• Cost Categories
• Security Controls
• Data Backup & Restore
• Business Performance Analysis

Module 18: Final Accounts & Reporting

• Trial Balance
• Profit & Loss Account
• Balance Sheet
• Cash Flow Statements
• MIS Reports

Module 19: Live Projects & Case Studies

• Business Accounting Project
• GST Billing System
• Payroll Processing Project
• Inventory Management Project
• Complete Business Accounting Cycle