Information Technology (Code 402) — CBSE India

Chapter 1

Course Orientation (Syllabus, Tools, Setup)

1

Understand the course structure (units) and assessment pattern

2

Set up your practice environment (LibreOffice, browser, folders, backups)

3

File management essentials (naming, folders, extensions, zip, PDF)

Chapter 2

Employability Skills (Unit 1)

4

Communication skills for school/workplace (listening, speaking, writing)

5

Self-management (goals, time management, stress management)

6

ICT skills (digital literacy for everyday tasks)

3 subtopics

7

Email basics and etiquette (subject lines, attachments, CC/BCC)

8

Cyber safety & netiquette (privacy, phishing, scams, reporting)

9

Productivity & collaboration tools (cloud docs basics, sharing permissions)

10

Entrepreneurial skills (basic business thinking)

11

Green skills (sustainability, energy saving, e-waste awareness)

Chapter 3

Digital Documentation (Advanced)

12

Writer fundamentals refresh (formatting, page setup, headers/footers)

13

Styles & templates for consistent documents

2 subtopics

14

Create and apply paragraph/character styles (headings, body, lists)

15

Build and reuse templates (standard formats, updating templates)

16

Tables, images, and objects (captions, wrapping, positioning)

17

Mail merge (data source, letters/labels)

18

Export/print workflow (PDF export, print settings, proofreading checklist)

Chapter 4

Electronic Spreadsheet (Advanced)

19

Formulas & functions

2 subtopics

20

Cell referencing (relative, absolute, mixed) and copying formulas correctly

21

Common functions practice (IF, COUNTIF/SUMIF, basic LOOKUP)

22

Data analysis (sort/filter/pivot, validation, conditional formatting)

2 subtopics

23

Create pivot tables (DataPilot) and summarize data

24

Conditional formatting and data validation (clean, correct spreadsheets)

25

Charts and basic reporting (choose the right chart, titles/labels)

26

What-if analysis (Goal Seek, scenarios basics)

27

Import/export & sharing (CSV, PDF, printing, page setup)

Chapter 5

Database Management System (DBMS)

28

Database concepts (data vs information, tables, records, fields)

29

Table design (primary key, foreign key, relationships, redundancy basics)

30

SQL basics (SELECT and filtering)

2 subtopics

31

Write basic SELECT queries (columns, DISTINCT, aliases, ORDER BY)

32

Use WHERE effectively (AND/OR/NOT, LIKE, BETWEEN, IN)

33

SQL aggregation & joins

2 subtopics

34

GROUP BY with aggregates (COUNT, SUM, AVG, MIN, MAX)

35

INNER JOIN two tables (match rows using keys)

36

Data modification queries (INSERT, UPDATE, DELETE) with caution

37

Forms and reports basics (DB front-end concept, simple outputs)

Chapter 6

Web Applications & Security

38

Internet and web basics (URL, domain, browser, HTTP/HTTPS)

39

HTML structure and semantics

2 subtopics

40

Build a basic HTML page (headings, paragraphs, lists, links)

41

Add images/media and tables with accessibility basics (alt text)

42

CSS basics (selectors and the box model)

2 subtopics

43

Style text, colors, and typography (readable UI basics)

44

Layout basics (display, spacing, simple responsive approach)

45

Web forms and user input (concept of forms, fields, validation)

↗ Cyber safety & netiquette (privacy, phishing, scams, reporting) (see Chapter 2)

46

Responsible web use (digital footprint, copyright, plagiarism awareness)

Chapter 7

Practical Work, Projects & Exam Preparation

47

Practical file readiness (proper naming, screenshots if needed, viva answers)

48

Mini-project workflow (problem statement → design → build → test → document)

49

Sample papers strategy (speed + accuracy + step marking)

2 subtopics

50

Timed practice: complete one practical set within the time limit

51

Maintain an error-log and convert it into revision notes

52

Troubleshooting checklist (common errors in Writer/Calc/DB/HTML)