CUET Computer Science Syllabus

Section: A

Exception and File Handling in Python

• Exception Handling: syntax errors, exceptions, the need for exception handling, user-defined exceptions, raising exceptions, etc.
• File Handling: text file and binary file, file types, open and close files, reading and writing text files, binary files using pickle module, etc.

Database Concepts

• Introduction to database concepts, the difference between database and file system, relational data model: the concept of the domain, relation, keys, etc.
• Relational algebra: selection, projection, union, set difference, and cartesian product.

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, Data Query, Data Manipulation, Math functions, & Text functions, and Operations on relations.

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.
• Network Topologies: Mesh, Ring, Bus, Star, and Tree topologies.
• Mesh, Basic concept of MAC and IP Address.
• Network Topologies: Difference between the Internet and the Web.

Section B1: Computer Science

Exception and File Handling in Python

• Exception Handling: syntax errors, exceptions, need for exception handling, user-defined exceptions, raising exceptions.
• File Handling: text file and binary file, file types, open and close files, reading and writing text files, reading and writing binary files using the pickle module.

Stack

Stack (List Implementation):

• Introduction to stack (LIFO Operations), operations on the stack (PUSH and POP), and its implementation in Python.
• Expressions in prefixes, Infix, and postfix notations, evaluating arithmetic expressions using stack, conversion of Infix expressions to postfix expressions.

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.

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.

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, Implementing the Map Abstract Data Type.

Understanding Data

• Data and its purpose, collection, and organization; understanding data using statistical methods: mean, median, standard deviation, variance; data interpretation; visualization of data.

Database Concepts

• Introduction to database concepts, the difference between database and file system, the concept of the domain, tuple, relation, keys, candidate key, primary key, alternate key, and foreign key.
• Relational algebra: selection, projection, union, set difference, and cartesian product.

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
• Data Query
• Data Manipulation
• Math functions
• Text function
• Date function
• Aggregate function
• Operation on Relation - Union, Intersection, Minus Cartesian.

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 the Internet and the Web.

Section B2: Information Practices

Database Query using SQL

Math functions

• Text functions
• Date Functions
• Aggregate Functions
• Operations on Relations - Union, Intersection, Minus, Cartesian Product.

Data Handling using Pandas – I

• Introduction to Python libraries- Pandas, NumPy, Matplotlib. Data structures in Pandas - Series, and DataFrames.
• Series: Creation of Series from – an array, dictionary, or scalar value; mathematical operations; Head and Tail functions; Selection, Indexing, and Slicing.
• Data Frames: creation - from the dictionary of Series, list of dictionaries, Text/CSV files; display; iteration, operations on rows and columns.
• Head and Tail functions; Indexing using labels, Boolean Indexing; Styling & Formatting data, Head and Tail functions; Joining, Merging, and Concatenations.
• Importing/Exporting Data between CSV files and DataFrames.

Data Handling using Pandas – II

• Descriptive Statistics: max, min, count, sum, mean, median, mode, quartile, Standard deviation, variance.
• Data Frame operations: Aggregation, group by, Sorting, Deletion and Renaming Index, Pivoting.
• Handling missing values – dropping and filling.
• Importing/Exporting Data between MySQL database and Pandas.

Plotting Data using Matplotlib

• Purpose of plotting; drawing and saving the following types of plots using Matplotlib – line plot, bar graph, histogram, pie chart, frequency polygon, etc.
• Customizing plots: colour, style (dashed, dotted), width; adding label, title, and legend in plots.

Introduction to Computer Networks

• Introduction to Networks, Types of networks: LAN, MAN, WAN. Network Devices: modem, hub, switch, repeater, router, gateway.
• Network Topologies: Star, Bus, Tree, Mesh. Introduction to Internet, URL, WWW, and its applications- Web, email, Chat, VoIP.
• Website: Introduction, the difference between a website and a webpage, static vs dynamic web page, web server, and hosting of a website.
• Web Browsers: Introduction, commonly used browsers, browser settings, add-ons and plugins, cookies.

Societal Impacts

• Digital footprint, Etiquettes for net surfing and communicating through social media, data protection, Intellectual Property Rights (IPR) and their violation, plagiarism licensing.
• Chapter 5: Introduction to Computer Networks.
• Chapter 11: Security Aspects copyrights, Free and Open Source Software (FOSS), Cybercrime and cyber laws, hacking, phishing, cyberbullying, Overview of Indian IT Act, preventing cybercrime.
• E-waste, it’s a hazard and management.
• Awareness about health concerns related to the usage of technology like effect on eyesight, physiological issues, and ergonomic aspects.

Data Communication

• 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).

Security Aspects

• Threats and prevention: Viruses, Worms, Trojan horses, 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.