CBSE Class 12 Computer Science Deleted Syllabus 2022 For Term 1 and 2

·         print  a  message forever, the sum of  first  n natural numbers, factorial, Fibonacci numbers, recursion on arrays: binary search

·          Idea of efficiency: performance measurement in terms of the number of operations.

·         Data-structures: Lists as covered in Class  XI, Stacks – Push, Pop using a  list,  Queues – Insert, Delete using a  list.

·         E-commerce payment transactions using online banking,  mobile banking,  payment apps, and services.

● Recursively find the factorial of a natural number

● Write a recursive code to find the sum of all elements of a list.

● Write a recursive code to compute the nth Fibonacci number

● Functions:  scope, parameter passing,    mutable/immutable properties of data objects, passing strings, lists, tuples, dictionaries to functions, default parameters,  positional parameters,  return values,  functions using libraries: mathematical and string functions.

● File handling: Need for a data file, Types of files: Text files, Binary files, and  CSV (Comma-separated values) files.

●Text  File:  Basic operations on a  text file:  Open  (filename  – absolute or relative path,  mode),  Close a text file, Reading and  Manipulation of data from a  text file, Appending data into a  text file, standard input/output, and error streams, relative and absolute paths.

●Binary   File:   Basic operations on a   binary file:   Open   (filename   – absolute or relative path,  mode),  Close a binary file, Pickle Module – methods load and dump;  Read, Write/Create,  Search, Append and Update operations in a binary file.

● CSV File: Import csv module, functions – Open,  Close a csv file,  Read from  a  csv file  and   Write  into  a  csv file  using  csv.reader (  )  and csv.writerow( ).

● Using Python  libraries: Import Python  libraries.

● Data-structures: Lists as covered in Class XI, Stacks – Push, Pop using a list.

● Data  Communication terminologies: Concept of  Channel,  Bandwidth (Hz,  kHz,  MHz), and   Data transfer rate (bps,  Kbps,  Mbps,  Gbps, Tbps).

●Transmission media:  Twisted pair cable,  coaxial cable,  optical fiber, infrared, radio link, microwave link, and satellite link.

●Network devices:  Modem,   RJ45  connector,  Ethernet  Card,   Router, Switch, Gateway, WiFi card.

●Network  Topologies and types:  Bus,  Star,   Tree,   PAN,  LAN, WAN, MAN.

●Network  Protocol:  TCP/IP,  File  Transfer  Protocol  (FTP),  PPP, HTTP, SMTP,  POP3, Remote Login (Telnet) and  Internet, Wireless / Mobile Communication protocol such as GSM, GPRS, and  WLL.

●Mobile  Telecommunication  Technologies:  1G,  2G,  3G,  4G, and  5G; Mobile processors;

Electronic  mail protocols  such as SMTP,  POP3, Protocols  for  Chat and  Video  Conferencing:  VoIP,  Wireless  technologies  such as Wi-Fi and WiMax

Threats and  prevention from Viruses, Worms, Trojan horse, Spams

Use of Cookies, Protection using Firewall, https;

India IT Act, Cyber Law, Cyber  Crimes, IPR issues, hacking.

● Introduction  To Web  services:  WWW, Hyper  Text  Markup  Language (HTML), Extensible  Markup  Language  (XML); Hyper  Text  Transfer Protocol  (HTTP); Domain  Names; URL; Website,  Web  browser, Web

Servers; Web Hosting.

·         Relational data model: Concept of the domain, relation, tuple, attribute, degree, cardinality,  key,  primary key, candidate  key,  alternate key, and  foreign key;

·         Structured Query Language:

·         General Concepts: Advantages of using SQL, Data Definition

·         Language and Data Manipulation Language;

·         Data  Types: number / decimal, character / varchar / varchar2, date; SQL commands covered in class XI (2019-20)

·         SELECT,  DISTINCT, FROM, WHERE, IN, BETWEEN, LIKE, NULL / IS NULL, ORDER BY, GROUP  BY, HAVING;

·         SQL functions: SUM ( ), AVG ( ), COUNT ( ), MAX ( ) and  MIN ( );

·         Joins: equi-join and  natural join

·         Interface of Python  with an SQL database

·      Connecting SQL with Python

·      Creating Database connectivity Applications

·      Performing Insert, Update, Delete queries