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

 Page 1


 
For the year 2025 
 
 
 
 
Computer 
Science/Information 
Practices -308       
Syllabus for CUET(UG)  
Page 2


 
For the year 2025 
 
 
 
 
Computer 
Science/Information 
Practices -308       
Syllabus for CUET(UG)  
 
1 | P a g e 
 
 
Section A 
 
1: 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. 
 
2: Structured Query Language - I 
? 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 ().Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID 
()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), 
RTRIM (), TRIM (). 
3: Structured Query Language - II 
 
? 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 
 
4: 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. 
 
Page 3


 
For the year 2025 
 
 
 
 
Computer 
Science/Information 
Practices -308       
Syllabus for CUET(UG)  
 
1 | P a g e 
 
 
Section A 
 
1: 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. 
 
2: Structured Query Language - I 
? 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 ().Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID 
()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), 
RTRIM (), TRIM (). 
3: Structured Query Language - II 
 
? 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 
 
4: 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. 
 
 
2 | P a g e 
 
Section B1: Computer Science 
 
 
   1: 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. 
 
  2: Stack  
 
? 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 
 
   3: Queue 
 
? 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. 
 
   4: Searching  
 
? 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. 
 
 
 5: Sorting  
 
? 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. 
 
  6: Understanding Data  
 
? Data and its purpose, collection and organization; understanding data using statistical methods: 
Page 4


 
For the year 2025 
 
 
 
 
Computer 
Science/Information 
Practices -308       
Syllabus for CUET(UG)  
 
1 | P a g e 
 
 
Section A 
 
1: 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. 
 
2: Structured Query Language - I 
? 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 ().Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID 
()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), 
RTRIM (), TRIM (). 
3: Structured Query Language - II 
 
? 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 
 
4: 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. 
 
 
2 | P a g e 
 
Section B1: Computer Science 
 
 
   1: 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. 
 
  2: Stack  
 
? 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 
 
   3: Queue 
 
? 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. 
 
   4: Searching  
 
? 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. 
 
 
 5: Sorting  
 
? 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. 
 
  6: Understanding Data  
 
? Data and its purpose, collection and organization; understanding data using statistical methods: 
 
3 | P a g e 
 
mean, median, standard deviation, variance; data interpretation. 
 
   7: 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. 
 
8: 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 (). 
? 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 
 
 
      9: 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 
 
10: Data Communication 
Page 5


 
For the year 2025 
 
 
 
 
Computer 
Science/Information 
Practices -308       
Syllabus for CUET(UG)  
 
1 | P a g e 
 
 
Section A 
 
1: 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. 
 
2: Structured Query Language - I 
? 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 ().Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID 
()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), 
RTRIM (), TRIM (). 
3: Structured Query Language - II 
 
? 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 
 
4: 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. 
 
 
2 | P a g e 
 
Section B1: Computer Science 
 
 
   1: 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. 
 
  2: Stack  
 
? 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 
 
   3: Queue 
 
? 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. 
 
   4: Searching  
 
? 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. 
 
 
 5: Sorting  
 
? 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. 
 
  6: Understanding Data  
 
? Data and its purpose, collection and organization; understanding data using statistical methods: 
 
3 | P a g e 
 
mean, median, standard deviation, variance; data interpretation. 
 
   7: 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. 
 
8: 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 (). 
? 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 
 
 
      9: 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 
 
10: Data Communication 
 
4 | P a g e 
 
 
? Concept of communication, Types of Data Communication, switching techniques 
? Communication Media: Wired Technologies – Twisted pair cable, Co-axial cable, 
Ethernet Cable, Optical Fibre; 
? Introduction to mobile telecommunication technologies 
? Wireless Technologies – Bluetooth, WLAN, Infrared, Microwave 
? Network Protocol: Need for Protocol, Categorization and Examples of protocol, HTTP, FTP, IP, 
PPP; electronic mail protocol 
? Concept of Channel, Bandwidth (Hz, KHz, MHz) and Data Transfer rate (bps, Kbps, Mbps, 
Gbps, Tbps) 
 
 
? Threats and prevention: Viruses, Worms, Trojan horse, Spam, Cookies, Adware, Firewall, 
http vs https. 
? Network Security Concepts: Firewall, Cookies, Hackers and Crackers 
? Antivirus and their workings 
? Network security threats: Denial of service, Intrusion problems, Snooping, Eavesdropping. 
 
Section B2: Informatics Practices  
 
1: Database Query using SQL 
 
? 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 
 
2: Data Handling using Pandas – I 
 
 
 11: Security Aspects