DETAILED SYLLABUS FOR Post Graduate Diploma in …

1 DETAILED SYLLABUS . FOR. post Graduate Diploma in computer applications (PGDCA). (Effective From July 2007). (REVISED). MAKHANLAL CHATURVEDI. RASHTRIYA PATRAKARITA EVAM SANCHAR VISHWAVIDYALAYA. B-38, PRESS COMPLEX, NAGAR ZONE I, BHOPAL. PH.: 4294448, 2768274 ( computer Deptt.). WEB : OR OR SYLLABUS For PGDCA Course Effective From July 2007 REVISED SYLLABUS For PGDCA Course Effective From July 2007. SYLLABUS FOR PGDCA COURSE SCHEME OF EXAMINATION FOR. post Graduate Diploma IN computer applications . (PGDCA). COURSE OBJECTIVES (EFFECTIVE FROM JULY 2007). Course Duration : 1 Year (TWO SEMESTERS). SEMESTER I. Eligibility : Any Graduate There are three main objectives of this degree course. SUBJECT SUBJECT NAME MARKS. To prepare a person who can work as Assistant Programmer in an CODE. organization and to train students to a level where they can readily 1 PGDCA1 FUNDAMENTALS OF COMPUTERS & 100. INFORMATION TECHNOLOGY. compete for seats for lateral entry to advanced degree courses like MSc(CS).

2 1 PGDCA2 OPERATING SYSTEMS 100. To prepare computer Operator to operate various office packages 1 PGDCA3 PC PACKAGES 100. effectively with some analytical approach and who can be directly 1 PGDCA4 ELECTIVE 1 (CHOOSE ONE OF THE 100. employed by many organization FOLLOWING). To prepare computer Assistant to Chartered Accountant (A). FOXPRO. (B). MS ACCESS. The course has been designed keeping in mind the desirable characteristics of a competent computer professional. We have 1 PGDCA5 computer LAB -I 100. identified these characteristics to be the following. 1. Strong knowledge and skill base of the followings from the core field : SEMESTER II. Office Application packages. Web designing SUBJECT MARKS. Programming methodology & techniques SUBJECT NAME. CODE. LAN and Internet 2 PGDCA1 PROGRAMMING WITH VISUAL 100. Database user 2 PGDCA2 INTERNET & E-COMMERCE 100. 2. Ability to work in a team 2 PGDCA3 SYSTEM ANALYSIS AND DESIGN 100. 2 PGDCA4 ELECTIVE - 2 (CHOOSE ONE OF THE 100.)

3 FOLLOWING). Strict standards would be maintained, to ensure quality. (A). OOPS & PROGRAMMING WITH C++. (B). FINANCIAL ACCOUNTING WITH TALLY. In addition, students have the option to select viz., FoxPro/. 2 PGDCA5 computer LAB- II 100. MSAccess and OOPS with C++/Financial Accounting described in detail below. 2 PGDCA6 PROJECT WORK 100. 1. Tuesday, July 31, 2007 Makhanlal Chaturvedi University, Bhopal ( OR OR ) Tuesday, July 31, 2007. SYLLABUS For PGDCA Course Effective From July 2007 REVISED SYLLABUS For PGDCA Course Effective From July 2007. General Instructions :- 1 PGDCA1 - FUNDAMENTAL OF COMPUTERS AND. INFORMATION TECHNOLOGY. For passing the examination minimum 40% marks must be scored in each passing head individually. UNIT I. For passing the overall aggregrate marks must be at least 45% Brief history of development of computers, computer system in theory & practical separately. concepts, computer system characteristics, Capabilities and For the purpose of award of merit or division only the marks limitations, Types of computers Generations of computers, Personal obtained in theory heads of all semester together shall be computer (PCs) evolution of PCs, configurations of PCs- Pentium considered.

