FUNDAMENTAL OF COMPUTER

1. Introduction :- What is computer, History of a computer; Shortcut Keys, Full form of Computer

2. Type of Computer :-  Based on Mechanism, Based on Size, Based on Purpose

3.Components of PC : - Computer System, Computer Hardware and Software

4. Input/Output (I/O) Devices: Input Devices, Output Devices

INTRODUCTION OF INTERNET

1. History of the WWW

2.LAN WAN & MAN

3. Creating an Email Account.

4. Browsers and Search Engines.

5. Surfing and Searching

MS OFFICE

1. MS Word :- Create Paragraph, Text Formatting, Change Case, Border, Page Border, Paragraph and Line Spacing, Styles & Editing, Create Table, Chart, Smart Art, Shapes, Hyperlink, Bookmark, Header & Footer, Text Box, Word Art, Object and Text from File, Page Setup, Page, Background, References, Mailings, Comment, Document View, Split Window, Show/Hide, Macro, Protect Document

2. MS Excel :- Introduction of Excel, Insert and Delete (Cells, Rows, Columns and Worksheet), Font, Alignment, Number Formatting, Hide & Unhide (Rows, Columns, and Worksheet), Workbook, Worksheet and File Protect, Customization, Data Fill, Merge Cells, Conditional Formatting, Formatting, Split Window, Freeze Panes

EXCEL FORMULAS:- 40 Count

Math Function (Sum, Round, Int, Mode) 

Stats Function (Count, Average, Max, Min)

Text Function (Upper, Lower, and Proper)

Logical Function (If, Count If, Count Ifs, Sum If, Sum Ifs, Lookup, Vlookup, Hlookup)

Salary Creation, Business Recept slip, and Mark Sheet

Sort, filter, group, and ungroup, remove duplicates.