Scribd Logo
Upload

Welcome to Scribd!

  • 225 views

    Class 12 CS - Program List

    Uploaded by

    Abc
    This document contains a list of 17 practical computer science exercises for Class XII. The exercises include writing programs to print Fibonacci series using functions, check for palindromes using functions, simulate a dice roll, create and import Python libraries, read and manipulate text files, implement stacks and queues using lists, perform SQL commands like ALTER, UPDATE, ORDER BY, DELETE, GROUP BY on a student database table, and integrate SQL with Python by importing the MySQL module to CREATE, INSERT, FETCH, UPDATE, and DELETE records.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Class 12 CS - Program List

    Uploaded by

    Abc
    225 views2 pages
    This document contains a list of 17 practical computer science exercises for Class XII. The exercises include writing programs to print Fibonacci series using functions, check for palindromes using functions, simulate a dice roll, create and import Python libraries, read and manipulate text files, implement stacks and queues using lists, perform SQL commands like ALTER, UPDATE, ORDER BY, DELETE, GROUP BY on a student database table, and integrate SQL with Python by importing the MySQL module to CREATE, INSERT, FETCH, UPDATE, and DELETE records.

    Original Description:

    CLASS 12 computer practicalsto be done

    Original Title

    Class 12 CS - program list

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a list of 17 practical computer science exercises for Class XII. The exercises include writing programs to print Fibonacci series using functions, check for palindromes using functions, simulate a dice roll, create and import Python libraries, read and manipulate text files, implement stacks and queues using lists, perform SQL commands like ALTER, UPDATE, ORDER BY, DELETE, GROUP BY on a student database table, and integrate SQL with Python by importing the MySQL module to CREATE, INSERT, FETCH, UPDATE, and DELETE records.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    225 views2 pages

    Class 12 CS - Program List

    Uploaded by

    Abc
    This document contains a list of 17 practical computer science exercises for Class XII. The exercises include writing programs to print Fibonacci series using functions, check for palindromes using functions, simulate a dice roll, create and import Python libraries, read and manipulate text files, implement stacks and queues using lists, perform SQL commands like ALTER, UPDATE, ORDER BY, DELETE, GROUP BY on a student database table, and integrate SQL with Python by importing the MySQL module to CREATE, INSERT, FETCH, UPDATE, and DELETE records.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    CLASS XII

    COMPUTER SCIENCE (083)


    LIST OF PRACTICALS

    1. Write a program to print the Fibonacci series using function.


    2. Write a program to check whether the string is palindrome or not using function.
    3. Write a random number generator that generates random numbers between 1 and
    6 (simulates a dice).
    4. Write a program to create a library in python and import it in a program.
    5. Read a text file line by line and display each word separated by a #.
    6. Remove all the lines that contain the character `a' in a file and write it to another
    file.
    7. Read a text file and display the number of vowels/ consonants/ uppercase/
    lowercase characters in the file.
    8. Write a program that reads a text file and create a new file after adding “ing” to all
    words ending with “t”, “p”, “d”.
    9. 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.
    10.Create a binary file with roll number, name and marks. Input a roll number and
    update the marks.
    11.Write a program to create a file CAMERA.csv having fields ModelNo,
    MegaPixel, Zoom and Price using comma as a delimiter and display its content.
    12.Write a program to read VOTERS.csv file containing VoterId, VoterName,
    VoterAge, Status having comma as a delimiter. Update the status of the voter as
    “Senior Citizen” whose age is above 60 years.
    13.Write a Python program to implement a stack using a list data-structure.
    14.Write a Python program to implement queue using a list data-structure.
    15.Take a sample of ten phishing e-mails (or any text file) and find most commonly
    occurring word(s).

    [Page 1 of 2]
    16.Create a student table and insert data. Implement the following SQL commands
    on the student table:
    a. ALTER table to add new attributes / modify data type / drop attribute
    b. UPDATE table to modify data
    c. ORDER By to display data in ascending / descending order
    d. DELETE to remove tuple(s) GROUP BY and find the min, max, sum,
    count and average
    17.Integrate SQL with Python by importing the MySQL module.
    a. CREATE A TABLE
    b. INSERT DATA
    c. FETCH DATA
    d. UPDATE RECORD
    e. DELETE RECORD

    ************

    [Page 2 of 2]

    You might also like