Basic HTML Version

|  | Table of Contents |  | View Full Version

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 |