CBSE AISSCE 2024 Marking Scheme for Computer Science CBSE AISSCE 2024 Marking Scheme for Computer

CBSE AISSCE 2024 Marking Scheme for Computer Science

(Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4 (Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4
Marking Scheme
General Instructions:
Strictly Confidential
(For Internal and Restricted use only) (i) Please check this question paper which contains 35 questions.
Senior Secondary School Certificate Examination, 2024 (ii) The paper is divided into 5 Sections - A, B, C, D and E.
Subject Name: Computer Science (Q.P. CODE 91)
(iii) Section A, consists of 18 questions (1 to 18). Each question carries 1 Mark.
1 You are aware that evaluation is the most important process in the actual and correct
assessment of the candidates. A small mistake in evaluation may lead to serious problems which (iv) Section B, consists of 7 questions (19 to 25). Each question carries 2 Marks.
may affect the future of the candidates, education system and teaching profession. To avoid
(v) Section C, consists of 5 questions (26 to 30). Each question carries 3 Marks.
mistakes, it is requested that before starting evaluation, you must read and understand the spot
evaluation guidelines carefully. (vi) Section D, consists of 2 questions (31 to 32). Each question carries 4 Marks.
2 “Evaluation policy is a confidential policy as it is related to the confidentiality of the (vii) Section E, consists of 3 questions (33 to 35). Each question carries 5 Marks.
examinations conducted, Evaluation done and several other aspects. Its’ leakage to public in any
manner could lead to derailment of the examination system and affect the life and future of (viii) All programming questions are to be answered using Python Language only.
millions of candidates. Sharing this policy/document to anyone, publishing in any magazine and
printing in News Paper/Website etc. may invite action under various rules of the Board and IPC.”
SECTION-A
3 Evaluation is to be done as per instructions provided in the Marking Scheme. It should not be
done according to one’s own interpretation or any other consideration. Marking Scheme should 1. State True or False : 1
be strictly adhered to and religiously followed. However, while evaluating, answers which are
While defining a function in Python, the positional parameters in the function header must
based on latest information or knowledge and/or are innovative, they may be assessed for their
always be written after the default parameters.
correctness otherwise and due marks be awarded to them. In class-XII, while evaluating two
competency-based questions, please try to understand given answer and even if reply is not from Ans False
marking scheme but correct competency is enumerated by the candidate, due marks should be
awarded. (1 Mark for the correct answer)
4 The Marking scheme carries only suggested value points for the answers 2. The SELECT statement when combined with ___ clause, returns records without repetition. 1
These are in the nature of Guidelines only and do not constitute the complete answer. The
students can have their own expression and if the expression is correct, the due marks should be (a) DISTINCT (b) DESCRIBE
awarded accordingly.
(c) UNIQUE (d) NULL
5 The Head-Examiner must go through the first five answer books evaluated by each evaluator on
the first day, to ensure that evaluation has been carried out as per the instructions given in the Ans (a) DISTINCT
Marking Scheme. If there is any variation, the same should be zero after deliberation and
discussion. The remaining answer books meant for evaluation shall be given only after ensuring (1 Mark for the correct answer)
that there is no significant variation in the marking of individual evaluators.
3. What will be the output of the following statement : 1
6 Evaluators will mark( √ ) wherever answer is correct. For wrong answer CROSS ‘X’ be marked.
Evaluators will not put right (✓)while evaluating which gives an impression that answer is print (16*5/4*2/5–8)
correct and no marks are awarded. This is most common mistake which evaluators are committing.
(a) – 3.33 (b) 6.0
7 If a question has parts, please award marks on the right-hand side for each part. Marks awarded
for different parts of the question should then be totaled up and written in the left-hand margin (c) 0.0 (d) –13.33
and encircled. This may be followed strictly.
Ans (c) 0.0
8 If a question does not have any parts, marks must be awarded in the left-hand margin and
(1 Mark for the correct answer)
encircled. This may also be followed strictly.
4. What possible output from the given options is expected to be displayed when the 1
9 If a student has attempted an extra question, answer of the question deserving more marks
following Python code is executed ?
should be retained and the other answer scored out with a note “Extra Question”.
import random
10 No marks to be deducted for the cumulative effect of an error. It should be penalized only once. Signal=['RED','YELLOW','GREEN']
for K in range (2, 0, – 1) :
11 A full scale of marks 70 marks as given in Question Paper has to be used. Please do not hesitate R = [Link](K)
to award full marks if the answer deserves it. print (Signal[R], end = '#')

Page 1/26 Page 3/26

CBSE AISSCE 2024 Marking Scheme for Computer Science CBSE AISSCE 2024 Marking Scheme for Computer Science
(Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4 (Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4
Ans (c) print("15" + 3) Ans (a) Both (A) and (R) are true and (R) is the correct explanation for (A).

(1 Mark for the correct answer) (1 Mark for the correct answer)

10. Select the correct output of the following code : 1

SECTION-B
event="G20 Presidency@2023"
19 (A) (i) Expand the following terms: 2
L=[Link](' ')
XML ,PPP
print(L[::–2])
(ii) Give one difference between circuit switching and packet switching.
(a) 'G20' (b) ['Presidency@2023']
OR
(c) ['G20'] (d) 'Presidency@2023' (B) (i) Define the term web hosting.
(ii) Name any two web browsers.
Ans (b) ['Presidency@2023']
Ans (A) (i) eXtensible Markup Language
(1 Mark for the correct answer) Point-to-Point Protocol

11. Which of the following options is the correct unit of measurement for network bandwidth ? 1 (½ Mark for writing correct expansion of XML)
(a) KB (b) Bit (½ Mark for writing correct expansion of PPP)

(c) Hz (d) Km Ans (ii)

Circuit Switching Packet Switching
Ans (c) Hz
A dedicated path is established between Data to be transmitted is divided into small
(1 Mark for the correct answer) the sender and the receiver before packets which are transmitted via nearest
starting data transmission. Entire data is service provider till all packets reach the
12. Observe the given Python code carefully : 1
transmitted in one go. recipient where the packets are reassembled.
a=20
def convert(a): (½ Mark for writing correct technique for Circuit Switching)
b=20 (½ Mark for writing correct technique for Packet Switching)
a=a+b
OR
convert(10)
print(a)
Ans (B) (i) Web hosting is a service that allows users to put a website or a webpage onto the
internet, and make it a part of the World Wide Web.
Select the correct output from the given options :
(1 Mark for writing the correct definition of Web hosting)
(a) 10 (b) 20
(ii) Google Chrome,Microsoft Edge, Safari, Mozilla Firefox, Opera etc.
(c) 30 (d) Error
(1 mark for writing names of any two web browsers)
Ans (b) 20
20 The code given below accepts five numbers and displays whether they are even or odd: 2
(1 Mark for the correct answer)
Observe the following code carefully and rewrite it after removing all syntax and logical
errors :
Underline all the corrections made.
13. State whether the following statement is True or False: 1
While handling exceptions in Python, name of the exception has to be compulsorily added def EvenOdd()
with except clause. for i in range(5) :
num=int(input("Enter a number")
Ans False if num/2==0:
print("Even")
(1 Mark for the correct answer) else:
print("Odd")
EvenOdd()

Page 5/26 Page 7/26

 CBSE AISSCE 2024 Marking Scheme for Computer Science CBSE AISSCE 2024 Marking Scheme for Computer Science
(Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4 (Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4
OR OR
Any other correct variation of the code Any other correct variation of the code

(½ Mark for the loop to process individual students from the dictionary) (1 Mark for correctly converting to list)
(1 Mark for calculating grades) (1 Mark for correctly popping the last element/name)
(½ Mark for displaying grades)
24. (A) Ms. Veda created a table named Sports in a MySQL database, containing columns 2
OR Game_id, P_Age and G_name.
After creating the table, she realized that the attribute, Category has to be
(B) Write a user defined function in Python named Puzzle(W,N) which takes the added. Help her to write a command to add the Category column. Thereafter,
argument W as an English word and N as an integer and returns the string where write the command to insert the following record in the table :
every Nth alphabet of the word W is replaced with an underscore ("_").
Game_id : G42
For example : if W contains the word "TELEVISION" and N is 3, then the function P_Age : Above 18
should return the string "TE_EV_SI_N". Likewise for the word "TELEVISION" if G_name : Chess
N is 4, then the function should return "TEL_VIS_ON". Category : Senior

Ans Word="TELEVISION" Ans (A) ALTER TABLE SPORTS

def Puzzle(W, N): ADD CATEGORY VARCHAR(10);
NW="" OR
Count=1 ALTER TABLE SPORTS
for Ch in W: ADD COLUMN CATEGORY VARCHAR(10);
if Count!=N: OR
NW+=Ch ALTER TABLE SPORTS
Count+=1 ADD CATEGORY CHAR(10);
else: OR
NW+="_" ALTER TABLE SPORTS
Count=1 ADD COLUMN CATEGORY CHAR(10);
return NW
print(Puzzle(Word,3)) INSERT INTO SPORTS
VALUES("G42","Above 18","Chess","Senior");
OR OR
def Puzzle(W,N): INSERT INTO SPORTS(Game_id, P_Age, G_name, Category)
W1="" VALUES("G42","Above 18","Chess","Senior");
for i in range(len(W)):
if (i+1)%N==0: (½ Mark for ALTER TABLE command)
W1=W1+"_"
(½ Mark for ADD CATEGORY part)
else:
W1=W1+W[i] (½ Mark for INSERT INTO command)
return W1 (½ Mark for VALUES part )
print(Puzzle("TELEVISION",4))
OR
OR
Any other correct variation of the code (B) Write the SQL commands to perform the following tasks :
(i) View the list of tables in the database, Exam.
(½ Mark for the loop to process individual (or Nth) characters)
(ii) View the structure of the table, Term1.
(1 Mark for changing/replacing the required characters)
(½ Mark for returning the new word) Ans (B) (i) SHOW TABLES;
22. Write the output displayed on execution of the following Python code : 2 (ii) DESCRIBE Term1
LS=["HIMALAYA","NILGIRI","ALASKA","ALPS"] OR
D={} DESC Term1
for S in LS :
if len(S)%4 == 0: Note: Ignore USE Exam; if not written
D[S] = len(S)
for K in D : (1 Mark for each correct command)
print(K,D[K], sep = "#")

Page 9/26 Page 11/26

CBSE AISSCE 2024 Marking Scheme for Computer Science CBSE AISSCE 2024 Marking Scheme for Computer Science
(Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4 (Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4
27 Consider the table ORDERS given below and write the output of the SQL queries that 1x3 Ans def c_words():
=3 f=open("[Link]","r")
follow:
Txt=[Link]()
ORDNO ITEM QTY RATE ORDATE
CLower=CUpper=0
1001 RICE 23 120 2023-09-10 for i in Txt:
1002 PULSES 13 120 2023-10-18 if [Link]():
CLower+=1
1003 RICE 25 110 2023-11-17 elif [Link]():
1004 WHEAT 28 65 2023-12-25 CUpper+=1
print(CLower, CUpper)
1005 PULSES 16 110 2024-01-15 [Link]()
1006 WHEAT 27 55 2024-04-15 OR
def c_words():
1007 WHEAT 25 60 2024-04-30 with open("[Link]","r") as F:
Txt=[Link]()
(i) SELECT ITEM, SUM(QTY) FROM ORDERS GROUP BY ITEM; CL=CU=0
(ii) SELECT ITEM, QTY FROM ORDERS WHERE ORDATE BETWEEN for i in Txt:
'2023-11-01' AND '2023-12-31'; if [Link](): # if i>="a" and i<="z":
(iii) SELECT ORDNO, ORDATE FROM ORDERS WHERE ITEM = 'WHEAT' CL+=1
AND RATE>=60 ; elif [Link]():# if i>="A" and i<="Z":
CU+=1
Ans (i) print(CL, CU)
ITEM SUM(QTY) ( ½ Mark for correctly opening the file)
RICE 48 ( ½ Mark for reading the content of file using any correct method/mode)
PULSES 29 ( ½ Mark for the correct loop)
WHEAT 80 ( ½ Mark for correctly checking and incrementing for uppercase alphabets)
( ½ Mark for correctly checking and incrementing for lowercase alphabets)
(ii) ( ½ Mark for printing/returning required output)
ITEM QTY
29 Consider the table Projects given below: 1x3
RICE 25 =3
Table: Projects
WHEAT 28
P_id Pname Language Startdate Enddate
(iii) P001 School Management System Python 2023-01-12 2023-04-03
ORDNO ORDATE P002 Hotel Management System C++ 2022-12-01 2023-02-02
P003 Blood Bank Python 2023-02-11 2023-03-02
1004 2023-12-25
P004 Payroll Management System Python 2023-03-12 2023-06-02
1007 2024-04-30
Based on the given table, write SQL queries for the following:
(1 Mark for writing each correct output) (i) Add the constraint, primary key to column P_id in the existing table
Projects.
Note: (ii) To change the language to Python of the project whose id is P002.
● Ignore output heading (iii) To delete the table Projects from MySQL database along with its data.
● Ignore order of rows

28 (A) Write a user defined function in Python named showInLines() which reads contents 3 Ans (i) ALTER TABLE Projects
of a text file named [Link] and displays every sentence in a separate line. ADD PRIMARY KEY (P_id);

Assume that a sentence ends with a full stop (.), a question mark (?), or an
exclamation mark (!). (½ Mark for ALTER TABLE part)
(½ Mark for ADD PRIMARY KEY part)

Page 13/26 Page 15/26

 CBSE AISSCE 2024 Marking Scheme for Computer Science CBSE AISSCE 2024 Marking Scheme for Computer Science
(Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4 (Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4
def PushBig(): Ans import csv
for N in Nums: def Add_Device():
if N >= 10000: F=open("[Link]","a",newline='')
[Link](N) W=[Link](F)
P_id=int(input("Enter the Peripheral ID"))
def PopBig(): P_name=input("Enter Peripheral Name")
while BigNums: Price=int(input("Enter Price"))
print([Link]()) L=[P_id,P_name,Price]
print("Stack Empty") [Link](L)
[Link]()
OR
def Count_Device():
Any other correct variation of the code F=open("[Link]","r")
L=list([Link](F))
( ½ Mark for the correct loop in the function PushBig)
Count=0
( ½ Mark for correctly checking the number of digits in the function PushBig)
for D in L:
( ½ Mark for pushing the correct number into BigNums in the function PushBig)
if int(D[2])<1000:
( ½ Mark for the correct loop in the function PopBig) Count+=1
( ½ Mark for correctly checking the underflow condition and printing "Stack print(Count)
Empty" in the function PopBig) [Link]()
( ½ Mark for popping and printing the correct number in the function PopBig)
OR
Note: Any other correct variation of the code
Ignore the declarations of Nums and/or BigNums
(½ Mark for opening the csv file correctly in the function Add_Device())
SECTION D (½ Mark for reading the data from the user in the function Add_Device())
(½ Mark for writing the data correctly into the csv file in the function
31 Consider the tables Admin and Transport given below: 1x4 Add_Device())
Table: Admin =4 (½ Mark for opening the csv file correctly in the function Count_Device())
S_id S_name Address S_type (½ Mark for reading the data from the file in the function Count_Device())
(½ Mark for loop in the function Count_Device())
S001 Sandhya Rohini Day Boarder
(½ Mark for checking the condition and counting correctly in the function
S002 Vedanshi Rohtak Day Scholar Count_Device())
S003 Vibhu Raj Nagar NULL (½ Mark for printing the output correctly in the function Count_Device())

S004 Atharva Rampur Day Boarder Note:

Full 4 mark should be awarded if the examinee has mentioned that there is no
Table: Transport mention of the task in the question
S_id Bus_no Stop_name
SECTION-E
S002 TSS10 Sarai Kale Khan
S004 TSS12 Sainik Vihar 33 Infotainment Ltd. is an event management company with its prime office located in 1x5
Bengaluru. The company is planning to open its new division at three different =5
S005 TSSl0 Kamla Nagar locations in Chennai named as - Vajra, Trishula and Sudershana.
You, as a networking expert need to suggest solutions to the questions in part (i) to
Write SQL queries for the following: (v), keeping in mind the distances and other given parameters.
(i) Display the student name and their stop name from the tables Admin and
Transport.

Ans SELECT S_name, Stop_name FROM Admin, Transport

WHERE Admin.S_id = Transport.S_id;

(½ Mark for SELECT - FROM part)

(½ Mark for WHERE part)

Page 17/26 Page 19/26

CBSE AISSCE 2024 Marking Scheme for Computer Science CBSE AISSCE 2024 Marking Scheme for Computer Science
(Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4 (Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4
(ii) Which block in Chennai division should host the server? Justify your answer. except:
break
Ans Vajra can host the server as it has a maximum number of computers. [Link]()
OR [Link]()
Any other answer with valid justification
OR
Any other correct variation of the code
(½ Mark for the correct answer)
(½ Mark for the correct justification)
(½ Mark for opening the file [Link] in correct mode)
(iii) Which fast and effective wired transmission medium should be used to connect (½ Mark for opening the file new_items.dat in correct mode)
the prime office at Bengaluru with the Chennai division? (½ Mark for reading the content of the file [Link])
(½ Mark for the correct loop)
Ans Optical Fiber (½ Mark for checking the condition)
(½ Mark for writing the required contents into the file new_items.dat)
(1 Mark for the correct answer)
Note: Ignore [Link]() and [Link]()
(iv) Which network device will be used to connect the digital devices within each
location of Chennai division so that they may communicate with each other ? OR

Ans Switch/Hub/Router (B) (i) What is the advantage of using with clause while opening a data file in Python ?
Also give syntax of with clause.
(1 Mark for the correct answer)
The advantage of using with clause is that any file that is opened using this clause is
(v) A considerable amount of data loss is noticed between the different locations of the closed automatically, once the control comes outside the with clause.
Chennai division, which are connected in the network. Suggest a networking device Example:
that should be installed to refresh the data and reduce the data loss during with open("[Link]","r+") as file_object:
transmission to and from different locations of Chennai division. content = file_object.read()

Ans Repeater In Python, we can open a file using with clause/statement.

OR
Mentioning any other valid reason or solution for data loss The syntax of with clause is:
with open (file_name, access_mode) as file_object:
(1 Mark for the correct answer)
(1 Mark for writing any one advantage of with statement)
34 (A) (i) Differentiate between 'w' and 'a' file modes in Python. 2+3
=5 (1 Mark for writing syntax OR any valid example of with statement)

Ans 'w': (ii)

Open the file in write mode. A binary file, [Link] has the following structure :
If the file doesn’t exist, then a new file will be created. [Emp_Id, Name, Salary]
The file pointer is in the beginning of the file.
where
If the file exists, the contents of the file, if any, are lost/truncated and the new data
Emp_Id : Employee id
is added as fresh data into the file. Name : Employee Name
'a': Salary : Employee Salary
Open the file in append mode.
Write a user defined function, disp_Detail(), that would read the contents of the
If the file doesn’t exist, then a new file will be created. file [Link] and display the details of those employees whose salary is below
The file pointer is at the end of the file. 25000.
If the file exists, the new data is added at the end of the file without deleting the
previous contents of the file. def disp_Detail():
try:
( 1 Mark each for any one correct characteristics of ‘w’ mode) with open("[Link]","rb") as F:

Page 21/26 Page 23/26

 CBSE AISSCE 2024 Marking Scheme for Computer Science
(Series &RQPS Sub Code: 083 Q.P. Code 91) SET-4
(ii) Sunil wants to write a program in Python to update the quantity to 20 of the
records whose item code is 111 in the table named shop in MySQL database named
Keeper.
The table shop in MySQL contains the following attributes :
● Item_code: Item code (Integer)
● Item_narne: Name of item (String)
● Qty: Quantity of item (Integer)
● Price: Price of item (Integer)
Consider the following to establish connectivity between Python and MySQL:
Username: admin
Password : Shopping
Host: localhost

Ans import pymysql as pm

DB=[Link](host="localhost",user="admin",\
passwd="Shopping", database="Keeper")
MyCursor=[Link]()
SQL=f"UPDATE SHOP SET QTY=%S WHERE ITEM_CODE=%S"%(20,111)
# OR
SQL="UPDATE SHOP SET QTY=20 WHERE ITEM_CODE=111"
[Link](SQL)
[Link]()

(½ mark for importing with any correct module/method)

(1 mark for correct connect())
( ½ mark for creating the cursor)
( 1 mark for the correct SQL command - ½ Mark for UPDATE SET and ½
Mark for WHERE)
(1 mark for correctly executing SQL)

OR

(B) (i) Give any two features of SQL.

Any two of the following

● Full form is Structured Query Language.
● Is used to retrieve and view specific data from a table in a database.
● Is case insensitive
● Each query in SQL ends with a semicolon (;)
● It contains DDL and DML

Ans ( ½ Mark each for the any two correct feature as mentioned above or any
other correct feature)

(ii) Sumit wants to write a code in Python to display all the details of the passengers
from the table flight in MySQL database, Travel. The table contains the
following attributes:
F_ code : Flight code (String)
Page 25/26