CBSE, Class XII Computer Science

Download CBSE Class 12 Computer Science Question Papers with solutions and latest Sample Papers, notes, practicals and other study material for all important topics like arrays, boolean algebra, c++ revision tour, classes and objects, communication and network concepts, constructors and destructors, data file handling, database concepts, etc, access free study material in pdf, practice to get better marks in examinations. all study material has been prepared based on latest guidelines, term examination pattern and blueprint issued by cbse and ncert

click below for class 12 computer science solved sample papers worksheets, assignments, syllabus, ncert cbse books, ncert solutions, hots, multiple choice questions (mcqs), easy to learn concepts and study notes of all chapters


Prerequisite 

Good understanding of Class 11 Computer Science

Learning Outcomes

  1. Understand the concept of functions and recursion.
  2. Learn how to create and use Python libraries.
  3. Learn file handling.
  4. Learn about the concept of efficiency in algorithms and computing in general.
  5. Learn basic data structures: lists, stacks, and queues.
  6. Get a basic understanding of computer networks: network stack, basic network hardware, basic protocols, and basic tools.
  7. Connect a Python program with an SQL database, and learn aggregation functions in SQL.
  8. Have  a  clear  understanding  of  cyber  ethics  and  cybercrime.  Understand  the  value  of technology in societies, gender and disability issues, and the technology behind biometric ids.

 

Distribution of Marks

Unit No.

Unit Name

Marks

1.

Programming and Computational Thinking – 2

30

2.

Computer Networks

15

3.

Data Management – 2

15

4.

Society, Law and Ethics – 2

10

5.

Practicals

30

 

Total

100

 

Unit 1: Programming and Computational Thinking (PCT-2)     (80 Theory + 70 Practical)

  1. Revision of the basics of Python
  2. Functions: scope, parameter passing, mutable/immutable properties of data objects, pass arrays to functions, return values, functions using libraries: mathematical, and string functions.
  3. File handling: open and close a file, read, write, and append to a file, standard input, output, and error streams, relative and absolute paths.
  4. Using Python libraries: create and import Python libraries
  5. Recursion:  simple  algorithms  with  recursion:  factorial,  Fibonacci  numbers;  recursion  on arrays: binary search
  6. Idea of efficiency: performance defined as inversely proportional to the wall clock time, count the number of operations a piece of code is performing, and measure the time taken by a program. Example: take two different programs for the same problem, and understand how the efficient one takes less time.
  7. Data visualization using Pyplot: line chart, pie chart, and bar chart.
  8. Data-structures: lists, stacks, queues.

 

Unit 2: Computer Networks (CN)              (30 Theory + 10 Practical)

  1. Structure of a network: Types of networks: local area and wide area (web and internet), new technologies such as cloud and IoT, public vs. private cloud, wired and wireless networks; concept of a client and server.
  2. Network devices such as a NIC, switch, hub, router, and access point.
  3. Network stack: amplitude and frequency modulation, collision in wireless networks, error checking, and the notion of a MAC address, main idea of routing. IP addresses: (v4 and v6), routing table, router, DNS, and web URLs, TCP: basic idea of retransmission, and rate modulation when there is congestion (analogy to a road network), Protocols: 2G, 3G, 4G, Wi- Fi. What makes a protocol have a higher bandwidth?
  4. Basic network tools: traceroute, ping, ipconfig, nslookup, whois, speed-test.
  5. Application layer: HTTP (basic idea), working of email, secure communication: encryption and certificates (HTTPS), network applications: remote desktop, remote login, HTTP, FTP, SCP, SSH, POP/IMAP, SMTP, VoIP, NFC.

 

Unit 3: Data Management (DM-2)            (20 Theory + 20 Practical)

  1. Write a minimal Django based web application that parses a GET and POST request, and writes the fields to a file - flat file and CSV file.
  2. Interface Python with an SQL database
  3. SQL commands: aggregation functions – having, group by, order by.

 

Unit 4: Society, Law and Ethics (SLE-2)    (10 Theory)

  1. Intellectual property rights, plagiarism, digital rights management, and licensing (Creative Commons, GPL and Apache), open source, open data, privacy.
  2. Privacy laws, fraud; cyber-crime- phishing, illegal downloads, child pornography, scams; cyber forensics, IT Act, 2000.
  3. Technology and society: understanding of societal issues and cultural changes induced by technology.
  4. E-waste management: proper disposal of used electronic gadgets.
  5. Identity theft, unique ids, and biometrics.
  6. Gender and disability issues while teaching and using computers.

 Also refer to NCERT Solutions for all classes by clicking here - NCERT Solutions

