Karnataka KSEAB II PUC Information Technology (Vocational) study plan

Map the DBMS domain syllabus into a one-page concept sheet covering data, DBMS advantages, data models, and schema versus instance

Define and distinguish primary key, candidate key, alternate key, foreign key, and composite key using your own worked example tables

Draw and label an ER diagram for a small library or shop scenario, marking entities, attributes, relationships, and cardinality

Write and trace at least six SQL statements using CREATE TABLE, INSERT, SELECT with WHERE, and simple ORDER BY

Explain to yourself in writing why normalization removes redundancy, using one unnormalized table split into 1NF and 2NF

Build a flowchart for three problems: largest of three numbers, sum of first N integers, and checking a prime number

Convert each flowchart into pseudocode and then into a program in a language you can run locally

Classify and give one example each of sequence, selection, and iteration constructs

Write SQL queries using aggregate functions, GROUP BY, and HAVING on a sample table you create

Debug five deliberately broken short programs by identifying the error type (syntax, logical, runtime)

Label the internal and external parts of a computer system on a blank diagram you draw yourself

Compare primary and secondary memory, and RAM versus ROM, in a table with at least four comparison rows

List input and output devices and state one practical use for each

Describe the boot process from power-on to loading the operating system in ordered steps

Perform file operations on your own machine: create, rename, move, copy, delete, and restore from recycle bin, and record each step

Explain the functions of an operating system and distinguish single-user, multi-user, and real-time systems

Practise keyboard shortcuts for cut, copy, paste, undo, redo, save, and find-and-replace until you can do them without looking

Produce a formatted document using headings, bulleted lists, tables, page numbers, and a header or footer

Apply paragraph and character formatting consistently and use styles rather than manual formatting

Insert a table of contents and a footnote, then export the document to PDF

Enter a dataset of at least twenty rows and apply cell formatting, number formats, and borders

Write formulas using SUM, AVERAGE, COUNT, MAX, MIN, IF, and one lookup function

Create a chart from your data and label axes, title, and legend clearly

Sort and filter the dataset and build a simple pivot-style summary

Build a five-slide presentation with a consistent theme, one chart, and speaker notes

Write valid HTML for a page containing headings, paragraphs, lists, a table, an image tag, and a hyperlink

Apply CSS for colour, font, margin, padding, and border to style that page

Distinguish internet, intranet, and extranet, and explain the roles of URL, HTTP, and a browser

Describe the functions of hub, switch, router, modem, and the difference between LAN, MAN, and WAN

Sketch a small star-topology network with labelled devices and state one advantage and one limitation of that topology

List and explain at least six cyber-safety practices including strong passwords, two-factor authentication, and safe browsing

Identify common threats such as phishing, malware, ransomware, and social engineering, with one prevention step each

Explain the purpose of the IT Act and the meaning of intellectual property and software piracy in your own words

Describe three emerging technologies such as cloud computing, artificial intelligence, and IoT with one real-world application each

Review your own online accounts and record which ones lack two-factor authentication

Revisit every domain using your own notes and list the five weakest topics

Solve one practice question from each domain under timed conditions

Re-run your SQL script and your program to confirm they still work

Recite key definitions for hardware, OS, networking, and safety terms without referring to notes

Assemble a single revision sheet of formulas, shortcuts, and definitions