Course Name: Diploma in Computer Applications(DCA)
Course Id: DCA/Q0001.
Education Qualification: 10th Class.
Duration: 370 hrs.
DCA Course Syllabus
- Computer Fundamentals
- PC Packages (Word, Excel, PowerPoint)
- Database Using FoxPro and MS Access
- IT Trends , Internet and E-Commerce
- Multimedia with Corel Draw
- DTP With Page Maker And Photoshop
How You will Get Diploma Certificate:
Step 1- Select your Course for Certification.
Step 2- Click on Enroll Now.
Step 3- Proceed to Enroll Now.
Step 4- Fill Your Billing Details and Proceed to Pay.
Step 5- You Will be Redirected to Payment Gateway, Pay Course and Exam Fee by Following Options.
Card(Debit/Credit), Wallet, Paytm, Net banking, UPI and Google pay.
Step 6- After Payment You will receive Study Material on your email id.
Step 7- After Completion of Course Study give Online Examination.
Step 8- After Online Examination you will get Diploma Certificate soft copy(Scan Copy) and Hard Copy(Original With Seal and Sign).
Step 9- After Certification you will receive Prospect Job Opportunities as per your Interest Area.
Online Examination Detail:
Duration- 60 minutes in each Module.
No. of Questions- 30. (Multiple choice Questions) in each Module.
Maximum Marks- 700, Passing Marks- 40%.
There is No Negative marking in this module.
Benefits of Certification:
- Government Authorized Assessment Agency Certification.
- Certificate Valid for Lifetime.
- Lifetime Verification of Certificate.
- Free Job Assistance as per your Interest Area.
DIPLOMA IN COMPUTER APPLICATION (DCA)
|Name of Paper||M. Marks||Pass Marks|
|PC Packages (Word, Excel, PowerPoint)||100||40|
|Database Using FoxPro and MS Access||100||40|
|IT Trends , Internet and E-Commerce||100||40|
|Multimedia with Corel Draw||100||40|
|DTP With Page Maker And Photoshop||100||40|
DCA- Computer Fundamentals
Brief history of development of computer, computer system concepts, Basic component of computer, control unit, ALU, Input/output, semiconductor memory function and characteristics, Memory-RAM, ROM, EPROM, PROM and other types of memory, Capabilities and limitation, Generation of computers, Analog and Digital Hybrid Computers, General and Special of Computer, Types Of Computer –Micro, Mini, Mainframe, Supercomputers.
Input Devices: Keyboard, Mouse, Trackball, Joystick, Scanners, Digitizing tablet, Digital Camera, MICR, OCR, OMR, Light Pen, Barcode and Barcode Reader, Quick Response Code (QR Code), Voice Recognition, Touch Screen.
Storage Fundamentals – Primary Vs Secondary Data Storage and Retrieval Methods – Sequential, Direct and Index Sequential, Various Storage Devices – Magnetic Disks, Hard Disk Drives, Floppy, Disks, Zip Drive, Optical Disks.
Types of Software – System Software, Application Software, System Software – Operating System – definition and function, Device Drivers and Utilities Programs, Introduction and Features of DOS, Windows, Programming language, Machine, Assembly, High Level.
Types Of Network-LAN, WAN, MAN, Internet, VPN etc. Component of LAN-Media, NIC, NOS, Network device- Bridges, HUB, Routers, Repeater, Gateways Uses, advantages and disadvantages.
DCA-PC Packages (Word, Excel, PowerPoint)
Operating System, Basic Operation-How to start a computer, login, logoff, hibernate, Shutdown etc, Personalizing Desktop-Desktop Background, Icon, Screen Saver, Themes, Setting Date and time, Task bar, Files and Folders, Create, Copy, Rename, Moving and Delete Files and Folders, Create and Using Shortcuts, Recycle Bin. Accessories-MS Paint, Notepad, WordPad, Windows Media Player, calculator, Games, Math input panel.
MS Word Basic: Introduction to MS Office, Introduction to MS Word, Formatting your Text and Documents: Auto Format, Paragraph and Page Formatting, Line spacing, Margins, Borders and Shading, Tab and Indents, Bullets, Numbering, Working with Styles, Printing and Various Print Option, Working With Headers and Footers, Tables: Creating a simple Table.
MS Excel Spreadsheet Basic and Features, Concept of Workbook and Worksheet, Entering and editing Numbers, Removing and Resizing of Rows and Columns, entering and editing Formulas, Referencing cells, moving cells, copying cells, sorting cell data, inserting rows, inserting cells, inserting columns.
Formatting: Page setup, Cell Formatting, Changing column width and row heights, auto format, changing font sizes and attributes, centering text across column, using border buttons and commands, changing colors and shading, hiding rows and columns, Working with data and ranges, Column Freezing, Labels, Hiding, splitting, merging etc. Working with MS PowerPoint, columns and List, Working with PowerPoint Objects.
DCA – Database Using Fox Pro and MS Access
The RDBMS for PC, Concept of database, Fox Pro – Versions, Features, requirement of Hardware and Software Fox Pro- Menu System, Working with Fox Pro creating Database file some common operation on data-CREATE, LIST, APPEND, CLOSE, QUIT, Fox Pro- Data Types Viewing and Editing Data, Data Displaying commands-LIST, DISPLAY, LOCATE, EDIT, CHANGE, BROWSE, REPLACE, DELETE, RECALL, PACK ( All Commands with various Option). Memory Variables, Date and Time Functions and, Keyboard Macros, Memory Variables-creation and uses, Simple Vs Array Saving and Restoring Memory Variables.
Introduction To database- What is a Database, why use a Relation Database, Concept of Primary Key relationship, Introduction to MS Access (Objects, Navigation). Create a Table in MS Access- Data Types, Field Properties, Fields: names, types, properties- -default values, Format, caption, validation rules Data Entry, Add record, delete record And edit text, sort, find/replace, and filter/select, rearrange columns, Freeze columns. Edit a Tables- copy, delete, import, modify table Structure, find, replace.
DCA – IT Trends, Internet and E-Commerce
Multimedia Definition and concept, Multimedia Elements- Text, Images, sound, Animation and video, Multimedia Hardware and Software Requirement. Introduction to Wireless LAN, Bluetooth, Wi-Fi, Wimax mobile Technology, 2G, 3G, 4G services, IMEI, SIM,IP Telephony, soft phone, voice mail, Ad-hoc and sensor network, GIS, ISP Mobile computing, cellular system cell, Mobile Switching office, Hands off, Base station.
Introduction to Internet – Internet Evolution, Word Wide Web (WWW), Advantages and Disadvantages, Internet Vs Intranet, Application of internet, Basic Operation Using Internet Browser- Working with browsers, view History in Browser, HTML- concepts Of Hypertext, Versions of HTML, Element of HTML.
DCA – Multimedia with Coral Draw
Graphics in Multimedia, Importance of graphics in multimedia, Vector and Raster Graphics, Image Capturing Method Scanner, Digital Camera etc. Introduction to Corel Draw, Usage and Advantages.
DCA – DTP with PageMaker & Photoshop
Introduction to desktop publishing (DTP), History, Definition, Need And area of Application, Difference between a word processor and Publication software, uses and importance of DTP in publication and Newspaper printing, Various DTP software’s, Introduction to offset Technology, Adobe Page Maker – Introduction to page maker, Aldus And adobe page maker, previous and current version of page maker, Page maker as a DTP Software, Attribute setting: Tools, Styles, Menus, Alignments, Grids, Guides etc. Introduction to adobe Photoshop, Photoshop Documents, Various Graphic files and Extension- JPG, GIF, PNG, TIF, BMP, PSD, CDR, SVG, etc., Graphics Files: Vector Image and Raster Images. Definition, Feature, Area of Application etc.