Page 119 - IT-802_class_12
P. 119

B.  Competency-based/Application-based question:                                         Experiential Learning
               Ms Kanika has all her students’ subject marks and their totals in a spreadsheet. She wants to find the names of the three
               students with the highest marks. Which feature of the spreadsheet should she use?


            Lab aCtiVity

             Group Practice:                                                                          [NCERT]

                Working on a presentation in LibreOffice impress.
             Material required: Computer with LibreOffice Impress, pen, notebook, etc.            Subject Enrichment
             Procedure:
                •  Divide the class into groups, depending on the number of computers. Each group will perform the following
                  activities.
                   – Save a presentation file by the name ‘Water Cycle Project’
                   – Close the file
                   – Open the file again
                   – Print the presentation
                •  Make sure that each student in the group gets a chance to perform at least one activity. Other members can watch
                  and give feedback on what was done correctly and what could be improved upon.



            Previous Years’ Questions



              1.  A ............................ is rectangle shaped box, where row and column meet in a spreadsheet.   [2023]
             Ans.  cell
              2.  In Open Office Calc ............................ contains the Name Box which shows the location of the selected cell.   [2023]
                  (a)  Formula Bar                             (b)  Status Bar
                  (c)  Menu Bar                                (d)  Title Bar
             Ans.  (a)  Formula Bar
              3.  Write down the main steps to apply filter to a tabular data in Calc.                         [2023]
             Ans.  The main steps to apply a filter to tabular data in LibreOffice Calc:
                  Step 1: Select the cell in the data.
                  Step 2: Go to “Data” > “Filter.”
                  Step 3: Click the filter arrow in the header.
                  Step 4: Set your filtering criteria.
                  Step 5: Click “OK” to apply the filter.
              4.  In spreadsheets content of a cell appears in ............................ and the cell.      [2022]
                  (a)  Title bar                               (b)  Formula bar
                  (c)  Address box                             (d)  Sheet tab
             Ans.  (b)  Formula bar
              5.  Select the correct option with respect to spreadsheets:                                      [2022]
                  (i)  A workbook is a spreadsheet that has one or more worksheets.
                  (ii)  A worksheet that has one or more workbooks.
                  (iii)  A cell is a grid of rows and columns.
                  (iv)  By default, data is sorted in ascending order in spreadsheets.
                  (a)  (i) is correct                          (b)  (ii) and (iii) are both correct
                  (c)  (i) and (iv) are both correct           (d)  (i), (iii) and (iv) are correct
             Ans.  (c)  (i) and (iv) are both correct
                                                                                                   ICT Skills-IV  117
   114   115   116   117   118   119   120   121   122   123   124