PRACTICAL FILE

INFORMATION
TECHNOLOGY(402)

Submitted by

____________________________________

Class :- X( )

Session 2025-2026
K JOHN PUBLIC SCHOOL ASSOLI

1
This is to certify that the student

_____________________________________, a student of k John public

School, Asoli of std X____, has successfully performed and completed the

practical syllabus of INFORMATON TECHNOLOGY(402) as prescribed by

CBSE for the academic session 2025-2026, and the same was completed

within the stipulated time.

Date :

Signature of subject Teacher Signature of Principal

(Miss Shirin Sheikh) (Miss Anjali John)

2
 INDEX
Sr No Title
1 Using various commands to create customer styles and apply
predefined styles in LibreOffice Writer.

2 Inserting images and shapes and rearranging them

3
Create and Customize Table of Contents

4 Applying Data Consolidation in LibreOffice Calc

5 Link data and Spreadsheet

6 Task:
1. Insert hyperlink from the internet.
2. Insert hyperlink email.
3. Insert hyperlink of existing file.
4. Insert hyperlink of new file.

7 Goal seek Application

8 Write formulas for the operation (i) to (iii) and answer question (iv) based
on the spreadsheet given below along with the relevant cell address.

9 Write the SQL queries for the following:

10 Write the SQL queries for the following:

3
 Unit 1: Digital Documentation (Advanced)
ASSIGNMENT 1
Objective: Using various commands to create customer styles and apply
predefined styles in LibreOffice Writer.
Task: Type a paragraph with at least 100 words and create below given styles
as instructed:
1. Title
a. Font Name: Kristen ITC, Size:28, Colour: Magenta
b. Give Style Name: Title AI (Use create styles using drag and drop)
2. Headings
a. Font name: Times New Roman, Size: 24 , Colour: Red.
b. Give the style name: My Heading (Use create style from selection
command)
3. Paragraph and Headings - My heading styles to all headings using Fill
Format
4. Load Styles in New Document and Save the document

SOLUTION
 PREPARING DOCUMENT
1. Click on Start > All Apps > LibreOffice 24.2 > LibreOffice Writer.
2. Type required text.
Creating styles
 Title (Using Drag and Drop)
1. Select the title “Generative Artificial Intelligence”.
2. Apply the desired formatting.
3. Now click on Styles > Manage Styles option.
4. Select the title “Generative Artificial Intelligence” and darg over the Styles
pane present on the screen.
5. New Style From Selection dialog box will appear with a prompt to enter
New Style Name. Type name as “Title AI”.
6. Click on OK button
4
Headings (Create Style using New Style from Selection option)
1. Select first heading – “Introduction”.
2. Apply the desired formatting for style as per instructions given in the question.
3. Click on Styles > Manage Styles option. A styles pane will appear.
4. Click on Style Actions button and choose New Style From Selection option.
5. New Style from Selection dialog box appears. Type Style name as – “My Heading”.
6. Click on OK.
 Applying Styles
 Using double click
1. Select the heading “Technology”.
2. Now Find the newly created styles “My Heading”.
3. Double Click on it.
 Using Fill Format
1. Click on Fill Format icon on Styles pane.
2. A fill format mode will be activated and mouse cursor changes to Fill Format mode
icon.
3. Select “My Heading” style from Styles pane.
4. Drag it over to the headings to apply “My Heading” style.
5. Save the file as “Practical 1 – Create and apply styles”.
 Load styles
1. Open new blank document.
2. Activate Styles pane from side bar or any other option.
3. Click on Style Actions button and choose “Load Styles from Template”.
4. Find the button From File and click on it.
5. Choose the previously saved file.

5
6. Click on Open button.
7. The styles from selected document will be added into the Style gallery.
8. Save the file.
Output Document:

6
 Learning Outcome – Working with Images in digital document
ASSIGNMENT 2
Objective: Inserting images and shapes and rearranging them
Task: Create a new document in LibreOffice prepare an advertisement using various
shapes and images.

Solution:
Add Page background
1. Open LibreOffice Writer and Background from Format > Page Style > Area >
Gradient.
2. Choose Sundown gradient for page background and Click on
Apply and OK. Add Page border
1. Click on Format > Page Style > Borders.
2. Click on All four borders option.
3. Choose the line style from Style.
4. Click on Apply
and OK button.
Add font work
(Learn Coding)
1. Click on View > Toolbar > Drawing.
2. Click on Insert Font Text icon from the Drawing Toolbar.
3. Select Gold Wave style.
4. Type the text Learn Coding and change color.
5. Press enter when you finished.
Add font work (For 3 to 12 Class Students)
1. Click on Insert Font Text icon from the Drawing Toolbar.
2. Select relevant style for Font Text.
3. Type the desired text and change the color.
4. Press enter when you finished.
Insert Image
1. Place the cursor where image is required.
2. Click Insert > Image option. An Insert Image dialog box will appear.
3. Select the image from the dialog box.
4. Click on open button.
Applying border to image
1. Select an image to apply border.
7
 2. Click on Borders icon on the Image toolbar and select Outer Border (Only).
