ICSO Class 9 Computer Science Olympiad 2026-27 Comprehensive Study Guide

Syllabus & Exam Overview

• Exam Specifications: SOF (Science Olympiad Foundation) Class 9 International Computer Science Olympiad (ICSO) 2026–27.
• Question Structure: 50 questions to be answered in 1 hour (applicable for Classes 5–10).
• Syllabus Composition (Level 1): $60\%$ current-class syllabus + $40\%$ previous-class syllabus.
• Achievers Section: Covers current-class syllabus only.
• Software Standards: Official syllabus specifically includes Windows 11 and MS-Office 2016.
• Key Added Topics: Animation & multimedia, binary/decimal conversion, Windows 11 features, advanced HTML tags, Excel Formula Auditing / Data Tools / protection & sharing / ranges, and Python 3.14.2.

1. Fundamentals of Computer

• Core Concepts:

  • Data Flow: Input $\rightarrow$ Processing $\rightarrow$ Output $\rightarrow$ Storage.
  • CPU (Central Processing Unit): The main processing unit containing:
  • ALU (Arithmetic Logic Unit): Performs arithmetic and logical operations.
  • CU (Control Unit): Controls and coordinates all computer activities and operations.
  • Registers: Ultra-fast CPU storage used during operation execution.
  • Hardware vs. Software: Hardware consists of physical components; software consists of programs and instructions.
  • Primary Memory: Includes RAM, ROM, and Cache.
  • Secondary Storage: Non-volatile storage such as Hard Disk Drives (HDD), Solid State Drives (SSD), optical discs, pen drives, and memory cards.

• Memory Characteristics:

  • RAM (Random Access Memory): Volatile, temporary memory that supports read and write operations.
  • ROM (Read Only Memory): Non-volatile memory that retains stored information even without power.
  • Cache Memory: Extremely fast memory used to hold frequently accessed data and instructions to speed up CPU processing.

• Input / Output (I/O) Devices:

  • Input Devices: Keyboard, mouse, scanner, microphone, webcam.
  • Output Devices: Monitor, printer, speakers, projector.
  • Dual-Purpose Devices: Touchscreens function as both input and output devices.

• Number Systems:

  • Binary System: Base-2 system using digits $0$ and $1$.
  • Decimal System: Base-10 system using digits $0$ through $9$.
  • Binary to Decimal Conversion: Multiply each bit by its corresponding power of $2$ ($2^n$) and sum the products. Example: $1011_2 = (1 \times 2^3) + (0 \times 2^2) + (1 \times 2^1) + (1 \times 2^0) = 8 + 0 + 2 + 1 = 11_{10}$.
  • Decimal to Binary Conversion: Repeatedly divide the decimal number by $2$ and record the remainders from bottom-to-top.

• Animation & Multimedia:

  • Multimedia: Combines multiple media types including text, graphics, audio, video, and animation.
  • Animation: Creates the optical illusion of movement by displaying sequential frames/images at high speeds.

• Essential Keywords:

  • Bit: Smallest unit of binary data ($0$ or $1$).
  • Byte: Group of $8$ bits ($1\,\text{byte} = 8\,\text{bits}$).
  • Firmware: Specialized software permanently programmed into non-volatile memory/hardware.
  • Booting: The startup process of loading the operating system into main memory.

2. Algorithms & Flowcharts in Programming

• Algorithm Concepts:

  • Definition: A finite, ordered, and unambiguous sequence of steps designed to solve a specific problem.
  • Control Structures:
  • Sequence: Executing steps in sequential order.
  • Selection: Making decisions based on conditions.
  • Iteration: Repeating steps via loops.
  • Pseudocode: Informal high-level description of program logic written without strict programming language syntax.

• Flowchart Symbols:

  • Oval: Represents Start / End points.
  • Rectangle: Represents a Process (computation or assignment).
  • Parallelogram: Represents Input / Output operations.
  • Diamond: Represents a Decision (conditional check with multiple path branches).
  • Arrow: Indicates flow direction.
  • Circle: Functions as a Connector between different parts of a flowchart.

3. Operating System

