Basic HTML Version

|  | Table of Contents |  | View Full Version

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 |