• Fill the form below

Home / International Olympiad of Computer Science / syllabus & sample question papers

syllabus & sample question papers

IOCS

The detailed Syllabus is provided here. For books please contact, School Coordinator or place your order online now.

Summarized Syllabus
  • For classes 1-10: There will be 30 questions and the time duration will be of 60 Minutes.*
  • For classes 11-12: There will be 40 questions and the time duration will be of 40 to 60 minutes.*
CLASSWISE TOPIC DETAILS
Class I

TOPICS

  • What is Computer
  • Devices used with Computer
  • How to Operate Computer
  • Application of Computer in Various Fields
Class II

TOPICS

  • Getting started with Computer’s basics
  • Calculations with Computer
  • Keyboard usage
  • What is Data and Information?
  • Number System for Data representation
  • Introduction to Windows
Class III

TOPICS

  • Evolution of Computers
  • Growth of the Modern Computer
  • Types of Computer Language
  • Binary Logic
  • Coding Schemes
  • What is Booting up?
  • Database Management Packages
  • Getting Familiar with Windows
  • Working with Paint Brush
Class IV

TOPICS

  • Generations of computers
  • Computer and its Peripherals
  • Computer Memories
  • Characteristics of Memory Devices
  • Software classification
  • A brief about Computer Languages
  • Windows XP overview
Class V

TOPICS

  • Categories and Classification of Computers
  • Logo Basics
  • Understanding Windows
  • Working With Ms-Word
  • Applications of Multimedia
  • E-mail & Internet
Class Vi

TOPICS

  • World of Computers
  • Input and Output Devices
  • Logo Intermediate
  • Word Processing
  • Spreadsheet
  • More on Windows
  • Multimedia, Networking and Internet
Class Vii

TOPICS

  • Programming with Logo
  • Computer Networking and its Usage
  • Accessing Windows Explorer
  • Multimedia: The Basic Concepts
Class Viii

TOPICS

  • Technological Development of Computers
  • How Computer Works?
  • Computer Software Fundamentals
  • Coding with Logo
  • Managing Windows 95/98
  • Word Processing with MS-Word
Class IX

TOPICS

  • Characteristics of Computer and Other Devices
  • Understanding Programming Languages
  • Operating systems
  • Computer and Communication
  • Office Automation
Class x

TOPICS

  • The world of Internet
  • Internet Usage
  • HTML: hyper text markup language
  • Internet Glossary
Class XI

TOPICS

  • Computer Systems & Business Applications
  • Hardware Concepts
  • Computer Software Concepts
  • Microsoft Windows
  • Word Processor – An Information Processing Tool
  • Programming Methodology
  • Programming Fundamentals
  • Business Computing
  • Programming with Visual Basic
  • Programming Tool: Visual Basic
  • RDBMS
  • Oracle A RDBMS Tool
  • Compute Science C++
  • Multimedia & Web Technology
  • Information Practice - Java & SQL
  • Networking

 

Class XII

TOPICS

Information Practice VB & ORACLE

1.  Business Computing

l  Concepts of Business Computing, What is a Front End and Back End System, How to integrate user interface with databases.

l  Application of database system in various areas of applications.

l  Program Development Methodology : System Development Life Cycle; What is RDBMS; What are data Models and its attributes.

l  Concepts of OOPs using Unified Modeling Language.

l  Concepts of Client Server Computing

2.  Programming with Visual Basic

l  Kinds of Modules available in VB

l  Control structure : Decision Structure (IF, IF-THEN-ELSE, Select Case)

l  Looping Structure : Do While, Do, For…Next, For Each

l  What are function and types of functions

l  Parameterized functions

l  Built-in Functions: String functions, Numeric Functions, Time-Related functions, Miscellaneous Functions.

l  What are forms in VB and their types.

l  What is a Visual Basic Project File (.PRJ)

l  What are the methods of accessing Database in VB

l  Various Data Controls for handling data

l  Bound Controls

l  ADO Data Controls and their properties

l  Data Reports in VB

l  Error handling with VB

3.  Programming Tool: Visual Basic

l  Types of Programming:  Modular Programming, Object Oriented Programming, Event Driven Programming;

l  Concept of Project in Visual Basic: VB Project Options-Standard EXE, Active-X DLL, ActiveX EXE Control, ActiveX Document DLL, ActiveX Document EXE

l  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

l  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

l  Object Naming Conventions, Event Procedures

4.  RDBMS

l  Database Fundamentals: What are Transactions; Network protocols required (TCP/IP) for Data communication; Stored Procedures; Concepts of database Fragmentation and Distributed database.

l  PL/SQL (programming Language in SQL)

l  Importance of writing procedures : Declaring variables; Block structure; Program Construct; Types of variables; Naming Rules; PL/SQL record structure.

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

l  Writing Control Structure : Controlling flow of execution; various control structure; looping structure using PL/SQL.

l  Creating Stored Procedure : What are producers; Creating stored procedures and their advantages; parameters in Stored Procedures, Removing stored procedure

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

l  Triggers : What are triggers and their types; BEFORE, AFTER and INSTEAD of Triggers, Valid Triggers types, Enabling, Disabling, Replacing and Deleting Triggers

