PGDCA Syllabus 2021-22 First Semester Makhanlal University PGDCA 1st Semester Syllabus 2020-21 | PGDCA Syllabus in Hindi
- What is PGDCA full form ? – Post Graduate Diploma in Computer
- PGDCA Computer course Syllabus in Hindi
- What is the PGDCA Syllabus PDF
Fundamentals of Computers & Information Technology PGDCA Syllabus
Unit- 1
Computer system concepts, Application area, advantage and disadvantage, components of a computer system – Control uni, ALU, Mother Board, Generation of Computer, Configurations of Computer system, input output , memory, Types PCs Supercomputers Characteristics and aras of uses, Primary OR Secondary memory, ROM, RAM, PROM. EPROM,
Various storage Devices Magnetic Disk, Zip Drive, Hard disk Driver, CD, Floppy Disk , CD-R, Optical Disks, DVD, VCD, Blue Ray Disk, CD-RW, DVD-RW, Solid-state Drive. Flash Drivers SD/MMC Memory Cards,
Unit- 2
Input devices- Keyboard,Scanners, Mouse Trackball,Digital Camera, joystick, OCR, Digitizing tablet, Light pen, MICR, Quick Response code (QR Code), OMR, Touch Screen. Barcode and Barcode Reader. Voice Recognition,
Output Device – Monitor – Characterstics and types of monitor,Analog, Size ,Refresh Rate,Digital,Resolution,Dot Pitch,Interlaced/Non – Interlaced,Video Standard- sVGA,XGAVGA. Printers aqnd its Types Impacts and Non- Impact Printer,plotter,laser,Dot Matrix inkjet,Sound card and Speakers. 3D Printers,
Unit- 3
Software and its Need,Application Software, Types of Software- System software, system Software, operating system- Definition and function,Windows, Device Drivers and Utility Programs Introduction and Features of Dos, Programming languages-high level, machine,4GL their merits and Demerits, Assembly,Computer coding system- ASCII, Compilers and interpreter, Number system of computer , User of Assemblers, Hexadecimal their conversion. ISCII and Unicode, Binary, Octal, Decimal,
Application software and its types- word Processing,Data Base Management , Spreadsheet,Educational , Presentation Graphics, business Accountiong, Desktop Publishing communication, Graphics and multimedia , MIS Gaming and ERP Software.
PGDCA Syllabus 2020-21 First Semester MCU Bhopal
Unit- 4
Communication process, Use of Communication and IT, component of communication –transmission medium and protocol, sender, receiver, Communication types –Half Duplex,simplex,full duplex, communication channelscoaxial, Twisted, fiber optic,
Modem – Types of network- client/ server and peer-to peer networks, working and characteristics,Types of connection – Leased lines, dialup, DSL , ISDN , RF, broad band uses, advantages and disadvantages.
Types of Network- LAN,MAN, WAN , VPN, internet,Topologies of LAN-Bus, Star, Ring , Tree ,Mesh Topologies- Structure,advantages and disadvantages. Uses, Components of LAN-NIC, Media, NOS, Network devices- Bridge,Routers, HUB, Gateways uses, Repeater, Advantages and Disadvantage.
Unit- 5
Disk Operation systerm (DOS)- Introducation ,FAT, DOS Basics – Drive Name, Booting Process, Dos system files,File and Directory Structure and Naming Rules,
Dos commands – internal – DIR,RD, MD,COPY CON, CD, DEL, Copy, REN, External –sort, Tree,mode, format, HELP, fdisk, ATTIRIB, applications and use of computer in various fields , SYS. Concept of Free/open source and proprietary software,
LINUX – History and Features,
Linux Standard Directories,
Hardware Requirement of Linux,
Linux kernel,
Various flavous of Linux,
Login and Lougout from Linux System,
Functions of Profile and login files in Linux,
Linux commands – bc,cd, cal,cmp, cat,mv, clear,find,cp, pwd,date, more,ls,rmdir,mkdir,chmod,rm,whois.chgrp, who.
PGDCA Syllabus PC Packages (word, Excel, Powerpoint)
Unit – 1
Operating system- overview of Window operating system, basic of operation- how to start a computer, login,hibernate,logout, shutdown
personalizing desktop-setting date and time, desktop background,create,screen saver, theme, rename, taskbar, file and folder, cream an sort, recycle bin.copy, moving and delete files and folders,
PGDCA Course Syllabus PDF
using window update, protecting your computer against the virus. remove for configuring new a existing device and software programming and font, disc disk Defragmenter, Accessories – MS paint,Windows Media Player, notepad, WordPad, game, calculator, math input Pannel , language setting- enhance the performance of computer- using disk cleanup,how to set other languages on computer using control panel to add,
working with Google application, earch engine, apply PAN card Passport aadhar card subscribe and reading News paper online , booking gas refill online, downloading ebooks.online ticket booking, pay electricity bill and service tax online, using internet in Windows- Basic operation using internet browser- URL, working with browser ,search information on Wikipedia, Know about www, typing text in the original language, using Google Map,
Unit 2
introducation adn comparison of various office suites like apache open office, Lobre office calligra suite wps office , Koffice, google docs and microsoft office. modern office activity and their software requirements, introducation to office Automation suit, element s of office suit and area of use. Word processing , spreadsheet, presentation graphics, database,
borders and shading, tabs and indents, text editing using various features, bullets, numbering , working with styles, printing and various print options, spell checking, working with headers and Footers. Different page views and layouts, Applying various text Enhancements- Fonts, styles, text Attributes, formatting your text and documents- Auto format paragraph and page formatting, linespacing, margins,
Toolbars and buttons, Shortcut menus, wizards and templates, creating a new Document, MS word basics- Introduction to ms office , Introduction to MS word, Features and area of use . Various versions of ms office and their requirements, working with ms word, menus, and commands , Ribbon,
PGDCA Full Form
Tables- creating a simple table , creating a table using the tabel menu, Entering and editing text in a table , selecting in table , adding rows, chaqnging row heights, deletin g rows, inserting columns, deleting columns, changing column width, conversion to and from text.
Unit 3
Advanced Features of MSWord- Spell check, Thesaurus, find and replace, adding references, using footnote and endnote in documents , creating sutomatic table of contents, using themes, watermarks, inserting equations and symbols. files, auto taxts, symbols , working with columns, tavs and indents, margins and space management in document , page column and section breaks,
Mail merge in MS Word, Mail merge concept, envelops and mailing labels,recording macros, editing macros, running a macro. importing and exportin to and from various formats, macros in MS Word- Macro introduction and their use ,
Graphics -importing graphics, clipart, insert picture , using clip Art, Sharpes and Smart Art in document , using word Arts and drop cap features in document. Templates -Template types, using templates, exploring templates, dodifying templates. using drawing features , drawing objects, text in drawing. Taking and inserting screenshots in documents,
Unit 4
MS Excel Spreadsheet basics and features, concepts of workbook and worksheets, geting stared, removing and resizing of columns and rows entering and editing formulas, referencing cells, moving cells, copying cells, sorting cell data inserting rows, inserting column, inserting cells, deleting parts of a worksheet, clearing part of a worksheet, defferent views of worksheets. creating a new worksheet, using wizard, various data types, selecting cells, entering and editing text, entering an editing numbers,
Charts- Chart parts and terminology, chart wizard, different types of charts, printing charts, deleting charts, linking in spreadsheet, printing of workbook and worksheets with various options.
Formatting – Page setup cell formation changing column widhths and row heights, auto format , changing colors and shading, hiding rows and columns, working with data and ranges, column freezing , labels, Hiding, splitting, merging. changing font sizes and attributes, centering text across columns, using boarder buttons and commands ,
Unit 5
Designing and presentation of a slide show, change slide backgrounds, change slide size, using animation and transitions in presentation ,Handout master and notes master. advanced slide options- manual and automatic, printion presentations notes handouts with print option slide master ,
MS Power Point – Introduction andd area of use, Working with MS PowerPoint, creating a New presentation ,working with notes, Handouts, columns and lists, adding graphics, shapes, screenshots, smart Art and charts in presentation, hounds and movies to a slide, working with powerpoint objects, working with presentation using wizards, slides and its different views, inserting, deleting and copying of slides,
PGDCA Syllabus Database using MYSQL (Optional A)
Unit -1
Introduction to database concept, need of database, flat database, database management system, characteristics of DBMS, database application example, banking , railways, school, retail store. database Elements – tables, query, form, report, introduction to client server paradigm. Relational database, entity and referential integrity, database concept of primary key,
Unit- 2
My SQL Database, its features, installation on windows, making it works on command line, important administrative my sql database commands- SHOW DATABASE, USE DATABASE, SHOW TABLES, SHOW COLUMN , and SHOW INDEX using the built in database, running and shutting down my sql server, setting up my sql user account. CREATE and DROP database,
PGDCA Syllabus Diploma Subjects
Unit- 3
Database query commands DDL, DML, DCL, creation tables using sql commands, using various data types, applying constraints on tables, updationg, deletiong my sql tables, string function, numerical function. insertiong data, updating and deleting data retrieving data from a my sql Database- Sortiong data retrived from a mysql database – using WHERE to filter data. sql functions and operators control flow function,
Unit- 4
mysql data aggregation functions- mysql users and security- administering and monitoring mysql using the mysql commands. Data- Advanced MySQL Data Filtering – AND, OR, NOT and IN- MySQL and IN- mysql wildcard filtering using like- mysql regular expression searches – joining tables in mysql, applying groupin of data by group by,
Unit- 5
Example Application for my sql database- workbench and phpmyadmin, graphical user interface of php my admin, phpmyadmin features, installation, structure search , insert, empty, drop, create new table and add data, execute mysql Query with sql tab. use of different section of phpmyadmin, nanaging database with hp myadmin, browse,
PGDCA Syllabus Database Using MS Access (Optional B)
Unit- 1
Introduction to database- what is a database, why use a relational database, overview of database design- data normalisation( determining datatables, many to one one to one , introduction to MS Access determining field, determining relationship) integrity rules primary key foreign key one to many e,
Unit- 2
table in database, create a table in MS Access- data types, field properties, fields- name, types, property- default value, format, caption, validation rules data entity, find and replace, filter\ select rearrange columns, freeze columns, editable- copy, delete, import, modify table structure ,find replace add record delete record and edit text, short,
Unit- 3
Working with Query, setting up relationship- define relationship, add a relationship, set a rule for referential integrity, fine record with select Queries , change the join type, delete a relationship, save relationship Queries and filter difference betweenQueries and filter, find duplicate record with Queries , find unmatched record with Queries , run Queries , save and change Queries. filter using multiple field AND ,OR advanced filterQueries create Queries with one table,
Unit- 4
Working with form, introduction to forms types of basic forms- calumnar, tabular, data sheet, main Subform , header and footer, combobox, list box, form wizard, create template. add fields to form, add text to to form use label option button, checkbox,
Unit- 5
Working with reports, introduction to reports, types of basic reports, multiple table report preview report print report, create and Labels, wizard. single column tabular report, group/ total single table report,
PGDCA Syllabus Fundamentals of multimedia (Optional A) PGDCA syllabus
Unit- 1
Introduction to multimedia, multimedia definition and concept, need of multimedia, area of you, concept of plain and formatted text, RTF and HTML development platform for multimedia, I didn’t text, images, sound, animation and video, text object linking and embedding concept, font need and types requirement. simple multimedia with PowerPoint text as a component of multimedia,
Unit- 2
Sound in multimedia, importance of sound in multimedia, sound and it attributes tone, overview of various sound file formats on PC, wave, MP3, concept of MIDI, software for sound editing and mixing 3D sound. intensity, frequency, wavelength, pitch. mono vs stereo sound, sound channels, effect in sound, analogue vs digital sound,
Unit- 3
Graphic in multimedia, importance of graphics in multimedia, digital camera, various attributes of image size colour beat Depth, resolution, various image file format vector and raster graphics, image capturing method scanner, , BMP,DIB, EPS,PIC, and TIFformat their feature and limitations
Unit- 4
Video and animation in multimedia, impact of video in multimedia, basic of video analogue and digital video,name of video editing software, basics of animation, how to use video on PC, brief note on various video standard, Pal NTSC, different file format and their use in multimedia, MPEG,AVI MJPG, types of animation and use of animation, software for creating animations,
Unit- 5
career in Multimedia Production,introduction to hmd Application of multimedia and its features, application of multimedia in different industries- education, entertainment, journalism, feature of multimedia, , BOOM cave , introduction to various type of authority tools . PGDCA Syllabus PGDCA syllabus virtual reality as new technology in multimedia, application of VR,
What are the Eligibility for PGDCA ?
What are the Eligibility for PGDCA ? – PGDCA का पूरा नाम “पोस्ट ग्रैजुएट डिप्लोमा इन कंप्यूटर है” यह एक डिप्लोमा कोर्स है जो ग्रेजुएशन के बाद किया जाता है ऐसे सभी विद्यार्थी जिन्होंने अपना ग्रेजुएशन पूरा कर लिया है ऐसे सभी विद्यार्थी PGDCA का डिप्लोमा कर सकते हैं यह एक कंप्यूटर कोर्स है
Programming with VB .NET (Optional B)
Leave a Reply