DR RAJU DAVIS INTERNATIONAL SCHOOL

A SENIOR SECONDARY SCHOOL AFFILIATED TO CBSE NEW DELHI,931314

MALA, THRISSUR, KERALA

ALL INDIA SECONDARY SCHOOL CERTIFICATE EXAMINATION

PRACTICAL LAB RECORD

INFORMATION TECHNOLOGY (402)

NAME : …………………………………………………………………
REG. NO. : ……………………………………………………………
Certified that this is a bonafide record Of practical work done by
Mr. /Mrs. : ………………………………………………………………………….
In this school and submitted for the practical examination On :
…………………………………………………………………………….
Teacher In-Charge : ………………………………………………………………

……………………………… …………………………..

External Examiner Principal

1
 INDEX

Signature
S.No Date Topic Page
of Teacher

Write the steps to create new style in Open

1. 08/06/2023 2
OfficeWriter.
Insert an image into document.Format the
2. 15/06/2023 belowcontents and apply any two wrapping 4
options.
Create a Template from a document and use it
3. 22/06/2023 7
asdefault template in Open Office Writer.

Insert two drawing objects and perform grouping and

4. 29/06/2023 10
ungrouping operations.

Explain the styles given in the Styles and

5. 06/07/2023 12
FormattingWindow for writer

Write the steps to consolidate data of two sheets in

6. 13/07/2023 13
Open Office Calc

Write the steps to record and run Macro in open

7. 27/07/2023 16
officecalc

Create the a table .Add hyperlink of the website

8. 03/08/2023 19
ofyour school and www.w3schools.com

9. 10/08/2023 Perform Goal seek. 22

10. 11/08/2023 Create Scenarios 25

11. 24/08/2023 Create Table FITNESS and write SQL Queries 27

12. 30/08/2023 Create table FABRIC in design view. 30

13. 12/09/2023 Write the SQL Queries based on the table FABRIC. 33

14. 21/09/2023 Create a Form for the Table FABRIC. 35

15. 28/09/2023 Create a report based on the above Table FABRIC. 39

2
Q1. Write the steps to create new style in Open Office Writer.
Ans. Creating a new style from a selection:
1. Open the Styles and Formatting window and choose the type of style you want to
create.

2. In the document, select the item you want to save as a style.

3
3. In the Styles and Formatting window, click on the New Style from Selection icon

4. After Clicking on New Style from Selection, create style dialog box appear.

5. Write the name for the new style and click on OK

4
Q2. Insert an image into document.Format the below contents and apply any two
wrapping options.

A computer is a programmable device that stores, retrieves, and processes data.

The term was later given to mechanical devices as they began replacing human
computers. Today's computers are electronic devices that accept data (input), process
that data, produce output, and store (storage) the results (IPOS).

Ans:
1. Insert an image into the Writer using any method.

2. Type the text given in the Writer.

5
3. Apply various formatting to the text.

4. To apply the wrapping techniques, right click on the image , wrap > choose the
wrapping option.

a) Page wrap

6
b) Optimal Page wrap

7
Q3.Create a Template from a document and use it as default template in Open Office
Writer.
Ans:
Creating New Template

1. Open a new document in Open Office writer and add the content and styles that you
want.

2. From the main menu,choose File > Template > Save. Templates Dialog Box
appears.

8
 a) In the New template field ,type a name for the new template.
b) In the categories list,click the category to which you want to assign the
template.
c) Click OK to save the new template.

Setting a custom template as the default

1. From the main menu,choose File > Template > Organize.The Template
Management Dialog box opens.

9
2. In the box on the left,select the folder containing the template that you want to set as
default,then select the template.

3. Click the commands button and choose Set As Default Template from the drop down
menu.

Open a New File to see the template set as default.

10
Q4. Insert two drawing objects and perform grouping and ungrouping operations.

Ans:
1. Open New Open Office writer File.
2. Enable the Drawing Toolbar by clicking View > Toolbars > Drawing

3. Draw any two objects using the shapes available in Drawing Toolbar.

4. To select the two objects,first select one object then hold down the shift key and select the
other object you want to include in the group.

11
5. With the objects selected ,hover the mouse pointer over one of the objects and choose
Format > Group > Group from the menu bar or right click and choose Group > Group
from the pop-up menu.

