CLASS XII: NOTES OF COMPUTER SCIENCE FILE HANDLING

 CLICK HERE TO OPEN NOTES

CLASS X IT BOOKS PDF

CLICK HERE FOR DOMESTIC DATA ENTRY OPERATOR 

CLICK HERE FOR EMPLOYABILITY SKILLS

Class XII: NOTES OF EXCEPTION HANDLING IN PYTHON

 Click here for Notes

CLASS X: PRACTICAL FILE IT 402 (2024-2025)

 FIRST PAGES    FOR DOWNLOADING

PRACTICAL FILE (PDF file)      FOR DOWNLOADIG

First Pages Sample (PDF file)    FOR FORMATTING PURPOSE

USE BAKER SIGNET FONT FOR SCHOOL NAME ONLY. CLICK HERE TO DOWNLOAD

Instructions: 

1. Kindly do the page setting before taking the printout of the first page's file because that file is in MS Word. 

2. Leave the Board Roll No. column blank on the first page.

3. Do not take screenshots for printing otherwise the file won't be accepted.

4. For editing in FIRST PAGES file, kindly download it first, and then you can edit it.

CLASS XI: PRATCICAL FILE OF COMPUTER SCIENCE 083 (2024-2025)

 Click here to open the practical file (pdf)

Click here to open the initial pages (word file)

Click here to open the SAMPLE initial pages (PDF file) (FORMATTING SAMPLE)

Instructions:

1. The first link is of practical questions with their output which you all have to take the printouts as it is (because it's in PDF format).

2. The second link is of initial pages which is in MS word document format and you have to edit it according to your details (like Name, roll no., etc.)

3. Do spiral binding of the printouts but make sure you get it checked from me before spiral binding. 

4. Do not open MS word document file online i.e. Initial Pages file (in google docs), first download it and then edit it, otherwise setting may vary.

5. Steps to download are; File>Download>Microsoft Word(.docx)

6. For any kind of query, contact me directly. (don't hesitate)

CLASS XII NOTES OF COMPUTER SCIENCE FILE AND EXCEPTION HANDLING

 NOTES

CS PROGRAMS

MCQs

CASE STUDY BASED QUESTIONS

EXCEPTION HANDLING CHAPTER PDF

CLASS XII: PRACTICAL PROGRAMS

 1. Write a menu drive program to perform following operations into a binary file shoes.dat. 8

a) Add record b) Display records c) Search record d) Exit The structure of file content is: [s_id, name, brand, type, price]

Solution:

import pickle def add_record(): s_id = int(input("Enter Shoe ID: ")) name = input("Enter Name: ") brand = input("Enter Brand: ") shoe_type = input("Enter Type: ") price = float(input("Enter Price: ")) record = (s_id, name, brand, shoe_type, price) with open("shoes.dat", "ab") as file: pickle.dump(record, file) print("Record added successfully.") def display_records(): try: with open("shoes.dat", "rb") as file: while True: record = pickle.load(file) print("Shoe ID:", record[0]) print("Name:", record[1]) print("Brand:", record[2]) print("Type:", record[3]) print("Price:", record[4]) print("-" * 30) except EOFError: pass except FileNotFoundError: print("File not found. No records to display.") def search_record(): try: s_id = int(input("Enter Shoe ID to search: ")) with open("shoes.dat", "rb") as file: while True: record = pickle.load(file) if record[0] == s_id: print("Record found:") print("Shoe ID:", record[0]) print("Name:", record[1]) print("Brand:", record[2]) print("Type:", record[3]) print("Price:", record[4]) return except EOFError: pass except FileNotFoundError: print("File not found. No records to search.") def main(): while True: print("\nMenu:") print("a) Add record") print("b) Display records") print("c) Search record") print("d) Exit") choice = input("Enter your choice: ").lower() if choice == 'a': add_record() elif choice == 'b': display_records() elif choice == 'c': search_record() elif choice == 'd': print("Exiting program. Goodbye!") break else: print("Invalid choice. Please try again.") if __name__ == "__main__": main()

2.

Solution:

import mysql.connector as mycon

# i. Fill in the parameters and values for statement 1 cn = mycon.connect(user='root', password='tiger', host='localhost',database='Customer')

# ii. Write function name to create a cursor and fill in the gap for statement 2 cr = cn.cursor() cust_id = int(input("Enter ID:")) cust_name = input("Enter Customer Name:") city = input("Enter City:") ba = float(input("Enter Bill Amount:")) mno = input("Enter Mobile No.") # iii. Write a query to fill statement 3 with desired values query = "INSERT INTO customer (CustomerID, CustomerName, City, BillAmt, MobileNo) VALUES (%s, %s, %s, %s, %s)" values = (cust_id, cust_name, city, ba, mno) cr.execute(query, values) # iv. Write a query to fill statement 4 to save the records into the table cn.commit() # Close the cursor and connection cr.close() cn.close()