Page 46 - Trackpad_V1_Book 6_Flipbook
P. 46
▶ Now create the following charts:
Histogram Frequency polygon
Pie chart Column chart
▶ Enter the data of your monthly expenditure in Excel. Use different columns for different months
(at least five months). Use different rows for different categories of expenditure.
After you are done, use the most suitable type of chart for this data and represent it graphically.
Now change the background to make it look more eye-catchy.
Creativity
FUN ACTIVITY
Collect the names and marks of your five friends and draw Pie chart, Column chart and Bar chart
on a chart paper. Also use different colour pens to make it attractive.
COding Zone COding Zone {} = COding Zone COding Zone
{C ding z ne}
Computational Thinking
[]
</>
1. If numbers 1 to 39, the ones that are exactly divisible by 3 are arranged in an ascending order,
the minimum number being on the top, which would come at the ninth place from the top?
______________________________________________________________________________
2. Write the missing number.
7 2 5 3 ? 8
4 6 120
3. Choose the odd one out.
a. 50—80 b. 25—55 c. 135—170 d. 14—44
CAREER HERE
People who are experts in Microsoft Excel may pursue their career as Data analysts.
FOR THE TEACHER
1. Describe the different components of a chart to the students.
2. Encourage the students to create a chart in Excel that shows their Annual Examination Result. Recommend them
the best chart type suitable for this task.
44 Trackpad (Version 1.0)-VI Charts in Excel 2010 PB