4 And Newer, PCs specifications and main characteristics. Basic components of a computer system - Control unit, ALU, Input/Output functions and characteristics, memory - RAM, ROM, EPROM, PROM. and other types of memory. UNIT II. Input/Output & Storage Units-:Keyboard, Mouse, Trackball, Joystick, Digitizing tablet, Scanners, Digital Camera, MICR, OCR, OMR, Bar-code Reader, Voice Recognition, Light pen, Touch Screen, Monitors - characteristics and types of monitor -Digital, Analog, Size, Resolution, Refresh Rate, Interlaced / Non Interlaced, Dot Pitch, Video Standard - VGA, SVGA, XGA etc, Printers& types - Daisy wheel, Dot Matrix, Inkjet, Laser, Line Printer, Plotter, Sound Card and Speakers, Storage fundamentals - Primary Vs Secondary Data Storage and Retrieval methods - Sequential, Direct and Index Sequential, SIMM, Various Storage Devices - Magnetic Tape, Magnetic Disks, Cartridge Tape, Hard Disk Drives, Floppy Disks (Winchester Disk), Optical Disks, CD, VCD, CD-R, CD-RW, Zip Drive, flash drives Video Disk , Blue Ray Disc, SD/MMC Memory cards, Physical structure of floppy & hard disk, drive naming conventions in PC.

5 DVD, DVD-RW. UNIT III. Software and its Need, Types of Software - System software, Application software, System Software - Operating System, Utility Program, Programming languages, Assemblers, Compilers and Interpreter, Introduction to operating system for PCs-DOS Windows, Linux, File Allocation Table (FAT & FAT 32), files & directory structure and its naming rules, booting process details of DOS and Windows, DOS system files Programming languages- Machine, Assembly, High Level, 4GL, their merits and demerits, Application 2. Tuesday, July 31, 2007 Makhanlal Chaturvedi University, Bhopal ( OR OR ) Tuesday, July 31, 2007. SYLLABUS For PGDCA Course Effective From July 2007 REVISED SYLLABUS For PGDCA Course Effective From July 2007. Software and its types - Word-processing, Spreadsheet, Presentation 1 PGDCA2- OPERATING SYSTEMS. Graphics, Data Base Management Software, characteristics, Uses UNIT-I. and examples and area of applications of each of them, Virus working DISK OPERATING SYSTEMS (DOS).

6 Principles, Types of viruses, virus detection and prevention, viruses Introduction, History & versions of DOS. on network. DOS basics- Physical structure of disk, drive name, FAT, file &. UNIT IV directory structure and naming rules, booting process, DOS. Use of communication and IT , Communication Process, system files. Communication types- Simplex, Half Duplex, Full Duplex, DOS commands : Internal - DIR, MD, CD, RD, COPY, DEL, REN, Communication Protocols, Communication Channels - Twisted, VOL, DATE, TIME, CLS, PATH, TYPE etc. Coaxial, Fiber Optic, Serial and Parallel Communication, Modem - External - CHKDSK, XCOPY, PRINT, DISKCOPY, DISKCOMP, Working and characteristics, Types of network Connections - Dialup, DOSKEY, TREE, MOVE, LABEL, APPEND, FORMAT, SORT, Leased Lines, ISDN, DSL, RF, Broad band ,Types of Network - LAN, FDISK, BACKUP, EDIT, MODE, ATTRIB, HELP, SYS etc WAN, MAN ,Internet, VPN etc., Topologies of LAN - Ring, Bus, Star, Executable V/s Non executable files in DOS.

