CBSE Class XII Informatics Practices Marking Scheme 2026–27 (Code 065)

The CBSE Class XII Informatics Practices Marking Scheme 2026–27 (Subject Code 065) provides the official answers and detailed mark-wise evaluation guidelines for the corresponding Sample Question Paper for the Academic Session 2026–27.

The examination is of 3 hours duration and carries a maximum of 70 marks. The marking scheme covers 37 questions divided into five sections, from Section A to Section E. All questions are compulsory, with internal choices provided in selected questions. All programming questions are to be answered using Python Language only. :contentReference[oaicite:1]{index=1}

Section-wise Mark Distribution

• Section A: Questions 1–21, 1 mark each = 21 marks.
• Section B: Questions 22–28, 2 marks each = 14 marks.
• Section C: Questions 29–32, 3 marks each = 12 marks.
• Section D: Questions 33–34, 4 marks each = 8 marks.
• Section E: Questions 35–37, 5 marks each = 15 marks.

The marking scheme confirms that there is no overall choice, although internal choices are available in some questions. Students are required to attempt only one option where an internal choice is provided. :contentReference[oaicite:2]{index=2}

Section A – Objective Questions

Section A provides the correct answers for Questions 1 to 21. The questions assess concepts from Pandas, SQL, Data Visualization, Computer Networks, Intellectual Property Rights, E-waste Management, Web Technologies, DataFrames and related Informatics Practices topics.

Each question carries 1 mark, awarded for the correct answer. The marking scheme includes answers such as LENGTH(), Patent, ylabel(), Modem, UPDATE, Refurbishing, HAVING, Cookies, DESC and NaN. :contentReference[oaicite:3]{index=3}

Section B – Conceptual and Programming Questions

Section B contains Questions 22 to 28, carrying 2 marks each. The marking scheme provides component-wise answers for Pandas functions, digital footprints, data visualization, networking concepts, SQL functions, online etiquette and DataFrame creation.

• Pandas: head(), Boolean indexing, DataFrame creation and read_csv().
• Digital Citizenship: Active and passive digital footprints.
• Data Visualization: Purpose and use of graphical representation of data.
• Networking: Star topology and VoIP.
• SQL: Functions such as RIGHT() and INSTR().
• Online Behaviour: Ethical and respectful conduct in online forums.

Marks are generally allocated equally to the individual components of each answer. For example, Question 23 awards 2 marks for the correct differentiation between active and passive digital footprints, while Question 28 awards 2 marks for the correct DataFrame program or for the correct explanation of read_csv() and its sep parameter. :contentReference[oaicite:4]{index=4}

Section C – Pandas, Cyber Safety and SQL

Section C consists of Questions 29 to 32, carrying 3 marks each. The marking scheme assesses practical application of Cyber Safety, Pandas Series and DataFrame operations, SQL queries and SQL output interpretation.

Question 29 covers identification of cybercrime and appropriate online communication behaviour, including Phishing, Cyber Bullying and the guideline to Be Credible/Use polite language.

Question 30 includes Pandas programming involving creation of a Series and output prediction, with marks distributed between the program and output. The alternative assesses DataFrame column addition, column renaming and column deletion.

Questions 31 and 32 assess SQL queries and outputs using functions such as LOWER(), DAYNAME(), ORDER BY, UPPER(), LENGTH(), DAY(), YEAR() and RIGHT(). :contentReference[oaicite:5]{index=5}

Section D – Data Visualization and SQL

Section D contains Questions 33 and 34, carrying 4 marks each. Question 33 requires a Python program using Matplotlib to create a line graph representing monthly sales.

The marking scheme awards marks for the correct import, use of plot() with a label, title, axis labels, legend and show(). The marks are distributed as 1 mark for imports, 1 mark for the plot, and 1/2 mark each for the title, labels, legend and display command. :contentReference[oaicite:6]{index=6}

Question 34 assesses SQL queries and query outputs. The first alternative requires GROUP BY, SUM(), HAVING and a table join. The alternative requires interpretation of grouped employee data and joined table output. Each sub-part carries 2 marks. :contentReference[oaicite:7]{index=7}

Section E – Case Study, Pandas and SQL

Section E contains Questions 35 to 37, carrying 5 marks each. These questions assess higher-order application of Informatics Practices concepts.

Question 35 – Computer Networking and Web Technologies

The marking scheme identifies Block D as the most suitable location for the server because it has the maximum number of computers (150). The network type is identified as a LAN, and a switch is recommended for every block.

The case also requires a Dynamic Website because the website involves user logins and real-time database updates. Repeaters are required between Block A and Block D and between Block C and Block D because the Ethernet distance exceeds approximately 100 metres. :contentReference[oaicite:8]{index=8}

Question 36 – Pandas DataFrame

Question 36 assesses the creation and manipulation of a Pandas DataFrame. The marking scheme provides a program to create a DataFrame containing Items, Quantity and Unit_Price, add a new record using loc, and display the Items column.

The marks are distributed as 3 marks for creating the DataFrame, 1 mark for adding the new row and 1 mark for displaying the selected column. :contentReference[oaicite:9]{index=9}

Question 37 – SQL Commands and Functions

Question 37 assesses practical SQL commands. The first alternative covers INSERT, UPDATE, DELETE, ALTER TABLE and DROP TABLE.

The alternative assesses SQL functions and queries using ROUND(), RIGHT(), comparison operators, SUM() and LTRIM(). Each of the five sub-parts carries 1 mark. :contentReference[oaicite:10]{index=10}

Evaluation Approach

The marking scheme follows a component-wise evaluation approach. Marks are assigned separately for individual elements such as correct program structure, appropriate Python statements, SQL syntax, query output, graphical components and conceptual explanations.

The document also reiterates that there is no change in the Question Paper Design and Assessment Pattern for Academic Session 2026–27. :contentReference[oaicite:11]{index=11}

This Marking Scheme should be used together with the corresponding Sample Question Paper to understand the expected answers, mark allocation and evaluation methodology for CBSE Class XII Informatics Practices (Code 065) for the Academic Session 2026–27.