A Diploma in Computer Application (DCA) is a one-year diploma course that provides foundational knowledge and skills in computer applications. This course is designed for individuals who are interested in entering the field of information technology (IT) and wish to gain

The course is intended to provide learners with basic, realistic and technological details pertaining to programming tools and applications which are used in our everyday lives.

In this era of modernity, youth have countless such opportunities available, through which youth get a lot of help in career options. One of these is DCA computer course. The full form of DCA is DCA "Diploma in Computer Application". It is a diploma course, after doing which youth get help in making their career in any field related to computer. This video of ours is based on DCA Syllabus, in which you will see what is DCA? What is the full form of DCA? How much time does it take to do DCA course? And what job can you do after doing it. Through this video you will learn in detail about DCA computer course and its syllabus, as well as by the end of this video you will get the answer to every question related to DCA computer course

DCA1 - ­ FUNDAMENTALS OF COMPUTERS AND INFORMATION TECHNOLOGY

Know the Computer -, Introduction, What does computer stand for?, Strengths of computers, Limitations of computers, Fundamental uses of computers, Development of computers, Types of Computers, Generations of Computers

Personal Computer - Introduction, Personal computer, Uses of personal computers, Components of personal computers, Evolution of PCs, Developments of processors, Architecture of Pentium IV, Configuration of PC

Input Devices - Introduction, Input Device, Typing Input Devices, Pointing Input Devices, Scanning Input Devices, Audio Visual Input Devices

Operating System - Introduction, Operating System, Why an Operating System, Functions of Operating System, The Booting Process, Types of Reboot, Booting From Different Operating System, Types of Operating System, Some Prominent Operating Systems

Computer Virus - Introduction, Virus, History, Mechanism of virus, How A Virus Spreads , How is virus named, A few Prominent Viruses, Types of Computer Virus, Related Concepts :, Anti Virus Programs, Norton Anti - Virus (NAV), Execution of Norton Anti-Virus

Communication and IT - Introduction, Computer Network, Communication Process, Communication Types, Transmission Media, Wireless Media, Communication Channels/Media, Modem, Characteristics of a Modem, Types of Modem

Internet - Introduction, What is Internet actually ?, Growth of Internet, Owner of the Internet, Internet Service Provider, Anatomy of Internet, ARPANET and Internet history of the World Wide Web, Services Available on Internet (Internet Tools), Basic internet terminologies, net etiquette, Application of internet

Applications of Computers and Information Technology - Introduction, Business And Computer, E-Mail, E-Commerce, Project management, Computers in Personnel Administration, Accounting, Computers in Cost and Budget Control, Marketing, Manufacturing, Materials management, Banking, Insurance And Stock broking, Purchasing, Computers in warehousing

Output Devices - Introduction, Output Devices, Soft Copy Vs Hard Copy Output, Monitor, Printers, Plotter , Electrostatic Technique, Special Purpose Output Equipments

Central Processing Unit - Introduction, What is Central Processing Unit, Arithmetic And Logic Unit, Control Unit, Registers, Instruction set, Processor Speed

Storage Devices - Introduction, Storage and its needs, Brain Vs Memory, Storage Evaluation Units, Data Access Methods, Primary Storage, Secondary Storage, Hard Disk Operations, Floppy Disk Drives, Winchester Disk, Optical Disk, VCD, CD-R, CD-RW, DVD, Zip Drive, Flash Drives, Blue Ray Disk, Memory Card, Driving Naming Conventions In a PC

Basics of Software- Introduction, What Does Software Stand For ?, Needs of software, Types of software, Open Source Software, Integrated Development Environment

Disk Operating System - Introduction, What is DOS?, Functions of DOS, Versions of DOS, DOS Commands , Important Internal Commands of DOS, Important External Commands of dos, Executable Vs Non-Executable Files In Dos Programming Languages , Introduction, Data, information And Knowledge, Characteristics of Information, Comparison between human language and , Computer Language, What is a program?, What is a Programming language?, Programming development cycle, Algorithm, Program Flowcharts, Pseudo code, Programming approaches, Programming Paradigms, Types of Programming Language, Third Generation Language, Fourth Generation Language

