DCA

Computer Fundamentals Notes

· कंप्यूटर का विकास तथा इतिहास (Brief history of development of computers)
· कंप्यूटर की अवधारणा (Computer System Concepts)
· कंप्यूटर के लाभ (Advantage of Computer)
· कंप्यूटर के तत्व (Components of a computer system) – Control unit, ALU, Input / Output, Memory Mother Board
· सेमीकंडक्टर मेमोरी क्या है? (semiconductor Memory functions and characteristics)
· मेमोरी क्या हैं और मेमोरी के प्रकार (Memory – RAM, ROM, EPROM, PROM and other types of memory, Capabilities and limitations)
· कंप्यूटर की पीढियां (Generations of computers)
· कंप्यूटर के प्रकार (Types of computers) – Analog& Digital & Hybrid Computers, General & Special Purpose computers, -Micro,Mini, Main frame and Super computers, 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 प्रिंटर (3D Printers)
· साउंड कार्ड और स्पीकर (Sound Card and Speakers)
UNIT III –
· Storage Fundamentals –
o प्राइमरी और सेकेंडरी मेमोरी में अंतर (Primary Vs Secondary Memory)
o डाटा एक्सेस करने की विधियाँ (Data Storage and Retrieval Methods- Sequential, Direct and Index Sequential)
o स्टोरेज डिवाइस (Various Storage Devices) – Magnetic Disks, Hard Disk Drives, Floppy Disk, Zip DriveOptical Disks, CD, VCD, CD-R, CD-RW, DVD,DVD-RW,Video Disk, Blue Ray Disc, flashiness/ MMC Memory cards, Solid-Stat Drive (SSD),
o हार्ड डिस्क का फिजिकल स्ट्रक्चर (Physical structure of hard disk)
o फ्लॉपी डिस्क का फिजिकल स्ट्रक्चर (Physical structure of Floppy Disk)
o कंप्यूटर ड्राइव का नामांकरण (drive naming conventions in PC)
UNIT IV –
· सॉफ्टवेयर क्या हैं और उसकी आवश्यकता (Software and Its Need)
· सॉफ्टवेयर के प्रकार (Types of Software) –
o सिस्टम सॉफ्टवेयर (System Software)
o एप्लीकेशन सॉफ्टवेयर (Application Software)
o यूटिलिटी सॉफ्टवेयर (Utility Software)
· डॉस क्या हैं इसकी विशेषताएं (Introduction & Features of DOS)
· विंडोज का परिचय (introduction to Windows)
· प्रोग्रामिंग लैंग्वेज (Programming Languages) Machine, Assembly, High Level, 4GL, their Merits and Demerits
· कम्पाइलर, इंटर प्रिटर और असेम्बलर (Uses of Assemblers, Compilers and Interpreter)
· Application Software and its Types-
o Word Processing
o Spreadsheet
o Presentation Graphics
o Data Base Management
o Desktop Publishing
o communication
o Educational
o Graphics & Multimedia
o Business Accounting
o MIS
o Gaming and ERP Software etc.
· कंप्यूटर कोडिंग सिस्टम (Computer coding system)-ASCII, ISCH and Unicode
· नंबर सिस्टम (Number system of computer)
· Binary, Octal, Decimal, Hexadecimal
· बाइनरी को डेसीमल में कैसे बदले (How to Change Binary to Decimal)
· हेक्साडेसीमल को डेसीमल में कैसे बदले (How to Change Hexadecimal to Decimal)
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.
· क्लाइंट सर्वर आर्किटेक्चर (client/ server and peer-to-peer networks)
· कनेक्शन के प्रकार (Types of connections)- Dial up, Leased Lines, ISDN, DSL, RF, Broad band uses, advantages & disadvantages.
· नेटवर्क के प्रकार (Types or Network)- LAN, WAN , MAN
· वीपीएन क्या हैं (What is VPN)
· टोपोलॉजी (Topologies of LAN) – Ring, Bus, Star, Mesh and Tree topologies structure, uses, advantage & disadvantages
· लेन के तत्व (components of LAN)- Media, NIC, NOS
· नेटवर्क डिवाइस (Network devices) – Bridges, HUB, Routers, Repeater, Gateways uses, advantages & disadvantages.
PC Package (Word, Excel, Power Point) Notes in Hindi (New 2018)
PC PACKAGES (WORD, EXCEL, POWERPOINT) DCA NOTES
UNIT I –
Operating System (Windows 8.1)
· Overview of Windows Operating System
Basic Operations-
· How to start a computer, login
· How to logoff, hibernate, shutdown etc
· Personalizing Desktop- Desktop Background, Icon, Screen Saver, Themes
· Setting date & time
· Task bar
· Files & Folders – Create, Copy, Rename, Moving & Delete
· Create & Using Shortcuts
· Recycle Bin.
· Accessories –
o MS Paint
o Notepad
o WordPad
o Windows Media Player
o Calculator
o Games
o Math Input Panel
· Language Settings – How to set other languages on computer
· Using Control Panel –
o How to Install Program in Windows 8.1
o How to uninstall Program
o How to Install and Uninstall Fonts in Windows 8.1
· Enhance the performance of computer
· Using Disk Clean-up
· Using Disk Derangement
· 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
· Customize the Ribbon
· Toolbars & Buttons
· Shortcut Menus
· Wizards & Templates
· Creating a New Document
· Different Page layouts
· Different Page View
· Applying various Text Enhancements- Fonts, Styles, Text Attributes
Formatting Your Text and Documents:
· Auto format
· Paragraph Formatting
· Page Formatting
· Line spacing
· Margins
· Borders and Shading
· Tabs
· Indents
· Text Editing using various features
· Bullets and Numbering
· Working with Styles
o How to add a Style in text
o How to remove style in Gallery
o How to Create a New Style
o How to Modify a Style
· Printing & various print options
· Working with Headers and Footers
o How to Add Header and footer
o How to add a image in header and footer
o How to ad a Page Number in Header and Footer
o How to remove Header and footer
· Tables:
o Creating a simple table, Creating a table using the table menu
o Entering and editing text in a table.
UNIT III –
Advanced Features of MS Word :
· Spell Check
· Thesaurus
· Find & Replace
· Auto texts
· Auto Correct
· Symbols
· Working with Columns
· Tabs
· Indents
· Margins & Space management in Document
· Column
· Section Breaks
· Adding References
· Using footnote and endnote in documents
· creating automatic Table of Contents.
Graphics:
· Importing graphics and insert picture
· Using Clip Art,
· Working with Shapes
· Smart Art in documents
· using drawing features
· drawing objects
· text in drawing.
· Taking and inserting Screen shots in Documents
· Using Word Art
· Drop Cap features in documents
· Mail Merge in MS Word
· Mail Merge concept
· Envelops
· Mailing Labels
· Importing data
· exporting to and from various formats.
UNIT IV –
MS Excel:
· 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 view 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
· Merge Cells
Charts:
· Chart parts and terminology
· chart wizard
· different types of charts
· printing charts
· deleting charts
· linking in spreadsheet
· 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
· 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
· Transitions in presentation
· Advanced Slide options Manual & Automatic
· Printing Presentations, Notes, Handouts with print options
· Slide Master
· Handout Master
· Notes Master.
DATABASE USING MS ACCESS 2013 DCA Notes in Hindi (New 2018)
DATABASE USING MS ACCESS 2013 DCA NOTES IN HINDI
UNIT – I
· डेटाबेस क्या हैं (What is a Database)
· रिलेशनल डेटाबेस क्या हैं (Why use a Relational Database)
· प्राइमरी की की अवधारणा (Concept of primary key relationshi_p
· ऍम एस एक्सेस का परिचय (Introduction to MS Access)
· ऍम एस एक्सेस के ऑब्जेक्ट्स (Objects of MS Access)
UNIT – II
Tables in Database
· ऍम एस एक्सेस में टेबल कैसे बनाये (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, import, modify table structure
UNIT – III
Working with Query
· रिलेशनशिप क्या हैं (Setting up Relationships- Define relationships)
· रिलेशनशिप कैसे बनाये (Add a relationship
· रेफरेंसियल इंटीग्रटी के लिए नियम सेट करें (Set a rule for Referential Integrity)
· ज्वाइन टाइप कैसे बदले (change the join type)
· रिलेशनशिप को डिलीट कैसे करें (delete a relationship)
· रिलेशनशिप को सेव कैसे करें (save relationship)
· क्वेरी का परिचय (Introduction of Query)
· क्वेरी और फ़िल्टर में अंतर (difference between queries and filter)
· एडवांस फ़िल्टर Filter using multiple fields AND, OR in Advance filter Queries
· एक टेबल के साथ क्वेरी कैसे बनायें (create Query with one table)
· सिलेक्ट क्वेरी (find record with select query)
· डुप्लीकेट रिकॉर्ड कैसे ढूंढे (find duplicate record with query)
· find unmatched record with query
· क्वेरी को रन और सेव कैसे करें (Run query and Save query)
UNIT – IV
Working with Forms
· फॉर्म का परिचय (Introduction to Forms)
· फॉर्म के प्रकार (Types of Basic Forms) :Columnar, Tabular, Datasheet, Main / Sub forms
· फॉर्म में हैडर और फुटर कैसे जोड़ें (Add headers and footers)
· फॉर्म में फील्ड कैसे जोड़ें (add fields to form)
· फॉर्म में टेक्स्ट कैसे जोड़ें (add text to form)
· Use Control Button
o कॉम्बो बॉक्स का प्रयोग कैसे करें (How to Use Combo Box)
o चेक बॉक्स का प्रयोग कैसे करें (How to Use Check box)
o आप्शन बटन का प्रयोग कैसे करें (How to Use Option Button)
o लिस्ट बॉक्स का प्रयोग कैसे करें (How to Use List Box)
· फॉर्म कैसे बनायें (How to Create form)
· विज़ार्ड के द्वारा फॉर्म कैसे बनायें (How to Create Forms Wizard)
· टेम्पलेट के द्वारा फॉर्म कैसे बनायें (Create Template)
UNIT – V
Working with report
· रिपोर्ट का परिचय (Introduction to Reports)
· रिपोर्ट के प्रकार (Types of Basic Reports): Single Column, Tabular Report Groups/Total, single table report, multi table report
· रिपोर्ट को प्रिंट कैसे करें (Preview and Print Report)
· रिपोर्ट कैसे बनाये (Creating Reports) and Labels, Wizard
IT Trends DCA Notes in Hindi (New Syllabus 2018)
IT TRENDS DCA 2nd SEMESTER NOTES
UNIT-I
· Multimedia Definition and concept, Need of Multimedia
· Areas of use multimedia
· 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-
o SAMADHAN online,
o CM Helpline
o MPonline services (mygov.in of government of India)
o UIDI & Adhar
· E-governance mobile apps like-
o umang
o Digital Locker
o 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 AI
· Application of AI
· Concepts of Expert Systems
· Merits and Demerits of Expert system
· Application of Expert system
· Cloud computing-Introduction, types, application
· Cloud Computing services-
o Google drive
o Google Doc,
o Google form
Internet and E Commerce DCA Notes in hindi (New Syllabus 2018)
इस पेज में आपको DCA 2nd सेमेस्टर के Internet and E Commerce विषय से सम्बंधित नोट्स प्राप्त होंगे|
INTERNET AND E-COMMERCE NOTES
UNIT-I
· Introduction to Internet
· Internet Evolution
· Word Wide Web (WWW)
· Advantages and Disadvantages of Internet
· Internet Vs Intranet
· the purpose and function of an Internet Service Provider (ISP)
· Connectivity – Dialup, Leased line, VSAT
· URLs
· Portals
· Internet Services and 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-
o Working with browsers
o View History in Browser
o Search Engines
o Searching information on Wikipedia
o 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
· How to apply for Passport
· How to apply Aadhar Card online
· Pay electricity bill
· Pay Service tax online
· Booking gas refill online
· Downloading eBooks
· Create & Using Bookmarks
· Using JustDial/quilcr.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 Tag
· 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
· Forms in Web Pages HTML
· Form and frame Design tools.
Unit-IV
· JavaScript Overview
· Syntax & conventions
· Variables
· Expressions
· Branching & Looping statements
· Functions
· Objects
· Document Object Model
· Arrays Objects
· Events- onClick, onMouseOver, on Submit, on Focus, on Change, onBlur, onLoad, onUnload ,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,Online Banking, E-Banking, E-Wallet
· 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.
DTP with Page maker & Photoshop DCA Notes in Hindi New syllabus 2018
DTP WITH PAGEMAKER & PHOTOSHOP NOTES
UNIT-I
· Introduction to Desk Top Publishing (DTP)
· History & Definition
· Need and Area of Application (DTP)
· Difference between a word processor and Publication Software
· Use and importance of DTP in Publication & Newspaper Printing,
· Various DTP Software
· 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 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, open Image in Photoshop
· Using File Browser
· Opening and Importing Selecting Image
· Adjusting Pixel
· Snap command
· Saving image 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 and 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,

Leave a Reply

Your email address will not be published.