Home

CUET UG Computer Science & IP Syllabus & Study Material

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, cartesian product

2. Structured Query Language – I

  • Advantages of using Structured Query Language
  • Data Definition Language, Data Query Language, 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 ()

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

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, Tree
  • Basic concept of MAC and IP Address
  • Difference between Internet and Web

Section B1 – Computer Science

1. Exception and File Handling in Python

Exception Handling

  • Syntax errors and exceptions
  • Need of exception handling
  • User-defined exceptions
  • Raising exceptions
  • Handling and 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

2. Stack

  • Stack (List Implementation)
  • Introduction to stack (LIFO operations)
  • Operations: PUSH and POP
  • Stack implementation in Python
  • Prefix, Infix and Postfix expressions
  • Evaluating arithmetic expressions using stack
  • Conversion of infix expression to postfix expression

3. Queue

  • Queue (List Implementation)
  • Introduction to Queue (FIFO)
  • Operations: INSERT and DELETE
  • Queue implementation in Python
  • Introduction to DQueue and its implementation in Python

4. Searching

  • Sequential search
  • Binary search
  • Analysis of Sequential and Binary Search
  • Best, worst and average cases (dry run)
  • Implementation of searching techniques in Python

5. Sorting

  • Overview of sorting techniques
  • Bubble Sort
  • Selection Sort
  • Insertion Sort
  • Best, worst and average cases (dry run)
  • Implementation in Python
  • Hashing: Hash Functions, Collision Resolution

6. Understanding Data

  • Data and its purpose
  • Data collection and organization
  • Statistical methods: mean, median, standard deviation, variance
  • Data interpretation

7. Database Concepts

  • Introduction to database concepts
  • Difference between database and file system
  • Relational data model: domain, tuple, relation
  • Keys: candidate key, primary key, alternate key, foreign key
  • Relational algebra: selection, projection, union, set difference, cartesian product

8. Structured Query Language

  • Advantages of SQL
  • DDL, DQL, DML
  • 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

Functions

  • Math: POWER (), ROUND (), MOD ()
  • Text: UCASE (), LCASE (), MID (), SUBSTRING (), SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ()
  • Date: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME ()
  • Aggregate: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*)

Query Clauses

  • GROUP BY, HAVING, ORDER BY

Operations on Relations

  • Union, Intersection, Minus, Cartesian Product, JOIN

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, Tree
  • MAC and IP Address
  • Difference between Internet and Web

10. Data Communication

  • Concept of communication
  • Types of Data Communication
  • Switching techniques

Communication Media

  • Wired: Twisted Pair, Co-axial Cable, Ethernet Cable, Optical Fibre
  • Wireless: Bluetooth, WLAN, Infrared, Microwave

Protocols

  • HTTP, FTP, IP, PPP
  • Electronic mail protocol

Other Concepts

  • Channel, Bandwidth (Hz, KHz, MHz)
  • Data Transfer Rate (bps, Kbps, Mbps, Gbps, Tbps)

Security & Threats

  • Viruses, Worms, Trojan horse, Spam, Cookies, Adware, Firewall
  • HTTP vs HTTPS
  • Firewall, Cookies, Hackers and Crackers
  • Antivirus and their working
  • Network security threats: DoS, Intrusion, Snooping, Eavesdropping

Section B2 – Informatics Practices

1. Database Query using SQL

  • Math, Text, Date, Aggregate functions
  • GROUP BY, HAVING, ORDER BY
  • Operations on Relations: Union, Intersection, Minus, Cartesian Product, JOIN

2. Data Handling using Pandas – I

  • Python Libraries: Pandas, NumPy, Matplotlib
  • Pandas Data Structures: Series and DataFrames

Series

  • Creation from array, dictionary, scalar
  • Mathematical operations
  • Head & Tail
  • Selection, Indexing, Slicing

DataFrames

  • Creation from dictionary, list of dictionaries, CSV/Text files
  • Display, iteration
  • Row & column operations: add, select, delete, rename
  • Indexing, Boolean Indexing
  • Styling and Formatting
  • Joining, Merging, Concatenation
  • Importing/Exporting CSV data

3. Data Handling using Pandas – II

  • Descriptive Statistics
  • Aggregation, Group By, Sorting
  • Deleting and Renaming Index
  • Pivoting
  • Handling missing values
  • Import/Export between MySQL and Pandas

4. Plotting Data using Matplotlib

  • Line plot, bar graph, histogram
  • Pie chart, frequency polygon
  • Box plot, scatter plot
  • Customization: color, style, width
  • Labels, titles, legends

5. Introduction to Computer Networks

  • LAN, MAN, WAN
  • Network Devices and Topologies
  • Internet, URL, WWW
  • Web applications: Email, Chat, VoIP
  • Website vs Webpage
  • Static vs Dynamic website
  • Web server and hosting
  • Web browsers, cookies, add-ons

6. Societal Impacts

  • Digital footprint
  • Net etiquettes
  • Data protection
  • IPR, plagiarism, licensing, copyrights
  • FOSS and Creative Commons
  • Cybercrime and cyber laws
  • Indian IT Act
  • E-waste hazards and management
  • Health issues related to technology usage