Networks - Introduction, Internet Vs Intranet, Types of Network, Topology, Types of Connectivity, Network Devices

Management Information System - Introduction, Information System, Management Information System (MIS), Fields of Information System, Elements Of MIS, Objectives Of MIS, Characteristics of MIS, Impact Of MIS, Designing An MIS, Placement Of MIS, Views Of MIS, Pitfalls In Designing an MIS, Advantages of MIS, Disadvantages of MIS

DCA2 ­ OPERATING SYSTEMS

WINDOWS - Introduction to Windows, its various versions and features. Hardware requirements for various versions of Windows. Working with Windows (XP or Windows 7) Windows concepts, Windows Structure, Desktop, Taskbar, Start Menu, Working with files and folders, create, copy, delete, renaming and moving files and folders, working with recycle binrestoring deleted files, emptying the recycle bin, searching files and folders .My computer, formatting floppy disks, Using CDROM Disk and Dives. Using Windows Accessories programs- Calculator, Notepad, Paint, WordPad, Character map, Paint, Command line. Using Media Player, Sound Recorder, Volume Control.Taking Printout from programs, Printer Properties, Add fonts to Windows (Specially adding Hindi Fonts and using them). Setting up Regional and Language settings in Windows. Advanced features of Windows -Managing Hardware & Software – Add or remove Hardware devices to/from computer, Add/remove programs, Using Scanner, Web camera, sharing of printers. System Tools - Backup, Clipboard Viewer, Disk Defragmenter, Drive Space, Scandisk, System Information windows update. Communication – Setting up Dial up Networking with Windows, Internet connection with Windows, Direct Cable Connection, Setting up TCP/IP properties, Hyper Terminal, Phone Dial ,Browsing the Web with internet explorer, communication through Outlook Express, Multiple Users Features of Windows. Creating and deleting user, changing user password etc. Accessibility Features of Windows.-Sharing Information between Programs, sharing folders and drives browsing the entire network, mapping windows shared drives, Using shared printers - Understanding OLE - Embed/Link Using Cut and Paste and Embed/Link Using Insert Object - Manage Embedded/Linked Object.

Fundaments of operating system , definition and need. Main Services of operating system , various types of operating system, (definition and characteristics), multitasking, multiprocessing , multiprogramming, real time, time sharing, parallel, network operating system, booting process, file system

DISK OPERATING SYSTEMS (DOS) - Introduction, History & versions of DOS DOS basicsPhysical structure of disk, drive name, FAT, file & directory structure and naming rules, booting process, DOS system files. DOS commands: Internal - DIR, MD, CD, RD, COPY, DEL, REN, VOL, DATE, TIME, CLS, PATH, TYPE etc. External Commands - CHKDSK, XCOPY, PRINT, DISKCOPY, DISKCOMP, DOSKEY, TREE, MOVE, LABEL, APPEND, FORMAT, SORT, FDISK, BACKUP, EDIT, MODE, ATTRIB, HELP, SYS etc

LINUX - Linux introduction, Basic Features, Advantages, Features of Linux, Basic Architecture of Unix/Linux system, Kernel, Shell, Linux File system, Linux standard directories. Partitioning the Hard drive for Linux, Installing the Linux system, System, startup and shut-down process, How Linux works, Linux GUI, Linux Desktop, Creating files in Linux. Essential linux commands Understanding shells, Commands for files and directories cd, ls, cp, md, rm, mkdir, rmdir, pwd, file, more, less, creating and viewing files using cat, file comparisons – cmp & comm, View files, disk related commands, checking disk free spaces.

DCA3 – COMPUTERS INOFFICE–I (MS WORD & MS EXCEL)

