CUET Computer Science Syllabus 2023: Important Topics, pattern And Pdf Download

Summary: Lakhs of students passing class 12 want to study computer science courses every year. Traditionally, we have engineering entrance exams like JEE Mains, GATE etc. Last year, additionally CUET was introduced for admission to the computer science UG programs in top universities across the country. Here is an article explaining the computer science syllabus for Central Universities Common Entrance Test. 

CUET computer science syllabus 2023 is prescribed by NTA and commonly followed across all the CUET central, state, deemed and private universities. The Central Universities Common Entrance Test participating colleges offer several undergraduate programs like B.Sc, B.Tech courses etc., in computer science specialization, and most universities include CS in their exam pattern.

Suppose you wish to study at these universities, it is strongly recommended that you carefully read through the course outline and note down the chapters that are considered to be important and plan their preparations accordingly. 

The National Testing Agency has made it clear to all aspirants that the computer science curriculum would be in and around topics taught until class 12. Let's dive in to check the CUET Computer Science Syllabus 2023 and the important topics to focus.

Download CUET Computer Science Syllabus Pdf

English Version

Hindi Version

Important facts about CUET Computer Science Syllabus 2023

• Computer Science is one question paper with two sections: Section A and Section B [B1 and B2].
• You must answer all 15 questions covering Computer Science and Information Practices in Section A. This section of the CUET exam is mandatory.
• There will be a total of 35 questions about computer science in Section B1, although only 25 of those questions must be attempted.
• Section B2 will have 35 questions about information practices; however, only 25 must be attempted.

CUET Computer Science Syllabus 2023 Reference Books

The CUET books are of the utmost significance for achieving success in the examination. Here is a list of CUET Computer Science books you can refer to. 

• In conjunction with Rachna Sagar's Computer Science Class 12
• Sumita Arora's Computer Science with Python Class 12
• NCERT Computer Science Textbook for Class 12th is also included.

Download Free Study Material for CUET Exam 2023 by SuperGrads

CUET Computer Science Syllabus from Class 12(Informatics Practices - 308)

Check of CUET Computer Science Syllabus 2023 to plan your preparations. 

Section A

Exception and File Handling in Python

Exception Handling: syntax mistakes, exceptions, exception managing necessity, user-defined exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - otherwise clause, Try - finally clause, recovering and continuing with finally, built-in exception classes.

Text file and binary files, file types, open and close files, reading and writing text files, reading and writing binary files using the pickle module, and file access modes are covered in File Handling.

Database Theory

Difference between database and file system, relational data model: domain, tuple, relation, candidate key, primary key, alternate key, and foreign key;

Relational algebraic operations: selection, projection, union, set difference, and cartesian product

Check: CUET Mathematics Exam Syllabus

SQL stands for Structured Query Language

Structured Query Language, Data Definition Language, Data Query Language, and Data Manipulation Language: Presentation of MySQL, Creating a database using MySQL, Data Types

Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE

Data Query: SELECT, FROM, and WHERE are the three components of a SELECT statement.

Data Manipulation: ADD, CHANGE, DELETE

Mathematical operations: POWER (), ROUND (), and MOD ().

Text functions: LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). ().

NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME () are Date functions ().

Aggregate Functions: Using COUNT (*) with the aggregate functions MAX (), MIN (), AVG (), SUM (), and COUNT (). Data manipulation and querying utilizing Group by, Having, and Order by

Relationship Operations - Union, Intersection, Subtraction, Cartesian Product join

Check: NTA CUET Exam Dates 2023

Computer Systems Networks

A primer on computer networks, The development of networking,

Types of networks: LAN, WAN, and MAN

Network devices: Modem, Ethernet Card, Repeater, Hub, Switch, Router, and Gateway are examples of network devices.

Network Topologies: Mesh, Ring, Bus, and Tree are examples of Conceptualization of MAC and IP Address Distinction between the Internet and web

Check: CUET Online Coaching

Section B1: Information Technology

Chapter 1: Handling Exceptions and Files in Python

Syntax mistakes, exceptions, the requirement for exception handling, user-defined exceptions, raising exceptions, handling exceptions, and catching exceptions. Try - except - otherwise clause, Try - finally clause, recovering and continuing with finally, and predefined exception classes.

Text file and binary files, file types, open and close files, reading and writing text files, reading and writing binary files using the pickle module, and file access modes are covered in File Handling.

Chapter 2: Stack

Stack (List Implementation): An introduction to stack (LIFO Operations), stack operations (PUSH and POP), and its Python implementation. Expressions in Prefix, Infix, and postfix notations; stack-based evaluation of arithmetic expressions; conversion of an Infix expression to a postfix expression.

Chapter 3: Queue

Introduction to Queue (List Implementation), Queue Operations (INSERT and DELETE), and its Python implementation.

Introduction to DQueue and its Python implementation.

Chapter 4: Research

Sequential search, Binary search, and sequential and binary search evaluation. A simulation to determine the best, worst, and average cases. Python implementation of searching strategies.

Chapter 5: Classifying

A summary of the sorting methods Bubble Sort, Selection Sort, and Insertion Sort. A simulation to determine the best, worst, and average cases. Python implementation of sorting procedures.

Hash Functions, Collision Resolution, and Map Abstract Data Type Implementation

Check: CUET Psychology Syllabus

Chapter 6: Understanding Data

