Page 111 - TP_Modular_V2.1_Class7
P. 111

PROJECT WORK












                 Excel 2016
                                                                                                  21 st
                                                                                                Century   #Critical Thinking
                 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.









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


                                                                                               Project Work      109
   106   107   108   109   110   111   112   113   114   115   116