Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    IT_project_file_Class_X_24-25

    Uploaded by

    gm0052593

    Copyright:

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

    IT_project_file_Class_X_24-25

    Uploaded by

    gm0052593
    2 views15 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
    2 views15 pages

    IT_project_file_Class_X_24-25

    Uploaded by

    gm0052593

    Copyright:

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

    St.

    John’s School, Faridabad


    Information Technology
    Subject Code : 402

    Practical File/ Student Portfolio


    Session 2024-25

    Submitted by :

    Name: ___________________________
    Class/Sec : ________________________
    Board Roll No: _____________________
    Examiner’s Signature: _______________
    ACKNOWLEDGEMENT

    I would like to express my special thanks and gratitude to my


    Computer Teacher Ms. ________________ for her able guidance
    and support in completing this project.

    I would also like to extend my gratitude to our Principal


    Ms. Aparna Gautam Panda for providing me with all the required
    facilities.

    Further, I would also like to thank my parents and friends who helped
    me in finishing this project.
    TABLE OF CONTENTS

    Q. No. Topic Page No.


    1 Consolidation

    2 Subtotals

    3 Scenarios

    4 Goal Seek

    5 Record Macro

    6 Hyperlink

    7 DBMS
    Instructions:-

    1. Do all questions given below practically and take coloured


    printouts / screenshots of steps while performing all
    operations. (A4 size sheet with portrait orientation)
    2. Sample of file is given for your reference. Attach Cover page
    and Acknowledgement page in the beginning of the practical
    file.

    3. Last date to submit Practical File is January 10, 2025


    Practical 1: Consolidation
    There are four sheets with same structure – quarterly results of
    sales of a stationery shop.
    A total yearly sales sheet has been made. The steps are: -
    1. Go to Data in menu bar Click on Consolidate.

    2. The Consolidate dialog box appears. Here, we can select the function we
    need to apply (Here, SUM).

    3. Then we have to specify the ranges for consolidation. To do so, choose the
    range while the Source data range text box in focus, then click on Add.
    4. Choose the desired cell for the results to copy in Copy results to text box.
    Click on OK.
    5. We will the final output as shown in the screenshot below.
    We get the consolidated data in the final sheet, named Yearly Sales.

    Practical 2: Subtotals
    In this table, different accounts are recorded and other important
    fields (AcctType, Branch, Customer etc.) are present.
    Here, we use Subtotal to find the total amount in different
    branches or number of branches.
    To perform subtotals, the steps are: -
    1. Select the range of cells as shown below.

    2. Go to Data menu → choose subtotals.

    3. Choose AcctType in Group by drop box menu → calculate subtotals for Amount
    → Use function Sum.
    4. In the 2nd Group, Group by branch → Calculate subtotals for amount → Use
    function count. Then press OK.
    Practical 3: Scenarios
    Scenarios in OpenOffice Calc comes under what-if analysis
    tools, where we are able to get different values for output by
    changing the input cells.
    Here, we have a table with cost price, selling price and profit
    percentage.

    Create 3 Scenarios by following the given steps:-


    1. Select the range of cells that are input and will be changed, here,
    Cost Price and Selling Price. → Go to Tools → Scenarios.

    2. Give the scenario desired name, check Prevent changes and uncheck Copy back.
    Also give different colours to different scenarios. → Click on OK.
    3. Repeat step 2 to add more scenarios and we can see the output changing.

    Practical 4: Goal Seek


    This option is used to find the value of input cells by giving the
    value of the output cell.

    The formula for finding Discount % is =(Discount/Marked


    Price)*100.
    The above image shows the Dis% as 12.5, Now by using Goal
    seek feature, take dis% as 30 and then compute Selling Price.
    We can use Goal Seek in the following ways: -
    1. Go to Tools Goal Seek.

    2. Set the formula cell as Discount %age cell, target as specified, here, and Variable
    Cell to be Selling Price.

    3. The result of Goal Seek is:-


    Practical 5: Record Macro
    The steps to record Macro are: -
    1. Go to Tools Macros Record Macro.

    2. Do the required steps to be recorded in the macro. Here, we write the formula
    in the cell G4 i.e., “=B2+C2+D2+E2+F2”. Then click on stop recording.

    3. Write a suitable name for the Macro Save.

    4. To run the macro, Go to Tools Macros Run Macros.

    5. Choose the desired Macro Click on Run.


    Practical 6: Hyperlink
    Here, we will add a hyperlink to a website. Steps are: -
    1. Go to Insert → Hyperlink.

    2. Click on Internet → Click on Web radio button → Under Target


    textbox, write the link of website.

    3. Click on Apply. The link will be visible in the selected cell.


    Practical 7: DBMS
    1. Create the table named “Staff” with specified fields . Also, set ID as
    a Primary Key. Use appropriate data types. Do take the screen shot
    of Design View.
    2. Insert any 7 records on your own and then take its screen shot and
    attach it in file.

    3. Display all records in increasing order of experience.

    4. Display those records whose Dept is sales and they should have experience
    of more than 10 years.
    5. Display dept and salary of all “Research” employees by making their salaries
    twice.

    Note:- After creating all the tasks(queries) from 1-5, take a screenshot and attach
    all these in your file.

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

    You might also like