Page 115 - modular4.0
P. 115

Project Work                                                   Chapter Profile








                 Excel 2019
                                                                                                 21 st
                                                                                                 Century   #Technology Literacy
                 Project 1                                                                      Skills
                   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.











                                                                                                 21 st
                 Project 2                                                                    Century   #Technology Literacy
                                                                                                Skills  #Critical Thinking
                   Rajat has created a list of the students who are a part of school cricket team.

                     Sr.      Name of the              Runs Scored in               Total Runs     Average Runs
                     No.        Student        Match 1     Match 2     Match 3        Scored           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.





                                                                                                       Project Work  113
   110   111   112   113   114   115   116   117   118   119   120