Add Textbox to insert courses
1. Select rectangle box from Drawing toolbar.
2. Draw the rectangle in the document.
Applying background colour to box
1. Select the box.
2. Choose the Fill Colour icon from drawing properties toolbar.
3. Select Yellow color from the Fill Colour icon.
4. Add the desired text.
Similarly add remaining shapes, apply the desired formatting and text. Save the file.
Output:

8
 Learning Outcome – Create Table of Contents

ASSIGNMENT3
Objective: Create and Customize Table of Contents
Task: Prepare a document with different headings and apply a table of contents to it.
Solution:
1. Type the contents.
2. Apply appropriate level of headings from the Styles window.
3. Place the cursor at the beginning of document to insert Table of Content.
4. Click on Insert → Table of contents and index → Table of contents, index or
Bibliography option. The Table of contents, index or Bibliography will
appear.
5. Select and apply the styles for the Table of Contents.
3. Click on OK.
Output

9
 Unit 2: Electronic Spreadsheet (Advanced)

Learning Outcome Consolidating Data

ASSIGNMENT 4
Objective: Applying Data Consolidation in LibreOffice Calc
Task: Prepare 3 worksheets for products sales and consolidate them
Solution:
Preparing sheets for Data Consolidation
1. Create a new file in spreadsheet software and enter data for 5 products.
2. Add two worksheets in the file and modify the data for all. Click on Sheet tab
and + icon there,
3. Rename all worksheets like sheet1 - Ahmedabad, sheet2 - Surat and sheet3 -
Rajkot. Select the sheets respectively and do right click on Sheet tab >
Rename Sheet option, Type the sheet name and Click on OK button.
4. Now add one more worksheet at the end and rename as Consolidated as similar
as step 2 and 3.
Perform Data Consolidation
1. Place the cursor in cell B2 in Consolidated sheet.
2. Click on Data > Consolidate option.
3. The Consolidate dialog box will appear.
4. Choose the Sum function.
5. Select Data Source ranges respectively and click on Add button.
6. Click on OK button.
Output:

10
11
Learning Outcome – Creating cell referencing in Spreadsheet
ASSIGNMENT 5
Objective: Link data and Spreadsheet
Task: Prepare a worksheets as following:
1. Enter the data such as Roll no, GR NO, First Name, Last Name, Date of Birth,
Father Name, Mother Name. Enter records for at least 10 students.
2. Rename this worksheet as "Student Profile".
3. Insert 3 new worksheets and rename as "PT2", "PT2" and "PT3" respectively.
4. In the PT1 worksheet create a reference for Roll No, First Name, and Last
Name columns from Student Profile by using the keyboard.
5. In the PT2 worksheet create a reference for Roll No, First Name, and Last
Name columns from Student Profile by using the mouse.
6. In the PT3 worksheet create a reference for Roll No, First Name, and Last
Name columns from Student Profile as you wish.
Solution:
1. Open Excel and create a new workbook.
2. In the first worksheet, enter the data.
3. Right-click on the sheet tab (usually named “Sheet1”).
4. Select “Rename” and change the name to “Student Profile”.
5. Insert three new worksheets by clicking the “+” icon at the bottom.
6. Rename them to “PT1”, “PT2”, and “PT3” respectively.
7. Go to the “PT1” worksheet.
8. In cell A1, type =Student Profile!A1 to reference the Roll No from the “Student
Profile” sheet.
9. Drag the fill handle to copy the formula down for all 10 students.
10. Repeat the process for First Name and Last Name columns.
11. Go to the “PT2” worksheet.
12. Click on cell A1, type =, then navigate to the “Student Profile” sheet and click
on cell A1.

12
[Link] Enter to create the reference.
14. Drag the fill handle to copy the formula down for all 10 students.
15. Repeat the process for First Name and Last Name columns.
16. Go to the “PT3” worksheet.
17. You can use either the keyboard or mouse method to create references for Roll
No, First Name, and Last Name columns from the “Student Profile” sheet.
Output:

13
 Learning Outcome – Hyperlink in Spreadsheet
