CBSE Class 12 Computer Science Syllabus for Term 2 Exam 2022 (PDF) with CBSE Sample Papers, Marking Scheme

Check and download CBSE Class 12 Computer Science Term 2 Syllabus 2022 in PDF here. The link to download Term 2 CBSE Class 12 Computer Science Syllabus 2022 PDF is given at the end of this article. Go through the syllabus and prepare for CBSE Class 12 Computer Science Term 2 Exam 2022 as per the weightage and content mentioned in it.

Read also| CBSE Class 12 Computer Science Sample Paper and Marking Scheme for Term 2 Exam 2022

Term 2 CBSE Class 12 Computer Science Syllabus 2022:

Term 2:

Unit I: Computational Thinking and Programming – 2

Data Structure: Stack, operations on the stack (push and pop), implementation of a stack using a list.

Unit II: Computer Networks

Development of Networking: Introduction to Computer Networks, Development of Networking (ARPANET, NSFNET, INTERNET)

Data Communication Terminology: Concept of Communication, Components of Data Communication (Sender, Receiver, Message, Communication Media, Protocol), Measuring Capacity of Communication Media (Bandwidth, Data Transfer Rate), IP Address, Switching Techniques (Circuit Switching, Packet Switching) ) )

Transmission media: wired communication media (twisted pair cable, coaxial cable, fiber-optic cable), wireless media (radio waves, microwave, infrared waves)

Network equipment (modem, ethernet card, RJ45, repeater, hub, switch, router, gateway, wifi card)

Network Topology and Network Types: Network Types (PAN, LAN, MAN, WAN), Networking Topologies (Bus, Star, Tree)

Network Protocols: HTTP, FTP, PPP, SMTP, TCP/IP, POP3, HTTPS, TELNET, VoIP

Introduction to Web Services: WWW, Hyper Text Markup Language (HTML), Extensible Markup Language (XML), Domain Name, URL, Website, Web Browser, Web Server, Web Hosting

Unit III: Database Management

Database Concepts: Introduction to Database Concepts and Its Need

Relational data model: relation, attribute, tuple, domain, degree, cardinality, key (candidate key, primary key, alternate key, foreign key)

Structured Query Language: Introduction, Data Definition Language, and Data Manipulation

language, data type (char(n), varchar(n), int, float, date), constraints (not null, unique, primary

key), create database, use database, show database, drop database, show table, create table, describe table, alter table (add and delete an attribute, add and delete primary key), drop table, insert , delete, select, operators (mathematical, relational and logical), aliasing, distinct clauses, where clauses, between, order by, means zero, is null, is not null, eg, update order, delete order

Aggregate functions (max, min, average, sum, count), group by, having clause, joins: cartesian product on two tables, same-join and natural join

Python’s interface with a SQL database: Connect SQL to Python, Insert, Update, Delete query using Cursor, Display data using fetchone(), fetchall(), rowcount, Build a database connectivity application

practical

Term-2

python programming

Write a Python program to implement a stack using a list.

database management

Create student table and insert data. Apply the following SQL command to the Student table:

o ALTER TABLE to add new attributes / modify data type / drop attribute

o Update table to modify data

o Commands to display the data in ascending/descending order

o DELETE to remove the tuple

o GROUP BY and find min, max, sum, count and average

o Joining two tables.

Similar exercises can be designed for other cases.

Integrate SQL with Python by importing an appropriate module.

database management

Create student table and insert data. Apply the following SQL command to the Student table:

o ALTER TABLE to add new attributes / modify data type / drop attribute

o Update table to modify data

o Commands to display the data in ascending/descending order

o DELETE to remove the tuple

o GROUP BY and find min, max, sum, count and average

Similar exercises can be designed for other cases.

Integrate SQL with Python by importing an appropriate module.

7. Suggested Reading Materials

NCERT Textbook for Computer Science (Class XII)

Help material on CBSE website.

8. Project

The class project aims to create something that is tangible and useful using Python file handling / Python-SQL connectivity. This should be done in groups of two to three students and started by students at least 6 months before the submission deadline. The objective here is to find a real world problem that is solvable.

Students are encouraged to visit local businesses and ask them about the problems they are facing.

For example, if a business is finding it difficult to generate invoices for filing GST claims, students can do a project that takes the raw data (list of transactions), transacts by category, GST tax Accounts for rates, and generates invoices in proper format. Students can be extremely creative here.

They can use a wide variety of Python libraries to create user-friendly applications such as games, software for their school, software for their fellow students with disabilities, and mobile applications, of course, to do some of these projects. requires some additional learning; It should be encouraged.

Students should know how to teach themselves.

Students should be sensitized to avoid plagiarism and copyright issues infringement while working on projects. For this teachers should take necessary steps.