Scribd
Upload
67 views3 pages

LibreOffice Class 10 Practical Guide

The document provides step-by-step instructions for creating various components in LibreOffice, including an 'Employees' table, a form, and a report. It also outlines how to create a 'Marksheet' table with specific queries, design a CV template, create a table of contents, and develop a class timetable. Each task is clearly defined with sequential steps for easy execution.

Uploaded by

Clash Ofclan
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
67 views3 pages

LibreOffice Class 10 Practical Guide

The document provides step-by-step instructions for creating various components in LibreOffice, including an 'Employees' table, a form, and a report. It also outlines how to create a 'Marksheet' table with specific queries, design a CV template, create a table of contents, and develop a class timetable. Each task is clearly defined with sequential steps for easy execution.

Uploaded by

Clash Ofclan
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 File - Class 10th (LibreOffice

Assignments)
Q1: Create Employees Table
Steps:

1. Open LibreOffice Base and create a new database.

2. In the left pane, select 'Tables' and click 'Use Wizard to Create Table'.

3. Add the fields: Emp_ID (Integer), Name (Text), Department (Text), Salary (Decimal).

4. Set Emp_ID as the primary key.

5. Save the table as 'Employees'.

Q2: Create emp_form from Employees Table


Steps:

1. In LibreOffice Base, go to 'Forms' and select 'Use Wizard to Create Form'.

2. Select 'Employees' table and include all fields.

3. Choose a layout and style as per your choice.

4. Save the form as 'emp_form'.

Q3: Create emp_report from Employees Table


Steps:

1. Go to 'Reports' in LibreOffice Base.

2. Select 'Use Wizard to Create Report'.

3. Choose 'Employees' table, select all fields, and set grouping/sorting if needed.

4. Save the report as 'emp_report'.

Q4: Queries on Marksheet Table


Steps:
1. Create a new table named 'Marksheet' with fields: Roll_No (Integer), Name (Text),
Phone_Number (Integer), Total_Marks (Integer), Percentage (Decimal).

2. Run the following queries:

a) Display Name, Roll_No, Total_Marks, and Percentage using design view.

b) Display Name, Roll_No, and Total_Marks using query wizard.

c) Display only those students where Roll_No > 10.

d) Display Roll_No, Name, and Percentage where Percentage > 70 using design view.

e) Display all records in ascending order of Name using design view.

Q5: Create a Curriculum Vitae Template


Steps:

1. Open LibreOffice Writer.

2. Go to 'File' > 'Templates' > 'Save As Template'.

3. Design a CV with sections: Personal Details, Education, Skills, Work Experience, and
References.

4. Save the template as 'My_CV_Template'.

Q6: Create a Table of Contents


Steps:

1. Open LibreOffice Writer and write a document with multiple headings.

2. Apply heading styles (Heading 1, Heading 2, etc.).

3. Place the cursor at the top and go to 'Insert' > 'Indexes and Tables' > 'Indexes and Tables'.

4. Select 'Table of Contents' and click OK.

Q7: Project - Create Class Timetable


Steps:

1. Open LibreOffice Writer and create a new document.

2. Insert a table with columns for Days (Mon-Sat) and rows for Periods.

3. Fill in subjects according to the class timetable.


4. Apply formatting for readability.

5. Save the file as 'Class_Timetable'.

You might also like