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
• 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.
• 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.
• e- SIKSHA :: o Computer Fundamentals. o Operating system (windows xp,7/8). o M.S Word (concept). o Online banking, internet, Emailing, online mobile recharge, online rail ticket & flight ticket booking.

2) Concept of software

• • Types of Software - System software, Application software, Utility software, Demo ware, Shareware, Freeware, Firmware, Free software.
• • Operating System - Functions, Types - Batch Processing, Single User, Multi User, Multiprogramming, Multi- Tasking.
• • Programming languages - Machines Assembly, High Level, 4 GL.
• • Data representation in computers .
• • Number System of computers - Binary, Octal, Hexa, Decimal - Representation & their conversion.
• • Coding System - ASCII, BCD, and EBCDIC etc.
• • Computer Viruses.

3) 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.
• HTML Form:-It discusses the syntax used to integrate forms in web pages and also talks about their importance in websites.
• HTML Headers:-Scrip , Title, Base, and other elements of HTML headers are explained in this subject.
• HTML Miscellaneous:-HTML Meta, tag, XHTML, and HTML deprecated tags and attributes are covered in this module.

4) SQL

• . Introduction to SQL (What is SQL?, Purpose of SQL, Who should learn SQL?, What are the subsets of SQL?, Data Definition Language, Data Manipulation Language, Data Control Language, and SQL vs. NoSQL)
• Introduction to Databases and RDMBS (What is a Database?, Database Objects, Database Tables, Table Records, Types of Database Management Systems, Relational Database Management Systems, and SQL/Relational Databases vs. No SQL Databases)
• . Install a Database Engine (Download MS SQL Server or Oracle or MySQL Database Engine, and Install. Launch SQL Server Management Studio, Select New Query, and launch SQL Query. Type SQL
• SQL Syntax (Focus on SQL Syntax, SQL keywords, SQL is not case sensitive, SQL Comments, SQL Commands, and writing SQL Statements.)
• SQL Data Types (SQL Numeric data types, Date and Time data types, Character and String data types, Unicode character string data types, Binary data types, and Miscellaneous data types.)
• SQL Operators (SQL Arithmetic Operators, Comparison Operators, Logical Operators, and Bitwise Operators)
• SQL Expressions (SQL Boolean Expression, SQL Numeric Expression, and SQL Date Expression)
• SQL Comments (SQL Comments, Comments are used to explain sections of SQL statements, or to prevent the execution of SQL statements. Single-Line Comments, and Multi-line Comments)
• . SQL – Data Definition Language Commands and Operations. (SQL Data Definition Language Commands, Create, Alter, Drop, Truncate, and Rename. Data Definition Language Operations, Create a Database, Use Database, Rename a Database, Drop Database, Create a Table, Rename Table, Add a Column to exiting Table, Add multiple columns to existing Table, Modify an existing column, Rename a Column, Drop a Column, Truncate a Table, and Drop a Table.)
• SQL – Data Manipulation Language Commands and Operations (Data Manipulation Language Commands, SELECT, INSERT, UPDATE, and DELETE. Data Manipulation Language Operations, Retrieving data from a table, Inserting data into a table, Updating existing data into a table, and Deleting all records from a table.)
• SQL – Data Control Language Commands DCL includes commands such as GRANT and REVOKE which mainly deal with the rights, permissions, and other controls of the database system.
• . DCL Operations (Providing the users the access or privileges to the database objects, and Taking back or canceling the privileges or permissions previously allowed or denied to the users.)

5) 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
• Working with Functions :- Introduction and Writing Functions, Scope of Variables, Storage Classes, Pass by Value and reference Recursion
• Working with Arrays :- Arrays Declaration and Initialization, Sample Programs using Arrays, Arrays as Function Parameters, 2-Dimensional Array
• Pointers :- Introduction to Pointers, Pointers as Function Parameter, pointers Arithmetic, Pointers and Arrays, Function Pointers, Dynamic Memory Allocation using malloc
• String Handling :- Introduction to Strings, Sample Program, More Sample Programs, Standaed String Library Functuion, Array of String
• Structures and Unions :- Declaring and Instantiating Structures, Structure as Parameter and pointer to Structure, ENumetated Data Type, Union, Bit Fields
• File Handling :- What is a stream, File Handling-Writing and Reading Characters, Writing and Reading structure in Text Format, Writing and Reading in Binary Format
• Pre-Processor Directives :- Understanding Pre-Processor directives, Header Files and Project
• Command Line Arguments and Variable Arguments :- Command Line Argument, Variable Number of Arguments
• Searching and Sorting :- Linear Search, Iterative Binary Search, Recursive Binary Search, Bubble Sort, Selection Sort, Insertion Sort, Quick Sort, Merge Sort
• Stack :- Introduction to Data Structures.

