Page 293 - TP_IT_V1.0_C10_flipbpookl
P. 293

21 st
                                                                                               Century   #Media Literacy
                                                                                                 Skills
                      Video based question                                                                     Scan the
                                                                                                               QR Code
                      Watch the video and answer the question. https://www.youtube.com/watch?v=xCL9hgGePGA
                         What is cell reference in LibreOffice Calc?














                                                                                         21 st   #Technology Literacy
                    LAB ACTIVITY                                                       Century   #Critical Thinking
                                                                                        Skills

                       1.  Create the following worksheet in LibreOffice Calc and display the sum of items according to items and then city.













                       2.  Enter the following data into the worksheet and compute the strike rate of the batsman:

                                              Runs Scored             67
                                              Balls Faced             78
                                              Strike Rate             85.90
                         Now find out the strike rate on the basis of the following records:
                         i.   When score is 45 and balls faced are 30.
                         ii.  When score is 40 and balls faced are 90.
                         iii.   When score is 89 and balls faced are 100.
                       3.  Create the following worksheet in Calc:

                                                        English              Hindi              Maths
                              Test 1              17                  16                  17
                              Test 2              15                  16                  18
                              Test 3

                         Use the goal seek feature to predict how much marks should the student score in Test 3 to get 88% marks in total.














                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  291
   288   289   290   291   292   293   294   295   296   297   298