PC Package (Word, Excel, Power point)

 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

Using Internet in Windows: Basic Operations using Internet Browser-

• Working with browsers
• Know about WWW
• URL
• Search Engines
• Searching information on Wikipedia
• Subscribing and reading newspapers online
• Typing text in the regional language
• Using Google Maps
• Working with Google Apps
• Online Ticket Booking
• Apply for PAN Card
• How to apply for online Passport
• How to Apply for online Aadhar Card
• Pay electricity bill
• How to pay service tax online
• Booking gas refill online
• Downloading Ebooks

UNIT II –

• Modern office activities and their software requirements
• Introduction to Office Automation Suit

Elements of office suit & area of use

• Word-processing
• Spreadsheet
• Presentation graphics
• Database

Introduction and comparison of various office suites like Apache OpenOffice, Libre Office, Calligra Suite, WPS office, KOffice
Google Docs

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
• selecting in table, adding rows, changing row heights, Deleting rows, Inserting columns, Deleting columns, changing column width
• conversion to and from text

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
• Using Themes
• Watermarks
• inserting Equations & Symbols

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

Templates:

• Template types
• using templates
• exploring templates
• modifying template

Mail Merge:

• Mail Merge in MS Word
• Mail Merge concept
• Envelops
• Mailing Labels
• Importing data
• exporting to and from various formats

Macros in MS Word:

• Macro introduction and their use
• recording macros
• Editing macros
• running a macro

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.
• Outlook Express:
• Features and uses
• Configuration and using Outlook Express for accessing emails in office
• How to Add e-mail accounts to Outlook
• How to set up an Internet email account in Outlook 2013
• How to Manual set up an Internet email account in Outlook 2013
• Create emails
• send and receive emails in outlook.

सभी प्रकार के नोट्स TOPPRS.IN पर FREE उपलब्ध है !