ASSIGNMENT 6
Task:
2. Insert hyperlink from the internet.
3. Insert hyperlink email.
5. Insert hyperlink of existing file.
6. Insert hyperlink of new file.
Insert Hyperlink from the internet
1. Type the text – NCERT Solution IT Class 10.
2. Click on Insert > Hyperlink option. Hyperlink dialog box will open.
3. Click on Internet and type the URL.
4. Set the behaviour of link by selecting frame and target.
5. Click on OK button.
Insert Hyperlink Email
1. Type the text – Gmail in the cell.
2. Click on Insert > Hyperlink option.
3. Select Mail option.
4. Type the recipient mail id in Recipient box.
5. Type Subject in Subject box.
6. Set the behaviour of link by selecting Frame, Target and Name.
7. Click on Apply and OK button.
Insert hyperlink of existing file
1. Type the text: File – Document
2. Click on Insert > Hyperlink option.
3. Choose Document button.
4. Select the file from Path option. Either type the path or select the file using
browse button.
5. Set target of link.
6. Apply settings required such as Frame, Name and Tax
14
7. Click on Apply and OK button.
Inserting Hyperlink of New Document
1. Type the Text – New Document.
2. Select option as Edit Now.
3. Type Filename in File box.
4. Select File Type as Text Document.
5. Apply settings such as Frame, Name etc.
6. Click Apply and
OK button.

Output:

15
 Learning Outcome – Goal Seek
ASSIGNMENT 7
Objective: Goal seek Application
Task: Enter data to obtain total net profit and set the goal to achieve total net
profit of ₹ 23,000 by changing the August month gross profit.

Sample Data:-
Month Gross Profit Net
April 20000 12% 2400
May 30000 14% 4200
June 40000 11% 4400
July 25000 15% 3750
August 35000 18% 6300
Total 21050

Solution:
1. Enter data and prepare the spreadsheet along with formula.
2. Place the cursor in D7 cell.
3. Click on Tools > Goal Seek option. The Goal Seek dialog box will appear.
4. Move the cursor in Target Value box and enter the value – 23000.
5. Now select the cell as a variable cell.
6. Click on OK.
7. It will display the value obtained by Goal seek. If you wish to insert it in the
spreadsheet click on Yes, otherwise No.
Output:-

16
ASSIGNMENT 8.
A stationery keeps stock of various stationery in his shop. The proprietor wants to
maintain a stock value and reorder level for the following items as given in a
spreadsheet. Write formulas for the operation (i) to (iii) and answer question (iv)
based on the spreadsheet given below along with the relevant cell address.

(i) To calculate the Stock Value as a product of ‘Quantity in Stock’ and ‘Rate’ for
each item present in the spreadsheet.
(ii) To calculate the ‘Quantity to Order’ as ‘Minimum Stock Quantity’-‘Quantity in
Stock’ for each item.
(iii) To calculate the ‘Order Value’ as a product of ‘Quantity to Order’ and ‘Rate’
for the items if ‘Quantity to Order’ > = 0, else assign the value as 0.
(iv) The Proprietor wants to graphically represent his stationery stock. Suggest to
him the most appropriate feature of MS Excel.

Answer:
(i) At cell F2, type = D2*E2 and then copy this formula using Fill handle in range
F3 : F5.
(ii) At cell G2, type = C2-D2 and then copy this formula using fill handle in range
G3 : G5.
(iii) At cell H2, type = IF (G2 > = 0, G2*E2, 0) and copy this formula using the Fill
handle in the range H3 : H5.
(iv) Fie should create a chart of any type to graphically represent his data.

17
ASSIGNMENT 9:-
Consider the following table: Employee

(a) How many fields and records are there in the table Employee?
(b) Write the SQL queries for the following:
(i) Display Ename and salary of those employees whose Salary is less than or equal
to 16000.
(ii) Display details of employees who are getting a commission of ₹ 300 or greater.
(iii) Display all the details of the employee profile ‘CLERK’.

Answer:
(a) There are 8 fields and 6 records in the table Employee.

(b)
(i) SELECT E_name, Salary FROM Employee WHERE Salary< =
16000;
(ii) SELECT* FROM Employee WHERE Commission >=300;
(iii) SELECT *FROM EMPLOYEE WHERE Profile=’CLERK’;

18
ASSIGNMENT 10:

Write SQL queries for the questions from (a) to (d) based on table Class.

(a) Select all the non-medical stream students from the class table.
(b) List the names that have grade A sorted by stipend.
(c) Arrange the records of class name-wise.
(d) List the records whose grade is B or C.

Answer:
(a) SELECT * FROM Class WHERE Subject=‘Non-medical1;
(b) SELECT Name FROM Class WHERE Grade=‘A’ ORDER BY
Stipend;
(c) SELECT * FROM Class ORDER BY Name;
(d) SELECT * FROM CLASS WHERE GRADE = ‘B’ OR GRADE = ‘C’;

19