Comprehensive notes Deleted portion Computer Science Class 12

In this article, you will get Deleted portion Computer Science Class 12. So let us begin. So keep the textbook index open and cross-mark the chapters and points discussed here. So let us begin!

Disclaimer: This article is written with the intention to help students and teachers to get ideas for their curriculum. I am not violating any rule or legal conditions with this article. Till anybody has any concern about this article, please got to contact us section and write about it. I will look into the matter and try to resolve it.

This article is written in the view of the textbook Computer Science with Python Textbook for Class XII by Sumita Arora to help the community.

Deleted portion Computer Science Class 12

Let’s start with the article deleted portion of computer science class 12 with the textbook index containing chapters. So these are the total chapters included in the textbook.

Ch No.Chapter NameCh No.Chapter Name
1Python Revision Tour I9Data Strcuture  II – Stack and Queue Using Lists
2Python Revision Tour I10Computer Networks – I
3Working With Functions11Computer Networks – II
4Using Python Libraries12Relational Databases
5File Handling13Simple Queries in SQL
6Recursion14Table creation and Data Manipulation Commands
7Idea of Algorithmic Efficiency15Grouping Records and Joins in SQL
8Data Structure – I : Linear Lists16Interface Python with MySQL

Let us see which chapters and topics are not to be covered in your current syllabus.

Chapterwise topics are as follows:

Python Revision Tour

No topic is mentioned in the syllabus.

Functions

The following topics need to be covered in this chapter from the syllabus:

  1. types of function (built-in functions, functions defined in module, user-defined functions)
  2. creating user-defined function
  3. arguments and parameters, default parameters, positional parameters,
  4. function returning value(s)
  5. flow of execution
  6. scope of a variable (global scope, local scope)

There is no extra topic given for this chapter in the textbook. So nothing is deleted from this chapter.

Exception Handling

This is a new addition to the Computer Science Class XII syllabus. The topics covered in this section are as follows:

  1. Introduction
  2. handling exceptions using try-except-finally blocks

Now in the next section of a Deleted portion of Computer Science Class 12, we will discuss these topics.

File handling

This is one of the large topics in the computer science class XII syllabus. Topics covered in this chapter are as follows:

  1. Introduction to files, types of files (Text file, Binary file, CSV file)
  2. relative and absolute paths
  3. Text file
    • opening a text file
    • text file open modes (r, r+, w, w+, a, a+)
    • closing a text file
    • opening a file using with clause
    • writing/appending data to a text file using write() and writelines()
    • reading from a text file using read(), readline() and readlines()
    • seek and tell methods
    • manipulation of data in a text file
  4. Binary file
    • basic operations on a binary file
    • open using file open modes (rb, rb+, wb, wb+, ab, ab+)
    • close a binary file
    • import pickle module
    • dump() and load() method
    • read, write/create, search, append and update operations in a binary file
  5. CSV file
    • import csv module
    • open / close csv file
    • write into a csv file using writer(),writerow(),writerows() and read from a csv file using reader()

Data Structure

From this section, the following topics should be covered in the syllabus.

  1. Stack
  2. operations on stack (push & pop)
  3. implementation of stack using list

In a few textbooks queues and other topics are also given which are not to be covered in the syllabus as per the curriculum document.

Computer Networks

From this section following topics should be covered in the syllabus. These topics are:

  1. Evolution of networking
    • introduction to computer networks
    • evolution of networking (ARPANET, NSFNET, INTERNET)
  2. Data communication terminologies
    • concept of communication
    • components of data communication (sender, receiver, message, communication media, protocols)
    • measuring capacity of communication media (bandwidth, data transfer rate), IP address,
  3. switching techniques (Circuit switching, Packet switching)
  4. Transmission media
    • Wired communication media
      • Twisted pair cable
      • Co-axial cable
      • Fiber-optic cable)
    • Wireless media
      • Radio waves,
      • Microwaves
      • Infrared waves
  5. Network devices
    • Modem
    • Ethernet card
    • RJ45
    • Repeater
    • Hub
    • Switch
    • Router
    • Gateway
    • WIFI card
  6. Network topologies and Network types:
    • types of networks
      • PAN
      • LAN
      • MAN
      • WAN)
    • networking topologies
      • Bus
      • Star
      • Tree
  7. Network protocol
    • HTTP, FTP, PPP, SMTP, TCP/IP, POP3, HTTPS, TELNET, VoIP
  8. Introduction to web services
    • WWW
    • Hyper Text Markup Language (HTML)
    • Extensible Markup Language (XML)
    • domain names
    • URL
    • website
    • web browser
    • web servers
    • web hosting
  9. Database Management
    • Database concepts
      • introduction to database concepts and its need
    • Relational data model
      • relation, attribute, tuple, domain, degree, cardinality
      • keys (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 databases, drop database, show tables, create table, describe table, alter table (add and remove an attribute, add and remove primary key), drop table, insert, delete, select, operators (mathematical, relational and logical), aliasing, distinct clause, where clause, in, between, order by, meaning of null, is null, is not null, like, update command, delete command, aggregate functions (max, min, avg, sum, count), group by, having clause
    • joins
      • cartesian product on two tables
      • equi-join and natural join
  10. Interface of python with an SQL database
    • connecting SQL with Python
    • performing insert, update, delete queries using cursor
    • display data by using connect(), cursor(), execute(), commit(), fetchone(), fetchall(), rowcount,
    • creating database connectivity applications
    • use of %s format specifier or format() to perform queries

Download PPT to know the deleted topics

Deleted chapters Computer Science Class 12

Thank you for reading this article. I hope this article will help the students’ and teachers’ community. Feel free to ask your doubts in the comment section.

Leave a Reply