PODAR INTERNATIONAL SCHOOL,

VASTRAL

Practical File Session-2025-26

Subject Code: 402
Grade: X

Student Name: Satyam Kumar Singh Submitted to:

Section: 10th “A” Mr. Jinal Parmar
Roll No: ___________________________________ (Internal Examiner)
 CERTIFICATE

THIS IS TO CERTIFY THAT ___________________________________

OF CLASS 10 HAS SUCCESSFULLY COMPLETED THE

PRACTICAL WORK ON IT-402 FOR CLASS X PRACTICAL

EXAMINATION AS PRESCRIBED BY MR. JINAL PARMAR

(INTERNAL EXAMINER), DURING THE ACADEMIC YEAR

2025-2026 AS PER THE GUIDELINES ISSUES BY CENTRAL

BOARD OF SECONDARY EDUCATION - CBSE.

Signature:

Date:
 INDEX

No. Practical List Date Tr. Sign

1.

2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
 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, Color: Magenta
b. Give Style Name: Title AI (Use create styles using drag and drop)
2. Headings
a. Font name: Times New Roman, Size: 24 , Color: 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
Practical:-
Step: Make a file in LibreOffice Writer.
Step: Type a para with heading on top.
Step: Change title look how you want.
Step: Pull title to style bar using drag and drop.
Step: A box come, give name "Title AI" and hit ok.
Step: Now, give different format to para and heading.
Step: Again, drag and drop heading to style part.
Step: In box, name it "My Heading" then press ok.
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.

Practical:-

Step: Pick any image from computer as idea.

Step: Put different shapes like circle, square etc.
Step: Set shapes how you like.
Step: Add textbox and write text inside image or shape.
Step: Write all important ad data in file.
Assignment 3
Objective: Create and Customize Table of Contents
Task: Prepare a document with different headings and apply a table of contents to it.

Practical:-
Step: Create new file with heading and para.
Step: Click on insert, choose Table of Content.
Step: One dialog box will show up.
Step: Press OK, table show where cursor is. Change it if need.
Assignment 4

Objective: Customize the table of contents

Task: Apply customization following customization on above Table of contents:

1. Apply heading levels up to 3

2. Divide Table of contents into two parts vertically

3. Add a background color of your choice.

Practical:-
Step: Again make file with heading text.
Step: Go insert, select Table of Content.
Step: Table settings come on screen.
Step: Pick column tab, select three columns.
Step: Go to background color, pick yellow shade.
Step: Press ok button.

Assignment 5

Create a question paper as per given below formatting.

(Given image for reference only you may create different question answer)
Practical:-
Step: Insert table as you want. (3 rows, 9 columns)
Step: Resize cells like you need.
Step: Join two cells, break them again to fit options.
Step: Write question answers inside table.
Step: Add 3x3 table for heading.
Step: Format it so heading look proper.
Step: Save the doc when done.

Electronic Spreadsheet (Advanced)

Assignment 1

Objective: Applying Data Consolidation in LibreOffice Calc

Task: Prepare 3 worksheets for products sales and consolidate them.

(Given image for reference only)

Practical:-
Step: Type data inside sheet 1.
Step: Give name Ahmedabad to sheet.
Step: Add more data in second sheet.
Step: Rename it Surat.
Step: Enter next data in sheet 3.
Step: Call it Rajkot.
Step: Now open sheet 4 and type product names.
Step: Use formula like `=SUM()` and add up from 3 sheets.
Step: Total shows in sheet 4.
Assignment 2
Objective: Applying subtotal in LibreOffice Calc
Task: Prepare a worksheet as following
Apply subtotal and find the sum of days required for project name.

Practical:-
Step: Fill sheet with data.
Step: Highlight whole data.
Step: Sort data up-down or down-up.
Step: From data tab, click subtotal.
Step: Subtotal settings pop up.
Step: Choose sum for adding days.
Assignment 3
Objective: Link data and Spreadsheet
Task: Prepare 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.

Practical:-
Step: Put student info in sheet 1.
Step: Call sheet "Student Profile".
Step: Make 3 more sheets and name them PT1, PT2, PT3.
Step: In PT1 use keyboard and type formula for roll no., name.
Step: Copy formula to whole columns.
Step: In PT2, use mouse to make same links.
Step: In PT3, do it any way you want.

