Cs Portfolio

CENTRAL BOARD OF SECONDARY EDUCATION
AISSCE EXAMINATION SESSION – 2022-2023
Techno India Group Public School

Raiganj
Gobindapur ,Kholshi,Raiganj,Uttar Dianjupur
PRACTICAL RECORD FILE IS SUBMITTED TO

DEPARTMENT OF COMPUTER SCIENCE FOR THE
PARTIAL FULLFILLMENT OF AISSCE
EXAMINATION SESSION – 2022-2023
SUBMITTED BY: Soumyadip Debnath

CLASS: XII
ROLL NO:
ACKNOWLEDGEMENT
I wish to express my deep sense of gratitude and indebtedness
to our learned teacher ________________, PGT, Computer
Science Techno India Group Public School Raiganj for his
invaluable help, advice and guidance in the preparation of this
project. I am also greatly indebted to our principal Mr. Avijit
Chakraborty and school authorities for providing me with the
facilities and requisite laboratory conditions for making this
practical file. I also extend my thanks to a number of
teachers ,my classmates and friends who helped me to
complete this practical file successfully.
Suumyadip Debnath
CERTIFICATE
This is to certify that Soumyadip Debnath, student of Class
XII, Techno India Group Public School Raiganj has
completed the PRACTICAL FILE during the academic year
2023-2024 towards partial fulfilment of credit for the
Computer Science practical evaluation of CBSE and
submitted satisfactory report, as compiled in the following
pages, under my supervision.
Signature of Internal Examiner Signature of Principal

INDEX
PART-A (PYTHON)
S.L. PRACTICAL DATE SIGANTURE
NO
1. Write a Python program to find the
largest/smallest number in a list/tuple
2. Write a Python program to input a list of
numbers and swap elements at the even location
with the elements at the odd location
3. Write a Python program to input a list/tuple of
elements, search for a given element in the
list/tuple
4. Write a Python program to create a 2D list
5. Write a Python program to input a list and
remove all occurrences of the given element from
the list
6. Write a Python program to read a list of n
integers(both positive and negative).Create two
new lists , one having all positive numbers and
the other having all the negative numbers from
the given list. Print all the three lists
7. Write a Python program to input a tuple and
check if it contains all elements as the same
8. Write a Python program to print minimum,
maximum, sum of keys of numbers dictionary as
given below
9. a Python program to split dictionary keys and
values into separate lists
10. Create a dictionary with the roll number, name
and marks of n students in a class and display the
names of students who have scored marks above
75
11. Input two numbers and display the larger /
smaller number.
12. three numbers and display the largest / smallest
number
13. Generate the following patterns using nested
loops
14. a program to input the value of x and n and print
the sum of the following series
15. Determine whether a number is a perfect number,
an Armstrong number or a palindrome
16. Input a number and check if the number is a
prime or composite number
17. Display the terms of a Fibonacci series
18. Compute the greatest common divisor and least
common multiple of two integers
19. Count and display the number of vowels,
consonants, uppercase, lowercase characters in
string
20. Input a string and determine whether it is a
palindrome or not; convert the case of characters
in a string
21. . Input a list/tuple of elements, search for a given
element in the list/tuple.
22. . Read a text file and display the number of

vowels/consonants/uppercase/
Lowercase characters in the file
23. Create a binary file with name and roll
number. Search for a given roll number and
display the name, if not found display
appropriate message
24. Write a random number generator that

generates random numbers between 1 and 6
(simulates a dice).
25. Write a Python program to implement a stack
using list
PART-B (SQL QUERIES)

26. . Using SQL Query display the names of Students
who are getting a grade “C” in either GAME or
SUPW
27. Using SQL Query display different games offered
in the school
28. Using SQL Query to display the SUPW taken up
by the students whose name starts with ‘A’
29. Using SQL Query display the names of Students
who play Cricket from class 10
30. List all the students sorted by Class in descending
order
31. List all the students who have Grade= A in either
Game and SUPW
PART-C (Python SQL Connectivity)

