CBSE COMPUTER SCIENCE

enter no of times :10 enter value :1 enter value :S enter value :E enter value :3 enter value :TEST enter value :56 enter value :MAIN enter value :EXAM enter value :87.3 enter value :60.4 SS 6.0 112.0 EXAMEXAM 120.8 >>>

# write a program to multiply an element by 2 if it is an odd index for a given list containing both numbers and strings #(review of python - unsolved Q18) L=[] N=int(input("enter no of times :")) for j in range(1,N+1): X=input("enter value :") if X.isalpha(): L.append(X) else: Y= float(X) L.append(Y) for i in range (0,N,1): if i%2!=0: print(L[i]*2)

EVERYONE WORK OUT WITH ABOVE SET OF QUESTIONS...

Question Set for Lab Practical

QUESTION PAPER 01. Write a Python program to find Factorial of a given number using iteration method 02. Write a Python program to check the given number is Prime or Not 03. Write a Python program to calculate the Fibonacci Series for N-Terms 04. Write a Python program to make a simple Arithmetic Calculator using function 05. Write a Python program to read and display content of the file line by line and each words separated by “#” 06. Write a python program to read a text file as file1.txt and display the number of vowels/ consonants/ uppercase/ lowercase characters in the file. 07. Write a Python program to implement a stack using a list data-structure. 08. Write a Python program to implement a queue using a list data-structure. 09. Write a Python program to remove all the lines that contains the character `a' in a file and write it to another file. 10. Write a python program to create a binary file as “student.dat” with name and roll number. Search for a given roll number and display the name, if not found display appropriate message. 11. Write a python program to create a binary file as student.dat with roll number, name and marks. Input a roll number and update the marks. 12. Write a Python program to display employee name and salary if employee number is exist in the CSV file. 13. Write a python program to generate random numbers between 1 and 6 (simulates using a dice). 14. Write a Python program to take a sample of ten phishing e-mails (or any text file) and find most commonly occurring word(s) 15. Write a Python with MySql interface program to create a database “SCHOOL” if not exists, otherwise display the proper message 16. Write a Python with MySql interface program to create a table if not exists in the database “MYSCHOOL” otherwise display the proper message 17. Write a Python with MySql interface program to Store and Retrieve records of employees from the database “OURSCHOOL” 18. Write a Python with MySql interface program to Search and Display the records of employee from the database “SCHOOL” 19. Write a Python with MySql interface program to to Update a record of the employeefrom the database “COMPANY” 20. Write a Python with MySql interface program to Delete the record of employee from the database “MYCOMPANY”

MySQL Commands : DML, DDL, DQL, TCL, select, create db, create table, insert, delete , drop , use, aggregate functions-avg(), min(), max(), sum(),

Data Structure: define data structure, types of datastructure-linear and nonlinear ds, stack and queue, operation on stack , applications of stack, opeartion on queue, application of queue, LIFO, FIFO

Functions: types of function-user defined, built-in function, formal and actual argument, argument passing technicques, argument types like default argument, positional argument and keyword argument

Python libraries: - pythonpath , absolute and relative path...module, library, package

Topics for Lab Viva-Voce : REVIEW OF PYTHON- list, tuples, dictionary, immutable obj, immutable, list , tuple and dictionary functions. File Handling: types of file, various modes of file operation, file handle/file obj. use of pickle and csv module... methods for reading text file(read,read(n), readline, readlines, write and writelines)—- Binary file: dump and load methods, CSV- reader, dictreader, writer and dictwriter , default separator