• Core OS Concepts:

  • Definition: System software that manages hardware and software resources and provides a user interface.
  • Key Functions: Process management, memory management, file management, device management, security enforcement, and user interface provision.
  • Interfaces:
  • GUI (Graphical User Interface): Uses visual icons, buttons, and windows.
  • CLI (Command Line Interface): Relies on text-based command prompts.
  • Kernel: The core component of an OS that manages system resources and low-level operations.
  • Device Driver: Software that enables the operating system to communicate with specific hardware devices.

• Types of Operating Systems in Syllabus:

  • Interactive / GUI-based OS: Designed for direct user interaction through graphical elements.
  • Real-Time OS (RTOS): Engineered to respond to events within strict, specified timing constraints.
  • Distributed OS: Manages and coordinates resources across multiple independent connected computers across a network.

• Common Operating Systems:

  • Examples: Windows, Linux, macOS, Android, iOS.

• Windows 11 Shortcuts:

  • Win + E: Open File Explorer.
  • Win + D: Show / Hide Desktop.
  • Win + L: Lock computer screen.
  • Alt + Tab: Switch between open applications.
  • Alt + F4: Close active window / app.
  • Ctrl + Shift + Esc: Open Task Manager directly.
  • F2: Rename selected file or folder.

4. MS-Access 2016

• Database Basics:

  • Database: An organized collection of related data.
  • Table: Core object comprising rows and columns.
  • Field: Column / attribute representing a specific data category.
  • Record: Row / entry representing a complete set of fields for a single item.
  • Primary Key: A field that uniquely identifies each record in a table; cannot contain duplicate or null values.

• Database Objects:

  • Table: Stores data in structured rows and columns.
  • Query: Retrieves, filters, or manipulates specific data based on defined conditions.
  • Form: Provides a user-friendly interface for entering, editing, and viewing data records.
  • Report: Formats and summarizes data for presenting or printing.

• Common Data Types:

  • Short Text, Number, Date/Time, Currency, Yes/No, AutoNumber.

5. Introduction to Visual Basic

• Core VB Concepts:

  • Visual Basic supports Graphical User Interface (GUI) and Event-Driven Programming.
  • Form: The application window or user interface container.
  • Control: Visual objects placed on a form (e.g., Label, TextBox, Button / CommandButton, CheckBox).
  • Property: Named attribute defining the appearance or behavior of an object.
  • Event: Action recognized by an object (e.g., user clicking a button).
  • Method: Action performed by an object.

• Key Events & Programming Style:

  • Examples of events: Click, Load, Change.
  • Event-driven code executes specifically in response to triggered events.

6. HTML & CSS

• HTML Concepts:

  • HTML (HyperText Markup Language): Language used to define webpage structure and content.
  • Essential Tags: <html>, <head>, <title>, <body>, <h1> to <h6>, <p>, <br>, <hr>, <a>, <img>, <ul>, <ol>, <li>, <table>.
  • Link attribute: href is used inside <a> tags to specify the destination URL.
  • Table Structure Tags: <table>, <tr> (table row), <th> (table header cell), <td> (table data cell).

• Advanced / Link Tags:

  • Anchor Link: <a href="URL">Link Text</a>.
  • Image Tag: ``.

• CSS Concepts:

  • CSS (Cascading Style Sheets): Language used to control presentation, styling, and layout of HTML elements.
  • Styling Methods: Inline CSS, Internal CSS, and External CSS.

• Key Traps & Distinctions:

  • HTML handles structure and content; CSS handles styling and layout.
  • <br> creates an explicit line break.

7. MS-Word 2016

• Shortcuts:

  • Ctrl + N: New document.
  • Ctrl + O: Open document.
  • Ctrl + S: Save document.
  • Ctrl + P: Print document.
  • Ctrl + A: Select all content.
  • Ctrl + C: Copy selected content.
  • Ctrl + X: Cut selected content.
  • Ctrl + V: Paste copied/cut content.
  • Ctrl + Z: Undo last action.
  • Ctrl + Y: Redo last undone action.
  • Ctrl + F: Open Find tool.
  • Ctrl + H: Open Replace tool.
  • Ctrl + B: Apply Bold formatting.
  • Ctrl + I: Apply Italic formatting.
  • Ctrl + U: Apply Underline formatting.
  • Ctrl + K: Insert Hyperlink.
  • Ctrl + L: Left align text.
  • Ctrl + E: Center align text.
  • Ctrl + R: Right align text.
  • Ctrl + J: Justify text alignment.

