DR.
CYRUS POONAWALLA ENGLISH MEDIUM
SCHOOL.
NAME---> RIYA VINOD KUMAR
CLASS--->Xth C
Roll no.10
IT PRACTICAL FILE
GUIDED BY--->ARCHANA MISS
CERTIFICATE
THIS IS TO CERTIFY THAT RIYA VINOD KUMAR,
STUDENT FROM CLASS Xth C HAS SUCCESFULLY
COMPLETED THE IT PRACTICAL FILE GIVEN BY
ARCHANA MISS IN THE ACADEMIC YEAR 2023-24.
ARCHANA MISS PRINCIPAL MAM
----------------------- ------------------------
Q1.SC Bank has it’s deposit and its withdrawal details
of each customer for 3 months prepare consolidated
data using open office calc?
ANS... Step 1:Create the three months information of
withdraw and deposit details in sheets 1,2 and 3:
Sheet 1(1st month data)
Sheet 2 (2nd month data)
Sheet 3(3rd month data)
Step 2: Click on Data--->Condolidate,in the dialogue box
specify source data range and copy results to.
Consolidate dialogue box
Step 3: Then,Click on OK button with the SUM function.
Consolidated sheet of 3 months together(FINAL)
Q2. SC distributes various items to different
sellers.Calculate the seller wish distribution of products
using subtotal options.
ANS.... Step 1:Enter the data in the worksheet
Step 2:Select the range of the data with column heading.
Step 3: Click on DATA-->SUBTOTALS
Subtotals dialog box
Step 4: In the broup by box slect the column you want to
add to the subtotals.Here it is 500 column.
Step 5: Click OK the subtotals get calculated.
Subtotal crated
Q3.Prepare scenarios to calculate profit and profit %
different selling and cost price?
Ans....Step 1: Select the range of the cells.
Step 2: Click on TOOLS-->SCENARIOS.
Creating a scenario
Step 3:Click the OK button to create a scenario.
A scenario is been created
This has only 1 scenario.
Q4.Find value of cost price, if the value of profit is
known ,using Goal seek operations ?
Ans... Step 1: Create the worksheet about the value of
profit.
Step 2: Now click the desired cell
Step 3: Click TOOLS--->GOAL SEEK
Sheet is been created
Goal seek dialog box appears
Step 4: In the variable cell enter the reference of the
cell that contains value to be changed.
Step 5: In the target value enter the desired result of
the formula.
Step 5: Click OK.
Output of goal seek
Q5.Step to create marksheet using Macros using in
open office calc.
ANS.... Step 1: Select TOOLS--->MACROS---
>RECORD MACRO to start recording a macro.
Step 2: Perfeorm a series of operation that you want to
perform.
Step 3: Click the stop recording option.
Make a worksheet in the macro and then click STOP
RECORDING.
Basic macro dialogue box
Step 4: Click the New module button. In the new
module box type the name of the module. Then click
on the OK button.
Step 5: Select the newly created module and enter the
macro name in the text box. Now click on Save to
save the macro.
Saving the module.
Q6.Create a table using:
A) Design view
ANS.... Step 1: Click on the databse option in the
spreadsheet.
Step 2:Click on Create a table using design view.
Step 3: Start entering the data with their proper
characters.
Click on Create table using design view
The database is being filled
Step 4: Now give the name of the table as 'TABLE 1'.
Naming of the table
Step 5:You can see in the tables option your saved
table.
Table is being saved
B)SQL commands
ANS....Step 1:Go to the databse click on TOOLS---
>SQL
Step 2:Write the SQL statements
Step 3: Consider of not doing any kind of syntax error
and any kind of error kindly check out through that.
Click on SQL
SQL box where we have to write commands.
Writting down the command
Q7.
Q8.Create Query using design view and execute
following commands.
A) Display Name , Salary ,Department of all Employee
ANS...Step 1:In the database option select the Create
Query using design view.
Step 2: Now select the table created earlier.
Create query using design view
This kind of box appears.
Select the table I have selected TABLE 2.
Step 3: Now fill the respective fields such as Roll
no,class,standard,marks etc.
Process of filling the fields
Step 4: Now click from the above option RUN
QUERY.
Finally the query is been run
A)Display name,salary,department of all employees.
ANS....
B)Display records of all female employees having salary
greater than 60000
ANS....
Q9.Write steps to create a form using Wizard in open
office.
ANS...
Step 1:Click on the “forms” icon in the database
menu.
Step 2: In the forms window “Use wizard to create a
form.
Step 3: Select the table that is needed to create a form.
Table 2 is been selected
Step 4: Choose the fields that you want to include in
your list.
Setting up a sub form.
Step 5: Add sub from fields
Step 6: If you need then set up joint fields.
Step 7: Now click on the option of arrange controls.
Step 8: You can apply any kind of style to the
document now.
Step 9: Now set the name of your form.
The form is been created with a sub form add on.
Q10.Write a step to create a report using wizard in
open office Base.
ANS...
Step 1: Go on the reports opetion after selecting the
existing database.
Step 2:Now click on “use wizard to create a report.”
Use wizard to create a form
Select the desired table
Step 3: Now click on the option of labelling fields and
label them as well.
Labelling fields.
Step 4:Now group the data if it's needed.
Grouping the data.
Step 5: Now further proceed by sorting the options.
Step 6: Select the desired layout
Clicking the desired layout.
Step 7: Now at last Create the report and if needed
then change the title of the report.
Creating the report
Step 8: Now click on the Finish button.
The report is been created.
