Page 90 - ModularV1.1 _c6_flipbook
P. 90

PROJECT WORK












                  MS Excel

                  Project 1                                                                             Inter-Disciplinary

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










                  Project 2                                                                            Subject Enrichment

                    Rajat has created a list of students who are a part of school cricket team.

                    Sr.     Name of the               Runs Scored in              Total Runs         Average
                    No.        Student        Match 1    Match 2     Match 3        Scored        Runs Scored

                     1           Ravi            65          45          59
                     2          Chirag           54         120          63

                     3           Amit            55          12          85
                     4          Rohan            68          89          78
                     5         Anurag            79          50         100

                     6         Mohan             90          12          36
                     7          Rajan            45          78          79
                     8        Devendra           25          36          40
                     9         Chetan            14          20          18

                    10         Ravindra           7          9           10
                    11        Narendra           12          5           0

                       Now, he wants to add a column titled ‘Designation’ between Name of the student and Runs
                     scored in columns to put category as Batsman, Bowler, All Rounder or Wicket Keeper.

                       Vikas and Nitin have resigned from the team. He has to remove the details of these students
                     from the list.
                      Change the width of the column ‘Designation’ to 20.
                      Find ‘Total Runs Scored’ and ‘Average Runs Scored’ by each student using formulas.



                  88      Modular (Ver. 1.1)-VII
   85   86   87   88   89   90   91   92   93   94   95