• Key Features:

  • Header & Footer: Header appears at top margin; Footer appears at bottom margin of pages.
  • Mail Merge: Tool to generate personalized letters, emails, or labels for multiple recipients simultaneously using a data source.
  • Find & Replace: Searches for specific text and replaces it automatically across the document.

8. MS-Excel 2016

• Excel Basics:

  • Workbook: Excel file containing one or more worksheets.
  • Worksheet: Individual grid sheet made of rows and columns.
  • Cell: Intersection of a row and a column (e.g., B5 represents Column B, Row 5).
  • Rows are numbered ($1, 2, 3\dots$); columns are lettered ($A, B, C\dots$).
  • Formulas always begin with an equals sign (=).

• Functions & Operators:

  • Arithmetic Operators: + (addition), - (subtraction), * (multiplication), / (division), ^ (exponentiation), % (percentage).
  • Built-in Functions: SUM(), AVERAGE(), MAX(), MIN(), COUNT().
  • Cell References:
  • Relative: A1 (changes when copied).
  • Absolute: $A$1 (locks row and column when copied).
  • Mixed: $A1 or A$1 (locks only row or column).

• Formula Auditing:

  • Toolset used to inspect and verify cell formulas and relationships, including Trace Precedents, Trace Dependents, and Error Checking.

• Data Tools:

  • Features for data handling including Sorting, Filtering, Data Validation, and Remove Duplicates.

• Ranges, Protection & Sharing:

  • Cell Range: Denoted with a colon, e.g., A1:A5 spans cells from A1 down to A5.
  • Protection: Worksheet and Workbook protection restricts editing permissions.
  • Sharing: Features allowing multi-user collaborative editing based on configuration.

9. MS-PowerPoint 2016

• Core Concepts:

  • Slide: Single page of a presentation.
  • Layout: Predetermined arrangement of content placeholders on a slide.
  • Transition: Visual animation effect that occurs when moving from one slide to another during a slideshow.
  • Animation: Visual effect applied to individual elements (text, graphics, shapes) on a single slide.
  • Presentation Views: Normal View, Slide Sorter View, Reading View, Slide Show View.

• Shortcuts:

  • Ctrl + M: Insert a New Slide.
  • Ctrl + S: Save presentation.
  • Ctrl + P: Print presentation.
  • F5: Start Slide Show from the beginning slide.
  • Shift + F5: Start Slide Show from the current slide.
  • Esc: End / exit Slide Show.

10. Networking

• Network Types & Scale:

  • PAN (Personal Area Network): Smallest scale (e.g., Bluetooth devices around a person).
  • LAN (Local Area Network): Local scale (e.g., home, office building, school).
  • MAN (Metropolitan Area Network): City-wide scale.
  • WAN (Wide Area Network): Country or global scale (e.g., Internet).
  • Scale Hierarchy: $\text{PAN} < \text{LAN} < \text{MAN} < \text{WAN}$.

• Network Devices & Terms:

  • Router: Connects and directs data packets between different networks.
  • Switch: Connects multiple devices together within a single local network.
  • Modem: Modulates/demodulates signals enabling computer communication with an Internet Service Provider (ISP).
  • IP Address: Unique numerical identifier assigned to a network interface/device.
  • URL (Uniform Resource Locator): Web address pointing to a specific web resource.
  • DNS (Domain Name System): Translates human-readable domain names into numerical IP addresses.
  • HTTP / HTTPS: HyperText Transfer Protocol (HTTPS is encrypted and secure).

• Topologies:

  • Types: Bus, Star, Ring, Mesh, Tree.
  • Star Topology: Features a central connecting device (such as a switch or hub) to which all nodes connect.

11. Cyber Safety

• Cyber Threats:

  • Virus: Malicious code that replicates by attaching itself to files or programs.
  • Worm: Standalone malware that self-replicates and spreads autonomously across network connections.
  • Trojan: Malicious program disguised as legitimate or useful software.
  • Spyware: Software that secretly monitors, tracks, and collects user information without authorization.
  • Ransomware: Malware that encrypts victim data and demands ransom payment for decryption keys.
  • Phishing: Fraudulent attempt to steal sensitive data (passwords, financial details) by masquerading as a trustworthy entity in electronic communications.

