Updated On : April 3, 2023
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.
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.
Check of CUET Computer Science Syllabus 2023 to plan your preparations.
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
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
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.
Frequently Asked Questions
How many section should be covered in the CUET Computer Science Syllabus?
2 sections and their sub-topics must be covered under CUET Computer Science Syllabus.
How should one go about preparing for the CUET Computer Science Syllabus?
Candidates for the CUET in Computer Science will want industry professionals' hints and tactics to prepare for the exam. The CUET Preparation Tips and techniques for computer science have been shared in this article, ensure you follow it.
What are some of the most important books to cover CUET Computer Science Syllabus?
Is there any new information that has been added to the CUET Computer Science Syllabus recently?
Where can I get the CUET CS Syllabus PDF file?