Page 45 - Trackpad_V5_Book 6
P. 45

▶  Now create the following charts:
                    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.







                                                                                                 21 st   #Creativity
             FUN ACTIVITY                                                                      Century   #Collaboration
                                                                                                 Skills
              Collect the names and marks of your five friends and draw Pie chart, Column chart and Bar chart
              on chart paper. Also, use different colour pens to make it attractive.






                    COding Zone       COding Zone     {}      =     COding Zone
                                                                                        #Computational Thinking
                           {C ding z ne}
                                                                                     21 st
                                                                                  Century
                                                                                        #Interdisciplinary
                                                                                    Skills
                                                                    </>
                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 number would come at the ninth place from the top?
                   _______________________________________________________________________________
                2.  Write the missing number.


                                         7        2      11      3       ?       4


                                             4               6               8
                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 careers 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.




                                                                                          Charts in Excel 2021  43
   40   41   42   43   44   45   46   47   48   49   50