Contents

1) FUNDAMENTALS OF COMPUTER & e-SIKSHA

• COMPUTER SYSTEM:-characteristics and capabilities computer Hardware and software, Block Diagram of a computer, Different Data Processing , data process system, strong Data,. Types of computer: Analogue, Digital , Hybrid, General and Special Purpose Computers. Generation of Computers. Computer Systems: Micros, Minis & Main-frames.
• COMPUTER SYSTEM:- . Limitation of Micro Computer. Number systems: Decimal Number System, Binary number system, Octal & Hexadecimal number system,
• complement Codes: ASCII,EBCDI Codes, Gray code & BCD. Logic Gates: AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates

2) MS WORD

• (HOME MENU)-New,Open,Close, Save, Save As, Formatting Text,Fontsize,Font Style, Font Color,Use The Bold, Italic, And Underlines. Line Spacing, Find ,Replace .Change The Text Case, Shanding With Tabs And Indents
• ( INSERT MENU):- Table Use, Shapes, Clipart And Picture, Word Art, Smart Art, Columns And Orderings- To Add, Columns To Document Change The Order And Objects, Smart Art, Hyperlink, Bookmark, Cross- Reference, Header And Footer, Page Number, Text Box, Quick Parts, Drop Cap, Signature Line, Date And Time, Equation Symbol
• (PAGE LAYOUT):-Themes, Margins, Orientation, Size, Columns Page Breaks, Line Numbers, Hyphenation, Watermark, Pagecolor, Page Borders, Left And Rigt Indent ,Before And After Spacing, Position, Bring Front, Send To Back, Text Warpping Align, Group, Rotate
• (MALLING )-Envelopes, Labels, Start Mail Merge, Select Recipients, Edit Recipients List, Highlight Marge Fields, Address Block, Greeting Line, Insert Merge Field, Rules, Match Fields Update Labels, Preview Results,Previous Record, Next Record, Last Record, Find Recipient, Auto Check For Errors, Finish & Merge
• (VIEW)- print layout, full screen, web layout, outline, draft, ruler, gridlines, document map, thumbnails, zoom, one page, two, page, page width, new window, arrange all, split, switch windows, macros

3) MS ACCESS

• 1. Introduction to Database Management :- Type of Database, Examples of DBMS
• 2. Definitions :- Table, Field, Field Name, Record, Database, Database Object
• 3. Opening Microsoft Access :- Start button & Desktop icon
• 4. Creating a Database file :- Designing a table - Field names, Data Types, Description
• 5. Data Types :- Text, Number, Data/Time, Yes/No, Currency, Memo, AutoNumber, Ole Object, Lookup Wizard
• 6. Entering Records within a table
• 7. Editing parts of a table :- Selecting, Renaming, Inserting, Deleting, Hiding, Freezing, Resizing

4) MS-EXCEL

• -CREATE WORKSHIT AND WORKBOOKS- create a workbook, import data from a delimited text file, add a worksheet to an existing workbook, copy and move a worksheet.
• NAVIGATE IN WORKSHEETS AND WORKBOOKS- search for data within a workbook, navigate to NAMED cell, range, or workbook element, insert and remove hyperlinks.
• Format worksheets and workbooks- change worksheet tab color, raname a worksheet, change worksheet order, insert and delete columns,or rows, change workbook themes , Adjust row height and column width, insert headers and footers,

5) TYPING- ENGLISH , BENGALI & OTHER REGONAL LANGUAGE

• Typing Practice in Englsh & Any one Regional Language