6) JAVA (Core Java and Advanced Java Syllabus Introduction)

• Introduction Programming language Types and Paradigms, Computer Programming Hierarchy, How Computer Architecture Affects a Language ? , Why Java ? ,Flavors of Java, Java Designing Goal, Role of Java Programmer in Industry, Features of Java Language, JVM –The heart of Java , Java’s Magic Bytecode.
• The Java Environment: Installing Java, Java Program Development , Java Source File Structure ,Compilation, Executions.
• Basic Language Elements: Lexical Tokens, Identifiers, Keywords, Literals, Comments ,Primitive Datatypes, Operators Assignments.
• Object Oriented Programming Class Fundamentals , Object & Object reference , Object Life time & Garbage Collection, Creating and Operating Objects , Constructor & initialization code block, Access Control, Modifiers, methods Nested , Inner Class &Anonymous Classes ,Abstract Class & Interfaces Defining Methods, Argument Passing Mechanism , Method Overloading, Recursion, Dealing with Static Members, Finalize() Method, Native Method. Use of “this “ reference, Use of Modifiers with Classes & Methods, Design of Accessors and Mutator Methods Cloning Objects, shallow and deep cloning, Generic Class Types.
• Extending Classes and Inheritance Use and Benefits of Inheritance in OOP, Types of Inheritance in Java, Inheriting Data members and Methods , Role of Constructors in inheritance , Overriding Super Class Methods ,Use of “super” , Polymorphism in inheritance ,Type Compatibility and Conversion Implementing interfaces.
• Package Organizing Classes and Interfaces in Packages , Package as Access Protection , Defining Package ,CLASSPATH Setting for Packages , Making JAR Files for Library Packages Import and Static Import Naming Convention For Packages.
• Exception Handling: The Idea behind Exception ,Exceptions & Errors ,Types of Exception ,Control Flow In Exceptions, JVM reaction to Exceptions ,Use of try, catch, finally, throw, throws in Exception Handling ,In-built and User Defined Exceptions, Checked and Un-Checked Exceptions.
• Array & String : Defining an Array, Initializing & Accessing Array, Multi –Dimensional Array, Operation on String, Mutable & Immutable String, Using Collection Bases Loop for String, Tokenizing a String, Creating Strings using String Buffer .
• Thread : Understanding Threads , Needs of Multi-Threaded Programming ,Thread Life-Cycle, Thread Priorities ,Synchronizing Threads, Inter Communication of Threads ,Critical Factor in Thread –Dead Lock
• A Collection of Useful Classes Utility Methods for Arrays ,Observable and Observer Objects , Date & Times ,Using Scanner Regular Expression, Input/Output Operation in Java(java.io Package),Streams and the new I/O Capabilities ,Understanding Streams, The Classes for Input and Output, The Standard Streams, Working with File Object, File I/O Basics, Reading and Writing to Files, Buffer and Buffer Management, Read/Write Operations with File Channel, Serializing Objects
• GUI Programming Designing Graphical User Interfaces in Java, Components and Containers, Basics of Components, Using Containers, Layout Managers, AWT Components, Adding a Menu to Window, Extending GUI Features Using Swing Components, Java Utilities (java.util Package) The Collection Framework : Collections of Objects , Collection Types, Sets , Sequence, Map, Understanding Hashing, Use of ArrayList & Vector.
• Event Handling Event-Driven Programming in Java, Event- Handling Process, Event-Handling Mechanism, The Delegation Model of Event Handling, Event Classes, Event Sources, Event Listeners, Adapter Classes as Helper Classes in Event Handling
• Database Programming using JDBC Introduction to JDBC,JDBC Drivers & Architecture, CURD operation Using JDBC, Connecting to non-conventional Databases
• Java Server Technologies Servlet Web Application Basics, Architecture and challenges of Web Application, Introduction to servlet, Servlet life cycle, Developing and Deploying Servlets, Exploring Deployment , Descriptor (web.xml), Handling Request and Response

7) 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,
• INTRODUCTION TO XHTML-xml, Move to xhtml. Meta tags, character entitites,frames and frame sets.inside browser.