MS Word Basics: Introduction to MS Office; its components, Introduction to MSWord; Features & area of use. Working with MS Word.; Menus & Commands; Toolbars & Buttons; Shortcut Menus, Wizards & Templates; Creating a New Document; Saving document, Saving as different format, Different Page Views and layouts; Applying various Text Enhancements; Working with – Styles, Text Attributes; Paragraph and Page Formatting- Using page border and watermark, Text Editing using various features ; Bullets, Numbering, Auto formatting, word count, various page view options, Printing & various print options

Advanced Features of MS-Word: Spell Check, Thesaurus, Find & Replace; Headers & Footers ; Inserting – Page Numbers, Pictures, Files, Auto texts, Symbols etc.; Working with section breaks and page breaks, Working with Columns, Tabs & Indents; Creation & Working with Tables including conversion to and from text; Margins & Space management in Document; Adding References – footnotes, endnotes, and Table of contents, Insert drawing, Mail Merge, Envelops & Mailing Labels, protect and secure documents in MS Word, Working in different languages in MS Word. Using Unicode in MS Word, Insert WordArt and other objects like shapes, clipart, charts and SamrtArts, symbol in Document. Using Macros in Word- Record, edit and run macros.

MS Excel: Introduction and area of use; Working with MS Excel.; concepts of Workbook & Worksheets; Using Wizards; Various Data Types; Using different features with Data, Cell and Texts; Inserting, Removing & Resizing of Columns & Rows; Working with Data & Ranges; Different Views of Worksheets; Zooming, Column Freezing, Labels, Hiding, Splitting etc.; Using different features with Data and Text; Use of Formulas, Calculations using various type of functions-Logical, string, date & time, maths and other types; Cell Formatting including Borders & Shading; conditional formatting, sorting data items, Working with Different Chart Types; Printing of Workbook & Worksheets with various options. Import and export excel sheets to/from various format, add headers and footers, using macros in excel sheet- Record, edit and run macros.

DCA4 – COMPUTERS INOFFICE–II (MS POWERPOINT, MS ACCESS & MS OUTLOOK)

MS PowerPoint: Introduction & area of use; Working with 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, Columns & Lists; Adding Graphics, Sounds and Movies to a Slide; Working with PowerPoint Objects, Insert WordArt and other objects like shapes, clipart, charts and SamrtArts, symbol in PowerPoint, Designing & Presentation of a Slide Show; Master slide, Adding custom animation and effects in your presentation, Add time to your slide, Slide Sorting, Printing Presentations, Notes, Handouts with print options, Package your presentation for CD.

MS-Access – Getting Started, Adding and Changing Data, Simple Queries, Creating Append Queries, Creating QBE Queries, Multi-table QBE Queries, SQL Queries.

Outlook Express - introduction, WHAT IS outlook express?, Features of Outlook Express, starting outlook express, Concepts of CC and BCC, Email Address, Reading a received message , composing message, Replying And Forwarding Messages, Attaching files, Creating Signatute In Outlook Express, Formatting message text, What is MIME?, Applying stationery, Inserting a hyperlink or HTML page into a message, Flagging an e-mail or news message, Importing messages from other e-mail prograMS, What are newsgroups?, Adding a newsgroup account, Switching between e-mail and news reading, Identities (Multiple Users on A Single Computer), Adding a new identity, Managing Contacts With Outlook, creating addresses, Importing an address book from another program, Using keyboard shortcuts in Outlook Express

DCA5­ COMMUNICATION SKILLS & PERSONALITY DEVELOPMENT

English Language - Listening, Speech, Pronunciation, Reading, Spelling, Writing Right Nouns : Countable and Uncountable, Pronouns : Personal, Relative and Others, Articles The Parts of Speech, The Prepositions, Clauses : Coordinate, Subordinate, Relative Adverbs, Adjectives and Adjective Phrases, Verb The Model Auxiliaries, Adverb, Adverb Phrases Comparisons and Intensification, Linking Devices, Subject Verb Agreement, Tenses, Common Errors, Word Building, Vocabulary Developing Ability of Question and Answer, Body Language and Its Use in Speaking, Group Discussions, Interview Skills Composition - Making a Technical Report, E-Mails and Text Messages Composing, Letter Writing, Paragraph Writing, E-mail Writing, Writing Resume, Writing a Cover Letter

