PRACTICAL FILE
STUDENT’S DETAIL
Board Roll No.:
Name of Student: SUPRATIM
MAHALA Class: 10
Subject: Information Technology
(402) School: Bholananda National
Vidyalaya
I thank my computer teacher
MEGHDOOT
MUKHERJEE for guidance and
support. I would also thank to
my parent for encouraging during the
course of this project. Finally, I would
like to thank CBSE for giving me this
opportunity to undertake this project.
InDEX
1. Create and Apply styles 29/11/2025
2. Working with images 26/11/2025
3. Create and use templates 25/11/2025
4. Create table of contents 25/11/2025
5. Customize table of contents 20/11/2025
6. Consolidating Data 18/11/2025
7. Subtotals 16/11/2025
8. Creating cell referencing in 15/11/2024
Spreadsheet
9. Hyperlink in Spreadsheet 12/11/2025
10. Goal Seek 11/11/2025
11. Create and edit tables using 11/11/2025
wizard
12. Review data using query 10/11/2025
13. Query using criterion and 9/11/2025
sorting
14. Creating forms in LibreOffice 9/11/2025
Base
15.16 Creating reports in 8/11/2025
LibreOffice Base
1
.
LibreOffice Writer provides different types of tools to apply
predefined style or formatting in a document. This style or formatting
helps to maintain uniformity in font size, font face, spacing, heading or
overall layout in the documents. There are six different types of Styles in
LibreOffice Writer: (a) Paragraph Styles, (b) Character Styles, (c) Page
Styles, (d) Frame Styles,
(e) List Styles and (f) Table Styles.
ThereareseveralwaystoopenStyleandFormattingwindowinLibreOffice–
Click on Format > Styles > Manage Style
To open style and formatting window press F11
Using Sidebar Menu
Using Style Drop Down list box from toolbar
Page style is used to define basic page layout like page size,
border, background or footnote etc. You can apply many page styles in a
document. If the page style is not declared then the user can define the
default page style.
Paragraph style helps to organize the content in paragraphs.
Paragraphs formatting includes border, tab stops, text alignment and line
spacing etc. It also includes character style attributes.
This style is used to change the appearance of the
characters. This style includes text color, highlighting text, text size and
emphasizing it.
2
.
Fill format is a quick method to apply the same style in different
locations in the document. In Manual formatting every time we have to
select the text and we have to apply the style which takes a lot of time.
Instead of manual method we can use the Fill Format method to apply the
style quickly.
Applythesamestyletomultiplesectionsquicklyusingfollowingsteps–
Open LibreOffice Writer
Open Style window
Select the paragraph where the style will be copy
Click on Fill Format button
Take the mouse pointer to the desired location and apply the
style.
Repeat step 5 until all the changes have been made
3
.
Table of content is used to create a list of topics and subtopics that
have been covered in the book along with page number, this table of
content you can define with different types of heading. This table of
contents can be inserted automatically in the document. Hyperlink can
navigate directly to the selected topic in the document.
StepstocreateaTableofContentinLibreOfficeWriterare–
To create a Table of content in the document first you have to use
paragraph styles for headings such as main sections will be Heading 1,
subsections will be Heading 2 vice versa.
Click on Insert > Table of Contents and Index
Select Table of Contents, Index or Bibliography
Click on Entries options in ToC
Customize Structure and Formatting
Click on OK
4
.
Track Changes is used when multiple people are working on a
single document and helps to keep a track of the editing being done by
other users. Track change ensures transparency about the person who
made the changes, It makes it easy for authors to see the suggestions
without losing the original text and the accept and reject change option
can be used for canceling or accepting any changes in the document.
Wecanusefollowingstepstoacceptorrejectthechangesinthedocuments–
Click on Accept Track Change/ Reject Track Change button
To navigate between the changes, Click on Previous Track
Changes and Next Track Changes.
Select Accept All Tracked Changes / Reject All Tracked
Changes button respectively.
5
.
6
.
Consolidate data feature allows to combine data from different
sheets and summarize into one place.
StepstouseconsolidatedatafeatureinLibreOfficecalcare–
Open a Workbook
Create a new sheet where the data has to combine
Click on Data > Consolidate option
Select the function from drop down menu
Add Source data ranges
Click on check button “Copy results to”
Click on “Copy result to” and specify the address where
you want to copy the result
Click on “Ok” button
7
.
Subtotals is used to find the subtotals of three arrays arranged in
labeled columns in
LibreOffice Calc and sorts the data automatically.
Stepsforusingsubtotalare–
Step 1: Click on Data > Subtotals
Step 2: Select Column a column where you want to apply subtotal
Step 3: Select any functions like sum, count, min, max or average etc.
Step 4: Click Ok
8.
Macro is used to performe the same task multiple times using
formulas. Macros helps
to use to do the same task multiple times.
Followthefollowingstepstorecordamacro–
Step 1: Click on Tools > Macros > Record Macro
Step 2: Start doing actions which you want to record
Step 3: After completion of your actions, Click on Save Macro
Step 4: Change the name of Macro
Stet 5: Click on Save button
9
.
What if scenarios is used to compare different alternatives
depending on the changing conditions.
StepsforcreatingScenariosinLibreOfficeCalcare–
Step 1: Select the cells where you want to apply scenarios
Step 2: Click Tools > Scenarios
Step 3: Enter name of Scenarios
Step 4: Click Ok Button
10.
S1234 X Student A Bandra, Mumbai
S1235 XI Student B Dharavi, Mumbai
S1236 X Student C Girgaon, Mumbai
S1237 XI Student D Worli, Mumbai
S1238 X Student E Bandra, Mumbai
(a) You want to design a student database in your school, based on the
above table, identify the fields, which of the above fields you will use to
store information of each record.
School supplies
(b) The database administrator needs to ensure that each student has a
unique identifier. Which of the above fields in the table would be used to
make a primary key and why.
(c) After reviewing the student database you realize that there should
be another field apart from the primary key which will uniquely identify
a record. Identify the above field and justify why it could be used as an
alternate key.
(d) If you want to integrate the student table with another table which
will store the students fee details. Justify how you will use the primary
key from the students table and a foreign key in the Fees collection table
to create a relationship between the two tables. Explain with examples.
(a) Above field which is used to store the student’s information
is – Admission_no,
Class, Student_namd, Address
(b) The “Admission_no” from the table can be used for primary key,
primary key ensure that the duplication will be not allowed in the table,
and the column will be not blank.
(c) Alternate key is a field that can be uniquely identify the record
beside the primary key, the student’s name field could use as a
primary key only if there is guarantee that the student’s name should
be not repeated.
(d) If we want to integrate the students table with another table for
storing fee details then relationship can be used as primary key from
the student table and foreign key from another table, the relationship
between two table will be one-to-many.
11
.
Answer: The difference between fields, records and tables in the database
are –
A field is the smallest entity in the database for example
name, phone number or address, field is a fundamental building
blocks of the database.
Record is a collection of fields, this collection of records makes
a table.
Table is a collection of records or logically related records,
table are organized in the form of row and column.
12.
The different types of keys in a database are –
1. Primary key is field or set of fields which is uniquely
identify in the table. A primary key must be unique and cannot
contain null values.
2. A composite primary key consists of two
or more field uniquely identify each record in the table.
3. Foreign key is used to link one table to another table
using referencing It is used to make relationship between two
tables.
13
.
To create a relationship between two table then the parent table
will will contain “Primary key” and the child table will contain “Foreign
key”.
14.
Query helps to retrieve and display data from one or more table
using set of instruction.
Q14 Write the steps to create table with minimum five fields on an entity
"STUDENT" in design view.
Ans. We will design the following table
Field Name Data Type Constraints
ID Integer Primary Key
Name Varchar
Address Varchar
Phone Varchar
DOB Date
1. Click on Create Table in Design View… option available under
Tasks and a Table Design window appears as shown below
2. Specify the field name and data type of the field to be created as
shown below
3. In the grey box at the left of the line, right-click and select Primary
Key, bringing up a key icon in the box.
4. Save the table (File > Save)
Q15 Write the steps to create Employee record Table using
wizard Option. The following are the steps to create a table
1 Click on Tables > Use Wizard to Create Table , the window shown
below will open
Click the Select Fields > Choose Category > Select the table (in
the picture shown below “Business” category and “Employee”
table has been chosen) > Click on Next Button.
3 Select the fields as per the requirements and select
on buttons to add the predefined columns or select to
remove the fields from the Selected Fields Box. After
selecting the fields click on Next Button.
5 Set primary key for the field according to your own choice and click
on FINISH
,Table has been created. Enter the data in the field of a table.
16. Write the command for the following table Student.
Roll_no Class Name Phone number
1 XII Sumit 112345
2 X Amit 345789
3 X Anuj 678890
4 XI Mini 806788
1. Display all the records of table Student.
2. Insert record of your choice
3. Display record of student whose roll number is 3
4. Display record of students who are in class 'X
5. Display the record of 'Anuj'
Ans 1. SELECT* FROM student;
2. INSERT INTO student VALUES(5, 'XI' , 'Suman' , 6953245) ;
3. SELECT * FROM student WHERE Roll no = 3;
4. SELECT * FROM student WHERE Class = 'X';
5. SELECT* FROM student WHERE Name = 'Anuj';
1 Write the steps to create a form using
a wizard view. A4 The following are the
steps to create a forms
1 )Click on Tables > Use wizard view to Create Form , the window
shown below will open
2 )Click Use Wizard to Create Form… option under Tasks group.
The Form Wizard dialog box appears as shown below.
3 )You can select selective fields to be sent onto the form by
selecting the field name and clicking >button.
4 )You can select individual fields in a database or all fields in a
database.
5) Click Next >. You see the Set up a sub form step dialog box of
the wizard as shown below.
6 )You can select the option Add if you need to insert the
contents in the table in a separate form. Click Next>.
Now you need to arrange selected fields in a form. You can use
different styles from the list displayed below
7) Once you have selected a style, click appears
where you can select the data entry model.
8 )Click You should see a dialog box wherein you can
specify the styles to be used in the form
9) Click Next >. You see a dialog box where you can specify the
name of the form. Click Finish.
A form window appears. Notice that the records in the table are
displayed automatically within the form that you just created.
CERTIFICATE
This is to certify that , a student of Class 10,
Section
- has successfully completed and submitted the practical file
of Information Technology (402) as per the guidelines provided by
CBSE in the prescribed curriculum for academic year 2024-25.
The practical file has been evaluated and found correct in
accordance with the guidelines provided by the board- for
Academic year 2024-25. The work has been completed and
presented in a satisfactory manner.