Join Today for better tomorrow
DCA | PGDCA Computer Diploma
DCA Diploma Syllabus
⇒ what is Computer Charecters?
⇒ what is Desktop?
⇒ what is a Computer?
⇒ Brief history of development of computers
⇒ Computer system concepts
⇒ Basic components of a computer system – Control unit, ALU, Input/Output, semiconductor Memory functions and characteristics
⇒ memory – RAM, ROM, EPROM, PROM and other types of memory, Capabilities and limitations
⇒ Generations of computers, Analog & Digital & Hybrid Computers, General & Special Purpose computers, Types of computers– Micro, Mini, Mainframe and Supercomputers
⇒ Characteristics and area of Uses. Personal Computer (PCs-evolution of PCs, configurations of PCs, Pentium and Newer
⇒ Types of PCs- Desktop, Laptop, Notebook, Palmtop, PDA etc.
⇒ Input Devices: Keyboard, Mouse, Trackball, Joystick, Scanners, Digitizing tablet, Digital Camera, MICR, OCR, OMR, Light pen, Barcode & Barcode Reader, Quick Response Code (QR Code), Voice Recognition, Touch Screen.
⇒ Output Devices: Monitors- Characteristics and types of monitor, Size, Digital, Analog, Resolution, Refresh Rate, Interlaced/Non-Interlaced, Dot Pitch, Video Standard- VGA, SVGA, XGA etc. Printers and its Types Impact and Non-Impact printer, Dot Matrix, Inkjet, Laser, Plotter, 3D Printers, Sound Card and Speakers.
⇒ (Storage Fundamental Primary Vs Secondary Data Storage ,SRAM (Static Random Access Memory,DRAM, SRAM
⇒ Retrieval method:-1Direct Access Method,
2. Sequencial Access Method,3. Index Sequence Method
⇒ Magnetic Memory:-Magenetic Tape,Hard Disk;1 Fixed Hard Disk : 2 Removable Hard Disk. 3 Winchester Hard Disk
⇒ 1. Compact Disk (CD) -VCD( Vedio Compact Disk),CD-R (Compact Disk -Recordable),CD-RW (Compact Disk Rewriteable)
⇒ 2 Digital Versatile Disk (DVD) 3 Blue Ray disk (BD) Flash drive ( PD SD/MMC Memory Cards).
⇒ Software needs, Types Of Software- .Opreting System-System Software,Applicatoin Software,System Software,compiler
BIOS,DOS (Disk Operating System), Application Software and Its Types- Word procrssing Software, Spreadsheet Software, presentation Software,Data Base Software,Desktop ⇒ Publishing Software,Communication,Software,Graphics and Multimedia Software,Eduction Software,Management Information System (MIS), Gaming Software, ERP Software etc.
⇒ Advantage OF Machine Language, Disadvantage of Machin Language
⇒ Assembly Language,Advantage OF Machine Language, Disadvantage of Machin Language
⇒ what is 4GL (fourth generation Language)
⇒ Computer Coding System -ASCII,ISCII,UNI COD,EBCDIC (Extended Binary Coded Decimal Interchange Code.
⇒ Number System of Computer- Types Of Number System -1 Decimal Number System,2 Binary Number System,3.Octall Number System,4 Hexadecimal Number System.
⇒ Use of Communication and IT,Components of Communication-1.Message,2.Medium,3.Sender,4.Receiver, 5.Communication Protocol
⇒ Types of Communication – 1 Simplex.
2 Half Duplex,3 Full Duplex
⇒ Unguided Media
⇒ Modem features:- 1 Tranmission Speed,2 Error Deleting and Correction,3 Compression
⇒ 1. Internal Modem
⇒ 2 External Modem
⇒ Advantages of Computer Network,1 Client/Server network 2 Peer to Peer network.
⇒ 1 Size,2 Capicity,3 Service,4 Security,5 Cost
⇒ Types of Connections:- 1 Dialup Connection,2 Leased Line Connections,3 ISDN,4 DSL,5 RF,6 Broad Band Connection,
⇒ Types Of Network:-(1) LAN,Advantage of LAN.1 Low Cost Per Connection,
⇒ 2 Limited Area,3 High Speed,4 Private Ownership.
⇒ MAN,Advantage of MAN,WAN,Advantage of WAN.
⇒ Internet,VPN(Virtual Private Network),Advantage of VPN,Disadvantage of VPN.
⇒ Topologies of LAN: 1 Ring Topology,
2 Bus Topology, Advantage,Disadvantage of Topology
⇒ 4 Mesh Topology, Advantage,Disadvantage of Topology
⇒ Tree Topology,Advantage,Disadvantage of Topology
⇒ 3 Star Topology,5 Advantage,Disadvantage of Topology
⇒ 1 Bridges 2 Hub 3 Routers 4 Repeater 5 Gate Ways.
Enquiry form
Our Selected Students
PGDCA Course Syllabus
BCA Course Syllabus
PC Package (Word, Excel Power Point)
MS Word Syllabus
⇒ New file,Open,Save,Save AS,Page Setup,Print,Exit.
⇒ Cut,Copy,Past,PastSpecial.
⇒ Font Style,SizeGrow Font,Shrink Font,Clear Formetting
⇒ Bold, Italic,Underline,Strike THroughSubScript,Super Script,sentence case Style,text Highlight Color
⇒ Bullet,Number,multilevel list,Decrease Indent,InCrease Indent,sort,Show&Hide
⇒ Align text left,center,Align text Right,line spacing,Shading,Border Style,Heading Style,Change Style,Find,Replace,Select.
⇒ Cover Page, Blank Page, page Break
⇒ Picture,clipart,Shape,Smartart,Chart,
⇒ Hyperlink,BookMark,cross-reference
⇒ Percentage Style, Comma Style, Increase Decimal, DeCrease Decimal
⇒ Header, Footer, Page Number
⇒ Quick Parts, Word Art, Drop Cap,Singnature Line,Date & Time, Object.
⇒ Equation, Symbol.
⇒ Theme,Themes Color, Theme Font, Theme Eefects
⇒ Size, OrentationColumns,Breaks, Line Numbers, hypenation, Margins
⇒ Insert Hyperlink.
⇒ Insert Text Box, Insert Header&Footer, Insert WordArt, Signature Line, Object, Insert Symbols
⇒ Apply Themes, Apply Themes Colors, Apply Themes Fonts, Apply Themes Effects.
⇒ Margine, Page Orientation, Page Size, Print Area, Page Breaks, Page Background, Print Titles
⇒ Water Mark, page Color, Page Border,
⇒ Indent-Left&Right,Spacing
⇒ Position,Bring to Front, Send to Back, TextWrapping, align, Group, Rotate
⇒ Table Of Content, Add Text, Update Table,
⇒ Insert Footnote, Insert EndNote,End FootNote, Show Notes.
⇒ Insert Caitation, Manage Sources,Style,Bibliography
⇒ Insert Caption, Insert Table Of figures, Update Table, Cross Reference
⇒ Insert Index, Update Index, Mark Entry
⇒ Mark Caitation, Insert Table Of Table Of Authorities
⇒ Update Table Of Authorities.
⇒ Create Envelopes, Lables
⇒ Start Mail Merg
⇒ Select Reciepents,Edit Reciepents List
⇒ Highlight Merge Field, Addres Block, Greeting Line, Insert Merge Field, Rules,Match Fields, Update Lables.
⇒ Preview Results, Find Reciepents, Auto Check for Errors
⇒ Finish & Merge.
⇒ Spelling & Grammer, Research,Thesausus, Translate
⇒ New comment, Delete, Previous, Next
⇒ Track Change, Balloons, Final Showing Markup, Reviewing, Markup,
⇒ Accept,Reject, previous Next
⇒ Compare, Show Source Documents.
⇒ Protect Document.
⇒ Protect Sheet, Protect Workbook, Share Workbook, Protact And Users to Workbook, Allow Users TO Ranges, Track Changes.
⇒ Shape Fill, Shape Outline, Shape Effects
⇒ Print Layout, Full Screen Reading, Web Layout, Outline, Draft
⇒ Ruler, Gridline, message Bar, Document Maps, Thumbnails
⇒ Zoom, 100% Zoom, One Page, Two Page, Page Width
⇒ View Slide by Slide, Syncronous Scrolling, Restart Window Position,Swith Windows
⇒ Micro.
MS Excel Syllabus
⇒ New file,Open,Save,Save AS,Page Setup,Print,Exit.
⇒ Cut,Copy,Past,PastSpecial etc.
⇒ Font Style, Size, Increase&Decrease,Bold, Italic,Underline,Border,Fill Color ,Font Color
⇒ Top Align, Middle Align, Bottom Align.
⇒ Align Text Left, Center, Align Text Right.
⇒ Orientation, Decrease Indent, Increase Indent.
⇒ Wrap Text, Merge & Center.
⇒ Number Format, Accounting Number Format,
⇒ Percentage Style, Comma Style, Increase Decimal, DeCrease Decimal
⇒ Conditional Formatting, Format, as Table, Cell styles
⇒ Insert cell, Delete Cell, Format For Cell Size.
⇒ Sigma, Fill, Clear, Sort & Filter, Find & Select.
⇒ Insert Pivot Table, Insert Table, Insert.
⇒ Insert Picture From File, Insert Clip, Insert Shapes , Insert Smart Art Graphics.
⇒ Insert Column, Insert Line, Inser Pie, Insert, Bar, Inser Area, Insert Scatter, Insert Other Charts.
⇒ Insert Hyperlink.
⇒ Insert Text Box, Insert Header&Footer, Insert WordArt, Signature Line, Object, Insert Symbols
⇒ Apply Themes, Apply Themes Colors, Apply Themes Fonts, Apply Themes Effects.
⇒ Margine, Page Orientation, Page Size, Print Area, Page Breaks, Page Background, Print Titles
⇒ Width, Height, Scale.
⇒ Gridline (View, Print) Headline (View, Print)
⇒ Bring to Font, Sent To Back, Selection Pane, Alig n, Group, Rotate.
⇒ Insert Function (Sum, Min, Max, Count,
⇒ Sin, Average, SumIf, PTM, Date, DateValue, Day360, Edate
⇒ EOMonth, Hour, Minute, Month, Now,
⇒ TimeValue,Todays,Workday,Year,Accrint,
⇒ PV,ABC,Round,Dcount Accrintm,Rate,Received,
⇒ Dcounta,Dget,DMax,DMin,DProduct,
⇒ Product,Colunm,Set,Loookup,
⇒ Vlookup,HLookupOffset,RTD,Grade ect.)
⇒ AutoSum, Recently Used, Financial, Logical, Text, Date & Time Looup & Reference, Math & Trig, More Function.
⇒
⇒ Name Manager, Define Name, Use In Formula, Create From Selection
⇒ Trace Precedents, Trace, Dependents, Remove Arrow, Show Formulas, Error Checking Evalution Watch Window
⇒ Calculation Option, Calculate Now, Calculate Sheet.
Bullets, Numbring, Decrease list level, Increase List Level, Line Spacing,
⇒ From Access, From Web,From Text,From Other Sources, Existing Connections
⇒ Refresh all, Connections, Properties, Edit Links
⇒ Sort AtoZ, Sort ZtoA, Sort, Filter, Clear, Reapply, Advanced
⇒ Text to Columns, Remove Duplicates, Data Validation, Consolidate, What-IF Analysis.
⇒ Group, Ungroup, Subtotal.
⇒ Spelling, ReSearch, Thesaurus, Translate
⇒ New Comment, Delete, Previous, Netx, Show/Hide Comment, Show All Comments, Show Ink
⇒ Protect Sheet, Protect Workbook, Share Workbook, Protact And Users to Workbook, Allow Users TO Ranges, Track Changes.
⇒ Shape Fill, Shape Outline, Shape Effects
⇒ Protect Sheet, Protect Workbook, Share Workbook, Protact And Users to Workbook, Allow Users TO Ranges, Track Changes.
⇒ Shape Fill, Shape Outline, Shape Effects
⇒ Normal , Page Layout, Page Brek Preview, Custom View, Full Screen.
⇒ Ruler, Gridlines, Headings, Message bar, Formula Bar, Headings
⇒ Zoom, 100% , Zoom to Selection
⇒ New Window, Arrange all, Freeze Panes, Split, Hide, Unhide, View Slide by Slide, Syncronous Scrolling, Reset Window Position, Save WorkSpace, Switch Windows.
⇒ Micros.
MS Power Point Syllabus
⇒ New file Open,Save,Save AS,Page Setup,Print,Exit.
⇒ Cut,Copy,Past,PastSpecial etc.
⇒ New Slide, Lyout, Reset, Delete,
⇒ Font Style, Size, Increase&Decrease,Bold, Clear Formatting, Italic,Underline,StrikeThrough, Text Shadow, Character Spacing, Change Case, Font Color
⇒ Bullets, Numbring, Decrease list level, Increase List Level, Line Spacing,
⇒ Text Direction, Align Text, Convert to Smart Art Graphic.
⇒ Left Text Align, Center, Right Text Align, Justisfy, Columns.
⇒ Shapes, Arrange, Quick Style, Shape Fill, Shap Outline, Shape Effects.
⇒ Find, Replace, Selecte.
⇒ Insert Table, Picture, ClipArt, Photro Album,Shape, Smart Art, Chart.
⇒ Hyperlink, Action.
⇒ Text Box, Header & Footer, Word Art, Date & Time , Slide Number, Symbol, Object.
⇒ Movie, Sound.
⇒ Page setup, Slide Orientation
⇒ Change Themes, Change the Overoll Design For Your Slide, Theme Color, Theme Font, Theme Effects
⇒ Background Style, Hide BackGround Graphics.
⇒ For Slid Preview – Preview
⇒ Animations, Custome Animations
⇒ Special Effect Transition to This Slide, Transition Sound, Transition Speed, Apply To All Current Slide, Advance Silde On Mouse Click, Automatically After.
⇒ Frome Begenning, Frome Current Slide, Custom Slide Show.
⇒ Set Up Slide Show, Hide Slide, Record Narration, Rehears Timings, Use Rehears Timings
⇒ Resolution, Show Presentation On, Use Presenter View.
⇒ Spelling, Research, Thesaurus, Translate, Language.
⇒ Show Markup, New Comment, Edit Comment, Delete, Preview, Next.
⇒ Protect Presantation.
Bullets, Numbring, Decrease list level, Increase List Level, Line Spacing,
⇒ Normal, Slide Sorter, naotes Page, Slide Show, Slide Master, Handout Master, Notes Master
⇒ Ruler, Gridline
⇒ Zoom, Fit to Window
⇒ Color, GrayScale, Pure Blace & White
⇒ Arrange All, Casecade, Move Split, Switch Windows
⇒ Micros
⇒ Insert Shapes, Text Box, Edit Text
⇒ Choose a Virtule Style For the Shape Ro Lines.
⇒ Shape Fill, Shape Outline, Shape Effects
⇒ Choose Virtule Style For Text, Text Fill, Text Outline, Text Effects
⇒ Bring To Front, Send To Back, Selection Pane, Align, Group, Rotate.
⇒ Shape Height, Shape Width.