CUET Syllabus: Computer Science | CUET UG Mock Test Series 2025 PDF Download

 Page 1


Page | 1 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Computer Science/ 
Informatics Practices - 308 
Syllabus for Class 12 
Page 2


Page | 1 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Computer Science/ 
Informatics Practices - 308 
Syllabus for Class 12 
Page | 2 
 
 Computer Science/Informatics Practices 
- 308 
 
 
 
 
 
 
 
 
 
 
 
Section A 
 
i. Exception and File Handling in Python  
Exception Handling: syntax errors, exceptions, need of exception handling, user-defined 
exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - else clause, 
Try - finally clause, recovering and continuing with finally, built-in exception classes. 
File Handling: text file and binary file, file types, open and close files, reading and writing text files, 
reading and writing binary files using pickle module, file access modes. 
 
ii. Database Concepts 
Introduction to database concepts, difference between database and file system, relational data 
model: concept of domain, tuple, relation, keys - candidate key, primary key, alternate key, foreign 
key; 
Relational algebra: selection, projection, union, set difference and cartesian product; 
 
iii. Structured Query Language 
Advantages of using Structured Query Language, Data Definition Language, Data Query Language 
and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data 
Types 
Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, 
Data Query: SELECT, FROM, WHERE 
Data Manipulation: INSERT, UPDATE, DELETE 
Math functions: POWER (), ROUND (), MOD (). 
 
  
  
  
 
      
 
      
 
Page 3


Page | 1 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Computer Science/ 
Informatics Practices - 308 
Syllabus for Class 12 
Page | 2 
 
 Computer Science/Informatics Practices 
- 308 
 
 
 
 
 
 
 
 
 
 
 
Section A 
 
i. Exception and File Handling in Python  
Exception Handling: syntax errors, exceptions, need of exception handling, user-defined 
exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - else clause, 
Try - finally clause, recovering and continuing with finally, built-in exception classes. 
File Handling: text file and binary file, file types, open and close files, reading and writing text files, 
reading and writing binary files using pickle module, file access modes. 
 
ii. Database Concepts 
Introduction to database concepts, difference between database and file system, relational data 
model: concept of domain, tuple, relation, keys - candidate key, primary key, alternate key, foreign 
key; 
Relational algebra: selection, projection, union, set difference and cartesian product; 
 
iii. Structured Query Language 
Advantages of using Structured Query Language, Data Definition Language, Data Query Language 
and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data 
Types 
Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, 
Data Query: SELECT, FROM, WHERE 
Data Manipulation: INSERT, UPDATE, DELETE 
Math functions: POWER (), ROUND (), MOD (). 
 
  
  
  
 
      
 
      
 
Page | 3 
 
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), 
LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). 
Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), 
DAYNAME (). 
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT 
(*). Querying and manipulating data using Group by, Having, Order by. 
Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN 
 
iv. Computer Networks 
Introduction to computer networks, Evolution of networking, 
Network types: LAN, WAN, MAN 
Network devices: Modem, Ethernet Card, Repeater, Hub, Switch, Router, Gateway. 
Network Topologies: Mesh, Ring, Bus, Star, and Tree topologies 
Basic concept of MAC and IP Address Difference 
between Internet and web 
 
Section B1: Computer Science 
 
 
Exception Handling: syntax errors, exceptions, need of exception handling, user-defined 
exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - else clause, 
Try - finally clause, recovering and continuing with finally, built-in exception classes. 
File Handling: text file and binary file, file types, open and close files, reading and writing text 
files, reading and writing binary files using pickle module, file access modes. 
 
Stack (List Implementation): Introduction to stack (LIFO Operations), operations on stack (PUSH 
and POP) and its implementation in python. Expressions in Prefix, Infix and postfix notations, 
evaluating arithmetic expressions using stack, conversion of Infix expression to postfix 
expression 
Chapter 1: Exception and File Handling in Python  
Chapter 2: Stack  
Page 4


Page | 1 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Computer Science/ 
Informatics Practices - 308 
Syllabus for Class 12 
Page | 2 
 
 Computer Science/Informatics Practices 
- 308 
 
 
 
 
 
 
 
 
 
 
 
Section A 
 
i. Exception and File Handling in Python  
Exception Handling: syntax errors, exceptions, need of exception handling, user-defined 
exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - else clause, 
Try - finally clause, recovering and continuing with finally, built-in exception classes. 
File Handling: text file and binary file, file types, open and close files, reading and writing text files, 
reading and writing binary files using pickle module, file access modes. 
 
