Diploma In Computer Application (DCA)

Paper-1
Fundamentals of Computers & Information Technology

UNIT – I

Introduction to Computer and IT

Brief history of development of Computers. Computer System Concept , Computer System Characteristics, Capabilities and Limitations, Types of Computer-Analog, Digital, Hybrid, General, Special Purpose, Micro, Mini, Super. Generations of Computers.

Types of PCL, Computer Organization and working, basic components of a computer System Control Unit, ALU, Input / Output Functions and characteristic, Memory-RAM, ROM, EPROM, PROM and other types of Memory.

UNIT- II

Input Devices

Keyboard, Mouse, Trackball, Joystick, Digitalizing tablet, Scanners, Digital Camera, MICR, OCR, OMR, Bar-Code Reader, Voice Recognition, Light Pen, Touch Screen.

Output Devices

Monitors –

Characteristics and types of Monitors – Digital, Analog, Size, Resolution, Refresh Rate, Interlaced/Non-Interlaced, Dot Pitch, Video tandard - VGA, SVGA, XGA etc. Printers – Daisy Wheel, Dot Matrix, Inkjet, Laser, Line Printer, Plotter, Sound Card and Speakers.

UNIT – III

Storage Devices

Storage Fundamentals – Primary Vs Secondary

Data Storage and Retrieval methods – Sequential, Direct and Index-Sequential. Various Storage Devices – Magnetic Tape, Magnetic Disks, Cartridge tape, data drives, hard disk drives, Floppy disk, Optical disk – CD, VCD, CR-R, CD - ROM,DVD.

Number System

Data Representation in Computers. Number System of Computers – Decimal, Binary, Octal, Hexa - Decimal Representation for their Conversion, Coding System – ASCII, BCD, EBCDIC etc. and Arithmetic of Number System.

UNIT – IV

Computer Software

Need, Types of Software’s – System Software, Application Software. System Software – Operating System, utility Program, Programming languages, Assemblers, Compilers and Interpreter. Operating System– Functions, Types- Batch, Single, Multiprogramming, and Multiprocessing. Programming Languages – Machine, Assembly, High level, 4GL their merits and demerits.

Application Software – Word Processing, Spreadsheet, presentation Graphics, Data Base Management Software, Characteristics, uses and examples and area of application of each of them.

Computer Virus

• Virus working principals.
• Types of Viruses.
• Virus detection and Prevention.

UNIT – V

Data Communication and Networks

Analog & Digital Signals, Communication Process, Direction of Transmissions Flow-Simplex, Half – Duplex, Full Duplex. Communication Protocols. Communication Channels – Twisted, Coaxial, Fiberb optic, serial and Parallel Communication.

Modem – Working and Characteristics, Types of N/W connections – Dialup, Leased Lines, ISDN, Types of Network – LAN, WAN, MAN etc.Topologies of LAN – Ring, Bus, Star, and Mesh for tree Topologies. Component of LAN – Media, NIC, NOS, Bridges, HUB, Routers, Repeaters and Gateways.

Paper- 2

PC Packages

(Word, Excel, PowerPoint)

UNIT- I MS-Word: -

Introduction to Word Processing, Introduction to MS-Word: Features, Creating, Saving, and opening document in word, Toolbars, Rulers, Menus, keyboard shortcuts. Editing a Document- Moving, scrolling in a document, opening multi document windows, editing text – selecting, inserting, coping, deleting, moving text etc. Previewing documents, Printing documents. Formatting Documents: Paragraph formats, aligning text and paragraph, Borders & Shading, header & Footer, Auto formatting, Auto correct, Bullets, numbering, Templets & wizards.

UNIT – II

Advanced Features of MS-Word.

Spell check, Thesaurus, find & Replace, Inserting – page Numbers, pictures, files, Auto text, Symbols etc. Creation & working with tables, Document protection, Adding Graphics, mail merge, envelops & mailing labels. Macros etc.

UNIT-III

MS-Excel

Worksheet basics, Creating worksheet, entering data into worksheet, heading info., Data, text, dates, alphanumeric values, saving & quitting from worksheet. Opening & Moving around in an existing worksheet. Toolbars and Menus, keyboard shortcuts. Working with Single and multiple workbooks – coping, renaming, moving, adding, and deleting, coping entries and moving between workbooks.

