Odisha CHSE +2 Vocational Computer Technique study plan

Convert numbers among binary, octal, decimal and hexadecimal, and solve 20 mixed conversion problems.

Draw and label the block diagram of a computer (input, CPU, memory, output, control unit), and explain each unit's function in 2-3 lines.

Classify 15 given devices as input, output or storage, and write three differences between RAM and ROM.

Perform 1's and 2's complement subtraction on five pairs of 8-bit binary numbers, and verify each answer in decimal.

List the four generations of computers with one defining hardware feature each, and state five characteristics of computers.

Write, compile and run 10 short C programs: sum of two numbers, largest of three, factorial, prime check, Fibonacci series, reverse of a number, multiplication table, palindrome check, sum of an array, and string length without a library function.

Draw flowcharts for three of the programs (factorial, prime check, largest of three) using standard symbols.

Write one program each using while, do-while and for, and state in two lines when each loop is preferred.

Trace two programs by hand with sample input, then match the trace output with the actual run output.

State the rules for declaring variables, choosing data types and using operators in C, and rewrite the sum-and-average program in BASIC syntax.

Type a two-page document containing at least three heading levels, one bulleted list, one numbered list and a 4x4 table.

Apply and demonstrate page setup, margins, line spacing, page numbers, header/footer, spell check and find-and-replace on that document.

Insert an image with wrapped text and add a footer showing page numbers in 'Page X of Y' format.

Match 15 word-processor toolbar icons with their functions, and list the shortcut keys for save, print, undo, redo, copy, paste, bold, italic and select-all.

Describe the step-by-step procedure to create a mail merge for five recipients using a name and address list.

Enter a 10-student marks sheet with five subject columns and compute total, percentage, average, highest and lowest using formulas and the SUM, AVERAGE, MAX, MIN and COUNT functions.

Write an IF formula to assign PASS/FAIL, extend it to a nested IF grade (A/B/C), and fill it down the whole column.

Create a bar chart and a pie chart from the marks data with titles and axis labels, then set page layout so the sheet prints on one page.

Demonstrate the difference between relative and absolute references by copying a formula containing A1 and one containing $A$1, and explain the results in two lines.

Use sort and auto-filter to display only students scoring above 75%, and note the count shown.

Define table, record, field, primary key, foreign key and candidate key, and write five differences between a DBMS and a plain file system.

Design a three-table school database (Student, Class, Marks) on paper with field names, data types, primary keys and foreign keys.

Write and execute 12 SQL statements: CREATE TABLE, three INSERTs, SELECT with WHERE, ORDER BY, DISTINCT, COUNT, SUM, AVG, GROUP BY, UPDATE and DELETE.

Classify 10 given SQL commands as DDL or DML, and explain the difference between DELETE, TRUNCATE and DROP.

Normalize a given flat table into 1NF and 2NF, and explain insertion, deletion and update anomalies with one example each.

Explain HTTP, HTTPS, FTP, SMTP, POP3 and TCP/IP in one line each, and match each to the task it performs (web page, file transfer, sending mail, receiving mail).

Compose an e-mail with To, Cc, Bcc, subject, body, one attachment and a signature, and state in two lines the difference between Cc and Bcc.

Break a sample URL into protocol, domain, path and file name, and list five search techniques (quoted phrase, minus sign, site:, filetype:, OR).

List six main functions of an operating system, then demonstrate file operations create, rename, copy, move and delete, and write one full file path with its extension.

Compare GUI and CLI in a four-row table, and list five file extensions with the software that opens each.

Build a 6-slide presentation on a topic of your choice with a title slide, bullet slides, one inserted image, one chart, a slide transition and one custom animation.

Identify and label 12 hardware parts on a hand-drawn diagram: motherboard, CPU socket, RAM slot, HDD/SSD, SMPS, expansion slots, USB, VGA/HDMI and audio ports.

Explain LAN vs WAN, describe four network topologies with one advantage and one disadvantage each, and state the role of hub, switch, router, modem and NIC.

Differentiate JPEG, PNG, GIF, MP3, MP4, AVI and WAV by use and typical file size, and name two multimedia authoring tools.

List the first five troubleshooting checks for each case: PC does not power on, no display, keyboard not detected, printer offline, and very slow computer.

Write a 5-6 page project report (aim, requirements, procedure, output, conclusion) for one of: the marks-sheet spreadsheet, the student database, or a chosen C program.

Answer 15 likely viva questions aloud and write the answers, including 'difference between RAM and ROM', 'why a primary key is needed' and 'what a flowchart symbol means'.

Take two full-length mock tests - one on domains 1, 3, 4 and 5, one on domains 2, 6, 7, 8 and 9 - and score at least 60% in each.

Re-solve every question in the error log and confirm each weak topic by answering three fresh questions correctly in a row.