Page 376 - Trackpad IT-402_Class-IX
P. 376

13.  Enter the marks of 5 subjects of 10 students and draw an area chart and a bar chart. Show the low-scorer subject-wise.

          14.  Draw a Pie Chart and a Column Chart for the following Electricity Consumption Year 2016-17:
               Railway Traction     Industrial    Agricultural   Commercial      Domestic       Others

                    22.2%             31.4%          24.9%          3.6%           15.6%         2.1%

        15.  The table below shows the marks obtained by 50 students in the Computer Class Test. Draw a Column Chart (graph) based on
            the table.

             Marks                  3        4        5        6        7        8        9       10

             No.of Students         1        3        4        8       12       10        9        3

          16.  For the following data, draw a Pie Chart.

                    Items             Rent           Food           Cloth        Education      Misc
                 Expenses in%         15%            35%            10%            20%          20%

        17.  The table below represents the population growth of a country. Draw a Column Chart for the same.
            In the above (all) charts, add the following:
            •  Add proper Chart Title and wherever required, show the data values in the chart.
            • Show Legends
            • Insert the chart in the same worksheet or in a new chart sheet.
          18.  In a Worksheet, store the data of a Class including the name of the student, address, date of birth and telephone number.
            Also, filter the records according to the address of the student.
          19.  Create an Impress presentation titled “Which has greater environmental destructive potential, Mankind or Nature?”
            Provide at least one slide for the following:
            • The Risks                                               •   Mega Tsunami

            •   Earthquake                                            •   Hurricanes
            •   Soil Degradation                                      • Man-made Global Warming
            •   Nuclear Bomb                                          • Conclusion
            •   For each of the above slides, select a suitable layout.
            •   Insert the Header and Footer and set the background colour as green.
          20.  Create an Impress presentation titled “Classical Dance forms of India”. Create at least any one slide for the following:
            1. Place of origin
            2. History

            3. Speciality
            4. Costumes
            Also, provide relevant images for each of the above.
















          376   Trackpad Information Technology-IX
   371   372   373   374   375   376   377   378   379   380   381