At modern days,Microsoft office( Excel,Word,PowerPoint and Access)has become one of the most useful tools at colleges,corporate offices for organization,handling and presenting data and information.
SL |
Name of Modules |
Number of Class |
Hours |
# |
Basic Computer Knowledge |
1 |
3 |
1 |
Ø Computer Basic Ø Concepts of Information Technology Ø Computer Component- Hardware, Software etc. Ø Uses of input & output devices Ø Concept of memory & storage Ø Using Computer & Managing files |
1 |
3 |
# |
Word Processing/Microsoft Word |
5 |
15 |
1 |
Ø Word 2010 interface Ø Ribbon understanding Ø Customizing the quick access tool bar Ø Navigation tool bar, Navigation pane, Status bar Ø Navigation pane, Status bar Ø Back stage view Ø Customizing tab
|
1 |
3 |
2 |
Ø Home tab: Font & Paragraph Customization, Style, Find And Replace Ø Short cut key Ø Insert tab: Photo, clip art, table, chart, Header & footer, Smart art, Equation & symbol Ø Table Customization briefly, Hyperlink concept |
1 |
3 |
3 |
Ø Design tab: Styles, Border & shading Ø Layout tab Ø Reference tab Ø View tab Ø Review tab |
1 |
3 |
4 |
Ø Mailing tab Ø Page layout tab Ø Typing Procedure |
1 |
3 |
5 |
Ø Review of Word Processing/Microsoft Word |
1 |
3 |
# |
Spread sheet/MS excel |
8 |
24 |
1 |
Ø What is excel Ø Ribbon bar in excel Ø Ribbon/tab customization in excel Ø Name box, Formula bar Ø Rows, column & cells Ø Selection in excel |
1 |
3 |
2 |
Ø What is formula & function Ø Add number manually in excel Ø Add number by auto sum Ø Subtracting Ø Conditional formatting in excel Ø Customize Conditional formatting Ø Style in excel Ø Insert in excel |
1 |
3 |
3 |
Ø Multiplying Ø Dividing Ø Update date & time automatically Ø Use template in excel Ø Create original template Ø Header & footer in excel |
1 |
3 |
4 |
Ø Average/min/max/count function in excel Ø Use sum if average if in excel Ø Chart customization and edit in excel Ø Different kinds of chart on excel Ø Chart customization and edit in excel Ø Different kinds of chart on excel Ø Date & time Formatting |
1 |
3 |
5 |
Ø Use if statement Ø Data validation |
1 |
3 |
6 |
Ø Custom view and print selection in excel Ø Hide row and column in excel Ø Calculation between worksheet Ø Add multi cell value in one cell in excel Ø Text Formatting |
1 |
3 |
7
|
Ø Sort and filter in excel Ø Remove duplicate data in excel Ø Subtotal tool in excel Ø Goal seek tool & PMT function in excel |
1 |
3 |
8 |
Ø Spread sheet/MS excel class review |
1 |
3 |
# |
Presentation / Microsoft PowerPoint |
2 |
6 |
1 |
Ø Work with Slides: Adding & deleting Slides, Adding slides with readymade content, Slide bar, Rearranging Slide bar and sectors, Ø Insert tab: Photo, Clip art, table, chart, smart art, Ø 3D effect, etc. Ø Design tab: Page setup, slide orientation, themes, Ø Back ground style etc. |
1 |
3 |
2 |
Ø 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 |
1 |
3 |
# |
Microsoft Access/ Database |
2 |
6 |
1 |
Ø 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 |
1 |
3 |
2 |
Ø Create Simple forms: Ø Creating forms by using form tools Ø Changing the look of forms Ø Changing the Argument of form Ø Display data: Ø Sorting information in table Ø Filtering information in table & forms |
1 |
3 |
# |
MS- Outlook |
1 |
3 |
1 |
Ø Send & receive email messages Ø Store & access contact information Ø Manage scheduling Ø Track task |
1 |
3 |
# |
Troubleshooting |
1 |
3 |
1 |
Ø Operating system Ø Basic networking Ø Functions of utility software’s Ø Connecting components of a computer Ø Basic hardware trouble shooting |
1 |
3 |
Total Duration (Hours): |
20 |
60 |
Module | Advanced Microsoft Office Specialist | 60 Hrs |