Computer science practical paper 2025 class 12 with solution

AISSCE Practical Examination 2025

COMPUTER SCIENCE (083)

Time : 3 Hours                                                                                      M.M.  30

Q1.                                                                                                                                                           8

(i) Write a user defined function countwords() in Python to count and display the number of times words “this” and “that” appear in a text file “data.txt”.

(ii) Write a user defined function countdigits() in Python to count and display the number of digits from a text file “data.txt”.

OR

(i) ADD() – To accept and add data of an employee to a CSV file ‘emp.csv’. Each record consists of a list with field elements as empid, name and salary to store employee id, employee name and employee salary

(ii) COUNTR() – To count the number of records present in the CSV file named ‘emp.csv’.

Q2. Write sql queries as per following tables.                                                                                                          4

Shop:

 Employee id Name Designation 101 Naresh Clerk 102 Ajay Manager 103 Manisha Clerk 104 Komal Advisor

 Details id Salary PhoneNo 101 32000 9898090909 102 45000 9888000909 103 33000 8008078787 104 40000 7009876543

i. View Name and salary of all employees.
ii. List Name and designation of all Clerks.
iii. Display id, Name and Phone number of all employees.
iv. Display records of all employees whose name starts with alphabet ‘K’.

Q3.Practical File                                                    7

Q4.Project File                                                       8

Q5.Viva-Voce                                                          3

Solution:

Q1

i.

```def countwords():
f=open("data.txt","r")
countthis=0
countthat=0
for d in data:
word=d.split()
for w in words:
if w=='this':
countthis+=1
if w=='this':
counthat+=1
print(‘Number of times "this" appears=’,countthis)
print(‘Number of times "that" appears=’,countthat)
f.close()```

ii

```def countdigits():
f=open("data.txt","r")
count=0
for d in data:
if d.isdigit():
count+=1
print(‘Number of Digits=’,count)
f.close()```

OR

(i)

```import csv
f=open(‘emp.csv’,’a’,newline=”)
w=csv.writer(f)
empid=int(input(‘Enter employee id=’))
name=input(‘Enter employee name=’)
salary=float(input(‘Enter salary =’))
rec=[empid,name,salary]
w.writerow(rec)
f.close()

(ii)```
```def COUNTR():
f=open(‘emp.csv’,’r’)
count=0
for rec in r:
count+=1
print(‘Number of records=’,count)
f.close()```

Q2.

i. select name,salary from employee, details where employee.id=details.id;
ii. select name,designation from employee where designation=’Clerk’;
iii. select employee.id, name,phoneno from employee, details where employee.id=details.id;
iv. select * from employee where name like ‘K%’;

Class xii computer science practical paper -1

Class xii computer science practical paper -2

Class xii computer science Sample paper 2023 with solutions

Class xii computer science project file

Class 12 Computer Science Practical File