Bihar Board Class 12 Computer Science Syllabus 2024-25 - Download Syllabus PDF

Unit 1: Programming and Computational Thinking (PCT-2)

Python fundamentals revision.

Scope, parameter passing, mutable/immutable data object characteristics, sending arrays to functions, return values, and functions employing libraries: string and mathematical functions.

Standard input, output, and error streams; relative and absolute paths; opening and closing files; reading, writing, and appending to files.

Create and import Python libraries by using Python libraries.

Simple recursive algorithms include factorial and Fibonacci numbers, and binary search uses recursion on arrays.

Definition of efficiency: count the number of operations a piece of code is executing and time spent by a program. Performance is defined as being inversely proportional to clock time. As an illustration, compare two programs that address the same issue and observe which is more time-effective.

Data visualization using Pyplot: line chart, pie chart, and bar chart.

Data-structures: lists, stacks, queues

Unit 2: Computer Networks (CN)

Network strutcture: Local and wide area (web and internet) network types; cloud and Internet of Things (IoT) technologies; public vs. private cloud; wired and wireless network types; client and server concepts.

Computer network interface cards (NICs), switches, hubs, routers, and access points.

Network stack: MAC addresses, error checking, wireless network collisions, amplitude and frequency modulation, and the fundamentals of routing. IP addresses (both v4 and v6), DNS, router, routing table, and site URLs TCP: fundamental retransmission concept, rate modulation in congested areas (like a road network), Protocols: WiFi, 2G, 3G, and 4G. What contributes to a protocol's increased bandwidth?

Traceroute, ping, ipconfig, nslookup, whois, and speed-test are examples of basic network tools.

Network applications: remote desktop, remote login, HTTP, FTP, SCP, SSH, POP/IMAP, SMTP, VoIP, NFC.

Application layer: HTTP (basic concept), working of email, secure communication: encryption and certificates (HTTPS).

Unit 3: Data Management

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.

Interface Python with an SQL database.

SQL commands: aggregation functions – having, group by, order by.

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

Intellectual property rights, plagiarism, digital rights management, and licensing (Creative Commons, GPL and Apache), open source, open data, privacy.

comprehending societal concerns and cultural shifts brought on by technology are key to comprehending technology and society.

E-waste management refers to the correct disposal of outdated electronic devices.

Identity theft, distinct identification, and biometrics.

Problems with gender and disability when utilizing computers in the classroom.

Unit 5: Programming in Python

Recursively find the factorial of a natural number.

Read a file line by line and print it.

Remove all the lines that contain the character `a' in a file and write it to another file.

To determine the value of sin(x) using its Taylor series expansion up to n terms, use the Python function sin(x, n). The values of sin(x) for various values of n should be compared to the right value.

Write a random number generator that replicates a dice roll and produces numbers at random between 1 and 6.

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

Make a graphical program that takes user inputs, processes them, and then prints the results on the screen. Write a simple calculator as an example. Make use of the tkinter library.

The urllib library is used to launch a website.

Utilize the numpy or scipy libraries to compute the EMIs for a loan.

Find the most frequent words by selecting a sample of 10 phishing emails.

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

7

The stub program with Python SQL connectivity must be provided with blanks (4 blanks) to be filled by the student with the desired SQL query.

3

Report file:

• Minimum 21 Python programs.
• SQL Queries – Minimum 4 sets using one table/two tables.
• Minimum 1 programs based on Python - SQL connectivity

7

Project (using concepts learned in Classes 11 and 12)

8

Viva voce

3+2

1.

Programming and Computational Thinking

30

2.

Computer Networks

15

3.

Data Management-2

15

4.

Society, Law and Ethics – 2

10

5.

Practicals

30

Total

100