6. To ungroup the two objects , hover the mouse pointer over one of the objects and choose
Format > Group > Ungroup from the menu bar or right click and choose Group >
Ungroup from the pop-up menu.

12
Q5. Explain the styles given in the Styles and Formatting Window for writer
Ans. OpenOffice.org supports the following types of styles:
1. Page style
2. Paragraph style
3. Character style
4. Frame style
5. Numbering style
6. Cell style
7. Graphics style
8. Presentation Style
Page style: include margins, headers and footers, borders and backgrounds. In Calc, page
styles also include the sequence for printing sheets.
Paragraph style: control all aspects of a paragraph’s appearance, such as text alignment,
tab stops, line spacing, and borders, and can include character formatting.
Character style: affect selected text within a paragraph, such as the font and size of text,
or bold and italic formats.
Frame style: are used to format graphic and text frames, including wrapping type, borders,
backgrounds, and columns.
Numbering style: apply similar alignment, numbering or bullet characters, and fonts to
numbered or bulleted lists.

13
Q6. Write the steps to consolidate data of two sheets in Open Office Calc

Ans.
1. Open a new file in Open Office Calc and write the following data :

2. Open another file in Open Office Calc and write the following data:

3. Open the third sheet and click on Data → Consolidate.

14
4. Click to select Source data range of first sheet and then click on Add button.

5. Click to select Source data range of second sheet and then click on Add button.

6. Click on Copy results to Text Box and choose the first cell in the sheet where data is
to be consolidated (sheet 3).Check Row labels, Column labels, Link to source data
under More option. Click OK Button.

15
7. After clicking OK button, we will get the consolidated data as shown below

16
Q7. Write the steps to record and run Macro in open office calc.

Ans. Following steps create a macro that performs paste special with multiply.

1. Open a new file in calc.

2. Enter the following data in Sheet1

3. Enter the following data in Sheet2

4. Goto Sheet1.Use Tools > Macros > Record Macro to start the macro recorder.

17
5. Apply various formatting to the table .Once it’s done, Click Stop Recording to stop the
macro recorder.

6. The OpenOffice.org Basic Macros dialog opens and save the macro at specified place
with a particular name.

7. Goto Sheet 2, Use Tools > Macros > Run Macro to run the saved macro.

18
8. The OpenOffice.org Macros selector dialog box opens .Locate the saved macros.

9. The formatting saved will be applied to the table created in sheet 2.

19
Q8. Create the following table .Add hyperlink of the website of your school and
www.w3schools.com as below.

Provide link to www.w3schools.com for study material column.

Ans:
1. Open a new Open Office Calc file.
2. Type the contents as given

3. Click on the cell in which hyperlink is to be added. Click on the Hyperlink option on the
standard toolbar or Insert > Hyperlink. Hyperlink Dialog box will be opened.

20
4. In the Target Text box, type the website address to which hyperlink is to be provided.
Type the Text to be displayed in the cell. Then click Apply Button.

5. Repeat the same for below rows.

21
6. Enter School website another cell and repeat the above step to add hyperlink. Leave
the Text column as blank. Then click Apply button.

22
Q9. Perform the below problem using Goal seek.

A student is planning her goals about the marks she should attain in the forthcoming
semester 4 examination in order to achieve a distinction (75%).Assuming that examination
of each subject is for 100 marks, her marks of the previous semesters are given under:

Subject 1 Subject 2 Subject 3 Subject 4

Semester 1 82 67 53 87
Semester 2 88 78 76 69
Semester 3 89 85 91 67

Find out how many marks should she obtain in 4th Semester to secure distinction.

Ans:
1. Open New Calc File
2. Create a table with the above contents and create a new row for SEMESTER 4 and
PERCENTAGE.

3. Type the formula for percentage in cell B6 .Drag the same to C6,D6 and E6.

23
4. To perform Goal Seek, Click Tools > Goal Seek.Goal Seek Dialog Box will be open.

5. Under the Default settings, enter the cell address where formula is typed(B6) in the
formula cell Box, enter the target value (75) in the target value Box ,enter the cell
address where value has to be assigned (B5) in the Variable cell Box. Then click OK
Button

24
6. Repeat the above step with corresponding cell addresses for SUBJECT2,
SUBJECT3 and SUBJECT4.