Assignment 4
Task:
1. Insert hyperlink from the internet.
2. Insert hyperlink email.
3. Insert hyperlink of existing file.
4. Insert hyperlink of new file.
(Paste output Images also)

Practical:-
Step: Open LibreOffice Calc.
Step: Go insert tab, click hyperlink.
Step: In box, pick Internet part.
Step: Paste NCERT IT class 10 website link.
Step: Add display text name.
Step: Hit OK.
Step: *Email Link:*
Step: Insert > Hyperlink > Email.
Step: Type email ID.
Step: Add subject.
Step: Put text name "Gmail Link".
Step: Click ok.
Step: *File Link:*
Step: Again insert hyperlink.
Step: Choose Document tab.
Step: Browse and select existing file.
Step: Rename text "File – Document".
Step: *New File Link:*
Step: Hyperlink option.
Step: Go document tab.
Step: Click on sheet or target.
Step: Text should be "New Document".

Assignment 5
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
Practical:-

Step 1:-enter the data in libreofice calc

Step 2:-click on tool tab
Step 3:-click on “goal seek”
Step 4:-select total as a formula cell
Step 5:-then write the targeted value (in QUESTION it is 23000)
Step 6:-select the variable cell in which values can deafer (acc... to question it is net profit
of august )
Step 7:-click of it will change the value of the august

Database Management System

Assignment 1
Objective: Steps to create a table Student Details using table wizard.
Task: Create a table using wizard and insert data using SQL prompt.
(Paste a image of table as well as Query)

Practical:-

Step: Start LibreOffice Base on your computer.

Step: Register your database if required.
Step: Choose the option “Create Table using Wizard.”
Step: Pick the fields you want based on what your table needs.
Step: Press OK to move forward.
Step: Give the fields names that make sense to you.
Step: Change the “Field Type” and “Entry Required” options, and also set the length as per
your requirement.
Step: Choose a primary key for your table structure.
Step: Give your table a name.
Step: Hit “Finish” to complete the table creation process.
Step: Go to the TOOLS menu and select “SQL...”
Step: Type the SQL command that matches the data you want to insert.
Step: Click “Execute” to run the command.
Step: Add more entries by using more SQL commands.
Step: Your data will now be saved in the table!
Assignment 2
Objective: Query creation using wizard
Task: Create table Marksheet (Using SQL Command) and perform the bellow given
queries using wizard and design view.
Field Name Data Type Size
Stu_No Integer 2
Name Text 15
Roll_No Integer 3
Sub101 Decimal 3,2
Sub102 Decimal 3,2
Sub103 Decimal 3,2
1. Enter 10 Record randomly.
2. Display name, rollno, marks of 3 subjects, total and percentage using design view.
3. Display name, rollno, grades from the marksheet table using query wizard.
4. Display the maximum marks for Sub101 and minimum marks for Sub102 using SQL.
5. Display the rollno, name and percentage whose percentage is more than 70 using SQL.
6. Display all the record in ascending order of names using SQL.
Practical:-
1. Enter 10 Record randomly.

Step : Write the SQL statement to make a table by defining different columns based on the details given in the
question.
Step : Execute the SQL statement to build the table in the database.
Step : Use the SQL command to fill the table with 10 different entries using made-up data.
Step : Now the table is ready and contains all the records you added.

2. Display name, rollno, marks of 3 subjects, total and percentage using design view.
Step 1: Use an SQL command to add a new column called "TOTAL" in the table.
Step 2: Now, use another SQL command to include a new column named "PERCENTAGE" in the same table.
Step 3: Apply an SQL update command to calculate the sum of marks from three subjects and store it in the "TOTAL"
column.
Step 4: Use SQL again to work out the percentage for each student and fill the "PERCENTAGE" column with the result.
Step 5: Go to the "Queries" section and choose the option to create a new query using the design view.
Step 6: Add the table where your records are saved. Then, in the field row, pick the columns for name, roll number,
Sub101, Sub102, Sub103, total, and percentage.

Step 7:- Save the query

Open the query that you saved

