Computer science practical paper 2025 class 12 with solution

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
    data=f.readlines()
    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
    data=f.read()
    for d in data:
           if d.isdigit():
               count+=1
   print(‘Number of Digits=’,count)
   f.close()

OR

(i)

import csv
def ADD():
  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’)
  r=csv.reader(f)
  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

Spread the love
Lesson tags: class 12 computer science practical paper, Computer science practical paper 2024 class 12 with solution, computer science practical paper class 12
Back to: CBSE class 12 Computer Science notes
Spread the love