INFORMATION

TECHNOLOGY
(PRACTICAL FILE)

CODE : 402

NAME: RONIT LOUR

CLASS: X
ROLL NO. : 10129
QA. Write the steps to consolidate data of two sheets in Libre Office Calc?

Ans: Below are the followings steps to consolidate the data of two sheets in Libre office calc:
i. Open the document that contains the data -cell ranges to be consolidated.
ii) We have to on Data option> Consolidate to open the Consolidate dialog. The
figure shows this dialog after making the changes described below:

iii) The Source data range list contains any existing named ranges (created using Data
> Define Range), so you can quickly select one to consolidate with other area.
iv) Click Add. The selected range is added to the Consolidation ranges list.
v) Select additional ranges and click Add after each selection.
vi) Specify where you want to display the result by selecting a target range from the
Copy results to drop-down list. If the target range is not named, click in the field
next to Copy results to and enter the reference of the target range or select the
range using the mouse or position the cursor in the top left cell of the target
range. Copy results to takes only the first cell of the target range instead of the
entire range as is the case for Source data range.

vii) Select a function from the Function list. This specifies how the values of the
consolidation ranges will be calculated. Select option SUM which adds the cell
values of the Source data range and gives the result in the target range.

viii) We have to select more option in the dialog box:

 Link to source data

  Consolidated by: Range and Columns

ix) Click OK to consolidate the ranges.

x) After click option ok we will get the sum of both sheets in the selected
Consolidated sheet.
Consolidated Sheet data:
QB. Write the steps to record Macro in Libre office calc.
1. Open the Spreadsheet where you want to record the macro.
2. Enable the macro recorder; we have to enable recording toolbar.
3. Go to view> Toolbars> macro recording. This will display the toolbar with buttons for
recording, stopping and managing macros.

4. Go to Tools > Macros > Record Macro to start recording a macro. A small dialog with a Stop
Recordin

b
utton will display indicating that LibreOffice is recording a macro.
5 Type the text you want to be entered when this macro is run. As an example, type your
name.
6 Click Stop Recording on the small dialog. This will open Basic Macros dialog to open (similar
to Figure 1, but with different action buttons).

7 Open the option library container My Macros.

8 Find the library named Standard in My Macros. Note that every library container has a library
named Standard.
9 Select the Standard library and then choose an existing module in which to save the macro.
Alternatively, you can click New Module to create a new module to contain the newly
recorded macro.
10 In the Macro Name text box at the top left section of the dialog, type a name for the macro
you have just recorded, for example EnterMyName.
11 Click Save to save the macro and close the Basic Macros dialog.
QC. Write steps to create or insert a table of contents (TOC) in digital documents.

Answer: Below are the steps for inserting the table of content in the documents:

1. Go to the Insert menu in the top toolbar.

2. Select Table of Contents and Index > Table of Contents, Index or Bibliography.

3. Table of content include various option to configuring the TOC like:

 Type
 Style drop-down list (e.g., Default, Classic, or Formal).
 Create: ensure the Heading levels (e.g., Heading 1, Heading 2, Heading 3) are
selected, as these will be used to generate the TOC.

4. Once you have configured the options, click OK to insert the TOC into your document.
QD. Prepare a calc worksheet showing What if Scenarios
Runs Scored 80

Balls Faced 77

Strike Rate 103.90

Formula for strike rate is:- (cell1/cell2)*100

Now find out strike rate of following data & give them proper names

i. Score is 55 & balls faced are 40

ii. Score is 78 & balls faced are 80

iii. Score is 95 & balls faced are 77

Ans4. Step1: Prepare the table in Libre office as below:

 Step 2: Put the formula of strike rate in column D for each player
  After putting the formula in each cell, we will get the strike rate of each scenario (each
player) as shown below:


I. strike rate if Score is 55 & balls faced are 40:

Strike rate= (55/40)*100 =137.5

II. strike rate if Score is 78 & balls faced are 80

Strike rate= (78/80)*100 =97.5

III. strike rate if Score is 95 & balls faced are 77

Strike rate= (95/77) *100 = 123.376

Q E. Below are the steps for finding the average marks obtained by students based on above table
of data use data sub totals to find out the average group by student name:

Step 1: Enter the Data

First, enter the following data into your spreadsheet:

Step 2: Sort Data by Student Name:

Before applying Subtotals, sort the data by "Student Name" to group the records for each student:

Select the data range (including headers). Go to Data > Sort>Choose Student Name as the column to
sort by (ascending or descending).

Step 3: Apply Subtotals- To calculate the average marks for each student:
Select the data range (including headers).

Go to Data > Subtotals >In the Subtotals dialog: select Group by >Select Student Name> Use
function: Select Average >Add subtotal to: Select Marks and select OK

Step 4: After applying the Subtotals, it will show as below:

The Subtotal row under each student shows the average marks for that student.
 QF. Explain how you can reference a cell from another sheet of the same workbook?

Answer: Steps to reference a cell from another sheet:

Suppose We have two sheets name sheet 1 and sheet 2 and also in the sheet 2 column A1 has value
call 6 now we will use reference function:

1. Open the workbook

2. Select the cell: go to the sheet where you want the reference to appear and type the
following:
3. In the cell where you want the reference cell A1 from the sheet named 2, we have to enter
= Sheet 2. A1
4. After typing the reference formula, click enter. The value from the referenced cell in the
other sheet will appear in the current cell.
Q g. If you have formatted a document consertain way, how will you go about saving the formatted
changes in the document by a new name as a style write all steps required to do this

Answer: Below are steps saving the formatted changes in the document by a new name as a style

1. Format your document (apply font, paragraph, etc.).

2. Open Styles and Formatting (F11).
3. Select the appropriate style category (Paragraph, Character, etc.).

