Page 154 - TP_Pluse_V2.2_Class_7
P. 154

https://www
                                                       PROJECT WORK
                                                       PROJECT







                     A.   In Excel,  create a tabular  data  of  5 of your friend’s marks
          https://www                                                                            21 st   #Communication   https://www
                        obtained in the previous exams and plot a graph for the average        Century   #Technology Literacy
                                                                                                 Skills
                        marks and the average percentage obtained for each of them.
                        Here is an example dataset.






         https://www                                                                                                     https://www


















                                                                                                 21 st
                                                                                               Century   #Critical Thinking
                     B.  Make the following table in Excel.                                      Skills


























         https://www                                                                                                     https://www

                        •    The formula for calculating average has been shown in the first cell.
                        •    Calculate averages for all the players using the formulas.

                        •    Calculate grand total of runs scored by all the players.
                        •    Create a pie-chart of the average runs scored by the players similar to this.




                  152   Plus (Ver. 2.2)-VII
                          https://www
   149   150   151   152   153   154   155   156   157   158   159