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:

unit no

unit name

term 2

I

Computational Thinking and Programming – 2

5

Second

computer network

10

third

database management

20

gross

35

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

serial number

term 2

1

lab test

1. Python Program

2

2. 3 SQL queries based on one/two tables, 2 output queries based on SQL queries

4

2

report file:

Term-1: Term-1. Minimum 15 Python programs based on

syllabus

Term – 2 :

– Term-2. Minimum 3 Python programs based on

syllabus

– SQL Queries – one table / two . Minimum 5 sets using

Table.

– Minimum 2 programs based on Python-SQL connectivity.

3

3

Project (using concepts learned in Class 11 and 12)

Term-1: Summary of the project to be submitted by the students (documents only, code cannot be submitted during term-1)

Term – 2 : Final Coding + Viva Voice

(Students will be allowed to modify their Term 1 document and submit the final executable code.)

5

4

oral test

1

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.

( डाउनलोड करे Govt Jobs App )

Download Our Android App  – Download Latest Govt Jobs App

10th12thPassGovtJobs.Com Home – Click here

Subscribe to Our YouTube, Instagram and Twitter – TwitterYoutube and Instagram.

Join Our Telegram Group for Instant Job and Study Information Daily Update

>>>Click Here<<<


Type and Ask Your Questions here OR Leave A Comment For Any Doubt And Query -

Leave a Reply



DISCLAIMER: 10th12thPassGovtJobs.Com does not have any connection with the Government and it does not represent any Government entity. No claim is made about the accuracy or validity of the content on this site, or its suitability for any specific purpose whatsoever whether express or implied. Since all readers who access any information on this web site are doing so voluntarily, and of their own accord, any outcome (decision or claim) of such access. All the Readers please also check details on the Original website before taking any decision. Here we are not responsible for any Inadvertent Error that may have crept in the information being published in this Website and for any loss to anybody or anything caused by any Shortcoming, Defect or Inaccuracy of the Information on this Application.