• Safety & Hygiene:

  • Practice strong, unique passwords; enable Two-Factor Authentication (2FA) / Multi-Factor Authentication (MFA); update software regularly; avoid suspicious attachments/links; maintain regular data backups.
  • Digital Footprint: The trail of data left behind by user activity on the internet.
  • Cyberbullying: Bullying or harassment conducted through digital platforms and online communication.

12. Scratch

• Core Concepts:

  • Scratch is a block-based visual programming environment.
  • Sprite: Main graphical character or object in a project.
  • Stage: Main area where sprites perform actions and scripts run.
  • Backdrop: Background graphic displayed on the Stage.
  • Script: Stack of visual blocks snapped together to control sprite or stage behavior.

• Block Categories & Logic:

  • Categories: Motion (blue), Looks (purple), Sound (pink), Events (yellow), Control (gold), Sensing (light blue), Operators (green), Variables (orange).
  • Loop & Control Blocks:
  • repeat: Executes contained blocks a fixed number of times.
  • forever: Continuously loops blocks indefinitely until stopped.
  • if then: Executes enclosed blocks only if the specified condition is true.
  • if then else: Two-way conditional choice branch.

13. Python

• Core Python Concepts:

  • Python is a high-level, interpreted, general-purpose programming language.
  • Syllabus specification: Python 3.14.2.
  • print(): Displays output on the console screen.
  • input(): Accepts user input (always returns input as a string str).
  • Indentation: Essential requirement used to define code blocks, functions, and control structures (replaces braces).

• Data Types:

  • int: Whole numbers (integers, e.g., 5, -10).
  • float: Floating-point numbers with decimals (e.g., 3.14).
  • str: Text string enclosed in single or double quotes.
  • bool: Boolean truth value (True or False).

• Operators:

  • Assignment: =.
  • Comparison: == (equality), != (not equal), >, <, >=, <=.
  • Arithmetic: +, -, *, / (float division), // (floor/integer division), % (modulus/remainder), ** (exponentiation).
  • Logical: and, or, not.

• Control Structures:

  • Selection: if, elif, else.
  • Loops: for, while.
  • range(): Generates sequence of integers commonly used in for loops.

• Key Traps & Examples:

  • = (assignment operator) and == (equality comparison operator) are distinct and not interchangeable.
  • Expression evaluation: 10 % 3 = 1 (remainder), whereas 10 // 3 = 3 (floor division).
  • Python is strictly case-sensitive (Print or TRUE will cause errors).

14. Artificial Intelligence & Robotics

• Artificial Intelligence (AI):

  • Definition: Systems capable of performing tasks requiring human-like intelligence.
  • Machine Learning (ML): A subset of AI where systems learn patterns and improve performance directly from data.
  • Deep Learning: Specialized branch of ML using multi-layered artificial neural networks.
  • NLP (Natural Language Processing): AI field enabling computers to understand and process human language text and speech.
  • Computer Vision: AI field focused on enabling computers to extract meaningful information from digital images and videos.

• Robotics Components:

  • Sensor: Detects and collects physical environmental information (e.g., light, temperature, distance).
  • Actuator: Component responsible for moving and controlling physical mechanisms/actions (e.g., motors).
  • Controller: Processing unit that processes input data from sensors and controls actuator actions.
  • Power Supply: Provides required electrical energy to operate robotic systems.

• Quantum Computing:

  • Classical computing uses bits ($0$ or $1$); quantum computing uses qubits.
  • Qubit: Basic unit of quantum information.
  • Superposition: Quantum principle allowing a qubit to exist in a combination of multiple states simultaneously before measurement.
  • Entanglement: Quantum phenomenon where states of distinct qubits become inextricably linked regardless of spatial separation.

15. Latest Developments in the Field of IT

• Key IT Terms:

  • Cloud Computing: On-demand delivery of network/internet-based computing services and storage resources.
  • IoT (Internet of Things): Interconnected physical objects equipped with sensors and software that collect and exchange data over networks.
  • Big Data: Extremely large, varied, and complex datasets requiring specialized tools for analysis.
  • Blockchain: Decentralized, distributed digital ledger recording transactions across blocks linked securely with cryptography.
  • AR (Augmented Reality): Overlays computer-generated digital elements onto a real-world view.
  • VR (Virtual Reality): Creates a fully immersive computer-generated artificial environment.
  • 3D Printing: Process of fabricating physical 3D objects layer-by-layer from a digital model file.
  • 5G: 5th generation mobile network technology providing higher data capacity, faster transfer speeds, and lower latency.