Personality development: Soft Skills Development, Body Language, Behavioral and Symptomatic Soft Skills, Etiquette and Manners, Positive Thinking, Motivation, Goal setting, Team building, Self Confidence, Leadership Skills, Time Management Introduction to Personality a) Basic of Personality b) Human growth and Behavior c) Theories in Personality d) Motivation Communication skills and Personality Development a) Intra personal communication and Body Language b) Inter personal Communication and Relationships c) Leadership Skills d) Team Building and public speaking Techniques in Personality development I a) Self confidence b) Mnemonics c) Goal setting d) Time Management and effective planning Techniques in Personality Development II a) Stress Management b) Meditation and concentration techniques c) Self hypnotism d) Self acceptance and self growth

2DCA1 ­INTERNET & WEB TECHNOLOGY

Introduction To Internet- introduction, what is internet actually ?, growth of internet , owner of the internet, internet service provider, anatomy of internet, Arpanet and internet history of the world wide web, services available on internet wais , basic internet terminologies, net etiquette, applications, commerce on the internet, governance on/through the internet, impact of internet on society

Internet Connectivity - connectivity types, level one connectivity, level two connectivity, level three connectivity, hardware requirements, modems, narrow-band/phone-line dialup modems, software requirements, modem configuration:, telephone line options, making a dial-up connection, protocol options, service options, news services, desktop alerts

Services Of Internet (Definition And Functions) - introduction, file transfer protocol, ftp related terminologies, ftp servers and authentication, public and private software services, ftp clients, types of ftp client software, displaying files , remote login, chat programs, connecting to a server, search engines

Current Trends On Internet -current trends of internet:, languages used on the internet, internet phones, internet video / internet tv, streaming video & audio, collaborative computing, e-commerce, technical and organizational aspects

World Wide Web- introduction , evolution of the www, basic features, mechanism of the world wide web, search and meta-search engines, searching the web, using Boolean operators in your searches, using advanced , using a Metasearch engine, site specific search tools, web protocols, hyper text transfer protocol (http), web server

Hyper Text Markup Language Programming Basics - introduction, html editors, elements of html, definition lists , compact attribute, nested list, type attribute, html links, using alt attribute, background graphics, html document tables, creating tables within tables, html frames, html rules, introduction of multimedia, meaning of multimedia, what is multimedia ?, identifying multimedia elements, audio on the web, video on the web

Internet Security Management Concepts, Information Privacy And Copyright Issues - overview , basic security concepts, security events, measures for check threats, firewalls , monitoring tools, security analysis tools, cryptography , information privacy, copyrights and the internet, copyright legislation in India, key points of copyright, encryption & decryption - cryptography, terminology

TCP/IP - Internet Technology And Protocols-introduction, switching technology , internet protocols, overview of TCP/IP reference model, introduction to TCP/IP, routers, internet addressing scheme

Internet Network- computer networks, applications of networks, common terminologies :, interoperability, network security, the need for security, common threats, security barriers in network pathways, network components :, communication media, network devices, types of network : client / server & peers, addressing in internet, domain name system (DNS), domain name and their organization, network topology, internet vs. intranet

Electronic Mail - introduction, what is an e-mail?, email networks and servers, merits of email, limitations, e-mail protocols, structure of an e-mail, e-mail address, Microsoft internet explorer and outlook express, applying stationary, web based emails, working with yahoo, starting the mail program , creating signature in outlook express, creating signature in yahoo, email encryption, why email encryption?, digital certificate

