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
   41   42   43   44   45   46   47   48   49   50   51