UP Polytechnic & Diploma In Computer Science And Engineering | Office Automation Tools | 2nd Semester Syllabus | 1st Year | BTEUP - EdufyHUB 4U

OFFICE AUTOMATION TOOLS

UP Polytechnic/Diploma In Computer Science And Engineering - Office Automation Tools 2nd Semester Syllabus - EdufyHUB 4U

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

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 Layout
• Creating And Printing Merged Documents
• Encrypting Document With A Password
• Printing Documents

2. SpreadSheet

MS Excel concepts :

• Creating
• Saving
• Closing
• Editing A Workbook
• Inserting Work Sheets
• 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 concepts :

• 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

MS Access concepts :

• Creating
• Saving
• Downloading
• Sharing Files/Folders From Google Drive
• Creating And Sharing Google Docs
• Importing And Exporting Google Docs
• Creating And Sharing Google Sheets
• Importing And Exporting Google Sheets
• 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. 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

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. 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
5. Websites for Reference

Websites for Reference:
https://support.microsoft.com/en-us/training
https://gsuite.google.com/learning-center
https://spoken-tutorial.orgs/

---

Download Official Syllabus
See Official Syllabus