Kerala Plus Two Computer Applications (DHSE) study plan

Convert between binary, octal, decimal and hexadecimal by hand for 20 mixed numbers without a calculator

Compute 2's complement and perform signed binary addition/subtraction for 10 pairs, then verify each result in decimal

Draw an ER diagram for a small library case and label entities, attributes, primary keys and relationship cardinalities

Write DDL statements to create 5 tables with primary key, foreign key, NOT NULL and CHECK constraints

Explain the difference between DBMS, RDBMS and file-based storage in your own words

Write 25 SELECT queries covering WHERE, ORDER BY, DISTINCT, BETWEEN, IN, LIKE and NULL handling against your own tables

Use aggregate functions with GROUP BY and HAVING to answer 8 reporting questions, and explain why HAVING differs from WHERE

Demonstrate INNER JOIN and LEFT JOIN on two tables and describe in writing what rows each returns

Classify 15 given devices/software items as hardware, system software or application software, and justify each

Describe the boot process and the roles of OS functions: process management, memory management, file system and device drivers

Normalize one unnormalized table up to 3NF, showing the intermediate 1NF and 2NF tables and stating the anomaly each step removes

Write INSERT, UPDATE, DELETE statements and explain COMMIT, ROLLBACK and SAVEPOINT with a worked example

Explain primary key, candidate key, foreign key, alternate key and composite key using your own tables as examples

Define algorithm, and write pseudocode plus a flowchart for finding the largest of three numbers and for checking a prime

Compare a linear search and a binary search on a sorted 10-element list, counting comparisons for each

Write, compile and run 10 C programs covering input/output, arithmetic operators, and if-else/switch selection

Write 5 C programs using for, while and do-while loops, including sum of digits and reversing a number

Declare and use one-dimensional and two-dimensional arrays in 4 programs, including matrix addition

Use user-defined functions with parameters and return values, and explain call by value with a trace

Trace 8 short code snippets by hand and predict the exact output before running them

Manipulate strings in C using arrays of characters and standard library functions such as strlen, strcpy, strcmp and strcat

Explain and demonstrate pointers: declare a pointer, pass it to a function, and show how it enables call by reference

Define a structure, create an array of structures, and write a program that stores and prints 5 student records

Write recursive functions for factorial and Fibonacci and trace the recursion depth for a small input

State the properties of a good algorithm (finiteness, definiteness, effectiveness, input, output) and apply them to critique two given algorithms

Classify 10 network scenarios by topology (star, bus, ring, mesh) and by scale (LAN, MAN, WAN), justifying each choice

Explain the functions of the OSI layers and map TCP/IP layers to them, then place hubs, switches, routers and gateways at their correct layers

Compute the number of hosts in given subnets and distinguish IPv4 address classes by first octet range

Write a complete HTML page using headings, paragraphs, lists, tables, images, hyperlinks and a form with 6 input types

Build a 3-page linked website and style it with an external CSS file using selectors, the box model and at least 4 properties

Create a spreadsheet with 30 rows of data and use SUM, AVERAGE, COUNT, MAX, MIN, IF and VLOOKUP in at least 8 formulas

Build a chart from spreadsheet data and sort/filter the data set by two criteria

Produce a 6-slide presentation with a consistent theme, transitions, speaker notes and one inserted chart

Apply word-processing skills: styles, headers/footers, table of contents, mail merge fields and page setup

Explain how HTTP request/response works, and distinguish static from dynamic pages and a URL's protocol, domain and path parts

Identify 10 cyber threats (phishing, malware, ransomware, keylogging, spam, cyberbullying and similar) and state one concrete prevention for each

Explain the legal and ethical duties covered by the IT Act provisions on unauthorized access and data misuse, in your own words

Describe safe practices for passwords, backups, firewalls and digital signatures, and evaluate two case scenarios for risk

Revise number-system conversions and hardware/software classification with 30 rapid-fire self-test items

Take two full-length timed mock tests and log every wrong answer with its domain and the reason for the error