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.

2) DISK OPERATING SYSTEM (DOS)

• • Introduction, History & Version of DOS.

3) MS WORD

• (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
• (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

4) MS POWERPOINT

• (GETTING ACQUAINTED WITH POWERPOINT)The PowerPoint envirionmment,the title bar, the ribbon, the Microsoft office button, the quick access toolbar, the scroll bar, the presentation view buttons, the zoom slider, the status bar, the mini Toolbar, keyboard shortcuts
• (USING PRESENTATIONS VIEWS)-normal view, slide sorter view, notes page view, slide show view.
• (USING CLIP ART) -Inserting Clip Art , And Pictures, Basic Graphic Manipulation, Using Picture Tools, The Format Picture Dialog Box
• (USING SMARTART)-Inserting And Manipulating Smart art, Formatting Smart art,
• (USING SLIDE SHOW VIEW)-Running a slide show, using custom shows.
• (USING TEXT) adding text to slides, basic object manipulation, font formatting, applying custom bullets and numbering, using tabs, setting text box options, checking spelling
• (PRINTING YOUR PRESENTATION)-
• ( CREATING BASIC PRESENTATIONS)-opening presentations, cloning presentations, creating new presentations, saving presentations, saving presentations, inserting new slides, applying slide layouts, using the "package for CD feature", working with power point file formats

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

6) VISULBASIC 6.0

• Getting Started- Procedure For Starting, Printing the Program, Saving the Program, Reloading a Program, Exiting Basic, Loading .tax Files.
• Screen Output- Programming Practices and conventions, The REM Statement, The CLS Command, The Print Command, print With a Semicolon, Print With a comma, On Your Own, Positioning output on the screen, Summary, Putting It All Together
• Input Values and Output Displays - Data Type Values, Variables, Assignment Statements, Displaying Values, Dialog Boxes, Numeric Values as Input. creating output Menus, Putting it all Together
• Numeric Calculations- operations, Functions and Expressions, Operation Hierarchy, Sub expressions, Built In Function, Concatenation, Formatting Output, Putting It All Together
• Decision Making - Simple comparisons, Numeric Comparisons, Strings, Character Representation, Dictionary Ordering, String comparisons, Conditional Statements, Simple if blocks, The Else option, compound conditional if Blocks, Multi-case if Blocks, Putting It All Together

7) HTML

• Introduction to web programming:-It talks about the architecture of a website and the different technologies used to design a website
• Introduction to HTML:-HTML tags versus HTML elements, history of HTML, how a design a first HTML page, HTML attributes , etc. are discussed in this subject
• HTML Basic Formatting Tags:-HTML colour coding , HTML basic tags, and formatting tags are covered here

8) MS EXCEL (Advance)

• PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing
• 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
• PIVOT TABLES–ADVANCE  Adding new calculatedFields/Items  ChangingtheSummaryFunction  ConsolidatePivot table
• VALIDATIONS  InputMessages/ErrorAlerts/Drop-DownLists  ConditionalFormatting

9) FUNDAMENTALS OF COMPUTER & e-SIKSHA

• 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.

10) NETWORKING

• (INTERNET TECHNOLOGY)-INTRODUCTION TO WWW-protocols and programs, secure connections. applications and development tools, the web browser,
• WEB DESIGN- web site design principles, planning the site and navigation,

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