Practical File Computer Science Class 12 – A comprehensive guide

Practical File Computer Science Class 12 is very essential for practical assessment of the board. In this article I will provide a complete and comprehensive guide including the file. Here we go!

If you don’t want to read this, watch this video instead:

Practical File Computer Science Class 12 – The Structure

Practical File Computer Science Class 12 is 7 mark component of practical exam for academic session 2024-25. In this practical file, the following things are requried:

15 – Python Programs for Practical File Computer Science Class 12

The first part of Practical File Computer Science Class 12 consists of 15 python programs as follows:

1. Python revision tour (2)
2. Working with Functions (4)
3. Exception Handling (2)
4. File Handling (5)
5. Data Structure Stack (2)

5 Sets of MySQL Queries for Practical File Computer Science Class 12

The second part of Practical File Computer Science Class 12 consists of 5 sets of MySQL Queries as follows:

1. Set 1 – Based on Database Basic Commands
2. Set 2 – Based on DDL Commands
3. Set 3 – Select Queries including order by
4. Set 4 – Group by, having and Aggregate Functions
5. Set 5 – Join Queries

Let’s see the initial documents required for the Practical File Computer Science Class 12.

Initial Pages for Practical File Computer Science Class 12

Let’s see the initial pages for practical file computer science class 12. These pages are:

1. Cover page
2. Certificate
3. Index

Cover Page of Practical File Computer Science Class 12

The practical file requires a cover page with details related to Practical file such as – Subject, Subject Code, Class, Academic Year, School logo and school details as well as student details. The page formatting and design should be as per student’s choice.

Certificate Practical File Computer Science Class 12

The certificate is the second page for Practical File Computer Science Class 12, which consists of student details, school details and no. of practicals certified in the file. Observe this:

Index page for practical file computer science class 12

The index page should contain four columns :

1. S.No
2. Assignment
3. Date
4. Signature

Download the initial pages by following this link:

Part A – Python Programs

For separate programs follow the list and given links:

1. Write a program to find the sum and average of list in python.
2. Write a program to remove duplicates from the dictionary.
3. Write a program to define a function to accept two integers m and n respectively as argument and display prime numbers between them.
4. Write a program to compute interest based on different arguments given in the function.
5. Write a program to largest element in a list using a function. Pass list object as argument.
6. Write a program to count the number of vowels in passed string to the function.
7. Write a program to take two integers and perform addition of two numbers handle exception when non-integers entered by user.
8. Write a program to find the square root of a positive number, raise a custom exception when user enters a non-integer number.
9. Write a program to replace entered word from a text file india.txt.
10. Write a menu driven program to store and manipulate data in binary file to insert, update, delete and display records. The data has following structure:
    Data Represents – Patient Information
    Dictionary – {‘P_ID’:101,’P_Name’:’Shiv’,’Charges’:25000}
    File Name – patient.dat
    Menu:
    1 – Add Patient
    2 – Display Patient
    3 – Search Patient
    4 – Update Patient
    5 – Delete Patient
    6 – Exit
11. Create a CSV file by entering user-id and password, read and search the password for given userid.
12. Write a program to create a binary file candidates.dat which stores the following information in list as follows:
    Structure of Data:
    Candidate_id – Integer
    Candidate_Name – String
    Designation – String
    Experience – Float
     (i) Write a function append() to write data into binary file.
    (ii) Write a function display() to display data from binary file for all candidates whose experience is more than 10.
13. Write a program to generate a CSV file named happiness.csv. Each record of CSV contains these data:
    Name of the country -String
    Population of country – Integer
    No. people participated in survey – Integer
    No. of people who are Happy – Integer
    Write user defined functions to do the following:
    1 – Insert records into CSV
    2 – Display records from CSV
    3 – Update record
    4 – Delete record
14. Write a menu drive program for stack operations.
15. Write a program to Push an item into stack where a dictionary contains the details of stationary items as follows: stn = {“Shirt”:700,”T-Shirt”:750,”Jeans”:1150,”Trouser”:400}

(a) Write a function to push an element into stack for those items names whose price is more than 850.

(b) Also display the count of elements pushed into the stack. Write a function to pop an element to remove the element and display appropriate message when the stack is empty.

Part B – MySQL Queries

As per CBSE syllabus of Computer Science 5 sets of MySQL queries are required in your practical file. I have taken these 5 sets:

1. Set 1 – Based on Database basic commands
   • Create a database named practical_2025
   • Check the database is created or not
   • Open a database
   • Create a database emp
   • Delete Database emp
2. Set 2 – Based on DDL commands
   • Create a table and insert data
   • Show the structure of table
   • Add a column
   • Modify a column
   • Rename a column
   • Delete a column
3. Set 3 – Select SQL Queries including SQL query
   • Artihmatic operator
   • In operator
   • Between Operator
   • Like operator
   • null operator
   • order by
4. Set 4 – Group by, having aggregate functions
   • Group by Query
   • Distinct Keyword
   • Aggregate function max()
   • Aggregate function avg()
   • Group by and Having
5. Set 5 – Join Queries
   • Display cartesian product
   • Equijoin
   • Natural Join
   • Where condition in join
   • Using alias names

Part C – MySQL & Python Connectivity Programs

Part C of Practical file contains MySQL & Python Connectivity Programs. These programs are as follows:

1. Write a program to connect with mysql database and insert a record into database.
2. Write a program to connect with mysql database and update a record into database.
3. Write a program to connect with mysql database and delete a record into database.
4. Write a program to connect with mysql database display record of particular label under the artist is working.

Download Practical File Computer Science Class 12

Here I am enclosing the Practical File Computer Science Class 12. Click on the file and download it for your reference.