Contents

1) CONCEPT OF WINDOWS

• • Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin.
• • Windows Accessories - Calculator, Notepad, Paint, WordPad, Character map.
• • Windows Explorer - Creating folders and other Explorer facilities.
• • Entertainment - CD Player, DVD Player, Media Player, Sound Recorder, Volume Control.

2) 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
• UNIT -II COMPUTER PERIPHERALS Introduction to input Devices: Categorizing input Hardware, Keyboard, Direct Entry - Card Readers, Scanning Devices - O.M.R., Character Readers, Thumb Scanner, MICR, Smart Cards, Voice Input Devices, Pointing Devices - Mouse, Light Pen, Touch Screen. Computer Output: Output Fundamentals, Hardcopy Output Devices, Impact Printers, Non - Impact Printers, Plotters, Computer output Microfilm/Microfiche (COM) systems, Softcopy Output Devices, Cathode Ray Tube, Flat Screen Technologies, Projectors, Speakers.
• UNIT - IV COMPUTER SOFTWARE & LANGUAGES System Software: System software Vs. Application Software, Types of System Software, Introduction and Types of Operating Systems. Boot Loader, Diagnostic Programs, BIOS, Utility Programs. Application Software: Microcomputer Software, Interacting with the System, Trends in PC software, Types of Application Software, Difference between Program and Packages. Computer Languages: Definition, Generations of computer languages, Types of Languages, Language Processors: Assembler, Interpreter, Compiler, Linker and Loader. Programming constructs, Algorithm & flowchart.

3) 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
• (REFERENCES):- Table Of Contents, Add Text, Update Table, Insert Footnote, Insert Endnote, Next Footnote, Show Notes, Insert Citation, Manage Sources, Style, Bibliography, Insert Caption Insert Table Of Figures, Update Table, Cross- References, Mark Entry, Insert Infex, Update Index, Mark Citation, Insert Table Of Authorities
• (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
• (REVIEW)-Spelling & Grammar, Research, Thesaurus, Translate, Translation Screen tip, Set Language, Word Count, New Comment, Delete, Previous, Next, Track Changes, Balloons, Final Showing Markup, Show Markup, Reviewing Pane, Accept, Reject, Previous And Next, Compare, Show Source Documents, Protet Document
• (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

4) 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
• 8. Sorting Records
• 9. Moving to specific records :- First, Last, Previous, Next, New

5) 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,

6) MS EXCEL (Advance)

• INTRODUCTIONTOCOMPUTERS  Fontformatting  Numberformatting  Tableformatting  Conditionalformatting  Hide/Unhide  Sort/filter  Pastespecial  Findandselect
• INSERT  Illustrations  Charts  Te
• PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing
• DATA  Import from web  Import from text  Text to columns  Remove duplicates  Grouping and ungrouping
• REVIEW  Proofing  Comments  Protection
• VIEWS  Typesofviews  Zoom  Windows
• DEVELOPER  Enable developer  Using checkbox/option buttons
• BASIC FORMULA  Formulae that Add/Subtract/Multiply/Divide  BODMAS/Formula Error Checking  The Sum Function
• ABSOLUTE REFERENCING  Problems with Absolute/ Relative Cell Referencing  CreatingAbsolute/MixedReferences
• LOOK UP FUNCTIONS  TheVLOOKUP/HLOOKUP Functions
• PIVOT TABLES  Creating,FormattingSimplePivotTables  PageFieldina PivotTable  Formattinga PivotTable  Creating/Modifyinga PivotChart
• LOGICALFUNCTIONS  IFs and Nested IF Functions  UsingAND/OR /NOTFunctions
• PIVOT TABLES–ADVANCE  Adding new calculatedFields/Items  ChangingtheSummaryFunction  ConsolidatePivot table
• LOOKUPFUNCTIONS–ADVANCE  MATCHwithVLOOKUP Functions  INDEX&MATCH Functions  OFFSET/INDIRECT functions
• STATISTICALFUNCTIONS  UsingTheSUMIF/COUNTIFFunctions  UsingTheAVERAGE/COUNT/LARGER/SMALLERFunctions
• LOGICALFUNCTIONS–ADVANCE  If Loop and Nested IF LoopFunctions  UsingIF/ISERRORFunctions
• CHARTDATATECHNIQUES  TheChart Wizard  ChartTypes  AddingTitle/ Legends/ Lables  PrintingCharts  AddingDatatoaChart  Formatting/Renaming/DeletingDataSeries  ChangingtheOrderofData Series
• DATE/TIMEFUNCTIONS  UsingTheToday  Now& DateFunctions  UsingTheDatedif/Networkdays/EomonthFunctions  UsingTheWeeknumFunctions  UsingTheEdate/Networkdays.Intl/Weekdays.IntlFunctions

7) COMPUTER HARDWARE (A+)

• • Fundamentals principal of using PC’s • Identify fiction partsofPC’s
• • Installation parts of PC’s • Installation PC(OS, Drivers ,Software)

8) TYPING- ENGLISH , BENGALI & OTHER REGONAL LANGUAGE

• Typing Practice in Englsh & Any one Regional Language