Web Publishing- overview, SGML (standard generalized markup language), what is the need of a website? , types of web sites, components of web publishing , domain name planning and registration, choosing a web host and signing up for an account, web hosting, web design and development, testing your website, promotion of the site, registering your site with a search engine, publishing tools, html editor, image editor, program to transfer your files to a web server, uploading web pages using CuteFTP

Browsers , introduction, www web browsers, Mozilla Firefox browser, the opera browser, google chrome, what are bookmarks?, adding folders, favorites, deleting favorite folders and pages, history, progress indicator, customizing internet explorer, turning off graphics to display all web pages faster, customizing the toolbar, copying, saving and printing in internet explorer, printing an image from a web page, printing a web page, cookies, what is cache setting ?, internet explorer, the standard toolbar, internet explorer keyboard shortcuts

Introduction To Interactivity Tools- overview, what is ASP?, functions of asp, the basic syntax rule , writing output to a browser, adding some html to the text, declaring a variable in asp, declaring an array in asp, what is VBScript?, java, features of java, starting with java, Javascript and java, syntax and conventions, FrontPage, introduction to flash, installation of flash MX, creating simple animation for the web, working with layers in flash, masking in flashmx, bouncing effect in flash, to create motion tween , flash ripple effect

Firewalls - firewalls, firewall design principles, firewall attributes, firewall strengths and weaknesses, types of firewalls, comparison of firewall types, DMZ DNS server, VLAN

2DCA2 ­INTRODUCTION TO FINANCIAL ACCOUNTING WITH TALLY

Accounting, Meaning Of Accounting, Objectives Of Accounting, Important Terms, Accounting Equation, Rules Of Debit And Credit- Journal & Ledger, Journal, Ledger, Cash Book, Subsidiary Books, Financial Statement, Trading & P&L A/C, Balance-sheet, Inventory, Adjustment Entries, Bill Of Exchange Installing Tally 9, Introduction, Tally 9.0 (Release 1.0), Major Enhancements In Tally 9, Minor Enhancements In Tally 9, Multilingual Business Accounting And Inventory Management Features, Performance And Implementation Features, Accounting And Inventory Control Features, Installing Tally 9.0, Application Directory, Data Directory, Configuration Directory, Language Directory, Activating Tally, Activating Tally Gold For Multi User, Registering Tally, Validating Tally, Tally Data Migration Tool, Uninstalling Tally 9 ABC of Company, Creation Of New Company Selection Of New Company Deletion Of Company Alteration Of Company Shut A Company Company Features, Features Of Company Accounting Features Inventory Features, , Statutory Features Tally Screen Components, Title Bar, Button Bar, Calculator, Working Are, Quitting, Gateway Of Tally, Current Status Area Configuration, General, Numeric Symbols, Accts/Inventory Info, Printing, Connectivity, Licensing, Shop, Quit Budget, Introduction, Budget, Creating Budget, Alter A Budget, Delete Budget, Display Budget/ Budget Variance, Scenarios Job Costing, Introduction, Enabling Or Configure Job Costing In Tally, Master Creation For Job Costing, Voucher Type And Voucher Class, Job Cost Reports Reports, Introduction Accounting Reports, Trial Balance, Balance Sheet, Profit & Loss, Cash Flow Statement, Fund Flow Statement, Ratio Analysis, Day Book, Cash/Bank Book Sales Register Purchase Register Outstanding Interest Cost Centers Job Work Analysis Statistics Inventory Reports Accounts Groups & Ledgers, Introduction Accounts Group Multiple Group Creation Display Group Alter Group Multiple Ledgers Display Ledger Alter Ledger Voucher Types Payroll Accounting, Introduction, To Activate Payroll In Tally 9, Payroll Menu, Display Pay Heads, Multiple Group Creation, Employee Creation, Salary Detail, Attendance, Attendance Type, Voucher Creation Export & Import, Introduction, Export, Import, ODBC Compliances. Cost Centre, Introduction Cost Centre, Creating Cost Centre, Display Cost Centre, Alter Cost Centre Cost Category, Create Cost Categories, , Display Cost Categories, Alter Cost Categories Voucher Entry Cost Centre Class, Creating Cost Centre, Invoice Entry Using Cost Centre Reports Related To Cost Centre Foreign Currencies, Introduction Foreign Currency, Create Foreign Currency, Alter Foreign Currency, Display Foreign Currency, Exchange Rate Entry Voucher Entry Using Foreign Currency Voucher Entry through Forex Journal Voucher Class Reports Related To Foreign Currency Interest, Introduction, Interest, Simple Mode, Interest On Outstanding Balances, Reports On Interest Calculated On Outstanding Balances, Advanced Parameter Mode, Interest Calculation Transaction By Transaction/Voucher Interest At Fixed Rate, Voucher Interest At Variable Rate, Statement Of Interest Due On Invoice, Interest Reports, Interest Voucher Class Printing, Introduction Cheque Printing, Multi Account Printing, Printing Options General, Purchase Printing, Sales Transaction, Receipt Voucher, Journal/Contra, Debit/Credit Note, Reminder Letter, Confirmation Statement Reports Printing Button Related Bank Reconciliation, Introduction, Bank Reconciliation In Tally 9, Configuration Of Bank Reconciliation Security Control, Introduction Security Levels Access Type Backup & Restore, introduction, Group Company, Create a Group Company, Alter a Group Company, Tally Audit, Splitting Company Data Inventory, Introduction Stock Group Stock Item Stock Categories Godowns Units Of Measures Rate Of Duty Inventory Vouchers Reorder Level Inventory Reports Inventory Info Inventory Books Statement Of Inventory Batch Wise Details Price List

