CBSE Computer Science Lab

 

UNIT NAME	MARKS (TOTAL=30)
FOLLOWING ANY ONE FROM EACH SECTION: PYTHON PROGRAM: 1.     Read a text file line by line and display each word separated by a #. 2.     Read a text file and display the number of vowels/consonants/uppercase/lowercase characters in the file. 3.    Remove all the lines that contain the character 'a' in a file and write it to another file. 4.    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. 5.    Create a binary file with roll number, name and marks. Input a roll number and update the marks. 6.   Write a random number generator that generates random numbers between 1 and 6 (simulates a dice). 7.   Write a Python program to implement a stack using list. 8.   Create a CSV file by entering user-id and password, read and search the password for given user id.	08
SQL QUERIES: 9.       Create a student table and insert data. 10.   ALTER table to add new attributes / modify data type / drop attribute 11.   UPDATE table to modify data 12.   ORDER By to display data in ascending / descending order 13.   DELETE to remove tuple(s) 14.   GROUP BY and find the min, max, sum, count and average 15.   Similar exercises may be framed for other cases. 16.   Integrate SQL with Python by importing a suitable module.	04
Report file	07
Project / Practical File	08
Viva Voce	03
TOTAL MARKS	30