[go: up one dir, main page]
Scribd
Upload
19 views2 pages

Class XII Practical file

The document outlines the requirements for a Class XII Computer Science practical file according to the CBSE curriculum, which includes Python programs, SQL queries, data structures, file handling, and project work. It provides a list of specific programming tasks and SQL queries that students must complete. The practical file aims to demonstrate proficiency in various programming concepts and data management techniques.

Uploaded by

SeanJoe2540U
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
19 views2 pages

Class XII Practical file

The document outlines the requirements for a Class XII Computer Science practical file according to the CBSE curriculum, which includes Python programs, SQL queries, data structures, file handling, and project work. It provides a list of specific programming tasks and SQL queries that students must complete. The practical file aims to demonstrate proficiency in various programming concepts and data management techniques.

Uploaded by

SeanJoe2540U
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Class XII

Computer Science (083) Practical File


� Contents of the Practical File

According to CBSE curriculum, your practical file must include:

1. Python Programs (20+ recommended)

2. SQL Queries

3. Programs on Data Structures (Stacks/Queues using Lists)

4. Programs on File Handling

5. Project Work (Python-based)

6. Report on Project Work

Practical File Questions

� 1. Python Programming (Functions, Strings, Lists, Dictionaries, etc.)

1. Write a Python program to calculate the factorial of a number using recursion.

2. Write a program to check whether a string is a palindrome or not.

3. Write a program to find the frequency of each character in a string.

4. Write a program to sort a list of integers using bubble sort.

5. Write a program to merge two lists and remove duplicates.

6. Write a program to count vowels and consonants in a given string.

7. Write a program to input a dictionary and display the key with the highest value.

8. Write a program to create a dictionary from two lists: one of keys and one of values.

9. Write a program to display the Fibonacci sequence using recursion.

10. Write a program to find the largest and smallest number in a list.
� 2. Data Structures (Stacks and Queues using Lists)

11. Write a program to implement a stack using list with push and pop operations.

12. Write a program to implement a queue using list with enqueue and dequeue operations.

13. Write a menu-driven program to perform stack operations (push, pop, display).

14. Write a program to reverse a string using stack.

� 3. File Handling

15. Write a Python program to create a text file and write some data into it.

16. Write a program to read contents of a text file and count the number of words.

17. Write a program to read a file and display only those lines that start with a vowel.

18. Write a program to store and retrieve student data using binary files.

19. Write a program to copy the contents of one file into another.

20. Write a program to count the number of lines, words, and characters in a file.

� 4. SQL Queries (Assume Table: STUDENT - RollNo, Name, Class, Marks)

21. Write a SQL query to display all the records from the STUDENT table.

22. Write a query to display names of students who scored more than 80 marks.

23. Write a query to change the marks of a student whose RollNo is 101.

24. Write a query to delete the records of students who failed (marks < 33).

25. Write a query to add a new column “Grade” to the STUDENT table.

26. Write a query to count the number of students in each class.

27. Write a query to find the student with the highest marks.

28. Write a query to sort students by name in ascending order.

You might also like