JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

Course Objectives:

• To learn various basic features of MS-Word.
• To understand the advanced features of MS-Word.
• To learn various basic functions of MS-Excel.
• To provide an understanding of various MS-Excel functions, formulas and its usage in business.
• To orient the students to apply the various aspects of multiple worksheets.

Course Outcomes

Students will be able to

• Write letters, format documents in MS-Word.
• Build spreadsheets to perform data analysis.
• Create technical documents incorporating equations.
• Insert tables, images from the data for better presentations.
• To create documents that demonstrates proficiency with the use of MS-office.

UNIT - I: Word Processing-MS Word

Introduction to Word Processing, introduction to MS Word, editing a document, previewing a document, printing documents, formatting a document.

UNIT - II: Word Processing - Advanced Features of MS Word

Find and replace, checking the grammar and spelling, using the thesaurus, auto correct, auto complete and auto Text, word count, mail merge, mailing labels, wizards and templates, handling graphics, table insert and modifications, conversion of table, converting a word document in various format.

UNIT - III: Work Sheets: MS Excel-I

Worksheet Basic, creating worksheet, entering data into worksheet, entering text data, dates, alphanumeric and values, saving and quitting worksheet, opening and moving around is an existing worksheet

UNIT - IV: Work Sheet: Using formulas

Toolbars and menus, keyboard shortcuts, working with single and multiple worksheets, Working with formulas and cell referencing, auto sum, copying formulas, absolute and relative addressing, working with range, formatting of worksheets.

UNIT - V: Work Sheets: Using Charts

Previewing and printing worksheets, page setting, print title, adjusting margins, headers and footers, page break, graphs and charts, previewing and printing charts, database creation, sorting, query and filtering, Functions database, multiple worksheets

Suggested Readings:

• Linda Foulkes, Learn Microsoft Office 2019A Comprehensive Guide to Getting Started with Word, PowerPoint, Excel, Access, and Outlook(E Book), Packt Publishing, 2020
• Dr.S.S. Shrivastava, Ms. Office, Firewallmedia,2007.
• Darry Kegg, Aaron Guilmette, LouMandich, Ed fisher, Microsoft Office 365 administration, Pearson Education, 2018.
• Anita Goel, Computer fundamentals, Pearson, 2010.
• Raja Raman, Fundamentals of computers, PHI, 2014.
• Tulasi Ram, Basics of Computer Skills, HPH, 2019. BBA SEMESTER – I