Office Automation Tools Information Tech 2nd Sem BTEUP Syllabus 2019-2020

Office Automation Tools detail BTEUP syllabus for Information Technology, effective from 2019-2020, is collected from BTEUP 2017 Syllabus official website and presented for diploma students. PDF download is possible from official site but you can download the istudy mobile app for syllabus on mobile. The course details such as exam duration, Teaching Hr/week, Practical Hr/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.

For all other bteup syllabus 2nd sem information tech 2019-2020 you can visit BTEUP Syllabus 2nd Sem Information Tech 2019-2020 Subjects. The detail syllabus for office automation tools is as follows.

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.

Learning 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.

1. Word Processing

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.

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

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.

5. Google Office Tools

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 Experiments:

Tools to be used: Microsoft office/ Libre Office / Open Office / G Suite

1. Creating a document using different font, changing font size and color, changing the appearance through bold/italic/underline.
2. Creating a document using subscript and superscript, justification of the document.
3. Create a document using Bullets and Numbering.
4. Create a document using page number, header and footer.
5. Create a document using inserting page breaks and column break, line spacing.
6. How to use mail merge and macro in MS Word.
7. 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.
8. Apply spelling checker, grammar mistakes, thesaurus in a document.
9. Create a Boucher using templates, page setup and print preview, and then print that document.
10. Working on spreadsheet like adding, deleting, merging cells, layout and style.
11. Create a table and perform operation using predefined function on it.
12. In MS Excel procedure to switching between different spreadsheets and workbook.
13. Create a spreadsheet and print selected as well as full workbook.
14. Create a spreadsheet with LOOKUP/VLOOKUP features.
15. Create different charts in excel and implement formulas(automatic and use defined).
16. Create a Power Point presentation using slide template.
17. Create a Power Point presentation using animation.
18. Create a Power Point presentation using transition
19. Create a Power Point Presentation with Adding movie and sound.
20. Create a Power Point Presentation with Adding tables and chart etc.
21. Changing slide color scheme in presentation.
22. Viewing the presentation using slide navigator.
23. Create, Save, Run and Print the Power Point Presentation.
24. Create a database table using predefined template.
25. Create a database form using form wizard.
26. Create and share files/folders in Google drive
27. Create and share Google docs.
28. Create and share Google sheets.
29. Create and share Google Forms.
30. Create and share Google slides.

Instructional Strategy:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.

Means of Assessment:

1. Assignments and quiz/class tests, mid-term and end-term written tests
2. Actual laboratory and practical work, exercises and viva-voce
3. Software installation, operation, development and viva-voce

Text Books:

1. Microsoft Office 2010 For Dummies By Wallace Wang
2. 2007 Microsoft Office System Plain & Simple by Jerry Joyce Microsoft Press
3. Office XP : The Complete Reference- Stephen L. Selson – Tata McGraw Hill Education.
4. Working in Microsoft Office – Richard Mansfield – Tata McGraw Hill Education.

Reference Books:

• http://office.microsoft.com/en-us/training/CR010047968.aspx
• https://gsuite.google.com/leaming-center
• http://spoken-tutorial.org

For detail syllabus of all other subjects of BE Information Tech, effective from 2019-2020 do visit Information Tech 2nd Sem BTEUP syllabus for 2019-2020.

Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.