• IT Gadgets / Apps:

  • Understanding functions and core application scenarios for smart wearables, mobile applications, and computerized automated systems.

Logical Reasoning

• Patterns & Series:

  • Number Series: Evaluate patterns using arithmetic operations ($+,-,\times,\div$), common differences, square/cube numbers, or alternating sequences.
  • Analogy: Identify established relationship logic between the first pair and apply it identically to the second pair.
  • Classification (Odd One Out): Identify the element that lacks the common shared property of the remaining group.

• Common Reasoning Types:

  • Coding-Decoding: Analyze consistent character or numerical transformation rules.
  • Direction Sense Test: Map out orientations on a diagram ($\text{North} \uparrow, \text{South} \downarrow, \text{East} \rightarrow, \text{West} \leftarrow$).
  • Blood Relations: Trace family hierarchy and generational trees step-by-step.
  • Logic Gate Rules:
  • AND: Evaluation is true if and only if all inputs are true.
  • OR: Evaluation is true if at least one input is true.
  • NOT: Inverts / reverses the input truth value.

Must-Memorise Keyboard Shortcuts

Final 30-Second Quick Check & MCQ Trap Check

• Core Data & Units:
  • $1\,\text{byte} = 8\,\text{bits}$.
  • RAM is volatile; ROM is non-volatile.
  • CPU: ALU handles arithmetic/logic; CU handles control.
• Flowchart Shapes:
  • Oval: Start / End.
  • Rectangle: Process.
  • Parallelogram: Input / Output.
  • Diamond: Decision.
• Database Terminology:
  • Field = Column.
  • Record = Row.
  • Primary Key = Unique and non-null identifier.
• Web Technologies:
  • HTML = Page Structure (<a> link, <img> image, tr row, th header, td data).
  • CSS = Page Styling.
• MS Excel Essentials:
  • Rows are numbered; columns are lettered.
  • Formulas start with =.
  • $A$1 is an absolute reference.
• MS PowerPoint Essentials:
  • Transition = movement between slides.
  • Animation = movement applied to an object on a slide.
• Networking Scale & Terms:
  • Scale: $\text{PAN} < \text{LAN} < \text{MAN} < \text{WAN}$.
  • Router directs traffic between networks; Switch connects devices within a network.
  • DNS converts domain names to IP addresses.
• Cyber Threats:
  • Phishing = deceptive identity theft for credentials.
  • Ransomware = encrypts files for extortion payment.
• Scratch Elements:
  • Sprite = active character; Stage = background performance area.
  • Control blocks: repeat, forever, if then else.
• Python Key Rules:
  • = is assignment; == is equality comparison.
  • % calculates remainder ($10 \pmod 3 = 1$); // calculates floor division ($10 \mathbin{/\!/} 3 = 3$); ** calculates exponent.
  • Indentation defines blocks.
  • Python is strictly case-sensitive.
• AI & Robotics:
  • Machine Learning is a subset of AI ($\text{AI} \supset \text{ML}$).
  • Sensors detect physical inputs; Actuators produce physical motion outputs.
• Quantum Computing:
  • Bit ($0$ or $1$) vs Qubit.
  • Key principles: Superposition and Entanglement.
• ★ MCQ TRAP CHECK LIST:
  • Bit $\neq$ Byte ($1\,\text{byte} = 8\,\text{bits}$).
  • Qubit $\neq$ Byte.
  • Primary key is strictly unique and non-null.
  • HTTPS is encrypted and secure (HTTP is unencrypted).
  • LAN is smaller than WAN ($\text{LAN} < \text{WAN}$).
  • Python is case-sensitive (print vs Print).

Verification & Syllabus Alignment Note

• Source Check: Syllabus additions checked against the official SOF Class 9 ICSO syllabus and MTG 2026–27 Class 9 Workbook.
• Coverage:
  • 15 core chapters + Logical Reasoning + Keyboard Shortcuts + Final Rapid Check.
  • Software baseline: Windows 11 & MS-Office 2016.
  • Exam format: 50 questions in 1 hour; Level 1 syllabus split $60\%$ (Class 9) + $40\%$ (Class 8). Achievers Section is $100\%$ Class 9 syllabus.