5.  Oracle A RDBMS Tool

l  ORACLE: Multi Tier support; Interface with oracle, Long Screen, Entering Name and password;

l  Classification of SQL Statement : DML (SELECT, INSERT, UPDATE, DELETE), DDL (CREATE, DROP, ALTER, RENAME, TRUNCATE), DLC (GRANT, REVOKE), TCL COMMIT, ROLLBACK)

l  SQL SELECT Statement

l  Functions: SQL Functions, Types of SQL Function (Single Row/Multiple Row), Single Row SQL Functions, Character Functions (Case Conversion Functions)

l  Grouping Records

l  What are Sub Queries

l  Displaying Data from Multiple Tables

l  Working with Data of A Table/Relation

l  Database Objects : View, Table, Sequence, Index, Synonyms, DDL, naming convention, Creating Views, Creating Synonyms, Views, Retrieving Data from Views, Querying and modifying Views

l  Constraints : Concepts of using Constraints, Defining Constraints, NOT NULL, UNIQUE KEY, PRIMARY KEY, FOREIGN KEY, Disabling Constraints, Viewing Constraints

l  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).

6.  Compute Science C++

l  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

7.  Multimedia & Web Technology

l  Database Terminology;

l  Evolution of Networking:

l  ARPANET, Internet, Interspace; Network devices;

l  Multimedia Application;

l  Web Development;

l  ASP;

l  Movie File Formats;

l  Macromedia Flash

8.  Information Practice - Java & SQL

l  Networking and Open Standards: Computer Networking, Object oriented Concepts;

l  IDE based programming using Java;

l  Open Source Concepts; Programing Fundamentals: Access specifier for classes, Members and methods, Concept of package;

l  Inheritance: Need and implementation, Method Overloading and Overriding, Abstract Class and Interfaces, use of interfaces;

l  Commonly used libraries;

l   Rational Database Management System: SQL Queries;

l   IT Applications : e- governance, e-Business and e-Learning

9.  Networking

l  Networking and open standards in place of Business Computing

l  IDE based programming using Java in place of IDE based programming using Visual Basic

 

l  Relational Database Management System with SQL

Testimonials
  • Mr Dhruv Sharma
    ARMY SCHOOL, JHANSI

    Standard of question paper is highly appreciated. Way of conducting the exams and documents enclosed are very good....

    Read more...
  • MRS ANITA RANI
    ST. SOLDIER DIVINE PUBLIC SCHOOL, PUNJAB

    DEALING REGARDING OLYMPIAD STUDENTS ARE GOOD. GIVE INFORMATION AS SOON AS THERE IS A LITTLE BIT CHARGE. MOTIVATE THE ST...

    Read more...
  • MRS GAYATRI G PATIL
    S. P. MANDALS PRE-PRIMARY ENG. MED. SCHOOL, MAHARASHTRA

    MARK SYSTEM IS GOOD, QUESTIONS SELECTION IS VERY GOOD...

    Read more...
  • MS SAVITA VERMA
    NETAJI MODEL SCHOOL (PUNJAB)

    ITS IMPROVES THE STUDENTS KNOWLEDGE, MAXIMUM STUDENTS PARTICIPATING IN IMMO...

    Read more...
  • A APARNA
    DR. K.K.R'S GOWTHAM CONCEPT SCHOOL, ANDHRA PRADESH

    STAFF AT IQ ZONE HAVE RECEIVED OUR PHONE CALLS IN A CORDIAL MANNER AND HAVE ARRANGED FOR THE QUESTION PAPERS AND HALL T...

    Read more...
  • SMT YALIGAR NAGRATNA BABURAO
    GANDHI NATHA RANGJI VIDYALAYA, MAHARASHTRA

    WE ARE SUCCESSFULLY ENABLED TO CONDUCT THE EXAM WITHOUT ANY MISTAKE. IT’S DUE TO YOUR GUIDELINE FORM SENT 6th to 12th Q...

    Read more...
  • MRS KAVITA MAHAJAN
    SWAMI PRITAM DAS GOVIND RAM ACADEMY, MADHYA PRADESH

    INCREASING REASONING AND KNOWLEDGE...

    Read more...
  • MR MAHESH MUDDALA
    SWARNANDHRA INTERNATIONAL SCHOOL, ANDHRA PRADESH

    THERE IS NO “OMR” SHEETS FOR 1st TO 5th classes. ATTRACTIVE PRIZES...

    Read more...
  • RAJESH KUMAR MAHATO
    ST XAVIERS ENGLISH SCHOOL JHARKHAND

    IT IS HELPING TO REMOVE FEAR OF APPEARING EXAMS. IT’S HELPING TO BRING OUT THEIR (STUDENT’S) SUBJECT WISE TALENT AND HE...

    Read more...
  • MR VIVEK MISHRA
    HAPPY MODEL SCHOOL UTTAR PRADESH

    GOOD WAYS TO EVALUATE THE CONCEPT, SKILL AND UNDERSTANDING THE TOPICS STUDIED BY STUDENTS....

    Read more...