Indian Learners’ Own Academy

INFORMATION TECHNOLOGY

NAME : Aaron Biju John

CLASS : X - <A>
ROLL. No : 31
YEAR : 2024-2025

1
 INDIAN LEARNERS’ OWN ACADEMY
KUWAIT

Bonafide Certificate
This is to certify that <Aaron Biju John> of Class X - <A>, ROLL. No.
__31__ has satisfactorily completed the Practical Assignments in
Information Technology in the year 2024 - 25.

Internal Examiner
Mrs. Deepalakshmi Jeyakumar

Signature: ……………………

2
 INDEX
EX. PAGE
PROGRAM NAME
NO NO.

Develop a database in LibreOffice Base to track employee records for a small

1. business. Include tables for employee details such as name, designation, 4
department, and salary information.

Design a table in LibreOffice Base to store information about books in a library.

2. 4
Include fields for book title, author, ISBN, genre, and availability status.

Create a table named "Student" with the following fields: Student ID (Integer),
3. 4
Name (Text), Age (Integer), Gender (Text), and Grade (Text).

4. Create a query using the wizard 4 and 5

5. Consider the Student table, Write Query in SQL View 5 and 6

6. Create a form ‘Faculty’ and record the details 6

7. Working with images in digital document 6 and 7

8. Create table of contents 12

Create two sheets’ Marks_Term1 and Marks_Term2 to store the marks in Term1
7,8,9and
9. and Term2 for a set of students.
10
use the consolidate function to merge these two sheets

3
1. Develop a database in LibreOffice Base to track employee records for a small business. Include tables for
employee details such as name, designation, department, and salary information.

2. Design a table in LibreOffice Base to store information about books in a library. Include fields for book title,
author, ISBN, genre, and availability status.

3. Create a table named "Student" with the following fields: Student ID (Integer), Name (Text), Age (Integer),
Gender (Text), and Grade (Text).

4. Create a query using the wizard

4
 Step 1: Select create > Quary Wizard

Step 2: Select Simple Quary, and then Ok

Step 3: Select the table that contains the field, add the Available Fields you want to Selected Fields, and
select Next

Step 4: Choose whether you want to open the query in Datasheet view or modify the query in Design view,
and then select Finish.

5. Consider the Student table, Write Query in SQL View

Step 1: SELECT: This clause specifies the fields to display data or information. For example SELECT
Code, Name, Amount This statement indicates that the fields Code, Name and Amount are to be displayed
by the query statement.

Step 2: FROM: This clause specifies the source of data in terms of tables or queries or a combination of
both. By specifying the JOIN clause, two tables are joined. Join clause can be of following three types.

a) INNER- This Join clause displays only those records that are exactly matching between two data
sources. For example, FROM Accounts INNER JOIN AccountType ON (CatId = Type) Here, only
those records of Accounts and AccountType table are a part of source of query data, which match ex-
actly on CatId = Type.
b) LEFT- This JOIN clause displays all the records in the primary table in a relationship irrespective of
whether there are matching records in the related table or not. For example, FROM Accounts LEFT
JOIN AccountType ON (CatId = Type) Here, all the records of Accounts along with the matching rec-
ords form a part of the source of the query data.
c) RIGHT- This JOIN clause displays all the records of related table in a relationship irrespective of
whether there are matching records in the primary table or not. For example, FROM Accounts RIGHT
JOIN AccountType ON (CatId = Type) Here, all records of the AccountType along with the matching
records of the Accounts table form a part of the source of query data.

Step 3: WHERE: This clause provides the condition to restrict the records to be returned by the query. The
result records of the query must satisfy the condition which is specified after the WHERE clause.

5
 Step 4: ORDER BY- This clause specifies the order in which the resultant records of the query are required
to appear. The basis on which this ordering is done is determined by the list of the fields specified after the
ORDER BY clause. For example, ORDER BY Type, Code This statement implies that the resultant record
set is ordered by the 'Type' field of Accounts and within Type, by 'Code' field of Accounts.

Step 5: GROUP BY- This clause enables the grouping of records for creating summary query. The fields
specified after the GROUP BY clause form the basis of grouping for which the summary results are ob-
tained.
For example,
SELECT Debit, Sum (Amount)
FROM Vouchers
GROUP BY Debit
Here, the GROUP BY clause uses debit account codes for calculating the sum total of the amount of the
vouchers.

6. Create a form ‘Faculty’ and record the details

7. Working with images in digital document

6
Internet of things (IoT) describes devices with sensors, processing ability, software and other technologies that
connect and exchange data with other devices and systems over the Internet or other communication networks.
The Internet of things encompasses electronics, communication, and computer science engineering. "Internet of
things" has been considered a misnomer because devices do not need to be connected to the public internet;
they only need to be connected to a network and be individually addressable.

9. Create two sheets’ Marks_Term1 and Marks_Term2 to store the marks in Term1 and Term2 for a set of
students. Use the consolidate function to merge these two sheets

Step 1: Create a new sheet where the data has to be consolidated.

Step 2: Choose Data > Consolidate option that open Consolidate dialog.

7
Step 3: Observe that the default function “Sum” is seen in the Function drop down. You will be able to see the
list of functions. clicking on the Function drop-down.

Step 4: Choose the required function from the drop-down list.

Step 5: The sources data range list contains existing named ranges to quickly select from that. But if the source
range is undefined, then click and select the range from the sheet which is to be consolidated.

8
Step 6: Click on Add to add this range under the ‘Consolidation ranges’ of the Consolidation dialog.

Step 7: Repeat steps 6 and 7 to add more sheets to be consolidated.

1. 2.

9
Step 8: Click on Options that will list two checkbox under Consolidate by “Row labels” and “Column labels”
and “Link to source data” under Options. From this you can select the additional feature as per requirement.
The option consolidate by rows and columns are checked to consolidate data as per row labels and column
label. Link to source data is checked to make the modification automatically in the consolidated (target) sheet
while making any changes in the source data.

Step 9: Finally click on OK button.

1.

2.

10
8.Create table of contents

CONTENTS
Foreword
About the Textbook

Unit 1: Digital Documentation (Advanced) using LibreOffice Writer

Chapter 1. Introduction to Styles
Chapter 2. Working with Images
Chapter 3. Advanced Features of Writer

Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc

Chapter 4. Analyse Data using Scenarios and Goal Seek
Chapter 5. Using Macros in Spreadsheet
Chapter 6. Linking Spreadsheet Data
Chapter 7. Share and Review a Spreadsheet

Unit 3: Database Management System using LibreOffice Base

Chapter 8. Introduction to Database Management System
Chapter 9. Starting with LibreOffice Base Chapter 10.
Working with Multiple Tables
Chapter 11. Queries in Base
Chapter 12. Forms and Reports

Unit 4: Maintain Healthy, Safe and Secure Working Environment

Chapter 13. Health, Safety and Security at Workplace
Chapter 14. Workplace Quality Measures
Chapter 15. Prevent Accidents and Emergencies
Answer Key

12