CBSE Class 12 Information Technology (802)

Chapters: 5

1. Part A: Employability Skills

Communication skills · Self-management skills · ICT skills · Entrepreneurial skills · Green skills

Communication Skills: How to Share Meaning Clearly and Kindly – Communication is sharing meaning between people. A sender encodes an idea into a message, sends it through a channel, and a receiver decodes it and gives feedback. Barriers such as noise, hard words, strong emotions and cultural differences can block or bend the message. We send meaning with words (verbal), with face, eyes, gestures, posture and tone (non-verbal), and with pictures (visual). Active listening — attention, patience, questions and paraphrasing — proves the message arrived. Good communicators adapt to context: formal or informal, spoken or written, and use polite requests, kind refusals, sincere apologies and assertive (not aggressive or passive) language.
Self-Management: Taking Charge of Your Feelings, Goals and Time – Self-management is the skill of guiding your own feelings, thoughts and actions so you can reach your goals. It starts with self-awareness: noticing what you feel and how strong it is. Then you pause before reacting (Stop, Think, Act) and use calming tools such as slow breathing. Your beliefs and thoughts shape your feelings and actions, so changing an unhelpful thought ('I'm useless') into a helpful one ('I can't do it yet') changes what you do. Good self-managers set SMART goals, plan their time by importance, build healthy habits and bounce back from setbacks (resilience). These skills help in school, friendships and future careers.
ICT Skills: Office Tools, Internet, E-mail and Staying Safe – ICT means Information and Communication Technology. It is the set of tools we use to make, store and share information: computers, phones, software and the internet. The core ICT skills are: using a word processor to write, a spreadsheet to calculate, a presentation tool to show ideas, the internet to search, e-mail to communicate, and good habits to stay safe online.
Green Skills: Sustainable Development, Green Economy and Green Jobs – Green skills are the knowledge, habits and job skills that help us live and work without harming the planet. They rest on sustainable development (meeting today's needs while leaving enough for the future). A green economy grows while cutting pollution and waste, often by going circular: make, use, repair, recycle. It creates green jobs such as solar technician or recycling worker. Everyone can use green skills through the 5 Rs: Refuse, Reduce, Reuse, Repair, Recycle.

2. Database Concepts: RDBMS Tool

RDBMS

SQL for Class 12: Build Tables, Ask Questions, Join Tables – SQL is the language used to create and query relational databases. DDL commands (CREATE, ALTER, DROP) build structure; DML commands (INSERT, UPDATE, DELETE) change rows; SELECT reads data. Columns get data types (CHAR, VARCHAR, INT, FLOAT, DATE) and constraints (NOT NULL, UNIQUE, PRIMARY KEY, DEFAULT, FOREIGN KEY). SELECT can use aliases, DISTINCT, WHERE with relational and logical operators, IN, BETWEEN, LIKE and IS NULL, and ORDER BY. Aggregate functions (MAX, MIN, AVG, SUM, COUNT) summarise many rows; GROUP BY makes groups and HAVING filters groups. A Cartesian product pairs every row of one table with every row of another; an equi-join keeps only pairs whose common column matches; a natural join does the same and shows the common column once.

3. Operating Web-based Applications

Web applications

Web Applications: Online Reservation, E-governance, E-learning and E-commerce – A web application is a program you use through a web browser. It runs mostly on a web server; your phone or computer (the client) sends a request over the internet, the server reads or changes data in a database, and sends back a response page. Because the data is shared, everyone sees the same up-to-date information. Common uses: online reservation (train, bus, flight, hotel, cinema tickets), e-governance (government services online such as certificates, tax filing, passports, land records), e-learning (online courses, video lessons, quizzes, virtual classes) and e-commerce (buying and selling online with cart, payment and delivery tracking). Benefits: available anytime, anywhere, saves time and paper, transparent. Risks: needs internet, privacy, fraud and phishing; use HTTPS, strong passwords, OTP and official sites only.

4. Fundamentals of Java Programming

Java programming

Java Programming Basics – Java is a strongly typed, object-oriented language. Code is compiled to bytecode that runs on the Java Virtual Machine (JVM), so the same program runs on any computer. Every value has a type (int, double, char, boolean, String). Operators compute, if/switch choose, and for/while loops repeat. Arrays hold many values of one type, counted from 0. A class is a blueprint and new makes objects. Exceptions handle errors, wrapper classes turn primitives into objects, and threads let a program do several jobs at once.

5. Work Integrated Learning: IT-DMA

Work integrated learning

Work Integrated Learning: Workplace Practice as a Data Entry Operator – Work integrated learning (WIL) joins classroom study with real work: internships, apprenticeships, on-the-job training, field visits and projects for real clients. Students practise skills, learn workplace habits and record what they did in a logbook and report. In IT, a common placement is as a domestic data entry operator: someone who types data from paper or digital sources into computer systems (spreadsheets, databases, forms) quickly and correctly, checks it, keeps it safe and private, and creates simple reports. Key ideas: speed in words per minute (WPM) and keystrokes per hour, accuracy, verification (re-checking against the source, double entry), ergonomics (screen at eye level, elbows about 90°, breaks), data security and confidentiality, and workplace etiquette (punctuality, dress, communication, following instructions).