ii. Database Concepts 
Introduction to database concepts, difference between database and file system, relational data 
model: concept of domain, tuple, relation, keys - candidate key, primary key, alternate key, foreign 
key; 
Relational algebra: selection, projection, union, set difference and cartesian product; 
 
iii. Structured Query Language 
Advantages of using Structured Query Language, Data Definition Language, Data Query Language 
and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data 
Types 
Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, 
Data Query: SELECT, FROM, WHERE 
Data Manipulation: INSERT, UPDATE, DELETE 
Math functions: POWER (), ROUND (), MOD (). 
 
  
  
  
 
      
 
      
 
Page | 3 
 
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), 
LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). 
Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), 
DAYNAME (). 
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT 
(*). Querying and manipulating data using Group by, Having, Order by. 
Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN 
 
iv. Computer Networks 
Introduction to computer networks, Evolution of networking, 
Network types: LAN, WAN, MAN 
Network devices: Modem, Ethernet Card, Repeater, Hub, Switch, Router, Gateway. 
Network Topologies: Mesh, Ring, Bus, Star, and Tree topologies 
Basic concept of MAC and IP Address Difference 
between Internet and web 
 
Section B1: Computer Science 
 
 
Exception Handling: syntax errors, exceptions, need of exception handling, user-defined 
exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - else clause, 
Try - finally clause, recovering and continuing with finally, built-in exception classes. 
File Handling: text file and binary file, file types, open and close files, reading and writing text 
files, reading and writing binary files using pickle module, file access modes. 
 
Stack (List Implementation): Introduction to stack (LIFO Operations), operations on stack (PUSH 
and POP) and its implementation in python. Expressions in Prefix, Infix and postfix notations, 
evaluating arithmetic expressions using stack, conversion of Infix expression to postfix 
expression 
Chapter 1: Exception and File Handling in Python  
Chapter 2: Stack  
Page | 4 
 
 
Queue (List Implementation): Introduction to Queue (FIFO), Operations on Queue (INSERT and 
DELETE) and its implementation in Python. 
Introduction to DQueue and its implementation in Python. 
 
Searching: Sequential search, Binary search, Analysis of Sequential and Binary Search. Dry run to 
identify best, worst and average cases. Implementation of searching techniques in Python. 
 
Overview of sorting techniques, Bubble Sort, Selection Sort and Insertion Sort. Dry run to identify 
best, worst and average cases. Implementation of sorting techniques in Python. 
Hashing: Hash Functions, Collision Resolution, Implementing the Map Abstract Data Type. 
 
 
Data and its purpose, collection and organization; understanding data using statistical methods: 
mean, median, standard deviation, variance; data interpretation; visualization of data. 
 
 
 
Introduction to database concepts, difference between database and file system, relational data 
model: concept of domain, tuple, relation, keys - candidate key, primary key, alternate key, 
foreign key; 
Relational algebra: selection, projection, union, set difference and cartesian product; 
 
 
Advantages of using Structured Query Language, Data Definition Language, Data Query 
Language and Data Manipulation Language, Introduction to MySQL, Creating a database using 
MySQL, Data Types 
Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, 
Data Query: SELECT, FROM, WHERE 
Data Manipulation: INSERT, UPDATE, DELETE 
Math functions: POWER (), ROUND (), MOD (). 
Chapter 7: Database Concepts  
Chapter 3: Queue  
Chapter 4: Searching  
Chapter 5: Sorting  
Chapter 6: Understanding Data  
Chapter 8: Structured Query Language  
Page 5


Page | 1 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Computer Science/ 
Informatics Practices - 308 
Syllabus for Class 12 
Page | 2 
 
 Computer Science/Informatics Practices 
- 308 
 
 
 
 
 
 
 
 
 
 
 
Section A 
 
i. Exception and File Handling in Python  
Exception Handling: syntax errors, exceptions, need of exception handling, user-defined 
exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - else clause, 
Try - finally clause, recovering and continuing with finally, built-in exception classes. 
File Handling: text file and binary file, file types, open and close files, reading and writing text files, 
reading and writing binary files using pickle module, file access modes. 
 
