Page 325 - IT_V1.0_Class10
P. 325

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.





















                                                                                    CBSE Sample Question Paper     323
   320   321   322   323   324   325   326