Data's purpose, collection, and arrangement; data comprehension utilizing statistical methods: mean, median, standard deviation, and variance; data interpretation; data visualization.

Chapter 7: Concepts for Databases

Difference between database and file system, relational data model: domain, tuple, relation, candidate key, primary key, alternate key, and foreign key;

Relational algebraic operations: selection, projection, union, set difference, and cartesian product;

Chapter 8: Structured Query Language

Structured Query Language, Data Definition Language, Data Query Language, and Data Manipulation Language: Presentation of MySQL, Developing a database with MySQL, Data Types

Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, 

Data Query: Data Definition SELECT, FROM, WHERE 

Data Manipulation: ADD, CHANGE, DELETE 

Mathematical operations: POWER (), ROUND (), and MOD ().

Text functions: LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). ().

Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME () are Date functions (). 

Aggregate Functions: Using COUNT (*) with the aggregate functions MAX (), MIN (), AVG (), SUM (), and COUNT (). Data manipulation and querying utilizing Group by, Having, and Order by

Relationship Operations - Union, Intersection, Subtraction, Cartesian Product JOIN

Chapter 9: Computer Networks

A primer on computer networks, The development of networking,

Types of networks: LAN, WAN, and MAN

Network devices: Modem, Ethernet Card, Repeater, Hub, Switch, Router, and Gateway are examples of network devices.

Network Topologies: Mesh, Ring, Bus, and Tree are examples of

The basic concept of MAC and IP Address Internet and web distinction 

Check: CUET Mock Tests 2023

Section B2: Information Practices

Chapter 1: Querying databases with SQL

Mathematical operations: POWER (), ROUND (), and 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 () are Date functions ().

Aggregate Functions: Using COUNT (*) with the aggregate functions MAX (), MIN (), AVG (), SUM (), and COUNT ().

Data manipulation and querying utilizing Group by, Having, and Order by

Operations on Relations - Union, Intersection, Minus, Cartesian Product, and join our operations on relations.

Chapter 2: Data Handling using Pandas - I

Pandas, NumPy, and Matplotlib, are introduced as Python libraries. Pandas data structures - Series and DataFrames

Series: Creation of Series from arrays, dictionaries, and scalars; mathematical operations; Head and Tail functions; Selection, Indexing, and Slicing.

DataFrames: construction - from the Series dictionary, the list of Series dictionaries, and Text/CSV files; display; iteration. Add, select, remove, rename; Operations on Rows and Columns: add, select, delete; Head and Tail functions; Indexing using Labels, Boolean Indexing; Styling and Formatting data; Head and Tail functions; Joining, Merging, and Concatenating.

Importing and exporting data between CSV and DataFrame formats.

Chapter 3: Data Handling using Pandas – II

Descriptive Statistics: Maximum, minimum, count, sum, mean, median, mode, quartile, standard deviation, and variance are descriptive statistics.

DataFrame operations: Aggregation, group by, Sorting, Index deletion, renaming, and pivoting are DataFrame operations. Handling missing values — dropping and filling.

Data import/export between the MySQL database and Pandas.

Chapter 4: Data Plotting with Matplotlib

Purpose of charting; creating and storing line plots, bar graphs, histograms, pie charts, frequency polygons, box plots, and scatter plots using Matplotlib.

Customize plot color, style (dashed, dotted), and width, and add a plot's label, title, and legend.

Chapter 5: Introduction to Computer Networks

Introduction to Networks, Network Types: LAN, MAN, and WAN 

Network Devices: Modem, Hub, Switch, Repeater, Router, and Gateway are Network Devices. Network Topologies: Star, Bus, Tree, and Mesh Network Topologies

Internet, URL, WWW, and its applications (Web, email, Chat, VoIP) are introduced.

Website: Introduction, the distinction between a website and a webpage, static versus dynamic web page, web server, and website hosting.

Web Clients: Introduction, commonly used browsers, browser settings, browser extensions, plug-ins, and cookies.

Check: CUET Economics Syllabus

Chapter 6: Societal Consequences

Digital footprint, Internet and social media etiquette, data protection, Intellectual Property Rights (IPR) and their breach, licensing for plagiarism, and plagiarism copyrights, Free and Open Source Software (FOSS), cybercrime, and cyber laws, hacking, phishing, and cyberbullying. A summary of the Indian IT Act, which prevents cybercrime.

E-waste is hazardous and must be managed.

Awareness of the effects of technology on eyesight, physiological difficulties, and ergonomic factors.

Chapter 10: Data Transmission

Communication Concepts, Data Communication Types, Switching Techniques

Communication Media: Wired Technologies — Twisted pair cable, Coaxial cable, Ethernet Cable, and Optical Fiber

Introduction to Mobile Telecommunication Technologies Bluetooth, WLAN, Infrared, and Microwave are Wireless Technologies.

Network Protocol: Need for Protocol, Categorization, and Examples of protocol, HTTP, FTP, IP, PPP; electronic mail protocol

Concept of Channel, Bandwidth (Hz, kHz, and MHz), and Data Transfer rate (bps, Kbps, Mbps, Gbps, Tbps)

Chapter 11: Security Aspects

Threats and defences: Viruses, Worms, Trojan horses, Spam, Cookies, Adware, Firewall, HTTP versus HTTPS

Network Security Concepts: Firewall, Cookies, Hackers and Crackers Antivirus and their workings Network security threats: Denial of service, Intrusion problems, Snooping, Eavesdropping.