PC PACKAGES (WORD, EXCEL, POWERPOINT) PGDCA NOTES
UNIT I –
Operating System (Windows 8.1)
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 –
- Language Settings – How to set other languages on computer
Using Control Panel –
- 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
- 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
- Printing & various print options
Working with Headers and Footers
Tables:
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:
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:
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.