Scribd
Upload
15 views7 pages

Data Analysis with LibreOffice Tools

The document outlines practical exercises for using Libre Office Calc and Base, focusing on data entry, profit analysis, and database management. It includes steps for creating tables, entering data, and generating SQL queries to analyze student records. Key conclusions highlight the importance of structured data organization and the ability to perform complex queries for data retrieval.

Uploaded by

phoenixcr788
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views7 pages

Data Analysis with LibreOffice Tools

The document outlines practical exercises for using Libre Office Calc and Base, focusing on data entry, profit analysis, and database management. It includes steps for creating tables, entering data, and generating SQL queries to analyze student records. Key conclusions highlight the importance of structured data organization and the ability to perform complex queries for data retrieval.

Uploaded by

phoenixcr788
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Practical – 10: MULTIPLE OPERATION

Objective:
-To learn how to enter data in a spreadsheet
-To use multiple operation for analyzing change in profit
Task:
-Enter the company expenses using the formula:
Profit = Income – Total expenses
-Display the results in a table

Steps:
-In libre office Calc, create a table with the required values
-Select a column where income values will be entered
-Use: Data-Multiple Operation
-Enter the row input cell which is B8
-Calc automatically fills profit for each income

Conclusion:
-The company faces a loss at Rs 40000 income
-The company starts making a profit when income crosses Rs
41000.
-The first profit appears at Rs 45000

Practical-11: CREATING A TABLE IN LIBRE


OFFICE BASE
Objective:
-To understand how to create a database in Libre Office Base
-To design a table with suitable fields and data types
Task:
-Create and save the table with the following fields

Steps:
-Open Libre Office Base
-Create a new database and save the database with suitable
name
-From the left panel, click Tables- choose Create table in
design view
-Enter the field names and choose proper data types
-Set Student ID as the primary key
-Save the table
-Switch to Data View and enter all the provided student
records
-Save and close the table
Conclusion:
From this we have learnt to make a table in Data Base
Management System. Tables provide a structured format ,
making it easier to organize and retrieve information.

Practical 12- Generating queries for a table in


Libre Office Base
Objective:
-To perform queries on a database table.
Task:
Create a table of the following data
Steps:
-Open Libre Office base
-Click on queries on the left panel and create query in SQL
view
-Generate queries for the above table
Answer the following
1, Display all the students who scored more than 80 marks.
SELECT * FROM StudentMarks WHERE Marks > 80;
2, Display the details of students who belong to Class 10B
SELECT * FROM StudentMarks WHERE Class = '10B';
3, Display all male students who scored more than 70 marks
SELECT * FROM StudentMarks WHERE Gender = 'M'
AND Marks > 70
4, Find the number of students in each class
SELECT Class, COUNT(*) AS TotalStudents
FROM StudentMarks
GROUP BY Class;
5, Find the highest marks scored in each class
SELECT Class, MAX(Marks) AS HighestMarks
FROM StudentMarks
GROUP BY Class;
6, Find the average marks of male and female students
SELECT Gender, AVG(Marks) AS AverageMarks
FROM StudentMarks
GROUP BY Gender;
7, Find the average marks of students in each class where the
marks are above 70
SELECT Class, AVG(Marks) AS AverageMarks
FROM StudentMarks
WHERE Marks > 70
GROUP BY Class;
8, Find the total marks of students aged 15 or above, grouped
by class
SELECT Class, COUNT(*) AS TotalStudents
FROM StudentMarks
WHERE Age >= 15
GROUP BY Class;

You might also like