2DCA3 ­ PROGRAMMING WITH VISUAL, BASIC.NET

FOXPRO - THE RDBMS FOR PC 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, QUIT, FoxPro - Data Types

PRINTING REPORTS AND LABELS FoxPro Report - its creation, features & Utilities, Preview, Printing, Custom Report, grouping & Subgrouping. FoxPro Label - Designing & Printing

MATHEMATICAL COMMANDS AND FUNCTIONS Arithmetic Operations, Mathematical Functions, Mathematical, Commands, Statistical Functions.

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 & USER DEFINE FUNCTIONS & OTHER TOOLS, Create Custom Screen with @, @_GET, @_EDIT, _SAY_GET_READ, Creating Box & Lines, User Define Functions, Custom Screen, Designing and their Use, FoxDoc for documentation.

SORTING AND INDEXING OF DATABASE FILES Sorting & Indexing Concept, Sort Commands - Single & Multiple Key, Advantage & Disadvantages of Sort Indexing Vs Sorting, Single & Multiple Key, Indexing, FIND, SEEK, Rushmore Technology

MEMORY VARIABLES, DATE & TIME FUNCTIONS AND KEYBOARD MACROS Memory Variables - Creation and Uses, Simple Vs Array, Saving and Restoring Memory Variables, ?/??/??? Commands, Time & Date Functions and Commands, Date Arithmetic, Converting Defining Function Keys, Keyboard Macros - Creating and Using

PROGRAMMING WITH FOXPRO Concepts of FoxPro commands file, Modify Commands, Conditioning , Branching and Looping within Program files with Do-While Enddo, If - Endif, Scan-Endscan, For - Endfor, DocaseEndcase, Text - Endtext, Executing Commands from

ERROR CONDITIONS AND PROGRAM DEBUGGING AIDS Common Error Massages, Debugging techniques and commands

2DCA5 – PROJECT REPORT

All the candidates of DCA are required to submit a project-report based on the work done by him/her during the project period. A detailed Viva shall be conducted by an external examiner based on the project report. Students are advised to see the detailed project related guidelines on the website of CVRU. (www.cvru.ac.in) under Project Guidelines for student section.

Scroll to Top