Here you can find the key syllabus topics for the Science stream all in one place. Whether you’re a student looking for a quick reference or a teacher seeking to streamline your lesson planning, our blog aims to provide concise and comprehensive summaries of the curriculum.
From Biology to Mathematics, Physics to Computer Science, our blog covers a wide range of subjects within the Science stream. Each topic is broken down into manageable sections, allowing you to quickly grasp the core concepts and understand the key points.
If you are interested to know about the CUET 2024 Exam Pattern, Subject List, Total Marks, Marking Scheme
Table of Contents
Physics
CUET Physics Syllabus 2024: Candidates must review the CUET Physics Syllabus 2024 from this page if they want to choose Physics for their CUET Entrance test in 2024. Additionally, the physics curriculum is available for download at cuet.samarth.ac.in, the official website. It is highly advised that you go over the CUET Physics Syllabus 2024 in detail and be ready as soon as feasible. Candidates must review the whole CUET UG 2024 curriculum in addition to the Physics curriculum. The dates of the CUET 2024 test are set for May 15–May 31, 2024.
CUET Physics Syllabus 2024
Physics is an essential science that studies the behavior of forces and energy in the cosmos, as well as matter and motion. The goal of the CUET Physics curriculum for 2024 is to evaluate a candidate’s comprehension of these ideas as well as their application skills in many contexts.
The subjects covered in the CUET Physics syllabus 2024 normally include electricity and magnetism, optics, waves and oscillations, contemporary physics, thermal physics, and mechanics. For applicants to perform well on the CUET 2024 Physics test, a thorough grasp of these subjects is required. A thorough comprehension of the foundational ideas of Physics is essential for any student hoping to pursue postgraduate studies or scientific research in Physics.
Physics Unit & Chapters
| Unit | Chapters Name |
| I | Electrostatics |
| II | Current Electricity |
| III | Magnetic Effects of Current and Magnetism |
| IV | Electromagnetic Induction and Alternating Currents |
| V | Electromagnetic Waves |
| VI | Optics |
| VII | Dual Nature of Matter and Radiation |
| VIII | Atoms and Nuclei |
| IX | Electronic Devices |
| X | Communication Systems |
CUET Exam Pattern
| Number of Questions | 50 |
| Questions need to be Attempted | 40 |
| Duration | 45 min |
| Marking | 5 marks will be given for each right response. |
Important Topics for Physics Syllabus
The following are some of the key subjects covered in the CUET Physics syllabus for 2024:
- Heat transport, the kinetic theory of gases, and thermodynamics are all included in the field of thermal physics.
- Waves and Oscillations: This covers subjects like superposition of waves, waves, and basic harmonic motion.
- Electric fields and potential, capacitance, current electricity, magnetic fields, and electromagnetic induction are all included in the category of electricity and magnetism.
- The study of optics covers polarization, interference and diffraction of light, lenses, mirrors, and the reflection and refraction of light.
- Quantum mechanics, atomic physics, nuclear physics, and particle physics are all included in the category of modern physics.
Chemistry
The CUET Chemistry syllabus includes topics such as Aldehydes, Ketones, Carboxylic Acids, Organic Compounds Containing Nitrogen, Solid State, Solutions, Electrochemistry, Chemical Kinetics, Surface Chemistry, p, d, and f Block Elements, Coordination Compounds, Haloalkanes and Haloarenes, Alcohols, Phenols, and Ethers, etc. The exam window for CUET 2024 is May 15–May 31, 2024.
Chemistry Unit & Chapters
The CUET exam’s Chemistry syllabus covers a wide range of subjects, including Surface Chemistry, Chemical Kinetics, Solid State, Solutions, and P, D, and F Block Elements. See the CUET Chemistry Syllabus 2024 in detail below.
| Unit | Title | Chapter |
| I | Solid State | Classification of solids into molecular, ionic covalent, and metallic categories according to various binding forces fundamental concept of amorphous and crystalline solids; unit cell in two- and three-dimensional lattices; computation of the unit cell’s density, number of atoms per unit cell, voids, packing efficiency, and packing in solids point flaws, electrical and magnetic characteristics, band theory of metals, conductors, in a cubic unit cell, semiconductors, insulators, and semiconductors of the n and p types. |
| II | Solutions | Types of solutions, how solid-to-liquid concentrations are expressed, and how soluble gases are in Raoult’s law, liquids, solid solutions, and colliding properties—the proportionate reduction of vapour pressure, B.P. elevation, freezing point drop, osmotic pressure, and molecular mass measurement utilizing Vant Hoff factor, aberrant molecular mass, and cooperative characteristics |
| III | Electrochemistry | Conductance in electrolytic solutions, redox processes, and changes in the specific and molar conductivity of Kohlrausch’s Law, electrolysis and the fundamental rules of electrolysis, conductivity with concentration notion), lead accumulator, electrochemical cell’s EMF, standard electrode, and dry cell – electrolytic and galvanic cells potential; the Nernst equation; and chemical cells: its application. Gibbs energy change and its relationship and fuel cells; corrosion; a cell’s EMF. |
| IV | Chemical Kinetics | Reaction rates (average and instantaneous), as well as the variables influencing them: focusing, temperature, a catalyst, the reaction’s molecular structure and order, rate law, particular rate constant, and integrated collision theory notion, rate equations, and half-lives (only for zero and first-order reactions) (basic concept; no mathematical analysis).The Arrhenius equation and activation energy. |
| V | Surface Chemistry | Adsorption, including chemisorption and physisorption; variables influencing gas adsorption on materials; catalysis: enzyme catalysis, which is both homogeneous and heterogeneous, active and selective; colloidal condition: the difference between colloids, suspensions, and real solutions; multimolecular and macromolecular colloids that are lyophilic and lyophobic; characteristics of colloids; emulsions – kinds of; Brownian movement, electrophoresis, coagulation, and Tyndall effect emulsions. |
| VI | General Principles and Processes of Isolation of Elements | The electrolytic process, concentration, oxidation, reduction, and other extraction principles and techniques refining: the processes and circumstances involved in obtaining iron, copper, zinc, and aluminum. |
| VII | p-Block Elements | Group 15 elements: overview, electronic configuration, occurrence, oxidation states, trends in physical and chemical properties; nitrogen – preparation, characteristics, and applications; nitrogen compounds: ammonia and nitric acid preparation and properties, nitrogen oxides (structure only); Phosphine, halides (PCl3, PCl5), and oxoacids (basic concept only) are examples of phosphorous-allotropic forms and compounds. Group 16 elements: Ozone; dioxygen: manufacture, usage, and qualities; oxide categorization; electronic configuration; oxidation states, occurrence; trends in physical and chemical properties. Allotropic forms of sulfur; compounds of sulfur: production, characteristics, and applications of sulfur dioxide; industrial manufacturing method, properties, and applications of sulfuric acid; oxoacids of sulfur (only structures). Group 17 elements: Overview, electronic structure, oxidation states, occurrence, trends in physical and chemical characteristics; halogen compounds: hydrochloric acid and chlorine production, properties, and applications; halogen interhalogen compounds; halogen oxoacids (structures only). Group 18 elements include: use, trends in physical and chemical characteristics, occurrence, electronic configuration, and general introduction. |
| VIII | d and f Block Elements | General introduction, electronic configuration, transition metal occurrence and characteristics, general trends in first-row transition metal properties (metallic character, ionization enthalpy, oxidation states, ionic radii, color, catalytic property, magnetic properties, interstitial compounds, alloy formation). The preparation and characteristics of KMnO4 and K2Cr2O7. Lanthanoids: chemical reactivity, oxidation states, electronic configuration, and the effects of lanthanoid contraction. The electronic structure, oxidation states, and analogy with lanthanoids of actinoids. |
| IX | Coordination Compounds | Introduction to coordination compounds; ligands; coordination number, color, and magnetic properties and shapes; bonding; Werner’s theory (VBT, CFT); isomerism (structural and stereo); significance of coordination compounds (in qualitative analysis, metal extraction, and biological systems). |
| X | Haloalkanes and Haloarenes | Haloalkanes: nomenclature, C-X bond type, physical and chemical characteristics, and substitution reaction process. rotation in optics. Haloarenes: C-X bond nature, substitution processes (hindrance of halogen for compounds that are solely monosubstituted). Applications and effects of DDT, freons, iodoform, trichloromethane, tetrachloromethane, and dichloromethane on the environment |
| XI | Alcohols, Phenols, and Ethers | Alcohols: naming, preparation techniques, physical and chemical characteristics (only of primary alcohols); distinguishing between primary, secondary, and tertiary alcohols; dehydration process; applications, with particular emphasis on methanol and ethanol. Phenols: nomenclature, production techniques, physical and chemical characteristics, acidity, electrophilic substitution processes, applications. Ethers: nomenclature, preparation techniques, chemical and physical characteristics, applications. |
| XII | Aldehydes, Ketones, and Carboxylic Acid | Aldehydes and ketones: nomenclature, carbonyl group nature, synthesis techniques, physical and chemical characteristics, nucleophilic addition mechanism, alpha hydrogen reactivity in aldehydes, applications. The nomenclature, acidic nature, production techniques, physical and chemical characteristics, and applications of carboxylic acids. |
| XIII | Organic Compounds Containing Nitrogen | Amines: naming, categorization, composition, preparation techniques, physical and chemical characteristics, applications, and differentiation between primary, secondary, and tertiary amines. Isocyanides and cyanides will be discussed in context and at appropriate points. Preparation, chemical interactions, and significance of dialzonium salts in synthetic organic chemistry |
| XIV | Biomolecules | Aldoses and ketoses, glucose and fructose, D-L configuration, oligosaccharides (sucrose, lactose, maltose), and polysaccharides (starch, cellulose, and glycogen) are the different classes of carbohydrates. A-amino acids, peptide bonds, polypeptides, proteins, primary, secondary, tertiary, and quaternary structures (qualitative notion only), denaturation of proteins, and enzymes are basics of proteins. The basic concept of hormones (not include structure). Vitamins: Their roles and classification. Genetic and ribonic acids |
| XV | Polymers | Categorization: natural and artificial, copolymerization, addition and condensation polymerization techniques. Important polymers include rubber, nylon, polyesters, bakelite, polythene, and nylon. Polymers that are biodegradable and non-biodegradable. |
| XVI | Chemistry in Everyday Life | 1. Chemicals found in medications, such as antibiotics, antacids, antihistamines, antimicrobials, tranquilizers, antiseptics, disinfectants, and analgesics. 2. Chemicals found in food, such as artificial sweeteners, preservatives, and basic antioxidant concepts. 3. Cleansing agents: detergents and soaps with a cleansing effect. |
Biology Syllabus
| Unit | Topic | Subtopics |
|---|---|---|
| Unit I: Reproduction | Reproduction in Organisms | Characteristic feature of all organisms for continuation of species; Modes of reproduction – Asexual and sexual; Asexual reproduction modes – Binary fission, sporulation, budding, gemmule, fragmentation; Vegetative propagation in plants. |
| Sexual Reproduction in Flowering Plants | Flower structure; Development of male and female gametophytes; Pollination – types, agencies, and examples; Outbreeding devices; Pollen-Pistil interaction; Double fertilization; Post-fertilization events – Development of endosperm and embryo, Development of seed and formation of fruit; Special modes – apomixis, parthenocarpy, polyembryony; Significance of seed and fruit formation. | |
| Human Reproduction | Male and female reproductive systems; Microscopic anatomy of testis and ovary; Gametogenesis – spermatogenesis & oogenesis; Menstrual cycle; Fertilisation, embryo development up to blastocyst formation, implantation; Pregnancy and placenta formation (Elementary idea); Parturition (Elementary idea); Lactation (Elementary idea). | |
| Reproductive Health | Need for reproductive health and prevention of sexually transmitted diseases (STD); Birth control – Need and Methods, Contraception and Medical Termination of Pregnancy (MTP); Amniocentesis; Infertility and assisted reproductive technologies – IVF, IUI, ZIFT, GIFT (Elementary idea for general awareness). | |
| Unit II: Genetics and Evolution | Heredity and Variation | Mendelian Inheritance; Deviations from Mendelism – Incomplete dominance, Co-dominance, Multiple alleles and Inheritance of blood groups, Pleiotropy; Elementary idea of polygenic inheritance; Chromosome theory of inheritance; Chromosomes and genes; Sex determination – In humans, birds, honeybee; Linkage and crossing over; Sex-linked inheritance – Haemophilia, Colour blindness; Mendelian disorders in humans – Thalassemia; Chromosomal disorders in humans – Down’s syndrome, Turner’s and Klinefelter’s syndromes. |
| Molecular Basis of Inheritance | Search for genetic material and DNA as genetic material; Structure of DNA and RNA; DNA packaging; DNA replication; Central dogma; Transcription, genetic code, translation; Gene expression and regulation – Lac Operon; Genome and human genome project; DNA fingerprinting. | |
| Evolution | Origin of life; Biological evolution and evidences for biological evolution (Paleontological, comparative anatomy, embryology and molecular evidence); Darwin’s contribution, Modern Synthetic theory of Evolution; Mechanism of evolution – Variation (Mutation and Recombination) and Natural Selection with examples, types of natural selection; Gene flow and genetic drift; Hardy-Weinberg’s principle; Adaptive Radiation; Human evolution. | |
| Unit III: Biology and Human Welfare | Health and Disease | Pathogens; parasites causing human diseases (Malaria, Filariasis, Ascariasis, Typhoid, Pneumonia, common cold, amoebiasis, ringworm); Basic concepts of immunology – vaccines; Cancer, HIV and AIDS; Adolescence, drug and alcohol abuse. |
| Improvement in Food Production | Plant breeding, tissue culture, single-cell protein, Biofortification; Apiculture and Animal husbandry. | |
| Microbes in Human Welfare | In household food processing, industrial production, sewage treatment, energy generation and as biocontrol agents and biofertilizers. | |
| Unit IV: Biotechnology and Its Applications | Principles and Process of Biotechnology | Genetic engineering (Recombinant DNA technology). |
| Application of Biotechnology in Health and Agriculture | Human insulin and vaccine production, gene therapy; Genetically modified organisms – BT crops; Transgenic Animals; Biosafety issues – Biopiracy and patents. | |
| Unit V: Ecology and Environment | Organisms and Environment | Habitat and niche; Population and ecological adaptations; Population interactions – mutualism, competition, predation, parasitism; Population attributes – growth, birth rate and death rate, age distribution. |
| Ecosystems | Patterns, components; productivity and decomposition; Energy flow; Pyramids of number, biomass, energy; Nutrient cycling (carbon and phosphorous); Ecological succession; Ecological Services – Carbon fixation, pollination, oxygen release. | |
| Biodiversity and its Conservation | Concept of Biodiversity; Patterns of Biodiversity; Importance of Biodiversity; Loss of Biodiversity; Biodiversity conservation; Hotspots, endangered organisms, extinction, Red Data Book, biosphere reserves, National parks and sanctuaries, sacred groves, in-situ & ex-situ. | |
| Environmental Issues | Air pollution and its control; Water pollution and its control; Agrochemicals and their effects; Solid waste management; Radioactive waste management; Greenhouse effect and global warming; Ozone depletion; Deforestation; Any three case studies as success stories addressing environmental issues. |
MATHEMATICS/APPLIEDMATHEMATICS Syllabus
The topics covered in Section A:
| Section A | Topic | Subtopic |
|---|---|---|
| 1. Algebra | Application of Integration | Area under the curve; Matrices and types of Matrices; Equality of Matrices; Transpose of a Matrix; Symmetric and Skew Symmetric Matrix; Formulating and solving of differential equations; Determinants with variable separable; Inverse of a Matrix; Solving simultaneous equations using Matrix Method. |
| 2. Calculus | Differentiation | Higher order derivatives; Tangents and Normals; Increasing and Decreasing Functions; Variance and Standard Deviation of a random variable; Binomial Distribution; Maxima and Minima. |
| 3. Integration | Integration and its Applications | Indefinite integrals of simple functions; Evaluation of indefinite integrals; Definite Integrals; Optimal feasible solution. |
| 4. Differential Equations | Basics | Order and degree of differential equations; Algebra of Matrices. |
| 5. Probability Distributions | Basics | Random variables and its probability distribution; Expected value of a random variable. |
| 6. Linear Programming | Basics | Mathematical formulation of Linear Programming Problem; Graphical method of solution for problems in two variables; Feasible and infeasible regions. |
The topics covered in Section B1 and Section B2:
| Section | Unit | Topic | Subtopic |
|---|---|---|---|
| Mathematics | Unit I: Relations and Functions | Relations and Functions | Types of relations: Reflexive, symmetric, transitive and equivalence relations; One to one and onto functions; Composite functions; Inverse of a function; Binary operations. |
| Inverse Trigonometric Functions | Definition, range, domain, principal value branches; Graphs of inverse trigonometric functions; Elementary properties of inverse trigonometric functions. | ||
| Unit II: Algebra | Matrices | Concept, notation, order, equality, types of matrices, zero matrix, transpose of a matrix, symmetric and skew-symmetric matrices; Addition, multiplication and scalar multiplication of matrices; Properties of matrices; Invertible matrices and proof of the uniqueness of inverse; Elementary row and column operations. | |
| Determinants | Determinant of a square matrix, properties of determinants, minors, cofactors, applications of determinants in finding the area of a triangle; Adjoint and inverse of a square matrix; Consistency, inconsistency and number of solutions of system of linear equations by examples; Solving system of linear equations in two or three variables using inverse of a matrix. | ||
| Unit III: Calculus | Continuity and Differentiability | Continuity and differentiability, derivative of composite functions, chain rule, derivatives of inverse trigonometric functions, derivative of implicit function; Concepts of exponential, logarithmic functions; Derivatives of log x and e^x; Logarithmic differentiation; Derivative of functions expressed in parametric forms; Second-order derivatives; Rolle’s and Lagrange’s Mean Value Theorems and their geometric interpretations. | |
| Applications of Derivatives | Rate of change, increasing/decreasing functions, tangents and normals, approximation, maxima and minima; Simple problems illustrating basic principles and understanding of real-life situations. | ||
| Integrals | Integration as inverse process of differentiation; Integration of a variety of functions by substitution, by partial fractions, and by parts; Definite integrals as a limit of a sum; Fundamental Theorem of Calculus; Basic properties of definite integrals and evaluation of definite integrals. | ||
| Applications of the Integrals | Finding the area under simple curves, especially lines, arcs of circles/parabolas/ellipses, area between the two curves. | ||
| Differential Equations | Definition, order and degree, general and particular solutions of a differential equation; Formation of differential equations; Solutions of linear differential equations of the type dy/dx + Py = Q or x dy/dx + Px = Q. | ||
| Unit IV: Vectors and Three-Dimensional Geometry | Vectors | Vectors and scalars, magnitude and direction of a vector; Direction cosines/ratios of vectors; Types of vectors; Position vector of a point; Components of a vector; Addition, multiplication, and scalar product of vectors; Scalar (dot) product of vectors; Vector (cross) product of vectors. | |
| Three-dimensional Geometry | Direction cosines/ratios of a line joining two points; Cartesian and vector equation of a line; Coplanar and skew lines; Shortest distance between two lines; Cartesian and vector equation of a plane; Angle between two lines, two planes, a line and a plane; Distance of a point from a plane. | ||
| Unit V: Linear Programming | Introduction and related terminology | Constraints, objective function, optimization, types of linear programming (L.P.) problems; Mathematical formulation of L.P. problems. | |
| Graphical method of solution for problems in two variables; Feasible and infeasible regions; Feasible and infeasible solutions, optimal feasible solutions. | |||
| Unit VI: Probability | Multiplication theorem on probability | Conditional probability, independent events, total probability, Bayes’ theorem; Random variable and its probability distribution; Mean and variance of a random variable; Repeated independent (Bernoulli) trials and Binomial distribution. | |
| Applied Mathematics | Unit I: Numbers, Quantification and Numerical Applications | Modulo Arithmetic | Define modulus of an integer; Apply arithmetic operations using modular arithmetic rules. |
| Congruence Modulo | Define congruence modulo; Apply the definition in various problems. | ||
| Allegation and Mixture | Understand the rule of allegation to produce a mixture at a given price; Determine the mean price of a mixture; Apply the rule of allegation. | ||
| Numerical Problems | Solve real-life problems mathematically. | ||
| Boats and Streams | Distinguish between upstream and downstream; Express the problem in the form of an equation. | ||
| Pipes and Cisterns | Determine the time taken by two or more pipes to fill or empty a tank. | ||
| Races and Games | Compare the performance of two players with respect to time, distance taken/covered, or work done from the given data. | ||
| Partnership | Differentiate between active partner and sleeping partner; Determine the gain or loss to be divided among the partners in the ratio of their investment. | ||
| Numerical Inequalities | Describe the basic concepts of numerical inequalities; Understand and write numerical inequalities. | ||
| Unit II: Algebra | Matrices and types of matrices | Define matrix; Identify different kinds of matrices. | |
| Equality of matrices, Transpose of a matrix, Symmetric and Skew symmetric matrix | Determine equality of two matrices; Write transpose of a given matrix; Define symmetric and skew-symmetric matrix. | ||
| Unit III: Calculus | Higher Order Derivatives | Determine second and higher order derivatives; Identify dependent and independent variables. | |
| Marginal Cost and Marginal Revenue using derivatives | Define marginal cost and marginal revenue; Find marginal cost and marginal revenue. | ||
| Maxima and Minima | Determine critical points of the function; Find the point(s) of local maxima and local minima and corresponding values. | ||
| Unit IV: Probability Distributions | Probability Distribution | Understand the concept of Random Variables and its Probability Distributions; Find probability distribution of a discrete random variable. | |
| Mathematical Expectation | Apply arithmetic mean of frequency distribution to find the expected value of a random variable. | ||
| Variance | Calculate the Variance and S.D. of a random variable. | ||
| Unit V: Index Numbers and Time Based Data | Index Numbers | Define Index numbers as a special type of average. | |
| Construction of Index numbers | Construct different types of index numbers; Apply time reversal test. | ||
| Test of Adequacy of Index Numbers | Apply time reversal test. | ||
| Time Series | Identify time series as chronological data; Distinguish between different components of time series. | ||
| Time Series analysis for univariate data | Solve practical problems based on statistical data and interpret. | ||
| Unit VI: Inferential Statistics | Population and Sample | Define Population and Sample; Differentiate between population and sample. | |
| Parameter and Statistics and Statistical Interferences | Define Parameter and Statistics with reference to Population and Sample; Explain the relation between Parameter and Statistic; Explain the limitation of Statistic to generalize the estimation for population; Interpret the concept of Statistical Significance and Statistical Inferences. | ||
| Central Limit Theorem | State Central Limit Theorem; Explain the relation between Population-Sampling Distribution-Sample. | ||
| Unit VII: Financial Mathematics | Perpetuity, Sinking Funds | Explain the concept of perpetuity and sinking fund; Calculate perpetuity. | |
| Valuation of Bonds | Define the concept of valuation of bond and related terms; Calculate value of bond using present value approach. | ||
| Calculation of EMI | Explain the concept of EMI; Calculate EMI using various methods. | ||
| Linear method of Depreciation | Define the concept of linear method of Depreciation; Interpret cost, residual value, and useful life of an asset from the given information; Calculate depreciation. | ||
| Unit VIII: Linear Programming | Introduction and related terminology | Familiarize with terms related to Linear Programming Problem. | |
| Mathematical formulation of Linear Programming Problem | Formulate Linear Programming Problem. | ||
| Different types of Linear Programming Problems | Identify and formulate different types of LPP. | ||
| Graphical Method of Solution for problems in two Variables | Draw the Graph for a system of linear inequalities involving two variables and to find its solution graphically. | ||
| Feasible and Infeasible Regions | Identify feasible, infeasible, and bounded regions. | ||
| Feasible and infeasible solutions, optimal feasible solution | Understand feasible and infeasible solutions; Find optimal feasible solution. |
Computer Science/Informatics Practices Syllabus
| Section | Unit | Topic | Subtopic |
|---|---|---|---|
| Computer Science | Chapter 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. | ||
| 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 | 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. | |
| Chapter 6: Understanding Data | Understanding Data | Data and its purpose, collection and organization; Understanding data using statistical methods: mean, median, standard deviation, variance; Data interpretation; Visualization of data. | |
| 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 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. | ||
| Chapter 8: Structured Query Language | 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. | |||
| 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 concept of MAC and IP Address; Difference between Internet and web. | ||
| Informatics Practices | Chapter 1: Database Query using SQL | Introduction to Python libraries | Pandas, NumPy, Matplotlib; Data structures in Pandas – Series and DataFrames. |
| Data Handling using Pandas – I | Series: Creation of Series from – and array, dictionary, scalar value; Mathematical operations; Head and Tail functions; Selection, Indexing, and Slicing. | ||
| DataFrames: 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 using Labels, Boolean Indexing; Styling & Formatting data, Head and Tail functions; Joining, Merging, and Concatenations. | |||
| Importing/Exporting Data between CSV files and DataFrames; 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 2: Data Handling using Pandas – II | 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. | |
| Chapter 3: 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 web page, web server, and hosting of a website. | |||
| Web Browsers: Introduction, commonly used browsers, browser settings, add-ons and plugins, cookies; 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. | |||
| E-waste its a hazard and management; Awareness about health concerns related to the usage of technology like effect on eyesight, physiological issues, and ergonomic aspects. | |||
| 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). | ||
| 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. |
