COURSE OBJECTIVE

PGDCA का उद्देश्य छात्रों को Computer Applications, Programming, Database Management, Accounting Software, Web Development, Networking तथा आधुनिक IT Tools में दक्ष बनाना है, ताकि वे सरकारी एवं निजी क्षेत्र में रोजगार प्राप्त कर सकें।

SEMESTER – I

Paper – I : Information Technology Fundamentals

• Computer Fundamentals
• Computer Architecture
• Operating System
• Software Engineering Basics
• Cyber Security
• Data Communication

Paper – II : Office Automation

MS Word

• Advanced Formatting
• Mail Merge
• Templates

MS Excel

• Advanced Functions
• Pivot Tables
• Charts
• Data Analysis

MS PowerPoint

• Professional Presentations
• Animations
• Slide Master

MS Access

• Database Management
• Queries
• Forms
• Reports

Paper – III : Programming in C

• Data Types
• Operators
• Control Statements
• Functions
• Arrays
• Structures
• File Handling

Paper – IV : Database Management System (DBMS)

• Database Concepts
• ER Model
• Normalization
• SQL Commands
• MySQL Basics

Practical – I

• MS Office Lab
• C Programming Lab
• SQL Practice

SEMESTER – II

Paper – V : Object Oriented Programming (C++)

• Classes & Objects
• Constructors
• Inheritance
• Polymorphism
• Exception Handling

Paper – VI : Web Designing & Development

HTML5

CSS3

JavaScript

Bootstrap

Website Hosting Basics

Paper – VII : Tally Prime with GST

• Company Creation
• Inventory
• GST Accounting
• Payroll
• Financial Reports

Paper – VIII : Computer Networking

• Networking Fundamentals
• LAN & WAN
• IP Addressing
• Network Devices
• Internet Concepts
• Troubleshooting

Paper – IX : E-Commerce & Digital Marketing

• E-Commerce Concepts
• Online Business
• SEO Basics
• Social Media Marketing
• Google Business Profile

Practical – II

• Web Designing Project
• Networking Lab
• Tally Practical

PROJECT WORK

छात्र निम्न में से कोई एक प्रोजेक्ट तैयार करेंगे:

1. School Management System
2. Library Management System
3. Student Information System
4. Billing Software
5. Personal Portfolio Website
6. Computer Institute Management System