Section-A : Programming in Python
1. Write a Python program to find the factorial of number
2. Write a program to check if a given number is even or odd
3. Write a program to find the largest among three numbers
4. Write a program to sort a list according to the order of another list
5. Write a program to create a NumPy array
Note : Additional Practicals for Practice
6. To find the average and grade for given marks
7. To find the sale price of an item with given cost and discount (%)
8. To calculate perimeter/circumference and area of shapes such as triangle, rectangle, square and circle
9. To calculate Simple and Compound interest
10. To calculate profit loss for given Cost and Sell Price
11. To calculate EMI for Amount, Period and Interest
12. To calculate tax-GST/Income Tax
13. To find the largest and smallest numbers in a list
14. To find the third largest/smallest number in a list
15. To find the sum of squares of the first 100 natural numbers
16. To print the first ‘n’ multiples of a given number
17. To count the number of vowels in a user entered string
18. To print the words starting with an alphabet in a user entered string
19. To print the number of occurrences of a given alphabet in each string
20. Create a dictionary to store names of states and their capitals
21. Create a dictionary of students to store names and marks obtained in 5 subjects
22. To print the highest and lowest values in a dictionary
Section-B : Data Management : SQL Commands
1. To create a database
2. To create student table with the student-id, class, section, gender, name, dob and marks as attributes where the student-id is the primary key
3. To insert the details of atleast 10 students in the above table
4. To display the entire content of the table
5. To display Rno, Name and Marks of students scoring marks more than 50
6. To display Rno, Name, DOB of those students who are born between ‘2005-01-01’ and ‘2005-12-31’
VIVA-VOCE : Questions and Answers
Excellent as described in the picture. Outstanding quality.