Page 204 - IT_V1.0_Class10
P. 204

21 st
                                                                                               Century   #Technology Literacy
                                                Lab Assignment ‘n Activity                       Skills



                     Complete the following activities and tick the circle.

                       During the beginning of every Academic Year, ABC Model School shuffles the section of
                       their students. Academic Incharge has prepared the data in a sheet as shown below.








                        Academic Incharge must type comment for changing section of any student. Admin will
                       review the comment and based on the analysis, change of section will be accepted or
                       rejected. Admin will save the file by a new name.
                        Now, both the sheets will be compared by the Principal and after merging the data,
                       Principal will publish a final sheet. Complete this lab assignment on behalf of Academic
                       Incharge, Admin and Principal of ABC Model School.



                  Recap Zone

                     In LibreOffice Calc, multiple users can simultaneously open and edit the same spreadsheet, allowing
                   for collaborative editing without managing multiple versions.
                    The Record Changes feature in spreadsheet packages tracks and highlights changes made in cells,
                   displaying details about who made the change, when, and which cells were altered, allowing reviewers
                   to accept or reject these changes before finalising the document.
                    In LibreOffice Calc, comments allow authors and reviewers to exchange ideas or suggestions, and can
                   be added by selecting a cell, right-clicking, and choosing Insert Comment to type the desired text.
                    Reviewing changes in a document allows the author to accept or reject suggested changes made by
                   other users, which can be done individually or all at once by accessing the Track Changes option in
                   the Edit menu and selecting Manage.


                                                          Exercise



                                                 Section A (Objective Type Questions)
              A.  Multiple choice questions.

                 1.  Reviewers and authors can add their ............................. to explain their changes in the cell of a Spreadsheet.
                    i.  Comments           ii.  Hyperlink            iii.  Sheet                  iv.  Macros
                 2.  Krish and Kritika have done a survey of age-wise literacy rates of their locality as a school project, which they
                    have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option
                    should they use to access the same Spreadsheet to speed up their work?     [CBSE Sample Paper, 2023]

                    i.  Consolidate Sheet   ii.  Shared Sheet        iii.  Link Sheet             iv.  Lock Sheet
                 3.  Which button is pressed to accept every change that has been made in the sheet?
                    i.  Accept             ii.  Accept All           iii.  Accept Changes         iv.  Accepted



                202     Information Technology Play (Ver 1.0)-X
   199   200   201   202   203   204   205   206   207   208   209