Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
1. Mr R K Sharma is planning to change his job. He approaches a company
(www.naukri.in) for help in finding a new job. Mr Sharma is asked to submit
his CV/Resume in the company. He has downloaded a sample CV from
“template.com”. Help him in creating his CV in the same format. Also save
the format as “CV1” on the computer, for future reference.
2. St. Mary’s School is planning to publish a monthly digital newsletter for
their school. Ravish Pandey of class 10, heads the group responsible to
design it on a computer.
3. Master Udit is helping his drawing teacher to create digital drawings. His
teacher asks him to write down the steps to create the following two
drawings. In the first drawing, objects are grouped and the second drawing
was created by resizing objects of the first drawing. How would you help
her to do so using the drawing tools of Writer?
4. Create a Company Invoice Template using LibreOffice Writer.
5. Pradeep has created a document on ‘Humans and Nature’ and has made
some changes after receiving comments from his friends. Now, he wants
to compare the original document with the edited version using the Track
Changes feature in LibreOffice Writer.
Unit-2 Electronic Spreadsheet (Advanced) using LibreOffice Calc
1. ABC Company wants to analyze their quarterly sales from a store. The
sales data is provided in three worksheets named "January," "February,"
and "March," each containing monthly sales figures for various products.
Consolidate the data from these three worksheets into a single summary
2. Create two sheets Marks_Term1 and Marks_Term2 to store the marks in
Term1 and Term2 for a set of students
3. XYZ Motors offers three car models: Sedan, SUV, and Hatchback. The
company provides loan options to customers, and the EMI (Equated
Monthly Installment) needs to be calculated for each car variant based on
the loan amount, interest rate, and loan tenure. Your task is to create a
spreadsheet in LibreOffice Calc to Create a Scenario.
4. Kavita wants to take a loan of ₹60,000 for a period of 3 years from a bank.
The interest rates offered by different banks are as follows:
SBI Bank: 9%
Canara Bank: 9.1%
HDFC Bank: 9.5%
Your task is to help Kavita determine which bank will charge the highest EMI
using Scenario in LibreOffice Calc
5. You produce toys which you sell for $10 each. Each toy costs $2 to make,
in addition to which you have fixed costs of $10,000 per year. Find the
profit using multiple operations you make in a year if you sell a particular
number of toys?
6. A student is setting goals for her upcoming examinations to achieve
distinction (75%). Each subject has a maximum score of 100 marks. The
student’s Term 1 marks are provided below. Your task is to help her plan
the minimum marks required in Term 1 to reach an overall distinction.
7. For the following worksheet obtain the solution for the Selling price so that
the profit will be 400.
8. You have a list of data in a spreadsheet, and you want to apply specific
formatting (bold, italic, and color) to a range of cells automatically using a
macro.
Unit-3 Database Management System using LibreOffice
Base
1. Create a table Std_Info with following fields and data type
2. Create a table Std_Marks with following fields and data type
3.Create a table Book_Issued with following fields and data type
4.ABC Company maintains employee records in a spreadsheet named
Emp_Rec.ods. The spreadsheet has 5 fields with data types as given
below. Your task is to create this employee record in LibreOffice Calc with
10 records and save the file.
5. You are working with two tables: Std_Info (student information) and
Book_Issued (library book records). Each student can borrow multiple
books, and the Student_ID field serves as the primary key in the Std_Info
table and as a foreign key in the Book_Issued table. Your task is to
create and establish a relationship between these two tables in
LibreOffice Base.
6. You are working with a table named Std_Info that contains student
records. Your task is to generate a query that retrieves all students
whose names start with the letter 'V', and display the results in ascending
order by name.
7. Design a Form to enter and show the record in Std_Info table
(Question-1) and Book_Issued table (Question-3) using wizard.
8. Generate a report for Res_Details Table.
