CBSE Class 12 Computer Science (Code 083) Comprehensive PYQ & Blueprint Notes

Curriculum Blueprint and Marks Distribution

• Course Overview:

  • Subject: CBSE Class 12 Computer Science (Code $083$).

  • Curriculum Alignment: Designed according to official CBSE Class 12 Computer Science curriculum guidelines and aligned with standard reference texts such as Preeti Arora's Computer Science with Python.

  • Compilation Objective: High-yield summary guide derived from compiled previous year questions (PYQs) and core conceptual trends across the last $5\text{ Years}$ for high-priority board examination preparation.

• Theory Examination Weightage Distribution:

  • Unit I: Computational Thinking and Programming - 2: $40\text{ Marks}$

  • Unit II: Computer Networks: $10\text{ Marks}$

  • Unit III: Database Management (SQL & Python Connectivity): $20\text{ Marks}$

  • Total Theory Examination Score: $70\text{ Marks}$

Unit I: Computational Thinking and Programming - 2

• File Handling (Text vs Binary vs CSV):

  • File Modes:

  • r+ mode: Open a file for both reading and writing.

  • w+ mode: Open a file for both writing and reading (overwriting existing content or creating a new file if non-existent).

  • File Reading Methods:

  • Explicit behavioral difference between readline() and readlines():

    • readline(): Reads a single line from the file at a time.

    • readlines(): Reads all remaining lines from the file and returns them as a list of string elements.

  • Exam Recurrence: Questions on these file modes and methods have been repeated consistently in the $2020$, $2023$, $2024$, and $2026$ board examination papers.

• Data Structures (Stacks):

  • List-Based Stack Implementation:

  • Implementation of push function to insert elements into the stack data structure in Python.

  • Implementation of pop function to remove elements from the top of the stack data structure in Python.

  • Operational Safeguards:

  • Handling Stack Overflow: Managing conditions when attempting to push onto a full stack.

  • Handling Stack Underflow: Managing conditions when attempting to pop from an empty stack.

Unit II: Computer Networks

• Network Hardware Devices:

  • Hub vs Switch Functional Differences:

  • Hub: Functions as a non-intelligent device that broadcasts incoming data packets to all connected ports/nodes.

  • Switch: Functions as an intelligent device that inspects destination addresses and forwards packets directly to the targeted port/node.

• Network Switching Technologies:

  • Packet Switching vs Circuit Switching:

  • Packet Switching: Data is broken into separate discrete packets routed independently across shared network channels.

  • Circuit Switching: Establishes a dedicated, continuous physical connection/channel between the sender and receiver for the complete duration of communication.

Unit III: Database Management and SQL

• Database Management & SQL Queries:

  • Operations on table 'EMPLOYEE':

  • Writing SQL queries to retrieve target records based on compound conditions.

  • Utilization of pattern matching using LIKE wildcard expressions.

  • Categorization and aggregation of query results using the GROUP BY clause.

  • Application of SQL aggregate functions: COUNT(), MAX(), and AVG().

Unit III: Python-SQL Connectivity

• Database Connectivity Sequence:

  • Protocol steps to establish connectivity between Python and a MySQL database:

  • Import the appropriate database driver module: mysql.connector.

  • Establish database connection using mysql.connector.connect() with mandatory connection parameters.

  • Instantiate a cursor object using the connection object.

  • Execute SQL commands/scripts using the cursor object.

  • Fetch and process the resultant datasets.

  • Commit transactions and close cursor and connection objects properly.

• Cursor Object Execution:

  • Explicit operational outline of how cursor objects process and execute SQL scripts and maintain returned dataset records within Python applications.