Page 1 :
2.6 OFFICE AUTOMATION TOOLS, , L T P, - - 6, RATIONALE, This subject aims to cover the handling of whole field of word processing. It also involves, various clerical tasks, such as organizing customer data or creating reports. It enables, people with lower skill levels to perform higher-level tasks. In Today's commercial world,, automation helps the users with a sophisticated set of commands to format, edit, and, print text documents. It is used as valuable and important tools in the creation of, application such as newsletters, brochures, charts, presentation, documents, drawings, and other graphic images.This will make the students proficient in office automation, applications., , LEAR NING OUTCOMES, After undergoing the subject, the students will be able to:, •, •, •, •, •, •, , Use file mangers, word processors, spreadsheets, presentation software’s, Describe the features and functions of the categories of application software., Present conclusions effectively, orally and in writing., Understand the dynamics of an office environment., Demonstrate the ability to apply application software in an office environment., Use Google Suite for office data management tasks., DETAILED CONTENTS, , 1. Word Processing, , MS Word concepts : Creating, saving, closing, Opening an existing document, Using, Featured Word Templates, Exploring Template and Formation of Documents, Selecting, text, Editing text, Finding and replacing text, Character and Paragraph Formatting,, Automatic Formatting And Styles, Inserting and removing page breaks, Header and, footers, Page No, Border & Shading, Change Case, Checking Spelling, Working With, Tables, Insert Table, Delete Cells, Merge Cell, Graphics And Frames , Page Design and

Page 2 :
Layout, Creating and Printing Merged Documents, Encrypting document with a, password, Printing documents, , 2. SpreadSheet, , MS Excel Concept: Creating, Saving, closing, Editing a Workbook, Inserting, Deleting, Work Sheets, entering data in a cell, Copying and Moving from selected cells, entering, formula, handling operators in Formula, Functions: Mathematical, Logical, statistical,, text, financial, Date and Time functions, Using Function Wizard. Formatting a, Worksheet: Formatting Cells – changing data alignment, changing date, number,, character or currency format, changing font, adding borders and colors, Printing, worksheets, Charts and Graphs – Creating, Previewing, Modifying Charts,, LOOKUP/VLOOKUP, , 3. Presentation, , MS Power Point Concept : Creating, Opening and Saving Presentations, Working in, Different Views, Working with Slides, Adding and Formatting Text, Formatting, Paragraphs, Checking Spelling and Correcting Typing Mistakes, Making Notes Pages and, Handouts, Drawing and Working with Objects, Adding Clip Art and other pictures,, Designing Slide Shows using templates, Rehearse timing, Narration, Multimedia, effects- Apply Transitions between Slides, Animate Slide Content, Set Timing for, Transitions and Animations, Insert and Format Media, Encrypting presentations with a, password, Running and Controlling a Slide Show, Printing Presentations, , 4. Database, , MS Access Concepts: Database, Relational Database, Integrity. Operations: Creating,, dropping, manipulating table structure. Manipulation of Data: Query, Data Entry Form,, Reports, , 5. Google Office Tools

Page 3 :
Creating , saving , downloading , sharing files/folders from Google drive , creating and, sharing Google docs, import and export docs, creating and sharing Google sheet, import, and export Google sheet, Google forms and form responses ,creating Google slides to, present your ideas, LIST OF PRACTICALS, Tools to be used: Microsoft office/ Libre Office / Open Office / G Suite, 1., 2., 3., 4., 5., 6., 7., , 8., 9., 10., 11., 12., 13., 14., 15., 16., 17., 18., 19., 20., 21., 22., 23., 24., 25., 26., 27., 28., , Creating a document using different font, changing font size and color, changing the, appearance through bold/italic/underline., Creating a document using subscript and superscript, justification of the document., Create a document using Bullets and Numbering., Create a document using page number, header and footer., Create a document using inserting page breaks and column break, line spacing., How to use mail merge and macro in MS Word., Creating table, formatting cells, use of different border styles, shading in tables,, merging of cells, and partition of cells, inserting and deleting a row in a table in MS, word document., Apply spelling checker, grammar mistakes, thesaurus in a document., Create a Boucher using templates, page setup and print preview, and then print that, document., Working on spreadsheet like adding, deleting, merging cells, layout and style., Create a table and perform operation using predefined function on it., In MS Excel procedure to switching between different spreadsheets and workbook., Create a spreadsheet and print selected as well as full workbook., Create a spreadsheet with LOOKUP/VLOOKUP features., Create different charts in excel and implement formulas(automatic and use defined)., Create a Power Point presentation using slide template., Create a Power Point presentation using animation., Create a Power Point presentation using transition, Create a Power Point Presentation with Adding movie and sound., Create a Power Point Presentation with Adding tables and chart etc., Changing slide color scheme in presentation., Viewing the presentation using slide navigator., Create, Save, Run and Print the Power Point Presentation., Create a database table using predefined template., Create a database form using form wizard., Create and share files/folders in Google drive, Create and share Google docs., Create and share Google sheets.

Page 4 :
29., 30., , Create and share Google Forms., Create and share Google slides., , INSTRUCTIONAL STRATEGY, , As the subject is practice oriented, more stress should be given to students to do the work, practically. The features of software packages MS Office/ Libre Office to be demonstrated, in class using LCD projector., , MEANS OF ASSESSMENT, , − Assignments and quiz/class tests, mid-term and end-term written tests, − Actual laboratory and practical work, exercises and viva-voce, − Software installation, operation, development and viva-voce, , RECOMMENDED BOOKS, , 1., 2., 3., 4., 5., , Microsoft Office 2010 For Dummies By Wallace Wang, 2007 Microsoft Office System Plain & Simple by Jerry Joyce Microsoft Press, Office XP : The Complete Reference- Stephen L. Selson - Tata McGraw Hill Education., Working in Microsoft Office - Richard Mansfield - Tata McGraw Hill Education., Websites for Reference, , • http://office.microsoft.com/en-us/training/CR010047968.aspx, • https://gsuite.google.com/learning-center, • http://spoken-tutorial.org