Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 123 - 2617_JSSPS_C-6
P. 123

    Practical Assessment

                     Excel                                                                   21 st  Century   #Technology Literacy

                     1.  Make the following table in Excel.                                      Skills  #Productivity & Accountability

                        a.  The formula for calculating average has been shown in the first cell.
                        b.  Calculate averages for all the players using the formulas.
                        c.  Calculate grand total of runs scored by all the players.

                        d.  Create a pie-chart of the average runs scored by the players similar to this.

                     2.   Using Excel, prepare a calculator that can calculate the total marks of a student and also calculate the
                       percentage of the marks they have obtained. Here is an example.

                                                                                                Practical Assessment   121

| 118 119 120 121 122 123 124 125 126 127 128 |