Office Automation Tools for Computer Science and Engineering

 List of Practicals for Office Automation Tools

Office Automation

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