21CSA205 PC SOFTWARE-

Unit I-

MS word for communication: Window parts, Menu Bar, Tool Bar, Status Bar, Scroll Bars, Understanding and arranging windows, Creating simple word documents, Saving files, Opening existing files, creating copies of files, Page set up options, Exiting word, Text Editing, Selection, deletion, cut, copy, Find & Replace, Using Undo & Redo, Document Views, Customizing toolbars, Inserting header & Footer, Zoom options, Inserting Page number, date & time, Symbols, Comments, Auto texts, Footnotes, Picture, Files & Objects, Bookmarks, Hyperlink, Cross references, Formatting Texts, Font, Paragraph, Columns, Bullets & Numbering, Borders & shading, Drop Cap, Auto format options, creating styles, Table of contents, Language Utilities, Spelling & Grammar, Mail merge Options, Creating Macros, Inserting tables, applying formula and sorting tables, Arranging windows and splitting windows.

Unit II-

MS Excel for data analysis and communication: Familiarizing with workbooks, work sheets and cells, Excel window, working with cells, moving around in excel, Using the Toolbars, Using Formula bar, Entering and editing data, Selecting ranges, copying and moving cells, Paste special options, Fill options, Clearing formats, Move, copy and delete sheets, finding and replacing texts, Inserting header and footer, Inserting cells, rows, columns and work sheet, Chart options- Inserting functions, Giving names to cell ranges, Manipulating hyperlink, Formatting cells, rows, columns and sheet, Practicing auto formatting and conditional formatting, Creating & merging styles, Spelling and Auto correct, Creating macros, protecting sheet, Sorting and filtering list, creating a form, validation, Creating subtotals, Manipulating pivot table, Consolidating data, arranging windows, Freeze panes, Hiding windows.

Unit III-

MS Power-point for Communication and Presentation: Inserting slides, new slide, existing slides, duplicate slide, slides from Auto layout, Slide show, start with first slide, current Slide, customized show, Slide views – normal, slide sorter, Slide Layouts, Design Templates, Deleting slides, Paste special, Inserting Header & Footer, Date & Time, Hyperlink, Picture, Object, Symbols, Text, Table, Chart, and Diagram, Paste as hyperlink, Format-Font, Bullets & Numbering, Custom animation, Slide Transitions, Action Buttons.