Computer Science

Class XII · CBSE 083 · Python
Ten chapters, three units. Every concept taught through a program that runs, a diagram that is drawn, or a query with its result set.

Unit 1 — Computational Thinking and Programming

Chapter 1
Python, Revised

Names and objects, mutability, operators, control flow, strings, lists, tuples, dictionaries — the Class XI ground that everything else stands on.

65 slides · 7 sections · 58 verified outputs
Chapter 2
Functions

Definition and call, flow of control, positional / default / keyword arguments, return values, local and global scope, and mutable arguments.

43 slides · 6 sections · 39 verified outputs
Chapter 3
Exception Handling

Syntax errors vs exceptions vs logic errors, the built-in exceptions seen live, try / except / else / finally, and raise and assert.

43 slides · 6 sections · 32 verified outputs
Chapter 4
File Handling

Text files, binary files with pickle, and CSV — the same five students stored three ways, with read, write, search, append and update on each.

37 slides · 5 sections · 32 verified outputs
Chapter 5
Stacks

LIFO, push / pop / peek / isEmpty on a Python list, underflow, and six worked applications — reversal, brackets, binary, undo, the call stack, files.

23 slides · 2 sections · 16 verified outputs

Unit 2 — Computer Networks

Chapter 6
Networks, Devices and Topologies

Evolution of networking, PAN / LAN / MAN / WAN, seven network devices, four drawn topologies, transmission media, and a worked campus case study.

25 slides · 5 sections · 13 drawn diagrams
Chapter 7
Applications and Protocols

Client–server, IP addresses, domain names, DNS and URL, HTTP/HTTPS, FTP, SMTP and POP3, TCP/IP, PPP and VoIP.

20 slides · 5 sections · drawn request sequences

Unit 3 — Database Management

Chapter 8
Relational Database Concepts

Relation, tuple, attribute, domain, degree and cardinality, the properties of a relation, and candidate / primary / alternate / foreign keys.

17 slides · 2 sections · introduces the sample database
Chapter 9
SQL

DDL and DML, WHERE, BETWEEN, IN, LIKE, IS NULL, ORDER BY, aggregate functions, GROUP BY / HAVING, and the three kinds of join.

29 slides · 6 sections · every result set actually run
Chapter 10
Python with MySQL

connect, cursor, execute, fetchone / fetchmany / fetchall, rowcount, commit, parameterised queries and SQL injection.

21 slides · 4 sections · the chapter that joins all the others

In class: next · back · m menu · f full screen