Contents

1) CONCEPT OF WINDOWS

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

2) Concept of software

• • Computer Viruses.
• Computer antivirus

3) DISK OPERATING SYSTEM (DOS)

• • Introduction, History & Version of DOS.
• DOS basic :- • Physical structure of disk, drive name, FAT, file & directory structure and naming rules, booting Process, DOS system files.

4) 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 -III BASIC COMPUTERS & STORAGE Central Processing Unit: The Microprocessor , control unit, A.L.U., Registers, Buses, Main Memory, Main Memory (RAM) for microcomputers, Read Only Memory(ROM). Storage Devices: Storage Fundamentals, Primary and Secondary Storage, Data Storage and Retrieval Methods - Sequential, Direct & Indexed Sequential, Tape Storage and Retrieval Methods Tape storage Devices, characteristics and Limitations, Direct access Storage and Microcomputers - Hard Disk Cartridges, Direct Access Storage Devices for large Computer systems, Mass storage systems and Optical Disks, CD ROM.

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
• BASIC FORMULA  Formulae that Add/Subtract/Multiply/Divide  BODMAS/Formula Error Checking  The Sum Function
• MANAGEDATACELLSAND RANGES  Mani palate data in worksheets  Paste data busing special paste options  Fill cells busing AutoFill  Insert and delete multiple columns or rows  Insert and delete cells  Format cells and ranges  Merge and unmerge cells  Modify cell alignment ,orientation, and indentation  Format cells by using Format Painter  Wrap text within cells  Apply number formats  Apply cell formats from the Format Cells dialog box  Apply cell styles  Clear cell formatting  Define and reference named ranges  Define named range  Summarize data visually  Insert Spark lines  Apply built-in conditional formatting  Remove conditional formatting
• 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
• VALIDATIONS  InputMessages/ErrorAlerts/Drop-DownLists  ConditionalFormatting
• ADVANCEDFILTERS  ExtractingRecordswithAdvancedFilter  UsingFormulasinCriteria
• SUMMARIZINGDATA  CreatingSubtotals/Nested Subtotals  SUBTOTALSFormula
• CONSOLIDATION  ConsolidatingDatawithIdentical/DifferentLayout
• PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing

7) 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
• ( 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
• (USING PRESENTATIONS VIEWS)-normal view, slide sorter view, notes page view, slide show view.
• (USING TEXT) adding text to slides, basic object manipulation, font formatting, applying custom bullets and numbering, using tabs, setting text box options, checking spelling
• (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.
• (PRINTING YOUR PRESENTATION)-

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

9) 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
• Branching - Ling Labels, Unconditional Branching, 3 Repetition of Code, Conditional Branching, Repetition a Number of Times, Sentinels, Prompt and Echo, 8 User Interrogation Technique, 9 Putting It All Together
• For ..Next Loops - The For ..Next loop, The Step Parameter, Program Applications, Generalized Functionality, Nested Loops , Putting It All Together
• Random Numbers - The Rnd Function, Using Randomize, Coin Tossing , Tossing a Biased Coin, Die Rolling, Scaling the Rnd Function , A Simulation , Putting If All Together
• Graphics- Resolution and Color, 2 Coloring Pixels , 3 Drawing Lines, Using the PSet Command, Using the Ling Command, 6 Drawing Rectangles, Drawing Circles , Drawing Arcs, Drawing sectors , Drawing Ellipses, Fill Styles, 12 A Pie chart, Histograms Putting If All Together
• Arrays and Tables - Defining an Array, The syntax of Defining Arrays, Assigning and Using Values in an Array, Finding the Average and the Standard Deviation, File Input, Using Arrays- Searching an Array , Using Arrays -Finding a Smallest Element in an Array, Using Arrays - interchanging Two Elements in an Array , using Arrays -sorting an Array , using Arrays - Finding a Distribution of Elements, Using Arrays - Parallel Arrays, Using Arrays - Drawing A Pie Chart, Using Arrays - Drawing a Histogram , Putting If All Together

10) C LANGUAGE

• Introduction and First Program :- why Programming, History of Language, Hello World Program Variables and Data types :- Identifiers in C, Variables and Data types, Constants
• Console IO Operations :- Peintf Scanf, Unfomatted IO Functions
• Operators and Expressions :- Expressions and Arithmetic Operators, Relational and Logical Operators, Bitwise Operators
• Control Flow Statements :- If Statements, Switch Statement, Unconditional Branching using goto Statement, While Loop, For Loop, Break and Continue, Special Cases

11) 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
• HTML- Grouping using Div Span:-The span and DIV tags used to format HTML web pages are introduced in this subject.
• HTML Lists:-The definition of HTML lists, their significance ,types of HTML lists like ordered and unordered lists, etc, are discussed here.
• HTML Images:-The use of image mapping in embedding images into HTML pages are explained in this module.
• HTML Hyperlink:- This subject focuses on uniform Resource Locator (URL) and related concepts. it also takes about URL encoding and the importance of hyperlinks in web pages.
• HTML Tables:- This module teaches how to represent tables in a webpage.
• HTML iFrame : How to use iFrame tag and attributes to embed one web page into another via nested browsing context is covered in this module.

12) NETWORKING

• (INTERNET TECHNOLOGY)-INTRODUCTION TO WWW-protocols and programs, secure connections. applications and development tools, the web browser,