32. Create a “Class12” Database in MySQL using
Python
33. CREATE TABLE STUDENT (id INT, name
VARCHAR (255), salary INT(6)).
34. INSERT INTO STUDENT (id, name) VALUES
(01, "John") in MySQL with Python
35. Delete column "salary" from STUDENT in sql
using python
PORTFOLIO
Q1.Write a Python program to find the largest/smallest number in a list/tuple.
INPUT:-
OUTPUT:-
Q2. Write a Python program to input a list of numbers and swap elements at the even location
with the elements at the odd location.
INPUT:-
OUTPUT:-
Q3. Write a Python program to input a list/tuple of elements, search for a given element in the
list/tuple
INPUT:-
OUTPUT:-
Q4. Write a Python program to create a 2D list.
INPUT:-
OUTPUT:-
Q5. Write a Python program to input a list and remove all occurrences of the given element
from the list.
INPUT:-
OUTPUT:-
Q6. Write a Python program to read a list of n integers(both positive and negative).Create two
new lists , one having all positive numbers and the other having all the negative numbers from
the given list. Print all the three lists
INPUT:-
OUTPUT:-
Q7. Write a Python program to input a tuple and check if it contains all elements as the same.
INPUT:-
OUTPUT:-
Q8. Write a Python program to print minimum, maximum, sum of keys of numbers dictionary
as given below
INPUT:-
OUTPUT:-
Q9. Write a Python program to split dictionary keys and values into separate lists.
INPUT:-
OUTPUT:-
Q10. Create a dictionary with the roll number, name and marks of n students in a class and
display the names of students who have scored marks above 75.
INPUT:-
OUTPUT:-
Q11. Input two numbers and display the larger / smaller number.
INPUT:-
OUTPUT:-
Q12.Input three numbers and display the largest / smallest number.

INPUT:-
OUTPUT:-
Q13. Generate the following patterns using nested loops:

Patterns 1
INPUT:-
OUTPUT:-
Pattern 2
INPUT:-
OUTPUT:-
Patter 3
INPUT:-
OUTPUT:-
Q14.Write a program to input the value of x and n and print the sum of the following series:
a) 1 + 𝑥 + 𝑥 2 + 𝑥 3 + 𝑥 4 + ⋯𝑥 n
b) INPUT:-
OUTPUT:-
Q15. Determine whether a number is a perfect number, an Armstrong number or a palindrome.
INPUT:-
OUTPUT:-
Q16 Input a number and check if the number is a prime or composite number.
INPUT:-
OUTPUT:-
Q17. Display the terms of a Fibonacci series.
INPUT:-
OUTPUT:-
Q18. Compute the greatest common divisor and least common multiple of two integers.
INPUT:-
OUTPUT:-
Q19. Count and display the number of vowels, consonants, uppercase, lowercase characters in
string.
INPUT:-
OUTPUT:-
Q20. Input a string and determine whether it is a palindrome or not; convert the case of
characters in a string.
INPUT:-
OUTPUT:-
Q21. Input a list/tuple of elements, search for a given element in the list/tuple.
INPUT:-
OUTPUT:-
Q.22. Read a text file and display the number of vowels/consonants/uppercase/

Lowercase characters in the file.
INPUT:-
OUTPUT:-
Q23. Create a binary file with name and roll number. Search for a given roll number and
display the name, if not found display appropriate message
INPUT:-
OUTPUT:-
Q.24.Write a random number generator that generates random numbers between 1 and 6
(simulates a dice).
INPUT:-
OUTPUT:-
Q.25. Write a Python program to implement a stack using list.
INPUT:-
OUTPUT:-
SQL QUERIES
 From the following table perform the following Queries:-
Q26. Using SQL Query display the names of Students who are getting a
grade “C” in either GAME or SUPW.
Q.27. Using SQL Query display different games offered in the school
Q.28. Using SQL Query to display the SUPW taken up by the students
whose name starts with ‘A’.
Q.29. Using SQL Query display the names of Students who play Cricket
from class 10.
Q.30. List all the students sorted by Class in descending order.

Q.31. List all the students who have Grade= A in either Game and SUPW.
Q.32. Create a “Class12” Database in MySQL using Python.
PYTHON:-
SQL:-
Q.33. CREATE TABLE STUDENT (id INT, name VARCHAR (255),

salary INT(6)).
PYTHON:-
SQL:-
Q.34. INSERT INTO STUDENT (id, name) VALUES (01, "John") in
MySQL with Python.
PYTHON:-
SQL:-
Q.35. Delete column "salary" from STUDENT in sql using python.
PYTHON:-
SQL:-

Cs Portfolio

Uploaded by

Copyright:

Available Formats

Cs Portfolio

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Cs Portfolio

Uploaded by

Copyright:

Available Formats

CENTRAL BOARD OF SECONDARY EDUCATION

AISSCE EXAMINATION SESSION – 2022-2023

Techno India Group Public School

PRACTICAL RECORD FILE IS SUBMITTED TO

SUBMITTED BY: Soumyadip Debnath

Signature of Internal Examiner Signature of Principal

22. . Read a text file and display the number of

24. Write a random number generator that

PART-B (SQL QUERIES)

PART-C (Python SQL Connectivity)

Q4. Write a Python program to create a 2D list.

Q12.Input three numbers and display the largest / smallest number.

Q13. Generate the following patterns using nested loops:

Q.22. Read a text file and display the number of vowels/consonants/uppercase/

 From the following table perform the following Queries:-

Q.30. List all the students sorted by Class in descending order.

Q.32. Create a “Class12” Database in MySQL using Python.

Q.33. CREATE TABLE STUDENT (id INT, name VARCHAR (255),

You might also like