CHSE Odisha Elective Information Technology study plan

Label the internal components of a desktop PC (CPU, RAM, ROM, motherboard, storage, SMPS, ports) on a hand-drawn block diagram and state each part's function in one line

Convert between binary, decimal, octal and hexadecimal by hand for 15 numbers and verify each answer with a second method

Classify 20 input and output devices by type and give one real use case for each

Perform file and folder operations in a file manager: create, rename, move, copy, delete, restore from Recycle Bin, and change file extensions

Explain the difference between primary and secondary memory, and between RAM and ROM, in writing with two examples each

Compare the features of at least three operating systems (Windows, Linux, Android) in a written table covering user interface, file system and typical use

Demonstrate and document the steps for creating a folder structure, compressing a folder, and searching by wildcard pattern

List five common hardware troubleshooting symptoms and the first diagnostic step for each

Describe the boot process from power-on to desktop in ordered steps

Explain the difference between a file, a folder, a path and an extension, giving one example of each

Enter a 30-row dataset into a spreadsheet and format it with headers, borders, number formats and column widths

Write formulas using SUM, AVERAGE, MIN, MAX, COUNT and COUNTA on the same dataset and verify results manually

Build IF, nested IF and COUNTIF formulas to classify rows into at least three categories

Create a sorted and filtered view, then produce a chart of the correct type for the data

Draft a 300-word formatted document with headings, a bulleted list, a table and page numbers, then apply spell check and print preview

Use VLOOKUP or INDEX-MATCH to pull values from a second sheet and explain in writing why absolute references are needed

Create a pivot-style summary using SUMIF and AVERAGEIF and cross-check the totals against raw data

Define the terms table, record, field, primary key, foreign key and candidate key with one example each from a school or shop scenario

Draw an entity-relationship sketch for a two-table database and identify the relationship type

Write and run SELECT queries with WHERE, ORDER BY, GROUP BY and HAVING on a small sample table

Create two related tables in a database tool, set a primary key and a foreign key, and enter 10 records in each

Write INSERT, UPDATE and DELETE statements and show before-and-after table states

Explain the difference between DBMS and RDBMS, and between DDL and DML, in writing with commands as examples

Distinguish LAN, MAN and WAN, and client-server versus peer-to-peer, using a labelled network diagram

Identify the function of hub, switch, router, modem and NIC, and map each to a layer of the TCP/IP model

Explain IP addressing basics: IPv4 structure, private versus public addresses, and the role of DNS and DHCP

Trace and describe what happens when a URL is typed into a browser, from DNS lookup to page render, in ordered steps

Write valid HTML using the document structure, headings, paragraphs, lists, links, images and a table

Build a two-page website linked by a navigation bar and validate that every tag is properly nested and closed

Differentiate the roles of HTTP, FTP, SMTP and POP3/IMAP with one use case each

Apply inline CSS and an internal stylesheet to control colour, font, spacing and borders on the existing site

Create a form with text fields, radio buttons, checkboxes and a submit button, and explain what each input type collects

Build a 6-slide presentation with a consistent theme, title slide, bullet slides, one chart slide and one closing slide

Apply slide transitions and one animation, then rehearse and time the presentation to fit 5 minutes

Compare raster and vector images, and list three common multimedia file formats with a suitable use for each

Write algorithms and draw flowcharts for five problems (sum of series, largest of three numbers, factorial, prime check, reverse a number) using correct symbols

Trace a short program line by line and state the output for three different inputs, including one with a loop

Explain the difference between a compiler and an interpreter, and between syntax and logical errors

List five cyber-safety practices for passwords, phishing recognition and safe browsing, and explain each in one sentence

Describe three emerging technologies (for example AI, cloud computing, IoT) with one benefit and one risk each