Computer Office Application
Module 1: Computer Basic
1. Concept of Computer
2. Concept of IT and ICT
3. Computer Hardware Configuration, Software
4. Concept of memory & storage
5. Uses of input & output devices
6. Introduce of Keyboard and Effectiveness
7. Concept of Computer Operating System
Module 2: Word Processing/Microsoft Word
1. Word 2010 interface
2. Understanding the Ribbon, Title bar and Menu bar
3. Customizing the quick access toolbar
4. Navigation toolbar, Navigation pane, Status bar
5. Understanding the tools box and Tools
6. Documentation in various file format
7. Concept of Home tab
8. Effectiveness of Clipboard tools
9. Effectiveness of Font tools
10. Effectiveness of Paragraph tools
11. Effectiveness of Styles and Editing Tools
12. Insert tab: page, Insert table, Draw table and Table properties
13. Illustrations of Picture, shape, chart and screenshot
14. Links, Header & Footer , text, Equation and symbol concept
15. Page Layout tab: Themes and Page Setup
16. Page Background Color, watermark and Borders
17. View tab: Document Views, Ruler, Gridlines and Navigation
18. Design tab: Styles, Border & shading
19. Layout tab
20. Reference tab
21. Typing Procedure
Module 3: Introduce of Microsoft Excel
1. What is excel
2. Usefulness of Microsoft excel
3. Concept of Various Excel sheet
Module 4: Working procedures of Microsoft Excel
1. Understanding the Ribbon, Title bar and Menu bar
2. Understanding the Documentation & Security
3. Concept of Rows, column & cells
4. Selection in excel
5. Merge & Unmerge cells
6. Understanding the formula & function
7. Add number & text manually in excel
8. Add number by auto sum
9. Subtracting
10. Conditional formatting in excel
11. Customize Conditional formatting
12. Multiplying
13. Dividing
14. Update date & time automatically
15. Use template in excel
16. Create original template
17. Header & footer in excel
18. Multiplying
19. Dividing
20. Update date & time automatically
21. Use template in excel
22. Create original template
23. Header & footer in excel
24. Average/min/max/count function in excel
25. Use sum if average if in excel
26. Chart customization and edit in excel
27. Different kinds of chart on excel
28. Date & time Formatting
29. Text Formatting Text Formatting
30. Custom view and print selection in excel
31. Hide row and column in excel
32. Text Formatting
33. Sort and filter in excel
34. Remove duplicate data in excel
35. Subtotal tool in excel
36. Goal seek tool & PMT function in excel
Module 5: Presentation / Microsoft PowerPoint
3D effect, etc.
Design tab: Page setup, slide orientation, themes,
Background style etc.Animation tab: custom animation, Transition customization, advanced slide etc.
Review tab: Spelling check, comment, protect presentation,
View tab: Presentation views, show hide, macros etc.Slide show tab: Starting slide shows, set up tools, monitors
Review of Presentation / Microsoft PowerPoint
Module 6: Microsoft Access/ Database
Explore an Access Database: Exploring tables, Exploring forms, exploring quires, Exploring reports
Creating Database and Simple data.
Creating Database from simple table
Creating Database from tables manually.
Customizing rows & columns Creating relationship between tables.
Create Simple forms:
Creating forms by using form tools
Changing the look of forms
Changing Argument of form.
Display data.
Sorting information in table filtering information in table & forms
Review of Microsoft Access/ Database
Module 7: MS- Outlook
1. Send & receive email messages
2. Store & access contact information
3. Manage scheduling
4. Track task
Module 8: Troubleshooting
Operating system
Basic networking
Functions of utility software’s