3. Display name, rollno, grades from the marksheet table using query wizard.
Step 1: Choose the option "Use Wizard to Create Query".
Step 2: Pick the table named "MARKSHEET" from the list.
Step 3: Move the fields like name, roll number, and grades into the query fields section. (If the "grades" column
doesn't exist, you can add it first using an SQL command.)
Step 4: Switch to the Overview tab as no further steps are needed.
Step 5: Give your query a new name and click Finish. Your query is now ready.
Here is the output.
4. Display the maximum marks for Sub101 and minimum marks for Sub102 using
SQL.
Step 1: Click on “Create Query” and choose SQL View.
Step 2: Write the SQL command to get the highest score in Sub101 and the lowest score in Sub102.
Step 3: Execute the command by pressing F5 or using the run button.
Step 4: Save your query. Then open it to see the results.

5. Display the rollno, name and percentage whose percentage is more than 70 using
SQL.
Step 1: Click on “Create Query” and select SQL View.
Step 2: Enter the SQL command to show roll number, name, and percentage for students whose percentage is
above 70.
Step 3: Run the query by pressing F5 or clicking the run button.
Step 4: Save the query and then open it to view the results.
6. Display all the record in ascending order of names using SQL.
Step 1: Select “Create Query” and choose SQL View.
Step 2: Write the SQL command to list all records sorted by names in ascending order.
Step 3: Execute the query by pressing F5 or using the run button.
Step 4: Save your query and then open it to see the sorted data.
Assignment 3
Objective: Creating form using wizard
Task: Create table a form using wizard by selecting all the fields for the table – Marksheet
Enter a record using a form and display before and after effect in table.

Practical:-
Step 1: Open the wizard to create a table.
Step 2: Select the table MARKSHEET.
Step 3: Choose data entry mode and select the option to display all data. Check “do not allow modification” and “do
not allow deletion” of existing data.
Step 4: Pick a style for the form.
Step 5: Name your form.
Step 6: Choose to work with the form and click Finish.
Step 7: Open the form, click New Record, enter data, and save the record.
Assignment 4
Objective: Creating report using wizard
Task: Create table a report using wizard by selecting all the fields for the table –
Marksheet and Student details.
Practical:-
Step 1: Create a query with all fields from both tables.
Step 2: Set relationships between matching fields.
Step 3: Save the query.
Step 4: In the Reports tab, use the wizard to create a report.
Step 5: Select the saved query.
Step 6: Move all fields to the report.
Step 7: Choose the layout.
Step 8: Click Finish to generate the report.
Assignment 5
Create a table with name Employees and write queries to design and enter the relevant
details of employees of an organization.(enter 15 records). Assign Employee_Id as
primary key
a. Employee_Id
b. . Name of the employee
c. Date_of_joining
d. Department
e. Basic_Salary

1. Display all employee data who joining year after 2020.

2. Count department wise no. of employees.
3. Arrange all the records in ascending order Basic Salary wise.
4. Calculate the yearly salary and given 10% increment to all employees.
5. Update Increase 8.5% salary who having less than 35000.00

Practical:-
1. Display all employee data who joining year after 2020.
Step 1: Create a table.
Step 2: Enter employee information (Employee_Id, Name, Date_of_Joining, Department, Basic_Salary).
Step 3: Create a query including all fields with the condition that Date_of_Joining is after 2020.
Step 4: Run the query.
Step 5: Save the query.
2. Count department wise no. of employees.
Step 1: Create a table.
Step 2: Enter the employee details (Employee_Id, Name of the employee, Date_of_joining, Department, Basic_Salary).
Step 3: Create a query containing all fields (I used SQL command to create it).
Step 4: Add the condition "Date_of_joining" > 2020 in the SQL command.
Final SQL command:
SELECT "Employee_Id", "Name of the Employee", "Date_of_Joining", "Department",
"Basic_Salary" FROM "Employees" WHERE "Date_of_Joining" > 2020
Step 5: Run the command.
Step 6: Save the query.

3. Arrange all the records in ascending order Basic Salary wise.

Step 1: Create query in Design View.
Step 2: Select the table.
Step 3: Add all fields.
Step 4: Sort Basic Salary in ascending order.
Step 5: Save the query.
4. Calculate the yearly salary and given 10% increment to all employees.
Step 1: Create query in Design View.
Step 2: Add the whole table.
Step 3: In Field, write: Basic_Salary * 12.
Step 4: Use alias yearly_salary.
Step 5: Save the query.
5. Update Increase 8.5% salary who having less than 35000.00

Step 1: Create query in Design View.

Step 2: Add all fields.
Step 3: Set criterion < '35000.00' in Basic_Salary field.
Step 4: Add field "Basic_Salary" * 1.085 as alias updated_salary.
Step 5: Save the query.