Login Id Password Login As iiO School Coordinator iOM School Coordinator iOS School Coordinator iOEL School Coordinator NGC School Coordinator GK School Coordinator School Teacher NGC Participant     Click here to Register L I N K S  :  2010 - 2011       About Informatics Olympiad   About Test Paper   Syllabus for iiO 2010   Sample Test Papers   Important Dates & Venue   Order CDs & Books   2nd Level Result   More Links for iiO ...       About Int. Olympiad of Mathematics   About Test Paper   Syllabus for iOM 2010   Important Dates & Venue   Order CDs & Books   Result iOM '09   Toppers of  iOM '09   More Links for iOM ...       Int. Olympiad of Science   About Test Paper   Syllabus and Sample Questions for iOS 2010   Important Dates & Venue   Order Books   Result iOS '09   Toppers of  iOS '09   2nd Level Result iOS '09   More Links for iOS...       Int. Olympiad of English   About Test Paper   Syllabus for iOEL 2011   Sample Questions for iOEL '11   Important Dates & Venue   Order Books   Result iOEL '10   Toppers of  iOEL '10   More Links for iOEL...     The Theme for NGC '10 will be declared in the month of September 2010   All About NGC '10   Result NGC '10   Top Teams of NGC '10   Buy CDs of Top Projects   More Links for NGC...       Smart Kid General Knowledge Olympiad   About Test Paper   Syllabus for SKGKO 2010   Sample Questions for SKGKO 2010   Important Dates & Venue   Books Will be available in the Month of August '10   More Links for SKGKO... Computer Training Workshops for IU Community & General Public 7th International Informatics Olympiad 2010 Syllabus for Senior Classes In iiO 2010, the 15% to 20% questions from 'Mental Ability' has been added. No such syllabus is being provided for the 'Mental Ability' section. The syllabus or the sample questions of the 'Mental Ability' section has not be disclosed to check the IQ level of the participant. While preparing the questions for 'Mental Ability' section, the age factor will be considered the major criteria.  Click on the following link to see Syllabus for iiO 2010. Class 11C Class 11S Class 11M Class 12C Class 12S Class 12M     Class 11C (Informatics Practice VB & ORACLE) COMPUTER SYSTEMS & BUSINESS APPLICATIONS How computers are helpful in Business HARDWARE CONCEPTS Functioning of a Computer: Functional Components of a Computer; Input Unit; Central Processing Unit (CPU); Output Unit Types of Computers: Digital Computers; Analog Computers; Hybrid Computers Strengths and Weaknesses of a Computer; Input, Output And Memory Devices :Input Devices; the Keyboard; optical Character Reader (OCR); Optical Mark Reader (OMR); The Mouse; The Joystick Light Pen; Output Devices; Printers; Impact Printers; Plotters; Visual Display Unit(VDU); Filmed Output; The Memory Devices; The Main Memory (Primary Memory); The Secondary Memory Devices COMPUTER SOFTWARE CONCEPTS Types of Software: System Software; Operating System; Language Processors; Application Software Packages; Utilities MICROSOFT WINDOWS General features; Elements of Desktop Elements of Start Menu Built-in options of Program Menu WORD PROCESSOR- AN INFORMATION PROCESSING TOOL What is Word Processor? Word Processor :Creating/ Opening/ Saving Documents in Word Word Processing Terminology : Margins and Columns; Word Wrapping Indentation; Paragraph Indenting vs. Page Margins; Fonts, Styles and Sizes; Text Attributes; Text Alignment Types of Horizontal Text Alignment; Types of Vertical Alignment; Line Spacing; Tab Stops; Headers and Footers, Page Orientation Editing Document : Cutting, Pasting Text and graphics, Navigating in Word; Inserting/ Overtyping in Documents Formatting the Document : Character Formatting; Paragraph Formatting; Page Formatting in Word Printing and Getting Help : Printing and Getting Help in MSWord Programming Methodology General Concepts: Modular approach; Stylistic Guidelines; Clarity and Simplicity of Expressions, Names, Comments, Syntax Errors, Run-Time Errors, Logical Errors; Problem Solving Methodology and Techniques: Understanding of the problem, Identifying minimum number of inputs required for output, Step by step solution for the problem, breaking down solution into simple steps, Identification of arithmetic and logical operations required for solution, Using Control Structure; Conditional control and looping (finite and infinite) Programming Fundamentals Data Types : Integer, Long, Single, Double, Currency, String Byte, Boolean, Date, Object, Variant; Variables : Need to use variable, Declaring Variables, Variable Naming Convention, Assigning value to Variables, Data Types of variable, Scope and lifetime of Variables (Public and Private); Controls (Advance) Image List Common Dialog Box, ADO DC, DB Combo, Media Player Control, DB Grid; Adding a Toolbar Creating an Image List, Adding Images to Toolbar, To Add Code for the Toolbar Buttons; Dialog Boxes: Pre-defined dialog box, Custom dialog box; Programming Tool: Visual Basic Types of Programming:  Modular Programming, Object Oriented Programming, Event Driven Programming; Concept of Project in Visual Basic: VB Project Options-Standard EXE, Active-X DLL, ActiveX EXE Control, ActiveX Document DLL, ActiveX Document EXE Visual Basic User Interface : Pull-Down menus, Toolbar, Toolbox, Project Explorer, Properties Window, Form Layout window, Form, Immediate window; Opening and Closing windows, Resizing and moving windows, Docking windows Visual Basics Standard Window Controls : Pointer, Picture Box, Label, Textbox, Frame, Command Button, Check Box, Option Button, Combo Box, List Box, Horizontal Scrollbar, Vertical Scrollbar, Timer, Drive List box, Directory List box, File List box, Shape, Line, Image, Data, OLE Object Naming Conventions, Event Procedures ORACLE A RDBMS TOOL ORACLE: Multi Tier support; Interface with oracle, Long Screen, Entering Name and password; Classification of SQL Statement : DML (SELECT, INSERT, UPDATE, DELETE), DDL (CREATE, DROP, ALTER, RENAME, TRUNCATE), DLC (GRANT, REVOKE), TCL COMMIT, ROLLBACK) SQL SELECT Statement Functions: SQL Functions, Types of SQL Function (Single Row/Multiple Row), Single Row SQL Functions, Character Functions (Case Conversion Functions) Grouping Records What are Sub Queries Displaying Data from Multiple Tables Working with Data of A Table/Relation Database Objects : View, Table, Sequence, Index, Synonyms, DDL, naming convention, Creating Views, Creating Synonyms, Views, Retrieving Data from Views, Querying and modifying Views Constraints : Concepts of using Constraints, Defining Constraints, NOT NULL, UNIQUE KEY, PRIMARY KEY, FOREIGN KEY, Disabling Constraints, Viewing Constraints Managing Existing Tables and other Database Objects : The ALTER TABLE Statement, Adding a new Column in a Table, Modifying existing Column, Dropping a column, Renaming an Object, Truncating a Table, Adding Comments to a Table, Dropping Views, Dropping Synonyms, Dropping Tables; Permissions (GRANT and REVOKE statement). Please refer suggested readings for class 11C : Information Practice (VB & Oracle) : Evangelos Petroutsos (Mastering VB6)-BPB; Ivan Bayross (Oracle) BPB; CLASS 11S (Computer Science C++) _____________Top MICROSOFT DISK OPERATING SYSTEM Disk Drives, Loading of DOS into Main Memory (Booting), Files and File Naming Conventions, Types of DOS Commands, Directory Structure of MS-DOS Concept of path, Wild Cards, DOS Internal Commands, File Commands; Directory Commands; Miscellaneous Commands, External Commands, Loading of Executable files, Piping and Redirection in DOS Commands, Filters and Pipes; Redirection, Batch Processing, How to create and execute a batch file ?; AUTOEXCE.BAT, Important function Keys and Control Keys GENERAL OOP CONCEPTS Evolution of Software :Programming Paradigms Basic Concepts of OOP : Data Abstraction Encapsulation; Inheritance; Polymorphism GETTING STARED WITH C++ C++ Character Set Tokens : Keywords; Identifiers; Literals; Punctuators; Punctuators; Operators A First Look at C++ Program: Why include iostream.h; The Function of I/O Library- iostream.h ; predefined Streams in I?O Operators Output operator”<<” Input Operator”>>” Cascading Of I/O Library – iostream. h; Predefined Streams in I/O Operators Using I/O Operators : Output Operator “<<” Input Operator”>>” ; cascading of I/O Operators DATA HANDLING Concept of Data Types C++ Data Types : Fundamental Data Types; Data Type Modifiers; Derived Data types Variables : Declaration of a Variable; Initialization of Variables; The Access modifier Const OPERATORS AND EXPRESSIONS IN C++ Operators : Arithmetic Operators; Increment/Decrement Operators: relational operators; Logical operators; Conditional operator?:; Some Other Operators; Precedence of Operators Expressions : Arithmetic Expressions; logical Expressions Assignment Statements : Variable Initialization; Type compatibility ALGORITHMS Flowcharts Writing Algorithms What is Structured Programs FLOW OF CONTROL Statements : Compound Statement (Block) Selection Statements : if Statement of C++ ; The switch Statement Iteration Statements :Elements That Control a Loop (Parts of a Loop); The for Loop; The While Loop; The do-while Loop; Nested Loops; Comparison of Loops Jump Statements :The goto Statement ; The break Statement; The continue Statement ; The exit() Function CONSOLE I/O OPERATIONS Header Files and Their Purpose Unformatted console I/O Functions : Single Character Functions; String Functions Unformatted Stream I/O Functions :Single Character function; Multi character Functions STRUCTURED DATA TYPE; ARRAY What is an Array Types of Arrays : Single Dimensional Arrays; Two-Dimensional Arrays; Multi Dimensional Arrays Array Initialization : Unsized Array Initializations FUNCTIONS Function Definition : Function Prototype Accessing is Function : Default Arguments; Constant Arguments; Call By Value; Call by Reference; Calling Functions with Arrays Returning from a Function: The return statement; Returning Values; returning Non-integer values; returning (by) Reference Scope Rules : Scope Determination Storage Class Specifier : Storage Class Specifiers and Variables Storage Class Specifiers and Functions STANDARD LIBRARY AND HEADER LILES What are Header Files : Stdio.h; String/h; Math.h; Stdlib.h.; Iomanip.h String and Character related Functions : Character Functions; String Functions, Mathematical Functions DATA REPRESENTATION Number System : Decimal Number System; Binary Number System; Octal Number System; Hexadecimal Number System Number conversions : Decimal-to-Binary Conversion; Binary-to-Decimal Conversion; Decimal-to-Octal Conversion; Octal-to-Decimal Conversion; Octal-to-Binary Conversion; Binary-to-Octal Conversion; Decimal-to Hex Conversion; Hex-to-Decimal Conversion; Binary-to-Hex Conversion; Hex-to-Binary Conversion Binary Representation of Integers : Sign and Magnitude Representation; One’s Complement Representation; Two’s Complement Representation Binary Representation of Real Numbers Representing characters in Memory COMPUTER ORGANIZATION Input, Output and Memory Devices Input Devices; Output Devices; The Memory Devices The Processor :Computer Registers; Common Bus System Operations for Hypothetical Computer : The Instruction Set; The Instruction Cycle; Program the Computer Pleaser refer suggested readings for 11S : Computer Science (C++) : Yashwant Kanetkar (Let us C++) -BPB; Class 11M (MULTIMEDIA & WEB TECHNOLOGY) __Top WEB Development using HTML/XML; Server & client scripts; Web Management; Creating Web Site; Image-Editing tools; Audio & video capture and editing using software tools; Multimedia authoring. Pleaser refer suggested readings for 11M : Mastering WEB DESIGNING – Maccoy (BPB),Multimedia on the PC – Sinclair (BPB), CorelDraw 9 – Training Guide – Lotia, M (BPB),ASP, ADO and XML Complete – Sybex (BPB),VBSCRIPT Interactive Course: Waite Group – Simon (BPB) CLASS 11J/12J (Information Practice  -Java & SQL ) ____Top Please follow the syllabus as Prescribed by CBSE/ICSE syllabus Networking and Open Standards: Computer Networking, Object oriented Concepts; IDE based programming using Java; Open Source Concepts; Programing Fundamentals: Access specifier for classes, Members and methods, Concept of package; Inheritance: Need and implementation, Method Overloading and Overriding, Abstract Class and Interfaces, use of interfaces; Commonly used libraries; Ralational Database Management System: SQL Queries; IT Applications : e- governance, e-Business and e-Learning Class 11J Introduction to computer systems with hardware concepts and software concepts in place of computer system and Business Applications IDE based programming using Java in place of IDE based programming using Visual Basic Relational Database Management System with SQL using MySQL in place of SQL using Oracle A new Unit ‘IT Applications’ has been added in the curriculum to enhance understanding of the above tools Class 12J Networking and open standards in place of Business Computing IDE based programming using Java in place of IDE based programming using Visual Basic Relational Database Management System with SQL Please refer suggested reading for 11J/12J : Introduction to Computer System:V. Rajaraman, Introduction to Programming: Herbert Schildt , Java : the complete reference; Relational Database Management System:Lerry Ulman, MYSQL Database; Computer Networking: William Stallings, Computer Networking Open Standard and Multi-Lingual Computing: www.w3c.org CLASS 12C (Information Practice VB & ORACLE) ____Top BUSINESS COMPUTING Concepts of Business Computing, What is a Front End and Back End System, How to integrate user interface with databases. Application of database system in various areas of applications. Program Development Methodology : System Development Life Cycle; What is RDBMS; What are data Models and its attributes. Concepts of OOPs using Unified Modeling Language. Concepts of Client Server Computing Programming with Visual Basic Kinds of Modules available in VB Control structure : Decision Structure (IF, IF-THEN-ELSE, Select Case) Looping Structure : Do While, Do, For…Next, For Each What are function and types of functions Parameterized functions Built-in Functions : String functions, Numeric Functions, Time-Related functions, Miscellaneous Functions. What are forms in VB and their types. What is a Visual Basic Project File (.PRJ) What are the methods of accessing Database in VB Various Data Controls for handling data Bound Controls ADO Data Controls and their properties Data Reports in VB Error handling with VB RDBMS Database Fundamentals : What are Transactions; Network protocols required (TCP/IP) for Data communication; Stored Procedures; Concepts of database Fragmentation and Distributed database. PL/SQL (programming Language in SQL) Importance of writing procedures : Declaring variables; Block structure; Program Construct; Types of variables; Naming Rules; PL/SQL record structure. Writing Executable Statements : PL/SQL Block syntax and Guidelines; PL/SQL Functions; Data type conversion; Nested Blocks and variable scope; Retrieving, manipulating ,inserting data, updating and deleting data; Commit and rollback statements; SQL Cursor and their attributes. Writing Control Structure : Controlling flow of execution; various control structure; looping structure using PL/SQL. Creating Stored Procedure : What are producers; Creating stored procedures and their advantages; parameters in Stored Procedures, Removing stored procedure Cursors : What are cursors and its types (Implicit and Explicit); Cursor Functions; Declaring, Opening, Closing and fetching data using Cursors; How to control multiple fetches; Cursors and Records; Cursor FOR loops; Cursor FOR Loops using Sub Queries. Triggers : What are triggers and their types; BEFORE, AFTER and INSTEAD of Triggers, Valid Triggers types, Enabling, Disabling, Replacing and Deleting Triggers Please refer suggested readings for 12C : Information Practice (VB & Oracle) : Steven Holzner(VB6 Black Book)-DreamTech Press; Ivan Bayross(Oracle)-BPB; Class 12S (Compute Science C++) ______________Top Major section of the Syllabus Structures Objects & Classes Constructors and destructors Function Overloading Inheritance: Extending Classes Pointers Basics of Data Structure Linked List Stank Queue File Organization File Handling in C++ Database Concepts Structure Query language Boolean Algebra Local Area Network Internet Related Terminology Please Refer Readings for 12S : Computer Science (C++) : Sumit Arora - Dhanpat Rai & Sons; Yashwant Kanetkar - BPB Publications; Class 12M (MULTIMEDIA & WEB TECHNOLOGY) __Top Database Terminology; Evolution of Networking: ARPANET, Internet, Interspace; Network devices; Multimedia Application; Web Development; ASP; Movie File Formats; Macromedia Flash Please Refer Readings for 12M : Mastering HTML 4 Premium Edition – Ray (BPB), ASP, ADO and XML Complete – Sybex (BPB), Multimedia Magic – Gokul, S (BPB), Learn Advanced HTML with DHTML – Ramalho (BPB), Effective Web Design – Navarro (BPB),Practical ASP – Bayross (BPB),Inside Flash 5 – Kea thing (BPB) TOP   Registration for International Informatics Olympiad 2010 has started. Important Links - iiO '10 How to Participate? About Test Papers & Language Medium Detailed Syllabus for all Classes Sample Test Papers for all Classes Important Dates & Venue Olympiad Books & CDs Sample Answer Sheet (PDF) Unique Features of iiO Facilities on Internet for - iiO Coordinators, Teachers and Students     Order Books and CDs Online for iiO '10  Feedback from Schools   More on Page :  1  2  3  4  5  6