M02

Office Application Tools, Internet Technology, and Personality Development Skills
Code: 
M02
Year / Semester: 
1st Semester
Objective: 

-

Credits: 
4

MODULE – MH 03 - OFFICE APPLICATION TOOLS

Office 2007

Introduction, Background, New features at a Glance, User interface, Office Button, Contextual tabs, Tool bars, Super Tool tips, Quick Access Toolbar, Zoom slider, Smart Art, File format, User Assistance, Outlook, Publisher, Info path, Visio, Share point Designer, Server Components.

Word

Introduction, Creating document, parts of Word windows, Mouse operations, Keyboard operations, Individual Key, Things to avoid, Formatting Features, Menus, Commands, Toolbars and their icons, Entering text, text in text box, changing font & font size, Alternative method, aligning the text, italicizing, bold text, numbering, bullets, spelling, print preview, Print, Document opening/saving/closing. Creating Template, creating tables, Inserting rows/columns, merging column/rows, moving table, drawing table, text box, formatting, picture insert, formatting a picture, formatting text. Mail Merge – Creating main document, creating data source, adding fields, removing fields, using address books, Creating a Mail Merge Document, Merging the Main Document with Data, Sending the Merged Document to the Printer, Saving the Main Document, Modifying records in the Data Source, Adding a New Record, Changing an Existing Record, Deleting an Existing Record, Closing the Main Document Macros - Introduction, Inserting header and Footer, inserting Current date, time and page numbers, etc.

EXCEL

Introduction, Navigation, Selecting Cells, Entering & editing Text, Entering umber, Entering Formulae, Entering Daters, Alignment, Menus, Command and Toolbars, Standard Toolbar, Formatting toolbar. Opening workbook, column width, series fill, entering formulas, copying and pasting the formula, summation, formatting cells, Currency notation, Centering , changing Font & Size, Column AutoFit, Inserting header & footers, page Setup, saving file, Data Sort – Data filters, Auto Filters, Valid Criteria, invalid Criteria, and Redundant Criteria etc. Functions - ROUND, SQRT, AVERAGE, AX, MIN, COUNT, SUM, IF, SUMIF, ABS, UPPER, LOWER TODAY, NOW, etc. Simple Graphs - Opening Excel and Entering Data, Drawing a Graph, Naming the Sheet, Saving the Workbook, Printing and Closing a Graphic Thee, Opening the Saved Graphic sheet

POWER POINT

Introduction, Navigation in PowerPoint, Creating a New Presentation, Opening a Presentation, Creating a New Slide, Deleting a Slide, Copying a Slide, Numbering the Slides, Saving a presentation, changing the default directory, Auto Save, Printing a presentation.

MODULE - MH 04 - INTERNET TECHNOLOGY

MS Outlook

Introduction, Working with Outlook, Parts of outlook windows, address book, editing contacts, changing view, finding a contact, filtering contacts, sorting contacts, calendar, tasks, journal, inbox, receiving E-mails.

Internet Technology

Introduction, Important Features, Internet Protocols, IP Address, DNS, Communication protocols, Connecting to the Internet, Dial-up/DSL, Cable modem, ISDN. Prerequisites for Internet (Hardware, Software, others), Modem configuration, (TCP/IP connection), Search Engine, E-mail (Creating an e-mail account, sending and receiving mails, internet phone,).

MODULE – MH 05 - PERSONALITY DEVELOPMENT & COMMUNICATION SKILLS

Meaning of Personality

Developing Self

Developing Communication Competence

Presentation Skills —‘Speak for Yourself’

Group Discussion

Interviews

Workplace Success
 

Suggested Readings: 

-