UNIT IV

Working with formulas & cell referencing - Auto sum - Coping Formulas - Absolute & Relative addressing. Working with ranges – Creating, editing and selecting ranges. Formatting of Worksheet – Auto Format, Changing – alignment, Character Styles, Column width, date format, borders & colors, currency sign. Graphics and Charts – Using wizards, various chart type, Formatting grid lines & legends Previewing & printing worksheet – page setting, print tittles, adjustment Margins, page break, headers and footers.
Functions – Date & Time, Math’s for Trigonometry, Statistical, Text and Logical functions, Database. Creating and using Macros. Database – Creation, Sorting, query & filtering a database. Multiple Worksheets – Concepts, Creating & using.

UNIT – V MS-PowerPoint: -

Creating a New Presentation, Working with Presentation, using wizards, Slides & its different views, Inserting, Deleting and copying of slides, Working with Notes, Handouts, Adding Graphics, Working with PowerPoint objects, Designing & presentation of a slide show, printing Presentations, Notes, Handouts with print options.

Paper- 3

DTP (Desk Top Publishing)

DTP:

Kinds of DTP software, CorelDraw: Different versions, Ventura Publisher, Adobe Photo Shop, MS - Publisher, MS-office: Word, Excel, PowerPoint, Access, Paint shop Pro-5, Quark x-press, Lotus Application, I photo plus, Photo Finish(For Scanning), Omni Page Limited Edition (OCR) Aldus Page Maker.

PageMaker 5.0 Feature:

File:- New, Open, Save, Save all, Revert, Export, Place, Links, Book Preference, Page Setup, Print, Exit.

Edit: Copy, Paste, Multiple paste, Select all, Paste Special, Insert Object, Edit Story Utilities: Aldus Assitions, Index Entry, Show Index, Create Index, Create TOC

Layout: View, Guides and rules, Column guides, Go To Page, Insert Page, Remove Page, Display master items, Auto flow.

Types: Font, Size, Leading, Set width, Track, Type Style, Type Space, Paragraph, Indents/tabs, Hphenation, Alignment, Style, Define Style Element: Fill and link, Rounded corners, Define colors.

Windows: Arrange icons, Tile, Cascade, Tool box, Stype Palette, Color Palette, Library palette

Help: Contents, Search, Shortcuts, using PageMaker Help, Learning PageMaker 5.0, About PageMaker.

Paper- 4

Internet & Web Page Designing

UNIT – I INTERNET

Evolution, Protocols, Interface Concepts, Internet Vs Intranet, Growth of Internet, ISP, Connectivity – Dial – up, Reused Line, VSAT etc., URLs, Domain names, Portals, Application, E - mail. Concepts, POP and WEB based E-mail, Merits, addresses, Basic of Sending & Receiving, E-mail protocols, Mailing list, Free E-mail Services.

Internet Protocols: -

Data Transmission Protocols, client/server Architecture & its Characteristics, FTP & its usages. Telnet Concept, Remote Logging, Protocols, Terminal Emulation, Message Board, Internet Chatting.

UNIT – II

WWW (World Wide Web)

History, Working, Web Browsers, its Functions, concept of search Engines, Searching the web, HTTP, URLs, Web server, Web Protocols.

UNIT-III

Concepts, Domain name Registration, space on Host server for web site, HTML, Design Tools, HTML editors, Image editors, Issues in web site creation & maintenance, FTP S/W for upload web site.

UNIT – IV

HTML –

Concepts of Hypertext, versions of HTML, Elements of HTML Syntax, Head & Body Sections, Building HTML Documents, Inserting texts, Images, Hyperlinks, Backgrounds and Color Controls, Different HTML Tags, Table Layout and Presentation, use of Font size & attributes, List types and its tags, use of Frames and forms in web pages.

UNIT – V

Introduction (Front Page -2000), HTML view, Tables, Properties. E-Commerce on introductions, concepts, Advantages and disadvantages, Technology in E - Commerce, Internet & E-Business, Application.
Electronic Payment Systems: Introduction, Types of electronic Payment System, Digital Token-Based, electronic Payment Systems, Credit Card Based, E - Payment Systems, Risk in E-Payment Systems.