DIPLOMA IN COMPUTER APPLICATION (DCA)

Course name: Diploma in Computer Application (DCA)

duration: 6 Month

Stage 1:

CHAPTER – 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 Chapter
ALU, Input / Output Functions and characteristic
Memory-RAM, ROM, EPROM, PROM and other types of Memory.

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

CHAPTER – 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.

CHAPTER – 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, TypesBatch, 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.

CHAPTER – 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 Meshfor tree Topologies. Componentof LAN – Media, NIC,
NOS, Bridges, HUB, Routers, Repeaters and Gateways.

Stage 2:

Application Programming in FoxPro

CHAPTER – I

FoxPro – Versions, Features, Requirement of hardware and software. FoxPro –
Menu System, Working with FoxPro. Creating database file some common
operations on data – Create, List, Append, Close, and Quit. FoxPro – Data Types
Viewing and Editing Data. Data displaying and Monitoring Commands – Display,
List, Locate, Edit, change, Browse, Replace, Delete, Recall, Pack. File utilities in
FoxPro – Display Directory, Copy, Delete, Rename.

CHAPTER-II

Sorting and Indexing of Database Files.
Sorting & Indexing Concept, Sort Commands– Single & Multiple keys, Advantage
& Disadvantages of Sort, Indexing Vs sorting, single & multiple keys, Indexing,
find, seek, Rushmore Technology. Printing Reports and Labels, FoxPro Report –
Its creation, features & utilities, Preview, Printing custom Report, Grouping & Sub
grouping. FoxPro Label – Designing & Printing.

CHAPTER-III

Memory Variables – Creation & uses, Arrays, Saving and Restoring Memory
Variables, Commands, Time & Date Functions and Commands, Date
Arithmetic. Converting defining function keys, Keyboard Macros – Creating and
using. Mathematical Commands and Functions.

CHAPTER – IV

Concepts of FoxPro Commands file, Modify Commands. Conditioning, Branching
and Looping within Program files with Do-while-end do, If-End if, Scan-End Scan,
For- End For, DoCase – Endcase, Text-End Text, Executing Commands from ther
Commands files, Macro Substitution.
Error Conditions and Program Debugging Aids.
Common Error Messages, Debugging Techniques and Commands.

CHAPTER-V

Multiple Data Files
Concept of Multiple Database Files – using multiple database files. Relationing the
database – set Relation, update, Append from, copy to, Join, Relation Query by
example and SQL Custom screens for userdefine functions & other tools, Create
custom screen with @, @-GET, @_Edit, @_SAY_GET, READ, Creating Box &
Lines, user Define Functions, Custom Screen Designing and Their use4 FoxDoc
for documentation

Stage 3:

PC Packages

(Word, Excel, PowerPoint)

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

CHAPTER – 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.

CHAPTER-III

MS-Excel
Worksheet basics, Creating worksheet, entering data into worksheet, heading info.,
Data, text, dates, alphanumeric values, saving & quitting fromworksheet. 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.

CHAPTER 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 gridlines & 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.

CHAPTER – 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.

Stage - 4

GUI Programming in Visual Basic

CHAPTER – I

Integrated Development Environment of Visual Basic
IDE of VB, user Interface, Designing,Basics of Event Driven Programming,
Form – Designing, Showing & Hiding.

CHAPTER-II

Working With Forms & Standard Controls:
Form: Text Box, Command Button, Combo Box, List Box, Dir list, File list and other
Controls.

CHAPTER – III

Data Types
ï¿½Control Statements
Data Types, Variables & Constant, Arrays, Dynamic Arrays, Array as Function,
Collections, Procedures, Arguments Passing,Functions Return Values. Control
Flow Statements: - If-then, if-then-else, select case.
Looping Statements: - Do -Loop, For - Next, While-wend, Nested Control
Structure, Exit Statement.

CHAPTER – IV

Building Blocks of Visual Basic: -
Graphics Controls, Image Handling in VB, Coordinate System, Graphic methods -Text Drawing, Lines & Shape, Filling Shapes, and Grid Methods.
Menu Editor: - Pull-down and Pop-up Menus.
Multiple Document interface – Parent & child forms & method
Error Handling: - Types of errors, Error handling methods and Functions.

CHAPTER-V

Database Programming with Visual Basic
Database Programming with VB – Data Control Methods, Properties, Visual data
manager, Connectivity with database, Data bound controls.

stage 5 :

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.

stage 6 :

Internet & Web Page Designing

CHAPTER – 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 basedE-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.

CHAPTER – II

WWW (World Wide Web)
History, Working, Web Browsers, its Functions, concept of search Engines,
Searching the web, HTTP, URLs,Web server, Web Protocols.

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

CHAPTER – 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.

CHAPTER – 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 inE-Payment Systems.s

S.No	Exam	% of mark to Certify	Timing (in minutes)
1	DCA_Programming - DCA01	30	60