DCA Eligibility, Syllabus and Subjects
Definition(परिभाषा)
- DCA का फुल फॉर्म – Diploma in Computer Application होता है.
- DCA Course में प्रवेश जनवरी एवं जुलाई में होता है.
- DCA एक साल का डिप्लोमा कोर्स है जिसमें कोई भी विषय से Graduation करने के पश्चात Admission लिया जा सकता है।
- DCA की फीस यूनिवर्सिटी व अध्ययन केंद्रों के अनुसार अलग-अलग हो सकती है फिर भी अनुमानित रूप से 10000 से 20000 तक हो सकती है.
- DCA का उद्देश्य छात्रों को कंप्यूटर सॉफ्टवेयर और प्रोग्रामिंग के Theory and Practical पहलुओं से परिचित कराना है।
DCA के तहत First Semester में Fundamentals of Computers, PC Packages, Database Using MS Access, तथा Second Semester में IT Trends, Internet and E Commerce, DTP with Page Maker and Photoshop or Multimedia with Corel Draw आदि विषयों का अध्ययन करना पड़ता है. - सभी विषयों का अच्छे से अध्ययन करने पर आपको भविष्य में Data Entry Operator, Office Work, Graphics Designer, Web Designer, जैसे क्षेत्रों में नौकरी के अवसर प्राप्त हो सकते है.
- इसके अलावा आप यदि किसी प्रतियोगी परीक्षा की तैयारी कर रहे है तो वहां भी एक साल का कम्प्यूटर डिप्लोमा के रूप में भी DCA का डिप्लोमा काम आयेगा साथ ही साथ परीक्षाओं में आने वाले कम्प्यूटर के प्रश्नों का भी आप आसानी से हल कर पाओगे.
इसकी Syllabus, Subjects की जानकारी नीचे दी गई है :-
| S.no | Class | Subjects |
| 1 | 1DCA1 | Fundamentals of Computers |
| 2 | 1DCA2 | PC Packages (WindowsWord, Excel, Powerpoint) |
| Elective | ||
| 3 | 1DCA3 (A) | Database Using Foxpro |
| 4 | 1DCA3 (B) | Database Using MS Access |
इन सभी विषयों की तैयारी करने के लिए यहां क्लिक करें.
DCA SEMESTER – II
| S.no | Class | Subjects |
| 1 | 2DCA1 | IT Trends |
| 2 | 2DCA2 | Internet and E Commerce |
| Elective | ||
| 3 | 2DCA3 (A) | Multimedia with Corel Draw |
| 4 | 2DCA3 (B) | DTP with PageMaker and Photoshop |
इन सभी विषयों की तैयारी करने के लिए यहां क्लिक करें.
SEMESTER-I
1DCA1 COMPUTERS FUNDAMENTALS
UNIT-I
Brief history of development of computers, Computer system concepts, Computer system characteristics, 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, PCs specifications and main characteristics, Types of PCs- Desktop, Laptop, Notebook, Palmtop, PDA etc.
UNIT-II
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.
UNIT-III
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, CD, VCD, CD-R, CD-RW, DVD, DVD-RW, Video Disk, Blue Ray Disc, flash drives SD/MMC Memory cards, Solid-State Drive (SSD), Physical structure of floppy & hard disk, drive naming conventions in PC.
UNIT-IV
Software and Its Need, Types of Software System Software, Application Software, System Software- Operating System- definition & function, Device Drivers & Utili Programs, Introduction & Features of DOS, Windows, Programming Language Machine, Assembly, High Level, 4GL, their Merits and Demerits, Uses of Assemblers, Compilers and Interpreter.
Application Software and its Types Word Processing, Spreadsheet, Presentation Graphics, Data Base Management, Desktop Publishing, communication, Educational, Graphics & Multimedia, Business Accounting, MIS, Gaming and ERP Software etc.
Computer coding system-ASCII, ISCII and Unicode, Number system of computers- Binary, Octal, Decimal, Hexadecimal their conversion
UNIT-V
Use of communication and IT, Communication Process, Component of communication- sender, receiver, transmission medium & protocol, Communication types-Simplex, Half Duplex, Full Duplex, Communication Channels-Twisted, Coaxial, Fiber Optic, Modem-Working and characteristics, Types of network-client/server and peer-to-peer networks, Types of connections-Dialup, Leased Lines, ISDN, DSL, RF, Broad band uses, advantages & disadvantages, Types of Network-LAN, WAN, MAN, Internet, VPN etc., Topologies of LAN-Ring, Bus, Star, Mesh and Tree topologies structure, uses, advantages & disadvantages, Components of LAN-Media, NIC, NOS, Network devices- Bridges, HUB, Routers, Repeater, Gateways uses, advantages & disadvantages.
1DCA2 – PC PACKAGES (WORD, EXCEL, POWERPOINT)
UNIT-I
Operating System (Windows 8.1): Overview of Windows Operating System, Basic Operations-How to start a computer, login, logoff, hibernate, shutdown etc, Personalizing Desktop-Desktop Background, Icon, Screen Saver, Themes, Setting date & time, Task bar, Files & Folders, Create, Copy, Rename, Moving & Delete Files & Folders, Create & Using Shortcuts, Recycle Bin.
Accessories-MS Paint, Notepad, WordPad, Windows Media Player, Calculator, Games, Math Input Panel, Language Settings-How to set other languages on computer, Using Control Panel to add, remove or configuring new or existing devices and software programmes and fonts, Enhance the performance of computer, Using Disk Clean-up- Using Disk Defragmenter, Using Windows Update, Protecting your computer against viruses.
UNIT-II
MS Word Basics: Introduction to MS Office (2013), Introduction to MS Word, Features & area of use. Various versions of MS Office and their requirements, Working with MS Word, Menus & Commands, Ribbon, Toolbars & Buttons, Shortcut Menus, Wizards & Templates, Creating a New Document, Different Page Views and layouts, Applying various Text Enhancements- Fonts, Styles, Text Attributes, Formatting Your Text and Documents: Auto format, Paragraph and Page Formatting, Line spacing, Margins, Borders and Shading, Tabs and Indents, Text Editing using various features, Bullets, Numbering, Working with Styles, Printing & various print options, Working with Headers and Footers, Tables: Creating a simple table, Creating a table using the table menu, Entering and editing text in a table.
UNIT-III
Advanced Features of MSWord-Spell Check, Thesaurus, Find & Replace;, Files, Auto texts, Symbols etc., Working with Columns, Tabs & Indents, Margins & Space management in Document, Page, Column & Section Breaks, Adding References, Using footnote and endnote in documents, creating automatic Table of Contents,
Graphics: Importing graphics, Clipart, Insert picture, Using Clip Art, Shapes and SmartArt in documents, using drawing features, drawing objects, text in drawing. Taking and inserting Screenshots in Documents, Using WordArt and Drop Ca features in documents.
Mail Merge in MS Word, Mail Merge concept, Envelops & Mailing Labels, Importing and exporting to and from various formats
UNIT-IV
MS Excel Spreadsheet Basics & features, concepts of Workbook & Worksheets, Getting started, Creating a new worksheet, Using Wizards, Various Data Types, Selecting cells, Entering and editing text, Entering and editing Numbers, Removing & Resizing of Columns & Rows, entering and editing Formulas, Referencing cells, moving cells, copying cells, sorting cell data, inserting rows, inserting columns, Inserting cells,Deleting parts of a worksheet, clearing parts of a worksheet, Different Views of Worksheets.
Formatting: Page setup, Cell Formatting, changing column widths and Row heights, auto format, changing font sizes and Attributes, centering text across columns, using border buttons and Commands, changing colors and shading, hiding rows and columns, Working with Data & Ranges, Column Freezing, Labels, Hiding, Splitting, merging etc.
Charts: Chart parts and terminology, chart wizard, different types of charts, printing charts, deleting charts, Printing of Workbook & Worksheets with various options
UNIT-V
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, shapes, screenshots, SmartArt and charts in presentation, Sounds and Movies to a Slide; Working with PowerPoint Objects, Designing & Presentation of a Slide Show, change Slide backgrounds, Change Slide Size, Using Animation and Transitions in presentation, Advanced Slide options- Manual & Automatic, Printing Presentations, Notes, Handouts with print options, Slide Master, Handout Master and Notes Master.
1DCA3(B) DATABASE USING MS ACCESS
(ELECTIVE-I)
UNIT-I
Introduction to database- What is a Database, Why use a Relational Database, concept of primary key relationship, Introduction to MS Access (Objects, Navigation)
UNIT-II
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, filter/select, rearrange columns, freeze columns. Edit a Tables- copy, delete, import, modify table structure, find, replace
UNIT-III
Add a relationship, set a rule for Referential Integrity, change the join type, delete a relationship, save relationship Queries & Filter difference between queries and filter, filter using multiple fields, Create Query with one table, find record with select query, find duplicate record with query, find unmatched record with query, run query, save and change query
UNIT-IV
Introduction to Forms Types of Basic Forms: Columnar, Tabular, Datasheet, Main/Subforms, add headers and footers, add fields to form, add text to form use label option button, check box, combo box, list box Forms Wizard, Create Template
UNIT-V
Introduction to Reports, Types of Basic Reports: Single Column, Tabular Report Groups/Total, single table report, multi table report preview report print report, Creating Reports and Labels, Wizard
SEMESTER-II
2DCA1-IT TRENDS
UNIT-I
Multimedia Definition and concept, need of Multimedia, areas of use, multimedia elements- Text, Images, Sound, Animation and Video, Multimedia Hardware and Software requirement. Making simple Multimedia with PowerPoint Application of multimedia in different industries- Education, Entertainment, Journalism etc., Future of Multimedia, Career in Multimedia Production
UNIT-II
Text as a component of Multimedia, Concepts of plain & formatted text, RTF & HTML texts, Object Linking and Embedding concept, Fonts need & types, Importance of sound in Multimedia, Mono V/S Stereo Sound, Effects in Sound, Analog V/S Digital Sound, Overview Of Various Sound File Formats on PC WAV, MP3. Concept of MIDI, Software for sound editing and mixing.
UNIT-III
E-governance, e-democracy, Government efforts to encourage citizen participation, PPP model, E-governance websites & services- SAMADHAN online, CM Helpline, MPonline services, mygov.in of government of India UIDI & Adhar, E-governance mobile apps like umang, Digital Locker, Digital Library, Introduction to cyber crime, types of attacks & crime email fraud, phishing, spoofing, hacking, spyware, malware, spam mail, logic bombs, denial of service, identity theft.
UNIT-IV
Introduction to wireless LAN, Blue tooth, WiFi, WiMax Mobile technology, 2G, 3G, 4G services, IMEI, SIM, IP Telephony, Soft phone, Voice mail, Ad-hoc & sensor networks, GIS, ISP Mobile Computing, Cellular System Cell, Mobile Switching office, Hands off, Base Station
UNIT-V
Artificial Intelligence and Expert system- Concepts of Al & Expert Systems, Merits and Demerits of Expert system, Application of Expert system and Al Cloud computing- Introduction, types, application, services, Google drive, Google Doc, Google form
2DCA2 – INTERNET AND E-COMMERCE
UNIT-I
Introduction to Internet Internet Evolution, Word Wide Web (WWW), Advantages and Disadvantages, Internet Vs Intranet, the purpose and function of an Internet Service Provider (ISP), Connectivity Dialup, Leased line, VSAT, URLs, Portals, Internet Services, Application, E-MAIL- Basics of Sending & Receiving, Free Email services, Protocols, FTP, DNS, TCP, UDP, HTTP, IP Telnet Concept, Internet chatting- Voice chat, Text chat, Web Servers, Space on Host Server for Website, Web Portals & Web publishing concepts, Domain name registration.
UNIT-II
Applications of Internet, Basic Operations using Internet Browser-Working with browsers, View History in Browser, Search Engines, Searching information on Wikipedia, Subscribing and reading newspapers online, Typing text in the regional language- Google input tools, Using Google Maps, Working with Google Apps, Online Ticket Booking. Apply for PAN Card/Passport /Aadhar Card online, Pay electricity bill and service tax online, Booking gas refill online, Downloading eBooks, Create & Using Bookmarks, Using JustDial/quikr.com/getit.co.in/sulekha.com to find online services, social sites, Client server architecture & characteristics, Telnet (Remote login concepts) & FTP its uses.
UNIT-III
HTML- Concepts of Hypertext, Versions of HTML, Elements of HTML, HTML editors, Tags and attributes, Syntax, Head & Body Sections, Building, HTML Documents. Inserting Texts, Images, List & its type, Hyperlinks, Backgrounds And Color Controls. Table Layout and Presentation, Use of Font Size & Attributes, List Types and Its Tags, Use of Frames and Forms in, Web Pages HTML, Form and frame Design tools.
UNIT-IV
JavaScript Overview, syntax & conventions. Variables, Expressions, Branching & Looping statements, Functions, Arrays Objects, Events & Document Object Model- onClick, onMouseOver, on Submit, on Focus, on Change, onBlur, onLoad, onUnk Alerts, Prompts & Confirms.
UNIT-V
Introduction to E-Commerce, Electronic Commerce Framework, Evolution of E- commerce, Advantages and Disadvantage of E-commerce, Introduction, E- organization, Electronic Payment Systems, Electronic Cash, Smart Cards and Credit Card Based, Risks, Online Banking, E-Banking, E-Wallet, E shopping, E-Marketing: The scope of E-Marketing, M-commerce- introduction, Potential Growth and Future, Mobile banking, Paytm, Bhim, UPI app etc.
2DCA3(A) – MULTIMEDIA WITH COREL DRAW
(ELECTIVE-II)
UNIT-I
Graphics in Multimedia, Importance of Graphics in Multimedia, Vector and Raster Graphics, Image Capturing Methods Scanner, Digital Camera Etc. Various Attributes of Images Size, Color, Bit Depth, Resolution etc, Various Image File Format BMP, DIB, EPS, PIC, and TIF Format Their Features and limitations
UNIT-II
Video and Animation in Multimedia, Impact of Video in Multimedia, Basics of Video Analog and Digital Video, How to use video on PC, Brief note on various video standards PAL, NTSC, Different file formats and their use in Multimedia, MPEG, AVI, MJPG, Name of video editing software, Basics of Animation, Types of Animation and use of Animation, Software for Creating Animations
UNIT-III
Introduction to Corel draw, Usage and Advantages, Introduction to User Interface, Introduction to tool panel and workspaces, Introduction to various size and formats of panels and layouts, File layouts and layout properties, Objects and using color profiles
UNIT-IV
Text tools and text properties, Creating Vector graphics by using editing tools, Importing Images and graphics in Corel draw layout, Creating shapes and editing shapes, Drawing curves and editing curves, special object effects, Using color effects Creating special text effects, Creating
UNIT-V
Using grid and rulers, Tracing images and graphics, Working with borders and page arrangements, Using Masking effects with Text, Using Masking effects with objects
2DCA3(B) – DTP WITH PAGEMAKER & PHOTOSHOP
(ELECTIVE-II)
UNIT-I
Introduction to Desk Top Publishing, Introduction to Desk Top Publishing (DTP), History, Definition, Need and Area of Application, Difference between a word processor and Publication Software, Use and importance of DTP in Publication & Newspaper Printing, Various DTP Softwares, Introduction to Offset Printing Technology, Printers Formatting of a text: Typography, Fonts, Point Size, Spacing, Breaks, Measurements etc., Types of Printing: Lithography, Flexography, Gravure, Screen Printing, Offset Printing. Working of offset Printing, Terms used in Offset Printing: Bleed, CMYK, Impressions, Importance of D.T.P in Publication, Advantage of D.T.P in Publication. Laser printers Use, Types, Advantage of laser printer in publication
UNIT-II
Adobe Page Maker Introduction to Page Maker, Aldus & Adobe Page Maker, Previous and current versions of Page Maker, Page Maker as a DTP Software, Attribute settings: Tools, Styles, Menus, Alignments, Grids, Guides etc., Keyboard shortcuts, Page Layouts- Margins and Page Orientations with various page sizes, Text Editing and Manipulation, Filters, Import and Export options, Placing of Text and Images, Auto flow and Story Editor, Different Layout views, Tab setting, Columns & Gutters, Use of Styles, Palettes & Colours, Find Option & Document Setup
UNIT-III
Adobe Page Maker- Page and document setup, working with rulers, setting the unit measurement, Bullets, Column Balancing, Breaks, Text Wrapping, Widows & Orphan lines, Revert Command and its use, Using Drop Caps and various style formats, Editing of Graphics and Frames, OLE & Embedding, Plug-ins, Mathematic Equation, Table Editor and it use, Master Pages, Headers & Footers, Frame Options, Print Setup Options, Managing and Printing Publications Tiles, multiple copies etc. Use of Page Maker in News paper and Magazines
UNIT-IV
Introduction to Adobe Photoshop, Photoshop Documents, Various Graphic Files anu Extensions- JPG, GIF, PNG, TIF, BMP, PSD, CDR, SVG etc., Graphic Files: Vector Image and Raster Images. Definition, Features, Area of application etc., Advantages and Disadvantages Vector & Raster Graphics, Bitmap Graphics, Pixels, Application Programs to work on Vector Graphics and Raster Graphics, Various Color Modes and Models: HSB, RGB, CMYK, Bitmap, Grayscale, Duotone Image: Image Size and Resolution, Changing Image Size and Resolution, Getting Image from Input Devices, Creating New image in Photoshop, Using File Browser, Opening and Importing Selecting Image, Adjusting Pixel, Snap command, Saving and Loading Selection, Deleting Selection
UNIT-V
Photoshop Introduction PSD files. Screen and Work Area Interfaces: Menu Bar, Option Bar, Palette, Active Image Area, Tool Box List etc., Opening a File, Saving a
File, Closing a File, Tool: Icons, Name and usage of Each tool, Setting History Option, Photoshop Layers & Palettes: Use of Layers, Why Use Layers, Using layer palette, Creating Layers and Layer Sets, Background layer
Working with layered Image: Layer and Layer sets, Selecting Layers, Displaying Content of a Layer, Duplicating Layers, Changing Order of Layers, Linking and Aligning Layers, Renaming, Deleting Layer, Color Coding, Rasterizing Layer, Setting Opacity and Blending, Layer Effect and Style, Applying Preset Style, Creating Custom Style, Masking Layer
Filters: Using Filter Gallery, Filter Gallery Dialogue box, Applying and Blending Filters, Choosing various Filter Effects