PC Package (Word, Excel, Power Point) DCA 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 –

  • MS Paint
  • Notepad
  • WordPad
  • Windows Media Player
  • Calculator
  • Games
  • Math Input Panel
• Language Settings – How to set other languages on computer

• Using Control Panel –

  • How to Install Program in Windows 8.1 
  • How to uninstall Program
  • 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

  • How to add a Style in text
  • How to remove style in Gallery
  • How to Create a New Style
  • How to Modify a Style
• Printing & various print options

• Working with Headers and Footers

  • How to Add Header and footer
  • How to add a image in header and footer
  • How to ad  a Page Number in Header and Footer
  • How to remove Header and footer

• Tables:

  • Creating a simple table, Creating a table using the table menu
  • 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.