Scribd Logo
Upload

Welcome to Scribd!

  • 48 views

    IT Practical File - X

    Uploaded by

    cbjpjyfcgr
    This document contains a summary of 14 practical exercises using Microsoft Office applications: 1. The first practical covers creating styles in Word. 2. The second covers cropping images in Word while maintaining scale. 3. Subsequent practicals cover topics like mail merge, consolidation of data across sheets in Excel, using subtotals and scenarios, linking data with hyperlinks, and recording macros. 4. The final two practicals discuss using accessibility options in Windows and creating a school database using tables, forms, and queries in Microsoft Access.

    Copyright:

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

    IT Practical File - X

    Uploaded by

    cbjpjyfcgr
    48 views49 pages
    This document contains a summary of 14 practical exercises using Microsoft Office applications: 1. The first practical covers creating styles in Word. 2. The second covers cropping images in Word while maintaining scale. 3. Subsequent practicals cover topics like mail merge, consolidation of data across sheets in Excel, using subtotals and scenarios, linking data with hyperlinks, and recording macros. 4. The final two practicals discuss using accessibility options in Windows and creating a school database using tables, forms, and queries in Microsoft Access.

    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 summary of 14 practical exercises using Microsoft Office applications: 1. The first practical covers creating styles in Word. 2. The second covers cropping images in Word while maintaining scale. 3. Subsequent practicals cover topics like mail merge, consolidation of data across sheets in Excel, using subtotals and scenarios, linking data with hyperlinks, and recording macros. 4. The final two practicals discuss using accessibility options in Windows and creating a school database using tables, forms, and queries in Microsoft Access.

    Copyright:

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

    IT Practical File - X

    Uploaded by

    cbjpjyfcgr
    This document contains a summary of 14 practical exercises using Microsoft Office applications: 1. The first practical covers creating styles in Word. 2. The second covers cropping images in Word while maintaining scale. 3. Subsequent practicals cover topics like mail merge, consolidation of data across sheets in Excel, using subtotals and scenarios, linking data with hyperlinks, and recording macros. 4. The final two practicals discuss using accessibility options in Windows and creating a school database using tables, forms, and queries in Microsoft Access.

    Copyright:

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

    INDEX

    Practical No. Topics Remark

    1 Writer Styles

    2 Image Cropping

    3 Writer Template

    4 Mail Merge

    5 Consolidation

    6 Subtotals

    7 Scenarios

    8 Multiple Operations

    9 Goal Seek

    10 Hyperlink

    11 Record Macro

    12 Self-defined Macro

    13 Structured Query Language

    14 Accessibility Options

    * Project Report on Result Management (MS Access)


    Practical 1: Writer Styles
    In this practical, we have to make a style in a file named
    - -
    To do so, the steps are: -
    1. Firstly, open a new writer document and make the desired style
    you like. I have taken my style to have font as Comic Sans MS, font
    size to be 18 and Italics.
    2. Select the text with the formatting. Go to Styles and
    Formatting in side bar Click on New Style from Selection.

    3. Write the desired style name in the Style name textbox, here
    My_Style Click OK.
    4. The style gets added and is shown in the Style and Formatting
    Menu.

    5. Save this file and open another file to which we want to import the
    style.

    6. In the Styles and Formatting sidebar, click on New Style from


    Selection drop down menu, then click on Load Styles.
    7. Click on From File button on the bottom right side of the dialog
    box.

    8. Browse the file and then Click on Open.

    The style will get added by these steps to the new file.
    Practical 2: Image Cropping

    1. We make a new writer file, and insert the image.


    2. Now we will crop the image by keeping scale. Right-click the
    image Click on Picture.

    3. Under the crop tab, Click on Keep Scale radio button Set other
    specification Click on OK.
    This image is about Cyber Ethics. Cyber Ethics are:
    1) We should not use abusive or offensive language with anyone
    online.
    2) We should or try to
    infect in any possible way.
    3) We should not do plagiarism or work and
    present it as our own.

    For this image, I have used Square as the text wrapping as


    it is easy to move or place it anywhere on the document
    after doing so.
    Practical 3: Writer Template
    A template is a document type that creates a copy of itself
    when we open it.

    For example, we can create a template for a certificate, and


    then use it again and again instead of making it again from
    scratch every time.
    To save it as a template, the steps are: -
    1. Go to the File Menu Click on Save As option.

    2. Browse to the desired place to save it and write the desired name
    for the file Choose the file type as Template (.ott).
    Practical 4: Mail Merge
    Mail Merge helps us create multiple copies of a document
    at once, such as letters, saving us time and effort to type the
    letter again and again.
    The steps are: -
    1. Make a document with spaces left for different fields.

    2. Make the database containing the details of the recipients. Go to


    File New Database.
    3. Create a new database and store it at an accessible place. Click on
    Use Wizard to create table.

    4. Under Personal category, in Addresses sample table, choose the


    required fields Next. Change anything if you want, and then
    click on Finish.

    5. Fill the details in the table Save it.

    6. In the writer, Go to Insert Fields Others.


    7. Go to Database Mail Merge Fields Choose the desired fields
    Click Add. After doing all, click on Close.

    8. Go to Tools Mail Merge Wizard.

    9. Click on Next until the last step. Choose the desired way to save or
    send the letter Click on Finish.
    Practical 5: 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 6: 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 7: 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.

    Now we will perform scenarios, the steps are: -


    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. Click on OK.

    3. Repeat step 2 to add more scenarios and we can see the output
    changing.
    Practical 8: Multiple Operations
    Here, we have a dataset and want to calculate the profit
    value.

    Now we use multiple operations to check the profit with


    changing the sale quantity and the price.
    To perform Multiple Operations, the steps are: -
    1. Select the data range with the input cells and space between them.
    Do not select the data labels.

    2. Go to Data Multiple Operations.

    3. Choose the cell containing the formula in Formulae textbox.


    4. Choose the Sale Quantity in Row Input Cell and Price per
    Quantity cell in Column Input Cell OK.

    By following these steps, we are able to perform Multiple


    Operations.
    Practical 9: Goal Seek
    This option is used to find the value of input cells by giving
    the value of the output cell.

    In the other cases, the discount %age is given and we have


    to find the 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.
    Practical 10: 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 11: Record Macro
    The steps to record Macro are: -
    1. Go to Tools Macros Record Macro.

    2. Do the required steps to be coded in the macro. Here, we write the


    formula in the cell B4 i.e., - 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 12: Self-defined Macro
    1. numberfive ()

    2. testmax (x, y)

    3. simpleinterest (p, r, t)

    4. compoundinterest (p, r, t)

    5. pover (x, y)
    Practical 13: SQL
    We will create a table and perform specific functions.
    1. Create a table named STAFF with specified fields.

    2. Add a new record of Fedrick.


    3. Display all records in increasing order of experience.

    4. Update the salary of people by adding 10,000 having experience


    more than 10 years.

    5. Display employees that belong to Sales Department.


    6. Delete the record of staff whose ID 117.

    7. Delete the table along with contents and structure.


    Practical 14: Accessibility Options
    Windows provide the users with many accessibility options.
    It enables a person with a disability or impairment to use a
    computer. It is known as Assistive Technology.
    Steps: -
    1. To launch the accessibility options, Open Control Panel Ease of
    Access Ease of Access Centre.

    2. Under Use text or visual alternatives, we can turn on Sound


    Sentry and Show Sounds by checking the check box beside the
    option Apply.
    3. Under Make the mouse easier to use, we can turn on Mouse
    Keys by checking the check box beside the option Apply.

    4. Under Make the keyboard easier to use, we can turn on Sticky


    Keys, Toggle Keys and Filter Keys by checking the check box
    beside the option Apply.

    5. Under Make the computer easier to see, we can turn on High


    Contrast by checking the check box beside the option Apply.
    PROJECT

    REPORT

    ON

    RESULT MANAGEMENT

    (MS ACCESS)
    PROJECT: RESULT MANAGEMENT

    1. CREATING SCHOOL DATABASE


    2. SAVING DATABASE

    3. CREATING TABLE USING DESIGN VIEW


    4. DEFINING STRUCTURE OF TABLE

    5. SAVING TABLE: PERSONAL_DATA


    6. SETTING PRIMARY KEY

    7. SAVING TABLE : MARKS


    8. CREATING RELATIONSHIP BETWEEN PERSONAL_DATA & MARKS
    9. CREATING FORM USING WIZARD – USER INTERFACE
    11. USER INTERFACE FOR PERSONAL_DATA TABLE

    12. USER INTERFACE FOR MARKS TABLE


    13. DATA ENTRY IN PERSONAL_DATA TABLE USING FORM
    14. DATA ENTRY IN MARKS TABLE USING FORM
    15. CREATING QUERY TO DISPLAY ALL RECORDS FROM BOTH TABLE

    16. CREATING QUERY USING DESIGN VIEW


    17. CREATING QUERY USING SQL VIEW
    18. CREATING REPORT USING QUERY
    19. REPORT GENERATED

    You might also like