Computer Science/Informatics Practices – 308

Note:

There will be one Question Paper which will contain Two Sections: Section A and Section B [B1 and B2].

  • Section A will have 15 questions covering both Computer Science and Informatics Practices, which will be compulsory for all candidates.
  • Section B1 will have 35 questions from Computer Science, out of which 25 questions need to be attempted.
  • Section B2 will have 35 questions purely from Informatics Practices, out of which 25 questions will be attempted.

Section A:

1. Exception and File Handling in Python:

  • Exception Handling:
    • Syntax errors, exceptions, need for 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 the pickle module.
    • File access modes.

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

3. Structured Query Language (SQL):

  • Advantages of using SQL.
  • Data Definition Language (DDL), Data Query Language (DQL), Data Manipulation Language (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 in SQL:
    • Math functions: POWER(), ROUND(), MOD().
    • Text functions: UCASE(), LCASE(), MID(), LENGTH(), LEFT(), RIGHT(), INSTR(), LTRIM(), RTRIM(), TRIM().
    • Date functions: NOW(), DATE(), MONTH(), MONTHNAME(), YEAR(), DAY(), DAYNAME().
    • Aggregate functions: MAX(), MIN(), AVG(), SUM(), COUNT().
  • 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, and Tree topologies.
  • Basic concepts of MAC and IP Address.
  • Difference between Internet and Web.

Section B1: Computer Science

Chapter 1: Exception and File Handling in Python:

  • Exception Handling: Syntax errors, exceptions, need for exception handling, user-defined exceptions, raising exceptions, handling exceptions, catching exceptions.
  • Try - except - else clause, Try - finally clause.
  • File Handling: Text and binary files, file types, opening and closing files, reading and writing text files, reading and writing binary files using pickle module.

Chapter 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 expressions using stack.
  • Conversion of Infix expression to postfix expression.

Chapter 3: 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.

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

Chapter 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.
  • Hashing: Hash Functions, Collision Resolution, Implementing the Map Abstract Data Type.

Chapter 6: Understanding Data:

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

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

Chapter 8: Structured Query Language (SQL):

  • Advantages of using SQL, DDL, DQL, DML.
  • 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 in SQL:
    • Math functions: POWER(), ROUND(), MOD().
    • Text functions: UCASE(), LCASE(), MID(), LENGTH(), LEFT(), RIGHT(), INSTR(), LTRIM(), RTRIM(), TRIM().
    • Date functions: NOW(), DATE(), MONTH(), MONTHNAME(), YEAR(), DAY(), DAYNAME().
    • Aggregate functions: MAX(), MIN(), AVG(), SUM(), COUNT().
  • Operations on Relations:
    • Union, Intersection, Minus, Cartesian Product, JOIN.

Chapter 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 concepts of MAC and IP Address.
  • Difference between Internet and Web.

Section B2: Informatics Practices

Chapter 1: Database Query using SQL:

  • Math functions: POWER(), ROUND(), MOD().
  • Text functions: UCASE(), LCASE(), MID(), LENGTH(), LEFT(), RIGHT(), INSTR(), LTRIM(), RTRIM(), TRIM().
  • Date functions: NOW(), DATE(), MONTH(), MONTHNAME(), YEAR(), DAY(), DAYNAME().
  • Aggregate functions: MAX(), MIN(), AVG(), SUM(), COUNT().
  • Operations on Relations: Union, Intersection, Minus, Cartesian Product, JOIN.

Chapter 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 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.
    • Boolean Indexing, Styling & Formatting data, Joining, Merging, and Concatenations.
    • Importing/Exporting Data between CSV files and DataFrames.

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

Chapter 4: 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, box plot, and scatter plot.
  • Customizing plots: color, style (dashed, dotted), width; adding label, title, and legend in plots.

Chapter 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, difference between website

 

Looking to achieve top results in CUET UG 2025 and gain admission to prestigious universities like Delhi University (DU), Banaras Hindu University (BHU), Jawaharlal Nehru University (JNU), and more? At our leading CUET coaching center in Jaipur, we offer a fully structured CUET UG 2025 Course with both CUET Online Coaching and in-person options to suit your study preferences. Our comprehensive curriculum covers everything you need to excel, including the CUET UG 2025 syllabus, exam pattern, and essential practice through CUET UG 2025 subject-wise MCQs and practice sets. Stay ahead with our CUET UG 2025 Crash Course, Foundation Course, and a thorough CUET UG 2025 Test Series to solidify your preparation. We also guide you through the CUET UG 2025 Application Form, exam dates, and admission process with personalized support for each step. Join the best CUET coaching in Jaipur to start your journey towards CUET success with Himalaya EduHub today! Visit CUET UG 2025 Course Information to learn more.