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

