Page 39 - iPro_trackGPT_V5_Class8
P. 39

Code Clues                                                   #Experiential Learning
                                                                                  #Coding & Computational Thinking
                 Predict the output of the following:

                     1.  =SUM(6,8,9)                               ...............................................

                     2.  =AVERAGE("4,6,5")                         ...............................................
                     3.  =UPPER(orange)                            ...............................................
                     4.  =MOD(6,3)                                 ...............................................

                     5.  =RIGHT("ORANGE",4)                        ...............................................

                           SDG Activity


                     Use Excel to create  a budget  tracker  where  you input your  weekly
                     savings and  expenses. Use functions to calculate your  expenses, and
                     use conditional formatting to highlight any expenses that exceed your
                     budget limits. Analyse the results and present it using charts to see how
                     managing your finances can lead to better economic stability.



                      Digital Drills                                              #Experiential Learning
                                                                                  #Coding and Computational Thinking


                       Create the following worksheet in Excel:











                      Perform the following tasks in a worksheet:
                      •  Write a function in cell H3 to find the total marks obtained by Aradhya.
                      •  Change the contents of cell B3 to upper case using a function.

                      •  Use a formula to find the percentage in cell I3.
                      •  Use the autofill feature to find the total and percentage of the remaining students.
                      •  Use the function in the cell H7 to find the highest marks obtained in Hindi.
                      •  Use the function in the cell E8 to find the least marks obtained in Maths.

                      •  Count the number of students who appeared for the English exam in cell C9.


                 Teachers' Turf


                 1.  Discuss the typical errors encountered in Excel.
                 2.  Explain the use of the filter command in Excel.
                 3.  Explain to the children how Excel is utilized in everyday life.
                 4.  Excel does not differentiate between uppercase and lowercase letters. Demonstrate this by providing examples.


                                                                             Spreadsheet—Functions and Charts    37
   34   35   36   37   38   39   40   41   42   43   44