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

