DETAILED SYLLABUS FOR Post Graduate Diploma In
DETAILED SYLLABUSFORPost Graduate Diploma in Computer Applications (PGDCA)(Effective From July 2007)(REVISED)MAKHANLAL CHATURVEDIRASHTRIYA PATRAKARITA EVAM SANCHAR VISHWAVIDYALAYAB-38, PRESS COMPLEX, M.P. NAGAR ZONE–I, BHOPALPH.: 4294448, 2768274 (Computer Deptt.)WEB : www.mcu.ac.in OR www.mcrpv.ac.in OR www.makhanlaluniversity.org
Syllabus For PGDCA Course –Effective From July 2007 –REVISEDSyllabus For PGDCA Course –Effective From July 2007SCHEME OF EXAMINATION FORPOST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS(PGDCA)(EFFECTIVE FROM JULY 2007)SYLLABUS FOR PGDCA COURSECOURSE OBJECTIVESCourse Duration :1 Year (TWO SEMESTERS)Eligibility:Any GraduateThere are three main objectives of this degree course.To prepare a person who can work as Assistant Programmer in anorganization and to train students to a level where they can readilycompete for seats for lateral entry to advanced degree courses likeMSc(CS).To prepare Computer Operator to operate various office packageseffectively with some analytical approach and who can be directlyemployed by many organizationTo prepare Computer Assistant to Chartered AccountantThe course has been designed keeping in mind the desirablecharacteristics of a competent computer professional. We haveidentified these characteristics to be the following.1. Strong knowledge and skill base of the followings from thecore field :SEMESTER ISUBJECTCODESUBJECT NAMEMARKS1PGDCA1FUNDAMENTALS OF COMPUTERS &INFORMATION TECHNOLOGY1001PGDCA2OPERATING SYSTEMS1001PGDCA3PC PACKAGES1001PGDCA4ELECTIVE – 1 (CHOOSE ONE OF THEFOLLOWING)(A). FOXPRO(B). MS ACCESS1001PGDCA5COMPUTER LAB -I100SEMESTER II Office Application packages. Web designing Programming methodology & techniques LAN and Internet Database user2. Ability to work in a teamSUBJECTCODE2PGDCA1PROGRAMMING WITH VISUAL BASIC.NET2PGDCA2INTERNET & E-COMMERCE1002PGDCA3SYSTEM ANALYSIS AND DESIGN1002PGDCA4ELECTIVE - 2 (CHOOSE ONE OF THEFOLLOWING)(A). OOPS & PROGRAMMING WITH C (B). FINANCIAL ACCOUNTING WITH TALLY1002PGDCA5COMPUTER LAB- II1002PGDCA6PROJECT WORK100Strict standards would be maintained, to ensure quality.In addition, students have the option to select viz., FoxPro/MSAccess and OOPS with C /Financial Accounting described indetail below.MARKSSUBJECT NAME1001Tuesday, July 31, 2007Makhanlal Chaturvedi University, Bhopal (www.mcu.ac.in OR www.mcrpv.ac.in OR www.makhanlaluniversity.org )Tuesday, July 31, 2007
Syllabus For PGDCA Course –Effective From July 2007 –REVISEDSyllabus For PGDCA Course –Effective From July 20071PGDCA1 - FUNDAMENTAL OF COMPUTERS ANDINFORMATION TECHNOLOGYGeneral Instructions :¾¾¾For passing the examination minimum 40% marks must bescored in each passing head individually.For passing the overall aggregrate marks must be at least 45%in theory & practical separately.For the purpose of award of merit or division only the marksobtained in theory heads of all semester together shall beconsidered.UNIT – IBrief history of development of computers, Computer systemconcepts, Computer system characteristics, Capabilities andlimitations, Types of computers Generations of computers, PersonalComputer (PCs) – evolution of PCs, configurations of PCs- Pentiumand Newer, PCs specifications and main characteristics. Basiccomponents of a computer system - Control unit, ALU, Input/Outputfunctions and characteristics, memory - RAM, ROM, EPROM, PROMand other types of memory.UNIT – IIInput/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 - Daisywheel, Dot Matrix, Inkjet, Laser, Line Printer, Plotter, Sound Cardand Speakers, Storage fundamentals - Primary Vs Secondary DataStorage and Retrieval methods - Sequential, Direct and IndexSequential, 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 inPC. DVD, DVD-RW.UNIT – IIISoftware and its Need, Types of Software - System software,Application software, System Software - Operating System, UtilityProgram, Programming languages, Assemblers, Compilers andInterpreter, Introduction to operating system for PCs-DOS Windows,Linux, File Allocation Table (FAT & FAT 32), files & directorystructure and its naming rules, booting process details of DOS andWindows, DOS system files Programming languages- Machine,Assembly, High Level, 4GL, their merits and demerits, Application2Tuesday, July 31, 2007Makhanlal Chaturvedi University, Bhopal (www.mcu.ac.in OR www.mcrpv.ac.in OR www.makhanlaluniversity.org )Tuesday, July 31, 2007
Syllabus For PGDCA Course –Effective From July 2007 –REVISEDSyllabus For PGDCA Course –Effective From July 2007Software and its types - Word-processing, Spreadsheet, PresentationGraphics, Data Base Management Software, characteristics, Usesand examples and area of applications of each of them, Virus workingprinciples, Types of viruses, virus detection and prevention, viruseson network.UNIT – IVUse of communication and IT , Communication Process,Communication types- Simplex, Half Duplex, Full Duplex,Communication Protocols, Communication Channels - Twisted,Coaxial, Fiber Optic, Serial and Parallel Communication, Modem Working and characteristics, Types of network Connections - Dialup,Leased Lines, ISDN, DSL, RF, Broad band ,Types of Network - LAN,WAN, MAN ,Internet, VPN etc., Topologies of LAN - Ring, Bus, Star,Mesh and Tree topologies, Components of LAN -Media, NIC, NOS,Bridges, HUB, Routers, Repeater and Gateways.UNIT-VComputer Applications in Business-Need and Scope, ComputerApplications in Project Management, Computer in PersonnelAdministration, Information System for Accounting-Cost andBudgetary Control, Marketing and Manufacturing, ComputerApplications in Materials Management, Insurance and Stock-broking,Production planning and Control, Purchasing, Banking, Credit andCollection, Warehousing. Use of computers in common publicservices and e-governance.1PGDCA2- OPERATING SYSTEMSUNIT-IDISK OPERATING SYSTEMS (DOS)Introduction, History & versions of DOSDOS basics- Physical structure of disk, drive name, FAT, file &directory structure and naming rules, booting process, DOSsystem files.DOS commands : Internal - DIR, MD, CD, RD, COPY, DEL, REN,VOL, DATE, TIME, CLS, PATH, TYPE etc.External - CHKDSK, XCOPY, PRINT, DISKCOPY, DISKCOMP,DOSKEY, TREE, MOVE, LABEL, APPEND, FORMAT, SORT,FDISK, BACKUP, EDIT, MODE, ATTRIB, HELP, SYS etcExecutable V/s Non executable files in DOS.UNIT-IIWINDOWS XPIntroduction to Windows XP and its features .Hardware requirements of Windows. Windows concepts, WindowsStructure, Desktop, Taskbar, Start Menu, My Pictures ,My Music, ,working with recycle bin-restoring a deleted file, emptying therecycle bin. Managing files ,folders and disk-navigating betweenfolders ,manipulating files and folders ,creating new folder,searching files and folders .My computer-exploring hard disk,coping and moving files and folder from one drive to another,formatting floppy drive. Windows Accessories - Calculator, Notepad, Paint, WordPad,Character map,paint,command prompt Windows Explorer - -exploring hard disk ,coping and moving filesand folder from one drive to another, formatting floppy drive.and other Explorer facilities. burning CD Entertainment- CD player, DVD Player, Media Player, SoundRecorder, Volume Control, movie makerUNIT-III TEXT & REFERENCE BOOKS : Anurag Seetha, “Introduction to Computers and InformationTechnology”, Ram Prasad & Sons, Bhopal.S.K.Basandra, “Computers Today “, Galgotia Publications.Alexis Leon & Mathews Leon, “ Fundamentals of Informationtechnology “, Vikas Publishing House, New Delhi.ADVANCED FEATURES OF WINDOWS XP Managing Hardware & Software - Installation of Hardware &Software, Using Scanner web camera, printers sharing of printersSystem Tools - Backup, Character map, Clipboard Viewer, DiskDefragmenter, Drive Space, Scandisk, System Information,3Tuesday, July 31, 2007Makhanlal Chaturvedi University, Bhopal (www.mcu.ac.in OR www.mcrpv.ac.in OR www.makhanlaluniversity.org )Tuesday, July 31, 2007
Syllabus For PGDCA Course –Effective From July 2007 –REVISEDSyllabus For PGDCA Course –Effective From July 2007System Monitor, Drive converter (FAT 32) ,disk cleanup ,usingwindows update. Communication - Dial up Networking, Direct Cable Connection,Hyper Terminal, Phone Dial ,Browsing the Web with internetexplorer ,communication through outlook express Multiple Users Features of Windows. Creating and deleting user,changing user password,etc Accessibility Features of Windows.-Sharing Information betweenPrograms ,sharing folders and drives browsing the entire network,mapping windows shared drives, Using shared printers- Understanding OLE - Embed/Link Using Cut and Paste aEmbed/Link Using Insert Object- Manage Embedded/Linked ObjectUNIT - IV Peter Norton Complete Guide to Linux by Peter Norton,Techmedia PublicationsLevel Module M 1.1 Information technology by Khanna BookPublications, NewDelhiWindows XP Complete Reference. BPB PublicationsLINUXHistory & Features of LinuxLinux StructureFile system of LinuxHardware requirements of LinuxVarious flavours of LinuxProgram & ProcessProcess creation and process identifiersFunctions of profile and login files in LinuxLinux kernelUNIT-VMulti-user features of LinuxLogin and logout from Linux systemLinux 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 conceptsUsing floppy and cdrom in linux.vi editorTEXT & REFERENCE BOOKS : DOS Quick reference by Rajeev Mathur, Galgotia Publications Linux Complete by BPB Publications4Tuesday, July 31, 2007Makhanlal Chaturvedi University, Bhopal (www.mcu.ac.in OR www.mcrpv.ac.in OR www.makhanlaluniversity.org )Tuesday, July 31, 2007
Syllabus For PGDCA Course –Effective From July 2007 –REVISEDSyllabus For PGDCA Course –Effective From July 20071PGDCA3 - PC PACKAGESRanges; Different Views of Worksheets; Column Freezing, Labels,Hiding, Splitting etc.; Using different features with Data and Text;Use of Formulas, Calculations & Functions; Cell Formattingincluding Borders & Shading; Working with Different Chart Types;Printing of Workbook & Worksheets with various options.NOTE:1. Theory and Practical of this course is based on at leastWindows XP and MS Office XP Version, newer versionscan also be used for performing practical in Lab.2. Demonstration of StarOffice and OpenOffice must begiven in the classroom, comparison can be asked in thetheory & practical examUNIT – IVMS PowerPoint: Introduction & area of use; Working with MSPowerPoint; Creating a New Presentation; Working with Presentation;Using Wizards; Slides & its different views; Inserting, Deleting andCopying of Slides; Working with Notes, Handouts, Columns & Lists;Adding Graphics, Sounds and Movies to a Slide; Working withPowerPoint Objects; Designing & Presentation of a Slide Show;Printing Presentations, Notes, Handouts with print options.UNIT–IOffice Packages-Office activities and their software requirement,word Processing, spreadsheet, presentation graphics, database,introduction and comparison of various office suites like MS office,Lotus Office, Star Office, Open Office etc.UNIT-VOutlook express: Setup email account with outlook, sending andreceiving mail through outlook, concepts of CC and BCC, forwardingmail, Draft messages, formatting e-mail message, Concept of MIMEProtocol, attaching files and items into messages, inserting hyperlinkusing outlook editor creating and using send and receive groupemails, opening received messages, opening messages withattachment, replying to mail forwardingmessages flagging forfurther action, setting email options, managingcontacts withoutlook, Setting up multiple email accounts on single machine.MS Word Basics: Introduction to MS Office; Introduction to MSWord; Features & area of use. Working with MS Word.; Menus &Commands; Toolbars & Buttons; Shortcut Menus, Wizards &Templates; Creating a New Document; Different Page Views andlayouts; Applying various Text Enhancements; Working with – Styles,Text Attributes; Paragraph and Page Formatting; Text Editing usingvarious features ; Bullets, Numbering, Autoformatting, Printing &various print optionsUNIT-IIAdvanced Features of MS-Word: Spell Check, Thesaurus, Find &Replace; Headers & Footers ; Inserting – Page Numbers, Pictures,Files, Autotexts, Symbols etc.; Working with Columns, Tabs &Indents; Creation & Working with Tables including conversion to andfrom text; Margins & Space management in Document; AddingReferences and Graphics; Mail Merge, Envelops & Mailing Labels.Text & Reference Books:Windows XP Complete Reference. BPB PublicationsMS Office XP complete BPB publicationMS Windows XP Home edition complete, BPB Publications I.T. Tools and Applications, A. Mansoor, Pragya PublicationsUNIT – IIIMS Excel: Introduction and area of use; Working with MS Excel.;concepts of Workbook & Worksheets; Using Wizards; Various DataTypes; Using different features with Data, Cell and Texts; Inserting,Removing & Resizing of Columns & Rows; Working with Data &5Tuesday, July 31, 2007Makhanlal Chaturvedi University, Bhopal (www.mcu.ac.in OR www.mcrpv.ac.in OR www.makhanlaluniversity.org )Tuesday, July 31, 2007
Syllabus For PGDCA Course –Effective From July 2007 –REVISEDSyllabus For PGDCA Course –Effective From July 20071PGDCA4[A] - FOXPROKeyboard Macros - Creating and UsingUNIT-IFOXPRO - THE RDBMS FOR PCMATHEMATICAL COMMANDS AND FUNCTIONSFoxPro - Versions, features, requirement of Hardware and SoftwareFoxPro - Menu System, Working with FoxProCreating Database File Some common operations on data- CREATE,LIST,APPEND, CLOSE, QUITFoxPro - Data TypesArithmetic Operations, Mathematical Functions, MathematicalCommands, Statistical Functions.UNIT - IVPROGRAMMING WITH FOXPROConcepts of FoxPro commands file, Modify CommandsConditioning , Branching and Looping within Program files with DoWhile Enddo, If - Endif, Scan-Endscan, For - Endfor, DocaseEndcase, Text - Endtext, Executing Commands from othercommand files, Macro SubstitutionVIEWINING AND EDITING DATAData Displaying and Monitoring Commands - DISPLAY, LIST,LOCATE, EDIT, CHANGE, BROWSE, REPLACE, DELETE,RECALL, PACK (All Commands with various Options)ERROR CONDITIONS AND PROGRAM DEBUGGING AIDSMODIFY STRUCTURE, MEMO FIELD AND FILE UTILITIES -Common Error MassagesDebugging techniques and commandsUNIT-VFile utilities in FoxPro - DISPLAY DIRECTORY, COPY, DELETE,RENAME.UNIT-IIMULTIPLE DATA FILESSORTING AND INDEXING OF DATABASE FILESConcept of Multiple Database Files - Using multiple database filesRelationing the database - SET RELATION, UPDATE, APPEND FROM,COPY TO, JOIN, Relation Query by Example and SQLSorting & Indexing ConceptSort Commands - Single & Multiple KeyAdvantage & Disadvantages of SortIndexing Vs Sorting, Single & Multiple KeyIndexing, FIND, SEEK, Rushmore TechnologyCUSTOM SCREENS & USER DEFINE FUNCTIONS & OTHER TOOLSCreate Custom Screen with @, @ GET, @ EDIT, SAY GET READ,Creating Box & Lines, User Define Functions, Custom ScreenDesigning and their Use, FoxDoc for documentationPRINTING REPORTS AND LABELSFoxPro Report - its creation, features & Utilities, Preview, PrintingCustom Report,grouping & Subgrouping.FoxPro Label - Designing & PrintingUNIT-IIITEXT & REFERENCE BOOKS :Foxpro Made Simple by R.K.Taxali, BPB PublicationsMastering Foxpro 2.5 BPB PublicationsFoxpro 2.6 for Dummies - Pustak MahalMEMORY VARIABLES, DATE & TIME FUNCTIONS AND KEYBOARD MACROSMemory Variables - Creation and Uses, Simple Vs ArraySaving and Restoring Memory Variables,?/?/? CommandsTime & Date Functions and Commands, Date ArithmeticConverting Defining Function Keys6Tuesday, July 31, 2007Makhanlal Chaturvedi University, Bhopal (www.mcu.ac.in OR www.mcrpv.ac.in OR www.makhanlaluniversity.org )Tuesday, July 31, 2007
Syllabus For PGDCA Course –Effective From July 2007 –REVISEDSyllabus For PGDCA Course –Effective From July 20071PGDCA4[B] -MS ACCESSUNIT IIntroduction to database -What is a Database ,Why use a rmalization(Determining tables, Determining Fields, DeterminingRelationships)Integrity Rules (Primary/Foreign Key, One-to-Many,Many-to-Many, One-to-One) Introduction to MS Access (Objects,Navigation).UNIT IICreate a Table in MS Access -Data Types, Field Properties , Fields:names, types, properties--default values, format, caption, validationrules Data Entry Add record delete recode and edit text Sort,find/replace, filter/select, re-arrange columns, freeze columns . Edita Tables- copy, delete, import, modify table structure find replace.UNIT IIISetting up Relationships- Define relationships, add a relationship, seta rule for Referential Integrity, change the join type, delete arelationship, save relationshipQueries & Filter –difference between queries and filter ,filter usingmultiple fields AND,OR ,advance filter Queries create Query with onetable ,fiend record with select query, find duplicate record with query,find unmatched record with query, run query ,save and changequery.UNIT IVIntroduction to Forms Types of Basic Forms: Columnar, Tabular,Datasheet, Main/Subforms, add headers and footers, add fields toform, add text to form use label option button, check box ,combobox, list box Forms Wizard, Create Template.UNIT VIntroduction to Reports ,Types of Basic Reports: Single Column,Tabular Report Groups/Total, single table report multi table reportpreview report print report, Creating Reports and Labels, Wizard 2PGDCA1–PROGRAMMING WITH VISUAL BASIC.NETUNIT–IIntroduction to .NET, .NET Framework features & architecture, CLR,Common Type System, MSIL, Assemblies and class libraries.Introduction to visual studio, Project basics, types of project in .Net,IDE of VB.NET- Menu bar, Toolbar, Solution Explorer, Toolbox,Properties Window, Form Designer, Output Window, Object Browser.The environment: Editor tab, format tab, general tab, docking tab.visual development & event drive Programming -Methods and events.UNIT–IIThe VB.NET Language- Variables -Declaring variables, Data Type ofvariables, Forcing variables declarations, Scope & lifetime of avariable, Constants, Arrays, types of array, control array, Collections,Subroutines, Functions, Passing variable Number of ArgumentOptional Argument, Returning value from function.Control flow statements: conditional statement, loop statement.Msgbox & Inputbox.UNIT – IIIWorking with Forms : Loading, showing and hiding forms, controllingOne form within another.GUI Programming with Windows Form: Textbox, Label, Button,Listbox, Combobox, Checkbox, PictureBox, RadioButton, Panel, scrollbar, Timer, ListView, TreeView, toolbar, StatusBar.There Properties,Methods and events. OpenFileDilog, SaveFileDialog, FontDialog,ColorDialog, PrintDialog. Link Label.Designing menues : ContextMenu, access & shorcut keys.Ms Office XP complete BPB publication ISBN 81-7656-564-4Ms Access 2002 fast&easy by Faithe Wempen PHI .ISBN 81-2031893-5UNIT–IVObject oriented Programming: Classes & objects, fields Properties,Methods & Events, constructor, inheritance. Access Specifiers: PublicPrivate, Projected. Overloading, My Base & My class keywords.7Tuesday, July 31, 2007Makhanlal Chaturvedi University, Bhopal (www.mcu.ac.in OR www.mcrpv.ac.in OR www.makhanlaluniversity.org )Tuesday, July 31, 2007
Syllabus For PGDCA Course –Effective From July 2007 –REVISEDSyllabus For PGDCA Course –Effective From July 20072PGDCA2 - INTERNET & E-COMMERCEOverview of OLE, Accessing the WIN32 API from VB.NET. C
post graduate diploma in computer applications (pgdca) (effective from july 2007) semester i subject code subject name marks 1pgdca1 fundamentals of computers & information technology 100 1pgdca2 operating systems 100 1pgdca3 pc packages 100 1pgdca4 elective – 1 (ch
Bruksanvisning för bilstereo . Bruksanvisning for bilstereo . Instrukcja obsługi samochodowego odtwarzacza stereo . Operating Instructions for Car Stereo . 610-104 . SV . Bruksanvisning i original
10 tips och tricks för att lyckas med ert sap-projekt 20 SAPSANYTT 2/2015 De flesta projektledare känner säkert till Cobb’s paradox. Martin Cobb verkade som CIO för sekretariatet för Treasury Board of Canada 1995 då han ställde frågan
service i Norge och Finland drivs inom ramen för ett enskilt företag (NRK. 1 och Yleisradio), fin ns det i Sverige tre: Ett för tv (Sveriges Television , SVT ), ett för radio (Sveriges Radio , SR ) och ett för utbildnings program (Sveriges Utbildningsradio, UR, vilket till följd av sin begränsade storlek inte återfinns bland de 25 största
Hotell För hotell anges de tre klasserna A/B, C och D. Det betyder att den "normala" standarden C är acceptabel men att motiven för en högre standard är starka. Ljudklass C motsvarar de tidigare normkraven för hotell, ljudklass A/B motsvarar kraven för moderna hotell med hög standard och ljudklass D kan användas vid
LÄS NOGGRANT FÖLJANDE VILLKOR FÖR APPLE DEVELOPER PROGRAM LICENCE . Apple Developer Program License Agreement Syfte Du vill använda Apple-mjukvara (enligt definitionen nedan) för att utveckla en eller flera Applikationer (enligt definitionen nedan) för Apple-märkta produkter. . Applikationer som utvecklas för iOS-produkter, Apple .
och krav. Maskinerna skriver ut upp till fyra tum breda etiketter med direkt termoteknik och termotransferteknik och är lämpliga för en lång rad användningsområden på vertikala marknader. TD-seriens professionella etikettskrivare för . skrivbordet. Brothers nya avancerade 4-tums etikettskrivare för skrivbordet är effektiva och enkla att
Den kanadensiska språkvetaren Jim Cummins har visat i sin forskning från år 1979 att det kan ta 1 till 3 år för att lära sig ett vardagsspråk och mellan 5 till 7 år för att behärska ett akademiskt språk.4 Han införde två begrepp för att beskriva elevernas språkliga kompetens: BI
**Godkänd av MAN för upp till 120 000 km och Mercedes Benz, Volvo och Renault för upp till 100 000 km i enlighet med deras specifikationer. Faktiskt oljebyte beror på motortyp, körförhållanden, servicehistorik, OBD och bränslekvalitet. Se alltid tillverkarens instruktionsbok. Art.Nr. 159CAC Art.Nr. 159CAA Art.Nr. 159CAB Art.Nr. 217B1B
