Number of questions

50 questions

Number of questions to be attempted

All compulsory

Type of question

Multiple Choice Question (MCQ)

CUET Computer Science exam duration

60 minutes

CUET marking scheme

+5 for each correct answer

-1 for each incorrect answer

A

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, opening and closing files, reading and writing text files, reading and writing binary files using pickle module, file access modes.

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

Structured Query Language (SQL)

• 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

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

B1: Computer Science

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.

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

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, 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;

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

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

B2: Informatics Practices

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

Data Handling using Pandas – I

• Introduction to Python libraries- Pandas, NumPy, Chapter 1: Database Query using SQL Chapter 2: Data Handling using Pandas – I Chapter 9: Computer Networks Page | 6 Matplotlib. Data structures in Pandas - Series and Data Frames.
• Series: Creation of Series from – and array, dictionary, 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: add, select, delete, rename; Head and Tail functions; Indexing usingLabels, 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.
• DataFrame operations: Aggregation, group by, Sorting, Deleting 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, bargraph, histogram, pie chart, frequency polygon, box plot, and scatter plot.
• Customizing plots: color, 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.
• Website: Introduction, the difference between a website and webpage, static vs dynamic web page, webserver, and hosting of a website.
• Introduction to Internet, URL, WWW, and its applications- Web, email, Chat, VoIP.
• Web Browser: Introduction, commonly used browsers, browser settings, add-ons and plugins, cookies.

Societal Impacts

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

Data Communication

• Concept of communication, Types of Data Communication, switching techniques
• Introduction to mobile telecommunication technologies
• Wireless Technologies – Bluetooth, WLAN, Infrared, Microwave
• Communication Media: Wired Technologies – Twisted pair cable, Co-axial cable, Ethernet Cable, Optical Fibre;
• Concept of Channel, Bandwidth (Hz, KHz, MHz) and Data Transfer rate (bps, Kbps, Mbps, Gbps, Tbps)
• Network Protocol: Need for Protocol, Categorization and Examples of protocol, HTTP, FTP, IP, PPP; electronic mail protocol

Security Aspects

• Network Security Concepts: Firewall, Cookies, Hackers and Crackers
• Antivirus and their workings
• Network security threats: Denial of service, Intrusion problems, Snooping, Eavesdropping
• Threats and prevention: Viruses, Worms, Trojan horse, Spam, Cookies, Adware, Firewall, http vs https

English

CUET English Syllabus

CUET English Question Paper

Biology

CUET Biology Syllabus

CUET Biology Question Paper

Chemistry

CUET Chemistry Syllabus

CUET Chemistry Question Paper

Computer Science/ Informatics Practices

CUET Computer Science Syllabus

CUET Computer Science Question Paper

Economics/ Business Economics

CUET Economics Syllabus

CUET Economics Question Paper

Engineering Graphics

CUET Engineering Graphics Syllabus

CUET Engineering Graphics Question Paper

Environmental Science

CUET Environmental Science Syllabus

CUET Environmental Science Question Paper

Mathematics

CUET Mathematics Syllabus

CUET Mathematics Question Paper

Physics

CUET Physics Syllabus

CUET Physics Question Paper

Agriculture

CUET Agriculture Syllabus

CUET Agriculture Question Paper

General Test

CUET General Test Syllabus

CUET General Test Question Paper