What you'll learn
PGDCA – Post Graduate Diploma in Computer Applications
Course Duration: 1 Year
Eligibility: Graduation (Any Stream)
Mode: Offline / Online
Language: English & Assamese (Available)
Course Description
The PGDCA course is designed to provide advanced knowledge in computer applications, programming, database management, web technologies, networking, and modern office automation.
This course prepares students for careers in IT, software development, database management, networking, and computer education.PGDCA is ideal for students who want to build strong professional skills in the IT sector.
Course Objectives
- To build advanced understanding of computers and IT.
- To train students in programming languages like C and Python.
- To develop skills in Accounting and Inventory management in Tally Prime.
- To provide practical knowledge of MS Office and data analytics.
- To train students in web development (HTML, CSS, JS).
- To introduce computer networking, cybersecurity, and cloud computing.
- To make students job-ready for IT and software industry.
Show More
Course Syllabus
Detailed Syllabus (PGDCA – 1 Year)
Semester – I
Module 1: Fundamentals of Computer & IT
- Computer architecture
- Operating system basics
- Number system
- File management
- Computer security
Module 2: Programming with C
- Introduction to programming
- Data types, operators, loops
- Functions, arrays, pointers
- Structures and file handling
Module 3: MS Office Advanced
- MS Word – documentation, templates
- MS Excel – formulas, charts, data analysis
- MS PowerPoint – advanced presentations
- MS Access – database creation, queries, reports
Module 4: Internet & Web Technologies
- WWW, browsers, search engines
- HTML (Forms, Tables, Media)
- CSS basics
- Introduction to JavaScript
Module 5: Computer Networking
- Types of networks
- Network devices (Hub, Switch, Router)
- IP address, DNS, DHCP
- LAN setup basics
Semester – II
Module 6: Database Management System (DBMS) (Optional Module)
- Introduction to DBMS
- SQL Queries (SELECT, INSERT, UPDATE, DELETE)
- Joins and Keys
- MySQL/SQL Server practical
Module 7: Python Programming
- Basics of Python
- Conditional statements & loops
- Functions, modules, exceptions
- File handling
- Basic data analysis with Python
Module 8: Web Development – II
- JavaScript Functions & Events
- DOM Manipulation
- Mini Web Projects
Module 9: Tally Prime (Optional Module)
- Company creation
- Ledger & voucher entries
- GST
- Inventory management
- Reports & statements
Module 10: Cloud Computing & AI Basics
- Introduction to cloud services
- Google Drive / OneDrive usage
- Basics of Artificial Intelligence
- Using AI tools (ChatGPT, Bard, Copilot)
- AI for office productivity
Project Work & Viva
Students must complete one major project in:
- Software Development
- Database Application
- Web Development
- Python Project
- Accounting System
Examination Pattern
- Theory: 40%
- Practical: 50%
- Project + Viva: 10%
Career Opportunities After PGDCA
- Software Developer (Entry Level)
- Web Designer / Developer
- Computer Instructor
- Database Assistant
- IT Support Executive
- Office Automation Specialist
- Data Entry & MIS Executive
- System Assistant
Certification
After completion, students will receive:
Post Graduate Diploma in Computer Applications (PGDCA)
Issued by Sankar Azan Computer Saksharata Mission (SACSM) / Oriental IT Centre.
Bestseller
