# Complete solution Information Technology Practical Paper 3 Class 10

#### Bytutorialaicsip

Dec 29, 2023

In this article, I am going to explain a complete solution for information technology practical paper 2 class 10. So let’s begin!

Topics Covered

## Solution Information Technology Practical Paper 2 Class 10

You will get the question paper information by following the link:

So let us begin with a solution from here:

Solution

1. Type the text as displayed in the question.
2. Create different levels of headings as per displayed outlines such as Heading 1 for – Database Query Using SQL, Sorting in SQL, and Group by and heading 2, heading 3 as per hierarchy.
3. Now separate them as per the given pages. Apply different page breaks after or before headings.
4. Go to the first page and apply page break to insert a blank page on top.
5. Click on Insert -> Indexs and Tables -> Indexes and Tables option.

## Question 2 Electronic Spreadsheet (Topic – Scenario)

• For the above spreadsheet consider the formula for profit as =B1/B2
• Create the following scenarios in the spreadsheet:
• Delete the scenario TH30
• Rename scenario FR40 to O40

Solution:

Steps to create scenarios:

1. Prepare the spreadsheet in OO Calc and enter the data given in question.
2. Enter the formula in the cell B3.
3. Now click on select the data.
4. Click on Tools -> Scenario.
5. Enter the scenario name for the current data. The default data scenario name is not given in the question so you can write as you wish.
6. Choose the color table for the current scenario.
7. Click on OK.
8. Change the data as per requirements.
9. Repeat the steps for creating scenarios and changing tab colors for all the given scenarios.

Steps to delete scenarios:

1. Click on the view -> Navigator option.
2. Now click on the scenarios button.
3. Right-click on the scenario named TH30.
4. Choose the option Delete. It will prompt the confirmation to delete the scenario. Click on the Yes button.

Steps to Rename Scenario:

1. Click on the view -> Navigator option.
2. Now click on the scenarios button.
3. Right-click on the scenario named FR40.
4. Now click on Properties. It will open the edit scenario dialog box.
5. Type O40 in the scenario name box and click on OK.

## Question 3 Database Management System

Create following table empl in OO Base and perform below given queries:

1. Create the above table using the SQL command.
2. Write Queries for the following:
a. Display the details of employees whose salary ranges from 60000 to 75000.
b. Display empno, ename, doj and salary of employees belongs to Ahmedabad and Surat.
c. Display ename and salary of employees except 5001.
3. Create a form using wizard enter, delete and show data of employee.
4. Create a report showing data city wise.

Create table command

``````create table empl
(empno int (4) primary key,
name varchar(20),
doj date,
salary int(5),
city varchar(20));

insert into empl values

Queries:

1. select * from empl where salary between 60000 and 75000; OR select * from empl where salary>=60000 and salary<=75000;
2. select empno, ename, doj, salary from empl where city =’AHMEDABAD’ or city=’SURAT’; OR select empno, ename, doj, salary from empl where city in (‘AHMEDABAD’,’SURAT’);
3. select ename, salary from empl where empno!=5001;

Steps to create forms:

1. Click on the forms button.
2. Click on Use Wizard to create a form. A form wizard dialog box appears.
3. Choose the table from the tables or queries option.
4. Now select all fields to add to the form. and click on the Next button.
5. Again click on Next as we are not going to add a sub form.
6. Now arrange the controls in the main form. and Click on the Next button.
7. Now click the form to display all data and click on the Next button.
8. Select the appropriate style for the form.
9. Name the form and select the option works with the form.
10. Click on the Finish button.

Create reports:

1. Click on the Reports button.
2. Click on the option to use a wizard to Create a Report.
3. Select the table and fields to be used in the report. and Click on Next.
4. Choose the labels from the window and click on Next.
5. Select the grouping on the city column and click on Next.
6. Click on Next after the sorting option.
7. Choose the desired layout. and click on the next button.
8. Choose the title of the report and select the Create Report Now radio button.
9. Click on the Finish button.