Page 124 - 2617_JSSPS_C-6
P. 124

3.  Create a worksheet as shown:                                               21 st  Century   #Technology Literacy
                                                                                                     #Critical Thinking
                                                                                                 Skills















                    a.   Find the name of the team which has played the most matches by using the MAX() function.


                    b.   Find the number of matches lost by each team by using the subtraction formula.
                    c.   Compare the performance of India and Pakistan by checking if India won more matches than Pakistan.

                    d.   Calculate the win percentage of each team.
                                                                                                     #Technology Literacy
                                                                                             21 st  Century
              4.   Enter the following data in Excel:                                            Skills  #Critical Thinking













                    Perform the following tasks:

                    a.  C2    =(A2*B2)

                    b.  C3    =(A5-B3)
                    c.  E5    =COUNT(A2:B5)
                                                                                                     #Information Literacy
                                                                                             21 st  Century
              HTML5                                                                              Skills  #Creativity
              1.   Create a simple web page, describing the Solar System and its constituents. Here is an example that has a short
                 description of the solar system and also a short description of the planet mercury. Surf the internet and find
                 more information to complete the web page.





                               Solar System

                               Solar system is a collection of plants and satellites that revolve around the Sun. It also consists of other heavenly bodies like
                               asteroids. All the planets revolve around the Sun, which is a star. The planets of our solar system are: Mercury, Venus, Earth, Mars,
                               Jupiter, Saturn, Uranus and Neptune.
                               Mercury
                               Mercury is the smallest planet of the solar system. It is also the closest to the sun. Being close to the sun, its surface is extremely
                               inhabitable.







                122     Premium Edition-VI
   119   120   121   122   123   124   125   126   127   128   129