1PGDCA4-PC packages (MS-WORD,
MS-EXCEL, MS-POWER POINT)
- Introduction to Word Processing
- Introduction to MS Word : Features, Creating, Saving and
Opening Documents in Words, Interface, Toolbars, Ruler
Menus, Key board Shortcut
- Editing a Document- Moving Scrolling in a document,
Opening Multi-document Windows, Editing Text-Selecting ,
Inserting, Deleting , Moving Text.
- Previewing documents, Printing documents-print a document
from the standard toolbar, Print a document from the
menu, Shrinking a document to fit a page, Reduce the
number of pages by one.
- Formatting Documents : Paragraph formats, Aligning Text
and Paragraph , Borders and Shading Headers and Footers,
Multiple Columns
- Advanced Features of MS Word :
- Find and Replace, Checking grammar and spelling , Formatting via find and replace
- Using the Thesaurus, Using Auto Correct, Auto Complete
and Auto –text, Word Count
- Hyphenating , Mail merge, mailing labels Wizards and
Templates, Handling Graphics, Table and Charts,
Converting a word document into various formats like
Text, Rich Text Format. WordPerfect, HTML etc.
WORK SHEET : MS EXCEL
- Worksheet Basics
- Creating worksheet, entering data into worksheet, heading
information, data text, alpha-numerics, values, saving
& quitting worksheet.
- Opening and moving around in an exiting worksheet.
- Toolbars and Menus, Keyboard Shortcuts
- Working with single and multiple workbook- copying,
renaming, moving, adding and deleting, copying entries
and moving between workbook.
- Working with formulae & cell referencing
- AutoSum
- Copying formulae
- Absolute & Relative Addressing
- Working with ranges- creating , editing and selecting
ranges
- Formatting of worksheet –Auto format, changing
–alignment, character styles, column width, date
format , borders & colours, currency sign.
- Previewing & Printing worksheet-page setting, print
titles, Adjusting margins , Page break, headers and
footers.
- Graphs and charts-using wizards, various charts type, formatting grid lines & legends , previewing &
printing charts
- Database-creation, sorting, query &
filtering a database
- Functions-Database, Date, and Time, Maths
& Trigonometry, Statistical, Text and Logical
Function
- Creating and Using Macros
- Multiple Worksheets-Concepts, Creating and
Using
PRESENTATION GRAPHICS : MS POWER P0INT
- Features and various versions
- Creating presentation using Slider Master and templates
in various color schemes.
- Working with different views and menus of power point
- Working with slider-Make new slider, move, copy, delete,
duplicate, lay-outing of slide, zoom in or out of a
slide.
- Editing and formatting text : Alignment, editing,
inserting, deleting, selecting, formatting of text, find
and replace text, bullets, footer, paragraph formatting spell checking.
- Printing presentation-Print slides, notes, handouts and
outlines
- Inserting Objects-Drawing and inserting objects using clip arts, pictures and charts.
- Slide sorter, slide transition effects and other
animation effects
- Presenting the show –making stand, alone
Presentation, Pack and go wizards.
TEXT AND REFERENCE BOOK :
- Learning Word 97 for Windows
- by Rajeev Mathur, BPB Publication
- Learning Excel 97 for Windows
- by Rajeev Mathur, BPB Publication
- A First Course in Computers
- by Sanjay Saxena, Vikas Publishing House Pvt. Ltd., New
Delhi.
- Microsoft Office 97
- by Gini Courter & Annette Marquis, BPB Publications.
- Office 97 Interactive Course
- by Greg Perry, Techmedia
