DAV PUBLIC SCHOOLS, JHARKHAND ZONE-F
Computer Science
(083) CLASS-XII
Session: 2025-26
Month Chapter/Topic ACTIVITY LEARNING OUTCOMES
April Revision of Python topics Program to find the largest Able to understand
covered in Class XI number. Program on list the concept of
implementation. looping and
selection
Find error(s) in the python statements.
program. Find Output from Learn to decide when to
use a dictionary, tuple or a
different program. list
Program to create different types Understand how a
of pattern. dictionary allows us to
represent attributes
Program to print triangle with keys and values
pattern. Program to use
different types of library Understand how to read a
function. value from a dictionary
Understand how to
assign a key-value pair to
a dictionary
May Functions: types of Able to understand about
function (built-in Find the simple interest passing the concept of modularity.
functions, functions arguments, no arguments,
defined in module, user keyword argument and positional Understand how to pass
defined functions), argument. arguments in a function.
creating user defined
function, arguments and Understand difference
parameters, default between Global and Local
parameters, positional variable.
parameters, function
returning value(s), flow of Able to understand
execution, scope of a different between Text,
variable (global scope, Binary and CSV files.
local scope)
Introduction to files, types
of files (Text file, Binary
file, CSV file), relative and
absolute paths
June Text file: opening a text Read a text file line by line and Able to read data from text
file, text file open modes display each word separated by a file.
(r, r+, w, w+, a, a+), #. Read a text file and display the
closing a text file, opening number of
a file using with clause, vowels/consonants/uppercase/low Able to use read and write
writing/appending data to e rcase characters in the file. functions in any file.
a text file using Remove all the lines that contain
write() and writelines(),
reading from a text file the character 'a' in a file and write
using read(), readline() and it to another file.
readlines(), seek and tell
methods, manipulation of
data in a text file
July Create a binary file with name Understand how a binary
Binary file: basic and roll number. Search for a and csv file is opened.
operations on a binary given roll number and display the
file: open using file open name, if not found display
modes (rb, rb+, wb, wb+, appropriate message. Create a
ab, ab+), close a binary binary file with roll number, name Able to know about text,
file, import pickle module, and marks. Input a roll number binary and csv file.
dump() and load() and update the marks. Write a
method, read, random number generator that
write/create, search, generates random numbers
append and update between 1 and 6 (simulates
operations in a binary file a dice).
CSV file: import csv Create a CSV file by entering user-
module, open / close csv id and password, read and search
file, write into a csv file the password for given userid.
using [Link]() and
read from a csv file using
[Link]( )
August Computational Thinking Write a Python program to Able to know about LIFO
and Programming – 2 implement a stack using list. and FIFO concept in
● Data Structure: Stack, stack.
operations on stack (push Write a python program
& pop), implementation using dictionary to
of stack using list. implement stack.
Synopsis of the project.
Septembe First Term Examination
r
October Unit II: Computer Networks Able to identify different
● Evolution of networks.
networking: Define different Network devices
introduction to Understand
computer networks, about networking
evolution of networking devices.
(ARPANET, NSFNET,
INTERNET) Able to know different
● Data communication topologies and their
terminologies: concept working
of communication, Able to distinguish
components of data Define different type protocols static and dynamic
communication (sender, with their use. web page Able to
receiver, message, know about switching
communication media, techniques.
protocols), measuring
capacity of Able to understand about
communication media LAN, MAN and WAN
(bandwidth, data
transfer rate), IP address, Able to identify different
switching techniques networking devices.
(Circuit switching, Packet
switching)
● Transmission media:
Wired communication
media
, Wireless media Able to use different
● Network devices Protocols and network
(Modem, Ethernet card, devices in Networking.
RJ45, Repeater, Hub,
Switch, Router, Gateway,
WIFI card)
● Network Topology
● Network protocol
● Introduction to
web services:
● Project discussion
Unit III: Database
Management
● Database concepts: Able to know
introduction to Database concepts
database concepts and use in different
and its need application.
● Relational data model:
relation, attribute, tuple,
domain, degree,
cardinality, keys
(candidate key, primary
key, alternate key,
foreign key)
Novembe Structured Query Create a student table and insert Understand basic
r Language: introduction, data. Implement the following SQL concepts of how a
Data Definition Language commands on the student table: database stores
and Data Manipulation o ALTER table to add new information via tables.
Language, data type attributes / modify data type /
(char(n), varchar(n), int, drop attribute Understand SQL syntax
float, date), constraints o UPDATE table to modify data used with MySQL.
(not null, unique, primary o ORDER By to display data
key), create database, use in ascending / descending Learn how to retrieve
database, show databases, order and manipulate data
drop database, show from one or more
tables, create table, tables.
describe table, alter table o DELETE to remove tuple(s)
(add and remove an o GROUP BY and find the min,
attribute, add and remove max, sum, count and average. Learn how to filter data
primary key), drop table, ● Similar exercise may be based upon multiple
insert, delete, select, framed for other cases. conditions.
operators (mathematical, ● Integrate SQL with Python
relational and logical), by importing suitable Understood to design SQL
aliasing, distinct clause, module. queries using aggregate
where clause, in, between, functions.
order by, meaning of null,
is null, is not null, like,
update command, delete Able to update and insert
command Aggregate data into the existing
functions (max, tables.
min, avg, sum, count),
group
by, having clause, joins :
Cartesian product on two
tables, equi-join and
natural join
Interface of python with
an SQL database: Create a program to connect Able to design a project
connecting SQL with python to MySQL using Mysql using. python and mysql.
Python, performing insert, connector.
update, delete queries
using cursor, display data
by using fetchone(), Create a Program using fetchall( ),
fetchall(), rowcount, fetchone( ), fetchall( ) and Program using Database
creating database rowcount Connectivity through
connectivity applications. Python using
[Link] as well
Project using Database activating
Connectivity cursor….Project based on
A stub program with Database Connectivity
Python SQL connectivity wih SQL
December Revision of Long Practice on CBSE sample paper.
Questions and Case Study Practice on output based
Based Questions Practice questions.
First Pre Board(Whole
Syllabus)
January Revision of Short type Practice on programming based
Questions and MCQ questions.
Second Pre Board Practice on Value based questions.
( Whole Practice on CBSE sample paper.
Syllabus)
February Revision and Practice of Practice on programming based
CBSE sample papers questions.
Practice on CBSE sample paper.
C
o
m
p
1. Prerequisites ut
er
S
ci
e
n
c
e
C
L
A
S
S
-
XI
I
Code No.
083
2025-26
Computer Science- Class XI
2. Learning Outcomes
Student should be able to
a. Apply the concept of function.
b. Explain and use the concept of file handling.
c. Use basic data structure: Stacks
d. Explain basics of computer networks.
e. Use Database concepts, SQL along with connectivity between Python
and SQL.
3. Distribution of Marks:
Unit Unit Name Mark Periods
No. s Theor Practica
y l
I Computational Thinking and Programming – 40 70 50
2
II Computer Networks 10 15 …
III Database Management 20 25 20
Total 70 110 70