25
Q10. Create Scenarios for the following question.
Find the Simple Interest, If Principle is 5000, rate of interest is 3% and Time is 2 years. Also
calculate the simple interest, if Principle is 6000.
Ans:
1. Open a New Open Office Calc File.
2. Create a table with the data given.

3. Select the data ,then click on Tools > Scenarios to create the Scenario.

4. Create Scenario Dialog Box is open. Provide a name to the Scenario .Uncheck copy
back option and choose a color for the Scenario to be created. Then click OK Button.

26
5. Scenario 1 is created.

6. To create the next Scenario, Change the Principle to 6000.Then select the data and
follow step 3 and 4.

27
Q11: Create Table Fitness and write SQL Queries.
Table: FITNESS
PCODE PNAME PRICE MANUFACTURER
P001 TREADMILL 21000 COSCORE
P002 BIKE 20000 AONE
P003 CROSS TRAINER 14000 RELIABLE
P004 MULTI GYM 34000 COSCORE
P005 MASSAGE CHAIR 5500 REGROSENE
P006 BELLY VIBRATOR BELT 6500 AMBAWAY

i) To display the names of all the products with price more than 20000

ii) To display the names of all products by the manufacturer AONE

iii) To display the details of all products in descending order of their price.

28
iv) To display the name and manufacturer of the products whose manufacturer of
COSCORE

v) To display the pcode, pname, price of items whose price is less than or equal to
20000

vi) To display the names and price of products in ascending order of their name.

vii) To change the price of TREADMILL to 27000

UPDATE FITNESS SET PRICE = 27000 WHERE PNAME = 'TREADMILL'

29
viii) To change the price of MASSAGE CHAIR to 10000

UPDATE FITNESS SET PRICE = 10000 WHERE PNAME = 'MASSAGE CHAIR'

30
Q12. Create table FABRIC in design view.

FABRICID FNAME TYPE DISC

F001 SHIRT WOOLLEN 10
F002 SUIT COTTON 20
F003 TUNIC COTTON 10
F004 JEANS DENIM 5
F006 SHORTS COTTON 7

Ans:

1. Open the Open Office Database.

2. Choose Tables under Database. Select Create Table in Design View under Tasks.

3. In the Table Design window ,enter the Field Names and Field Type as follows

31
4. Set FABRICID as Primary Key.

5. Give a name to the table and save it.

6. Table FABRIC is created.

32
7. Double click on the FABRIC Table to enter the data. Click Save Button to save the
data.

33
Q13. Write the SQL Queries for the following questions based on the table FABRIC.

Ans:
1. Insert the following record(‘F005’,’KURTA’,’WOOLLEN’,5)

INSERT INTO FABRIC VALUES ('F005','KURTA','WOOLLEN', 5)

2. To display those records whose type is woollen.

3. To display only those fabric whose disc is more than 10

4. To modify the fabric shirt by increasing discount by 10.

UPDATE FABRIC SET DISC=DISC+10 WHERE FNAME='SHIRT'

34
5. To display all the records.

6. To display those records whose disc is 5 or 20

7. To display all the records in descending order of type.

8. To delete the record of fabric F003 from the table.

DELETE FROM FABRIC WHERE FABRICID=’F003’

35
Q14. Create a Form for the above Table FABRIC.

1. Open the Open Office Database.

2. Click Forms under Database. Then click Create Form in wizard View under Tasks.

3. Form wizard will be open

4. Choose the Table from the drop down list under Tables or queries

36
5. Select the fields needed in the Form from the available fields and click > or >> to add
all the fields.

6. Choose the arrange controls

37
7. Select the data entry mode.

8. Apply styles to your Form.

9. Set the name of the form. Click Finish Button.

38
10. Form is created.

39
Q15. Create a report based on the above Table FABRIC.

Ans:
1. Open the Open Office Database.
2. Choose Reports under Database. Click on Use wizard to create Report under Tasks.

3. Select the table for which Report is to be created from the drop down list under tables
or queries.

40
4. Select the fields under Available fields and click >> to add it to the Fields in report.

5. After adding the fields click next.

41
6. Give labels to each field.

7. Select the field by which the data needs to be grouped and click > to add it into
Groupings.

42
8. Select the field and sorting order.

9. Choose the layout from the list of available layouts.

43
10. Give a title to the report and click Finish button.

44