Page 27 - 2617_JSSPS_C-6
P. 27

A Better Me!                                                 21 st  Century   #Initiative
                                                                                           Skills
                                                                                               #Leadership & Responsibility
                           Your neighbour has been preparing a list of grocery items with their prices. She has been manually
                         calculating the total amount. Do you think you should help people whenever you see an opportunity?




                          Explore in the Lab                                 21 st  Century   #Technology Literacy
                                                                                 Skills
                                                                                     #Productivity & Accountability
                  To
                  Subject  Preparing Result
                   Create a worksheet with the following two columns:

                                                          A                   B
                                                        Name                Score

                                                  John                        85
                                                  Sarah                       62
                                                  Emily                       78
                                                  Michael                     92

                   After creating the worksheet, perform the operations given below:
                     In the Column C, enter the header as Result.
                     Display the result of each student as Pass if the Score is greater than or equal to 70; otherwise, Fail.

                     In the Column D, enter the header as Remarks.
                     Display the remarks as “Good Job!” if the result of the students is Pass; otherwise, “Keep Trying”



                 For The Teacher

                    Do a detailed walk-through of all the Excel topics listed in the chapter.
                    Explain to the children the use of Excel in homes, shops, businesses, industries, etc.


































                                                                             Charts, Formulas & Functions in Excel  25
   22   23   24   25   26   27   28   29   30   31   32