Practical

S.No.

 

Unit Name

Marks (Total=30)

1.

 

 

Lab Test (10 marks)

 

 

Python program (60% logic + 20% documentation + 20% code quality)

7

 

 

Small Python program that sends a SQL query to a database and displays the result. A stub program can be provided.

3

 

2.

 

Report File + viva(9 marks)

 

 

Report file: Minimum 21 Python programs. Out of this at least 4 programs should send SQL commands to a database and retrieve the result; at least 1 program should implement the web server to write user data to a CSV file.

7

 

 

Viva voce based on the report file

 

2

 

3.

 

Project + viva (11 marks)

 

 

Project (that uses most of the concepts that have been learnt)

8

 

 

Project viva voce

 

 

3

 

 

Some sample lab assignments are as follows:

Programming in Python:

  1. Recursively find the factorial of a natural number.
  2. Read a file line by line and print it.
  3. Remove all the lines that contain the character `a' in a file and write it to another file.
  4. Write a Python function sin(x, n) to calculate the value of sin(x) using its Taylor series expansion up to n terms. Compare the values of sin(x) for different values of n with the correct value.
  5. Write  a  random  number  generator  that  generates  random  numbers  between  1  and  6 (simulates a dice).
  6. Write a recursive code to find the sum of all elements of a list.
  7. Write a recursive code to compute the nth Fibonacci number.
  8. Write a Python program to implement a stack and queue using a list data-structure.
  9. Write a recursive Python program to test if a string is a palindrome or not.
  10. Write a Python program to plot the function y = x2 using the pyplot or matplotlib libraries.
  11. Create a graphical application that accepts user inputs, performs some operation on them, and then writes the output on the screen. For example, write a small calculator. Use the tkinter library.
  12. Open a webpage using the urllib library.
  13. Compute EMIs for a loan using the numpy or scipy libraries.
  14. Take a sample of 10 phishing e-mails and find the most common words.

 

Data Management: SQL and web-server

  1. Find the min, max, sum, and average of the marks in a student marks table.
  2. Find the total number of customers from each country in the table (customer ID, customer name, country) using group by.
  3. Write a SQL query to order the (student ID, marks) table in descending order of the marks.
  4. Integrate SQL with Python by importing the MySQL module
  5. Write a Django based web server to parse a user request (POST), and write it to a CSV file.

 

Project

The aim of the class project is to create something that is tangible and useful. This should be done in groups of 2 to 3 students, and should be started by students at least 6 months before the submission deadline. The aim here is to find a real world problem that is worthwhile to solve. Students are encouraged to visit local businesses and ask them about the problems that they are facing. For example, if a business is finding it hard to create invoices for filing GST claims, then students can do a project that takes the raw data (list of transactions), groups the transactions by category, accounts for the GST tax rates, and creates invoices in the appropriate 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 disabled fellow students, and mobile applications, Of course to do some of this projects, some additional learning is required; this should be encouraged. Students should know how to teach themselves.

If three people work on a project for 6 months, at least 500 lines of code is expected. The committee has also been made aware about the degree of plagiarism in such projects. Teachers should take a very strict look at this situation, and take very strict disciplinary action against students who are cheating on lab assignments, or projects, or using pirated software to do the same. Everything that is proposed can be achieved using absolutely free, and legitimate open source software.

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

CBSE advisory on student marks

CBSE has issued a public advisory for all students to be careful from unscrupulous persons impersonating themselves as officers/officials of CBSE. These people have been contacting parents and have been telling them that they have access to student marks data for Board...

Board Cancelled Official CBSE Statement

Keeping in view the requests received from various State Governments and the changed circumstances as on date, following has been decided- 1. Examinations for classes X and XII which were scheduled from 1st July to 15th, 2020 stand cancelled. 2. Assessment of the...

CBSE Decision on Board Exam 2020

The Class 10 and 12 exams are cancelled, and results for both 10th and 12th would be declared by July 15 based on internal exams. CBSE Class 12 students would have the option to appear for the exams at a later date. CBSE has a scheme in which marks scored in past 3...

Class 12 Board Exams Datesheet Announced

CBSE has announced the datesheet of the remaining class 12 board exams, see below:  

Board Exams Class 10 and Class 12 Datesheet 2020

CBSE has announced the datesheet for the remaining exams of class 10 and class 12 exams. The exams are going to start in July. The class 10 and 12th board exams will be conducted for the remaining 29 papers from July 1 to July 15, 2020, at various centers nominated by...

×
Studies Today