Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    pdf_1735074319094 (1)

    Uploaded by

    yhrajesh78

    Copyright:

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

    pdf_1735074319094 (1)

    Uploaded by

    yhrajesh78
    4 views6 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    pdf_1735074319094 (1)

    Uploaded by

    yhrajesh78

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 6

    CLASS – X

    PRACTICAL FILE WORK (2024–25)


    SUBJECT – INFORMATION TECHNOLOGY (SUBJECT CODE-402)
    IMPORTANT INSTRUCTIONS:
    • Your file must include the following sections: front page, certificate, acknowledgement, index and
    bibliography.
    • After completing all the questions, take a printout and attach it to your practical file.
    • For every printout use Print Screen command.
    • Do not use plastic file to submit your work.
    • Submit your file by December 30, 2024, without fail.

    DIGITAL DOCUMENTATION (ADVANCED)


    1. Create a template for a formal letter to some government authority.
    2. Create a ToC for Unit-2 (Electronic Spreadsheet) which is given in your book on index page.
    SAMPLE IMAGE
    3. Write the following paragraph and insert relevant image in the file and place it as displayed in
    the following screenshot:

    4. Design a visiting card for your friend mentioning his/her name, address, designation, company,
    contact details and a company logo assuming that your friend works in that company as
    Regional Sales Manager.
    SAMPLE IMAGE

    ELECTRONIC SPREADSHEET (ADVANCED)


    5. Prepare the following worksheet and use Subtotal to find the total amount in different branches
    or number of branches.
    6. Prepare the monthly class test worksheet as given in below screenshot and prepare the
    consolidated result as displayed below:

    7. Enter the following data into the worksheet and compute the strike rate of the batsman:

    The formula for strike rate is=B1/B2*100


    Now find out the strike rate for the following data and give them proper names and comments.
    a) When score is 55 and balls faced are 40.
    b) When score is 78 and balls faced are 80.
    c) When score is 95 and balls faced are 77.
    8. Write the functions or formulas for the following table:

    a) Calculate the DA of all the employees as 10% of their salary.


    b) Calculate the TA of all the employees as 15% of their salary.
    c) Calculate the HRA of all the employees as 25% their Salary.
    d) Calculate the Total Salary as DA+TA+HRA.
    e) Find the maximum, minimum, and average salaries being dispensed by this company.
    (After applying all the formulas attach the printout in your file)

    DATABASE MANAGEMENT SYSTEM


    9. The student admission system refers to storing and managing student details along with their
    fees details. To do so you will have to create two tables in the student database. The first table
    will be a ‘student data’ table which will contain all the details of student. The second table will
    be a ‘fees’ table which will contain the details of fees deposited by these students. You have to
    use Design view to create the structure of these two tables as shown below:
    Student data Table Design View
    Field Specifications
    Enrollment
    Field type- Integer
    Primary Key
    Length- 10
    Name
    Field type- Text(VARCHAR)
    Length-30
    Class
    Field type- TinyInteger(TINTINT)
    Entry required-Yes
    Length-3
    Roll No
    Field type- SmallInterger(SMALL INT)
    Entry required-Yes
    Length-5
    DOB
    Field type- Date
    Entry required-Yes
    Format-01/01/00
    Address
    Field type- Text (VARCHAR)
    Entry required- Yes
    Length-50

    City
    Field type- TEXT(VARCHAR)
    Entry required-Yes
    Length-15
    Default Value-Jaipur
    After creating the table enter any 10 records in it.
    Fees Table Design View
    Field Specifications
    Enrollment
    Field type- Integer
    Primary Key
    Roll No
    Field type- Small Integer (SMALL INT)
    Length-5
    Fee Date
    Field type- Date
    Entry Required- Yes
    Format- 01/01/00
    Receipt No.
    Field type- Small Integer (SMALL INT)
    Length-5
    Amount
    Field type- Float
    Entry required- Yes
    Format- General
    After creating the table enter any 10 records in it.
    • Set the relationship in both the tables on their common field Enrollment.
    • Create a query which shows the records of those employees only who belongs to Jaipur city.
    10. Write the SQL commands for the following table: Student

    a) Display all the records of table Student.


    b) Display record of student whose roll number is 3.
    c) Display record of students who are in class ‘X’
    d) Display the record of ‘Anuj’.
    11. Create a database named as Stock Inventory containing the following tables:

    • Choose the data types as per your requirement and set the primary key also.
    • After creating the table enter any 10 records in it.
    • Create all the tables in design view only.
    • After creating this database create a database report.

    You might also like