7 Mesh and Tree topologies, Components of LAN -Media, NIC, NOS, UNIT-II. Bridges, HUB, Routers, Repeater and Gateways. WINDOWS XP. UNIT-V Introduction to Windows XP and its features . computer applications in Business-Need and Scope, computer Hardware requirements of Windows. Windows concepts, Windows applications in Project Management, computer in Personnel Structure, Desktop, Taskbar, Start Menu, My Pictures ,My Music, Administration, Information System for Accounting-Cost and ,working with recycle bin-restoring a deleted file, emptying the Budgetary Control, Marketing and Manufacturing, computer recycle bin. Managing files ,folders and disk-navigating between applications in Materials Management, Insurance and Stock-broking, folders ,manipulating files and folders ,creating new folder Production planning and Control, Purchasing, Banking, Credit and ,searching files and folders .My computer -exploring hard disk Collection, Warehousing. Use of computers in common public ,coping and moving files and folder from one drive to another, services and e-governance.

8 Formatting floppy drive. Windows Accessories - Calculator, Notepad, Paint, WordPad, TEXT & REFERENCE BOOKS : Character map,paint,command prompt Windows Explorer - -exploring hard disk ,coping and moving files Anurag Seetha, Introduction to Computers and Information and folder from one drive to another, formatting floppy drive. Technology , Ram Prasad & Sons, Bhopal. and other Explorer facilities. burning CD. , Computers Today , Galgotia Publications. Entertainment- CD player, DVD Player, Media Player, Sound Alexis Leon & Mathews Leon, Fundamentals of Information Recorder, Volume Control, movie maker technology , Vikas Publishing House, New Delhi. UNIT-III. ADVANCED FEATURES OF WINDOWS XP. Managing Hardware & Software - Installation of Hardware &. Software, Using Scanner web camera, printers sharing of printers System Tools - Backup, Character map, Clipboard Viewer, Disk Defragmenter, Drive Space, Scandisk, System Information, 3. Tuesday, July 31, 2007 Makhanlal Chaturvedi University, Bhopal ( OR OR ) Tuesday, July 31, 2007.

9 SYLLABUS For PGDCA Course Effective From July 2007 REVISED SYLLABUS For PGDCA Course Effective From July 2007. System Monitor, Drive converter (FAT 32) ,disk cleanup ,using Peter Norton Complete Guide to Linux by Peter Norton, windows update. Techmedia Publications Communication - Dial up Networking, Direct Cable Connection, Level Module M Information technology by Khanna Book Hyper Terminal, Phone Dial ,Browsing the Web with internet Publications, NewDelhi explorer ,communication through outlook express Windows XP Complete Reference. BPB Publications Multiple Users Features of Windows. Creating and deleting user, changing user password,etc Accessibility Features of Information between Programs ,sharing folders and drives browsing the entire network, mapping windows shared drives, Using shared printers - Understanding OLE - Embed/Link Using Cut and Paste a Embed/Link Using Insert Object - Manage Embedded/Linked Object UNIT - IV. LINUX. History & Features of Linux Linux Structure File system of Linux Hardware requirements of Linux Various flavours of Linux Program & Process Process creation and process identifiers Functions of profile and login files in Linux Linux kernel UNIT-V.

10 Multi-user features of Linux Login and logout from Linux system Linux commands - bc, cal, cat, cd, chgrp, chmod, chown, clear, cmp, copy, date, find, ps, kill, ls, mail, mkdir, more, mv, rm, rmdir, tty, wc, who, whois, grep, write, telnet. Pipeline concepts Using floppy and cdrom in linux. vi editor TEXT & REFERENCE BOOKS : DOS Quick reference by Rajeev Mathur, Galgotia Publications Linux Complete by BPB Publications 4. Tuesday, July 31, 2007 Makhanlal Chaturvedi University, Bhopal ( OR OR ) Tuesday, July 31, 2007. SYLLABUS For PGDCA Course Effective From July 2007 REVISED SYLLABUS For PGDCA Course Effective From July 2007. 1 PGDCA3 - PC PACKAGES Ranges; Different Views of Worksheets; Column Freezing, Labels, Hiding, Splitting etc.; Using different features with Data and Text;. NOTE:- Use of Formulas, Calculations & Functions; Cell Formatting 1. Theory and Practical of this course is based on at least including Borders Working with Different Chart Types.