Join Today for better tomorrow

DCA | PGDCA Computer Diploma

DCA Diploma Syllabus

DCA Syllabus - ZINT

 

⇒ 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

    ⇒ 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

    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.

    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.

    ⇒ 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

    ⇒ Zoom, Fit to Window

    ⇒ Color, GrayScale, Pure Blace & White

    ⇒ Arrange All, Casecade, Move Split, Switch Windows

    ⇒ 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.

    error: Content is protected !!