Grade 10
Practical File
IT-402
Electronic Spreadsheet
Practical 1. Create three worksheets in a spreadsheet in Libre Office Calc.
Illustrate the use of Consolidate tool with the help of following example.
Practical 2. Create a spreadsheet in Libre Office Calc. Illustrate the use of Subtotals tool
with respect to following data. Using SUBTOTALS tool, calculate the total quantity for each
appliance.
Practical 3. Use Goal seek to know how much the investment (Principal) would have to
be modified in order to attain a particular simple interest. For this example, calculate
how much Principal would be required if you want an annual simple interest of particular
amount.
Practical 4: Show an example to show the use of Multiple Operations in spreadsheet.
Practical 5: Show an example to show the use of Scenarios in spreadsheet.
1
DBMS
Practical 1. Create a School Database with Details table in Libre Office Base in Design
View. (Show fields and data types)
Following will be the fields of the table-‘Details’:
Rno Name Address Age Gender DOB
Choose the appropriate field as a Primary Key.
Practical 2. Insert 10 records in ‘Details’ table in School Database. (Show the datasheet view
of table with records in it.)
Practical 3. Design the form to enter data in the table.
Digital Documentation
Practical 1. Write an article on “Digital Footprints” in Libre Office Writer.
Include different styles for titles and subtitles.
Insert relevant images and drawing objects wherever required.
Practical 2. Illustrate the implementation of Table of Contents in Writer.
Practical 3. Create a template for your Company’s letter head. Save it as a default
template.