Page 315 - IT_V1.0_Class10
P. 315

10.  You and your classmates are working on a group project using a shared spreadsheet.

                    •  Set up a shared spreadsheet for collaborative editing among classmates.
                    •   Practice adding, editing, and formatting comments to enhance communication and clarity within the
                       spreadsheet.

                    •  Learn to manage changes effectively by reviewing and either accepting or rejecting them.
                 11.  Create a table Product in Design View:

                      ProductID      ProductName            Category              Price
                          1       Laptop                Electronics              80000
                          2       Tablet                Electronics              30000
                          3       Chair                 Furniture                15000

                          4       Desk                  Furniture                25000
                          5       Smartphone            Electronics              50000

                    Tasks:
                    •  Sort the Product table by Price in descending order.
                    •   Use a wildcard to create a query that retrieves all products where the ProductName starts with the
                       letter T.
                    •   Generate a report based on the Product table.
                    •   Format the report to show products in ascending order of ProductID.
                    •   Add the page number in the footer of the report.
                 12.  You are tasked with organising student marks data in a spreadsheet and automating the calculation of
                    total marks using a macro named “TotalMarks”.
                    •   Set up a spreadsheet with three columns: “Student Name” in column A, “Subject” in column B, and
                       “Marks Obtained” in column C. Ensure data starts from row 2.
                    •   Develop a macro named “TotalMarks” that iterates through each row of the spreadsheet (starting from
                       row 2) to calculate the total marks obtained by each student.
                    •  For each student, sum up the marks obtained from all subjects listed.
                    •  Display the total marks for each student in column D, starting from row 2.
                    •   Execute the macro to automatically calculate and populate the total marks for each student based on
                       the data provided in the spreadsheet.

                 13.  You  have  received  two  versions  of  a  financial  report  from  different  teams.  You  need  to  identify
                    discrepancies and reconcile the differences between the two sheets. How would you do this task in
                    LibreOffice Calc?

                 14.  Create the following table using the ‘Design View’.
                                                                Date of            Marks
                          Reg No.             Name                                                    Grade
                                                              Submission         Obtained
                          T/121/15      Anshu Verma            11/07/15              18                 A
                          T/137/15      Anjali Kumari          12/07/15              20                A+
                          T/145/15      Deepak Kohli           14/07/15              17                B+

                    •  Name the table as ‘Marks Distribution’.
                    •  Enter atleast 3 records.
                    •  Sort the data on the basis of grades.


                                                                                                   Practical Work   313
   310   311   312   313   314   315   316   317   318   319   320