CUET Computer Science

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.

Note for Students: This unit establishes the foundational theory of relational databases and the mathematical operations used to manipulate data structures.

Section A - 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, DataTypes
• 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 ().

Note for Students: Focus on mastering basic SQL syntax and built-in functions for string and numerical data manipulation in MySQL.

Section A - 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.

Note for Students: This unit covers advanced querying techniques, including data aggregation, grouping, and performing operations across multiple tables.

Section A - 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.

Note for Students: Understand the physical and logical components of networking, including hardware devices and various structural arrangements of computers.

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. Setting Offsets in a File

Note for Students: This unit focuses on robust programming practices in Python, including error management and permanent data storage using files.

Section B1: Computer Science - 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 (Postfix) expressions using stack, conversion of Infix expression to postfix expression.

Note for Students: Mastery of the Stack data structure is crucial for understanding expression evaluation and memory management in computer science.

Section B1: Computer Science - 3: Queue

• Queue (List Implementation): Introduction to Queue (FIFO), Operations on Queue (INSERT and DELETE) and its implementation in Python.
• Introduction to Deque and its implementation in Python.

Note for Students: Learn the FIFO principle and its implementation using Python lists, including variations like Double-Ended Queues.

Section B1: Computer Science - 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.
• Hashing: Hash Functions, Collision Resolution.

Note for Students: Focus on the efficiency of different searching algorithms and the fundamental concepts of data retrieval through hashing.

Section B1: Computer Science - 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.

Note for Students: Practice the logic and implementation of basic sorting algorithms and evaluate their performance in different scenarios.

Section B1: Computer Science - 6: Understanding Data

• Data and its purpose, collection and organization; understanding data using statistical methods: mean, median, mode (Measures of central tendency), (Measures of Variability) range ,standard deviation. variance; data interpretation.

Note for Students: This unit integrates statistics with computer science to help students analyze and interpret data sets effectively.

Section B1: Computer Science - 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.

Note for Students: A reinforcement of core database theory, emphasizing the relational model and algebraic operations.

Section B1: Computer Science - 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 and constraints in MySQL
• 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.

Note for Students: This comprehensive SQL unit covers everything from basic table creation to complex multi-relation operations and constraints.

Section B1: Computer Science - 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
• Domain Name System

Note for Students: Essential knowledge for understanding how information is routed and addressed across local and global networks.

Section B1: Computer Science - 10: 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).

Note for Students: This unit details the physical mediums and protocols that enable data to travel between devices.

Section B1: Computer Science - 11: Security Aspects

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

Note for Students: Focus on identifying various digital threats and the defensive measures used to secure network environments.

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

Note for Students: Application-heavy SQL unit focusing on data retrieval and function usage within the Informatics Practices context.

Section B2: Informatics Practices - 2: Data Handling using Pandas – I

• Introduction to Python libraries-Pandas, NumPy, Matplotlib.
• Data structures in Pandas - Series and DataFrames.
• Series: Creation of Series from – and array, dictionary, scalar value; mathematical operations; Head and Tail functions; Selection, Indexing, and Slicing.
• DataFrames: creation - from 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 using Labels, Boolean Indexing; Styling & Formatting data, Head and Tail functions; Joining, Merging and Concatenations.
• Importing/Exporting Data between CSV files and DataFrames.

Note for Students: Essential for data science enthusiasts, this unit covers the fundamentals of using Pandas for data manipulation and structure management.

Section B2: Informatics Practices - 3: 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.

Note for Students: Learn advanced data cleaning and statistical analysis techniques using the Pandas library.

Section B2: Informatics Practices - 4: 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.

Note for Students: Master the art of data visualization to effectively communicate insights through various chart types.

Section B2: Informatics Practices - 5: 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 webpage, static vs dynamic webpage, webserver, and hosting of a website.
• Web Browsers: Introduction, commonly used browsers, browser settings, add-ons and plug-ins, cookies.

Note for Students: This unit bridges hardware networking concepts with practical web technologies and browser usage.

Section B2: Informatics Practices - 6: 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), creative commons, Cybercrime and cyber laws, hacking, phishing, cyberbullying, Overview of Indian IT Act, preventing cybercrime.
• E-waste: Hazards and management.
• Awareness about health concerns related to the usage of technology-like effect on eyesight, physiological issues, and ergonomic aspects.

Note for Students: A critical look at the legal, ethical, and environmental impacts of technology on modern society.

Section B2: Informatics Practices - 7: Project Based Learning

• Approaches for Solving Projects, Steps in project-based learning, Teamwork, Components of Teamwork

Note for Students: Focus on the methodology of collaborative learning and the systematic steps required to complete technical projects.