ii. Database Concepts 
Introduction to database concepts, difference between database and file system, relational data 
model: concept of domain, tuple, relation, keys - candidate key, primary key, alternate key, foreign 
key; 
Relational algebra: selection, projection, union, set difference and cartesian product; 
 
iii. Structured Query Language 
Advantages of using Structured Query Language, Data Definition Language, Data Query Language 
and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data 
Types 
Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, 
Data Query: SELECT, FROM, WHERE 
Data Manipulation: INSERT, UPDATE, DELETE 
Math functions: POWER (), ROUND (), MOD (). 
 
  
  
  
 
      
 
      
 
Page | 3 
 
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), 
LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). 
Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), 
DAYNAME (). 
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT 
(*). Querying and manipulating data using Group by, Having, Order by. 
Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN 
 
iv. Computer Networks 
Introduction to computer networks, Evolution of networking, 
Network types: LAN, WAN, MAN 
Network devices: Modem, Ethernet Card, Repeater, Hub, Switch, Router, Gateway. 
Network Topologies: Mesh, Ring, Bus, Star, and Tree topologies 
Basic concept of MAC and IP Address Difference 
between Internet and web 
 
Section B1: Computer Science 
 
 
Exception Handling: syntax errors, exceptions, need of exception handling, user-defined 
exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - else clause, 
Try - finally clause, recovering and continuing with finally, built-in exception classes. 
File Handling: text file and binary file, file types, open and close files, reading and writing text 
files, reading and writing binary files using pickle module, file access modes. 
 
Stack (List Implementation): Introduction to stack (LIFO Operations), operations on stack (PUSH 
and POP) and its implementation in python. Expressions in Prefix, Infix and postfix notations, 
evaluating arithmetic expressions using stack, conversion of Infix expression to postfix 
expression 
Chapter 1: Exception and File Handling in Python  
Chapter 2: Stack  
Page | 4 
 
 
Queue (List Implementation): Introduction to Queue (FIFO), Operations on Queue (INSERT and 
DELETE) and its implementation in Python. 
Introduction to DQueue and its implementation in Python. 
 
Searching: Sequential search, Binary search, Analysis of Sequential and Binary Search. Dry run to 
identify best, worst and average cases. Implementation of searching techniques in Python. 
 
Overview of sorting techniques, Bubble Sort, Selection Sort and Insertion Sort. Dry run to identify 
best, worst and average cases. Implementation of sorting techniques in Python. 
Hashing: Hash Functions, Collision Resolution, Implementing the Map Abstract Data Type. 
 
 
Data and its purpose, collection and organization; understanding data using statistical methods: 
mean, median, standard deviation, variance; data interpretation; visualization of data. 
 
 
 
Introduction to database concepts, difference between database and file system, relational data 
model: concept of domain, tuple, relation, keys - candidate key, primary key, alternate key, 
foreign key; 
Relational algebra: selection, projection, union, set difference and cartesian product; 
 
 
Advantages of using Structured Query Language, Data Definition Language, Data Query 
Language and Data Manipulation Language, Introduction to MySQL, Creating a database using 
MySQL, Data Types 
Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, 
Data Query: SELECT, FROM, WHERE 
Data Manipulation: INSERT, UPDATE, DELETE 
Math functions: POWER (), ROUND (), MOD (). 
Chapter 7: Database Concepts  
Chapter 3: Queue  
Chapter 4: Searching  
Chapter 5: Sorting  
Chapter 6: Understanding Data  
Chapter 8: Structured Query Language  
Page | 5 
 
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), 
LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). 
Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), 
DAYNAME (). 
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT 
(*). Querying and manipulating data using Group by, Having, Order by. 
Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN 
 
Introduction to computer networks, Evolution of networking, 
Network types: LAN, WAN, MAN 
Network devices: Modem, Ethernet Card, Repeater, Hub, Switch, Router, Gateway. 
Network Topologies: Mesh, Ring, Bus, Star, and Tree topologies 
Basic concept of MAC and IP Address 
Difference between Internet and web 
Section B2: Informatics Practices 
 
Math functions: POWER (), ROUND (), MOD (). 
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING 
()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM 
(). 
Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), 
DAYNAME (). 
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using 
COUNT (*). Querying and manipulating data using Group by, Having, Order 
by. 
Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN 
 
Introduction to Python libraries- Pandas, NumPy, 
Chapter 1: Database Query using SQL  
Chapter 2: Data Handling using Pandas – I  
Chapter 9: Computer Networks