Page 350 - open office
P. 350

13.  Enter  the  marks  of  5  subjects  of  1   students  and  draw  an  area  chart  and  bar  chart.  Show  the  low-scorer
                  subject-wise.
                14.  Electricity Consumption  ear 2 14-15:

                    Railway Traction     Industrial    Agricultural   Commercial      Domestic       Others
                         22.2%             31.4%          24.9%           3.6%          15.6%         2.1%

                 Draw a Pie Chart and Column Chart for the above data.
              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.
                1 .  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.
                1 .  Create an Impress presentation titled  Which has greater environmental destructive potential, Mankind or  ature
                 Provide at least one slide for the following:
                  •  The Risks                                              •  Mega Tsunami

                  •  Earthquake                                             •  Hurricanes
                  •  Soil Degradation                                       •  Man-made  lobal Warming
                  •   uclear Bomb                                           •  Conclusion
                  •  For each of the above slides, select a suitable layout.
                  •  Insert Header and Footer and set the background colour as green.
                2 .  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.












               350      Touchpad Information Technology-I
   345   346   347   348   349   350   351   352   353   354   355