Page 444 - TP_IT_V1.0_C10_flipbpookl
P. 444
14. How do Merging and Comparing Spreadsheets differ in Calc?
15. Describe referential Integrity.
16. What causes eye strain and how to avoid it?
Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
17. Imagine you are preparing a series of school reports that need to include your school’s logo, a picture of your project,
and a standard footer with your name and class. Instead of adding and formatting these elements individually in each
report, you use LibreOffice Writer templates to simplify this process.
a. How can we apply the template from the available template list?
b. When is exporting of templates useful?
18. Imagine you are a student organizing a fundraising event for your school club. You have a spreadsheet in LibreOffice Calc
that lists donations from different sponsors. Each sponsor has contributed multiple times, and you need to summarize
the total amount donated by each sponsor.
a. Which tool in Calc can be used to create the group automatically?
b. Which functions can be applied to the grouped data?
c. Which menu option is used to apply this Tool?
d. What is purpose of e (-)or (+) signs on grouped data?
19. What are Data Models? Explain different types of Data models.
a. She wants to show the sales data in a pictorial form. Which tool/option should she use to compare the data?
b. She wants to give some effect whenever the slide changes.
c. She has to show a table created in spreadsheet on her slide.
d. She wants to take printouts such that more than one slide is printed on the page having only textual content.
20. Imagine you are a safety officer overseeing electrical maintenance work at a manufacturing plant. To spread the
awareness among your team you have to conduct training on safety measures. List out electrical rescue techniques
which you will discuss with them.
21. Consider the following table: Employee
Emp_id Name Salary Designation
E01 Kajal 78000 Manager
E02 Rahul 50000 Sales Executive
E03 Tarun 55000 Clerk
a. You are tasked with designing a new employee database for your company. Based on the given table structure,
identify the fields that would be necessary to store key information about each employee.
b. As a database administrator, you need to ensure each employee has a unique identifier. Which field in the table
would you choose as the primary key, and why?
c. During a review of the employee database, you realize there could be another field apart from the primary key that
can uniquely identify a record. Identify the field and justify why it could serve as an alternate key.
d. You are integrating the employee table with another table that stores department details. Explain how you would
use the primary key from the employee table and a foreign key in the department table to establish a relationship
between the two tables. Illustrate with an example.
442 Trackpad Information Technology (Ver. 1.0)-X