4. Click the New Style button.

5. Name your style and modify its settings if needed.
6. Click OK to save the style.
7. Apply the new style by double-clicking it in the Styles and Formatting window.
8. Save your document with a new name,
QH. If there is a template with some predefined style, how will you apply it to a newly opened
document write the steps required to do

Answer- Below are the steps to Apply a Template with Predefined Styles to a New Document:

1. Open LibreOffice and Create a New Document

2. Select File > New from the top menu, then Choose Text Document
3. Open the Template Dialog: to apply a predefined template, Go to File > New > Templates

4. This will open the template dialog, where you can browse and select any templates that have
been saved in LibreOffice.
5. In the Templates dialog, we can see a list of available templates by categories (e.g., My
Templates, Text Documents, Business, etc.).
6. Click on the template you want to apply to the new document. This template will contain all
the predefined styles, page layouts, and formatting settings.
7. After selecting the template, click Open.
8. A new document will be created based on the template, and all of the predefined styles and
formatting from the template will be applied automatically.
9. We can now start typing or editing your document, and the predefined styles from the
template will be available in the Styles and Formatting
10. Save the New Document: to File > Save As.
QI Create a new template as a template for letter write steps for doing so in libre

Answer: Below are the steps for creating the new template:

1. Open LibreOffice Writer document.

2. Setting up the basic layout for letter. This includes margins, page size, and text alignment.

3.Define the Styles for the Letter: Paragraph Styles, Heading. Salutation, Body Text, Signature

4. Insert Placeholder Text where the specific details will go (like the recipient’s name or
signature).

5. Insert Fields: it includes the option like insert the date, page number (in the footer or
header)
6. Save the Document as a Template as follow: Go to File > Templates > Save As Template then
click OK to save the template.

7. Apply the template to new documents via File > New > Templates.
Q J You have to create a poster on a given topic you need to insert some pictures related to the
topic write the steps how will you insert image from gallery and also image by copy paste method?

Answer J- Below are the steps for inserting the pictures from gallery:

1. Open LibreOffice Draw for preparing the poster then select File > New > Drawing.

2. Go to View > Gallery to open the Gallery panel. This panel contains various images and
clipart that we can use in the poster.

3. In the Gallery window, we will find a list of categories (e.g., Clipart, Photographs, Textures,
Symbols, etc.). In these categories we have to choose an image that fits the topic of the
poster.
 4. Insert the Image into Your Poster: once we select the picture click and drag it from the
Gallery panel directly into the LibreOffice Draw workspace or right-click on the image and
choose Insert and paste the same in libre office draw.

5. Adjust the Image, click and drag it to the desired location on the poster and change the size if
required.

Steps for inserting the pictures by Copy-Paste Method:

1. Select an image from the location like computer, web, or another source.
2. Right-click on the image and select Copy, or we use Ctrl+C to copy the image to your
clipboard.
3. In the libre office draw Click anywhere on the poster where you want to place the image.
4. Right-click and choose Paste or use Ctrl+V
5. The image will be inserted into the sheet.
6. Adjust the Image- After pasting, we can resize the image by clicking on it.
 SQL COMMANDS
Create Table "STUDENT" in Design View*

1.Open LibreOffice Base.

2.Create a new database.

3.Click "Tables" and then "Create Table in Design View".

4.Enter the following fields: | Field Name | Data Type | Constraint | SQL COMMANDS

Save the table as "STUDENT".

SQL Commands for Table "Student"*

Display all records:

SELECT * FROM Student;

Display record with Roll No 2:

SELECT * FROM Student WHERE Roll_No = 2;

Display records for Class 'X' & 'XII':

SELECT * FROM Student WHERE Class=('X', 'XII');Display record for 'Anuj'

SELECT * FROM Student WHERE Name = 'Anuj';

Show entire table:

SELECT * FROM Student;

Show Reg. No. of Pradeep:

SELECT Reg_No FROM Student WHERE Name = 'Pradeep';

Show Name & Branch columns:

SELECT Name, Branch FROM Student;

Count the number of rows:

SELECT COUNT(*) FROM Student;

Add another column as Address:

ALTER TABLE Student ADD Address VARCHAR(100);

Update the branch of Hari to IT:

UPDATE Student SET Branch = 'IT' WHERE Name = 'Hari';

Find marks obtained by student with Roll No 101:

SELECT Marks_Obtained FROM Student WHERE Roll_No = 101;

SELECT * FROM Student WHERE Scholarship_Awarded > 3500;

- Find students in class 10:

SELECT * FROM Student WHERE Class = 10;

- Update marks of Swati Saini to 85:

UPDATE Student SET Marks Obtained = 85 WHERE Roll_No = 104

 Click Add. The
Save the table (File > Save)

selected range is added to

the Consolidation ranges
list.
xi) 5. Select additional
ranges and click Add after
each selection.
xii) 6. Specify where you
want to display the result
by selecting a target
range from the Copy
results to drop-down list.
xiii) If the target range is
not named, click in the
field next to Copy results
to and enter the
reference of the target
xiv) range or select the
range using the mouse or
position the cursor in the
 top left cell of the target
range. Copy
xv) results to takes only the
first cell of the target
range instead of the
entire range as is the
case for Source data
xvi) range.
xvii) 7. Select a function
from the Function list.
This specifies how the
values of the
consolidation ranges will
be
xviii) calculated. The
default setting is Sum,
which adds the
corresponding cell values
 of the Source data range
and
xix) gives the result in the
target rang
xx) Choose Data >
Consolidate to open the
Consolidate dialog. The
figure shows this dialog
after making the
xxi) changes described
below
xxii) Choose Data >
Consolidate to open the
Consolidate dialog. The
figure shows this dialog
after making the
xxiii) changes described
belo